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

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


Jun
22
comment Column of generic/variable type?
@marc_s: The DB I am going to use will probably be PostgreSQL, but my question does not intend to be database specific.
Jun
15
comment Column of generic/variable type?
I put a BLOB in case I have to store, e.g., an integer or an image. Does it have issues with space in case of small data values?
May
20
comment How to put one table on one disk and anther table on another (a ramdisk)?
Yes, it seems to be the right solution.
Jan
23
comment Problem with nested UPDATE queries
@ypercube: I updated the question. Thank you.
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.
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
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.
Jun
15
comment Copying a database for testing in a safe way
Thank you Rolando!
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?