176 reputation
211
bio website sites.google.com/site/…
location
age
visits member for 2 years, 9 months
seen May 29 at 16:23

Interested in spiking neural networks, genetic algorithms, Standard C++, OpenCL, database, ... and a few more things.


Jan
23
comment Problem with nested UPDATE queries
@ypercube: I updated the question. Thank you.
Jan
23
revised Problem with nested UPDATE queries
Specified that id is the primary key of Tab1.
Jan
23
asked Problem with nested UPDATE queries
Jan
22
accepted How to search for a specific column name in all the tables in MySQL Workbench?
Jan
22
comment How to search for a specific column name in all the tables in MySQL Workbench?
Thank you. If you add it as an answer I will accept it.
Jan
22
asked How to search for a specific column name in all the tables in MySQL Workbench?
Sep
27
comment RAM/memory based databases
I used a RAM disk. It seems to be the most transparent and portable solution; the OS is in charge of everything...
Sep
20
accepted execute() vs executeQuery() in MySQL Connector C++
Sep
20
comment execute() vs executeQuery() in MySQL Connector C++
Yes, but suppose I have a "readOnly" flag in my program. If it is true, I am forbidden to make any change to the DB. So I would like to know if the current query can modify anything before running it.
Sep
20
comment execute() vs executeQuery() in MySQL Connector C++
OK, that works. Do you know if it is possible to know if any write operation will be performed before running the query itself? I need it in case I want to access the DB in read only mode.
Sep
19
asked execute() vs executeQuery() in MySQL Connector C++
Sep
14
accepted Can I use SQLite to share data among different applications?
Sep
14
asked Can I use SQLite to share data among different applications?
Jun
15
awarded  Scholar
Jun
15
comment Copying a database for testing in a safe way
Thank you Rolando!
Jun
15
accepted Copying a database for testing in a safe way
Jun
14
comment Copying a database for testing in a safe way
The size of the DB is roughly 50 GB.
Jun
14
comment Copying a database for testing in a safe way
Regarding foreign key constraints, since some of them are "CASCADE", others are unspecified, could be a good thing to make a dump of the whole DB, import this dump in a new DB, and then delete part of the records from there so that the constraints can be applied? (I still have to check the size of the DB itself, which should be a critical detail for any answer...).
Jun
14
comment Copying a database for testing in a safe way
I will check for any "DROP DATABASE" string. Could be there anything else that modifies/deletes anything else in the production DB, even a single bit?
Jun
14
awarded  Supporter