*** 69,74 **** --- 69,81 ---- _:::: This doesn't really make a lot of sense for an embedded database. + _::::: I could use this. Im trying to use sqlite as a 'fake database' + that i can use in testing suite. For sqlite to be a good 'fake' of + something like Oracle it would help a lot if it had the ability to do stuff + like 'select * from blah.PERSON'. In this case the 'blah' is the schema name. PERSON is the table name. Another example: 'select zipcode from blorg.ADDRESS'. blorg is the schema name, ADDRESS is the table name. + right now it is giving 'no such database as blah' or 'no such database as + blorg'. i try to 'create database blah' but of cousre that doesnt work either. + *: TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command) - _SQLite does this automatically when you do a DELETE without a WHERE clause. You can use also VACUUM command_
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|