*** 4,9 ****
--- 4,15 ----
SHOW TABLES
Or how do I find out what tables does a SQLite database have?
+ A) It's not as simple as "show tables", but it does work:
+
+ SELECT name FROM sqlite_master WHERE type = "table"
+
+ I guess you could create a view to simply frequent querying.
+
------
Q) Are there any plans for Concurrent Queryes Improvements on SQLite??? I mean, when i'm hipotetically inserting 100000 records in a table throguht a PHP PDO Query, and i try to access this table for a simply query like (select * from table where id = 1), SQLite returns a message that the table is locked. Are there any research for this? Is there a active project roadmap?
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|