*** 3,14 ****
features that SQLite does not support, you may want to list them
below.
----
! *: This is related to using SQLite with are many attached
! databases. For example, I want create table in the database db1, based
! on the table in the database db2:
! create table db2.table1 as select * from db1.table1;
! It doesn't work. But very often it will need.
! So, it should looks like a schemas in ORACLE database.
*: Hierarhical Queries. START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)
--- 3,10 ----
features that SQLite does not support, you may want to list them
below.
----
! *: Multiple databases are not supported. For example, the following construct for creating a table in a database db1 based on a table in database db2 won't work: create table db1.table1 as select * from db2.table1; But I often need this. So, it should looks like a schemas in ORACLE database.
! Comment from a second user: The documentation under {link http://sqlite.org/lang.html#expr Expressions} allows for database names. I'd be happy enough if that could work somehow (even so, I don't see how the current PHP 5RC would allow for it). [My particular context being that one database of Users, say, belongs in one place (file) logically, while each type of service might have its own separate database, no problem. But complicated queries against this type of 'separate databases system' run into severe issue under the current scheme.]
*: Hierarhical Queries. START WITH <conditions> CONNECT BY [PRIOR]<conditions> (ORACLE)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|