SQLite Database Usage Problems
Posted: Thu Jun 11, 2009 8:40 am
After several hours of playing with sqlite I am struck by how seemingly incompatiable the available editing tools are.
If I create a sqlite db using the sqlite manager firefox addon in firefox, the db is usuable from a PHP script or sqlite3 cmd line interface.
If I create a sqlite db using the sqlite cmd line interface , the db is usuable from a PHP script or sqlite manger interface.
If I create the db from within a php script, similarly the cmd line interface and sqlite manager for firefox think the db is junk.
So depending on the medium of creation, that seems to dictate usage.
Yes, I can persist with one method 'scripting from php', however I had assumed I could perhaps use the sqlite manager gui in firefox to design a schema, push a stack of data at the db from a php script, then do a bit of analysis from the cmd line tool. All seemed very logical, and a neat solution, however I am not sure why I may be experiencing this behaviour from sqlite.
I am using win xp.
Any feedback as to why this is so, would be greatly appreciated. Kind regards, Andrew
If I create a sqlite db using the sqlite manager firefox addon in firefox, the db is usuable from a PHP script or sqlite3 cmd line interface.
If I create a sqlite db using the sqlite cmd line interface , the db is usuable from a PHP script or sqlite manger interface.
If I create the db from within a php script, similarly the cmd line interface and sqlite manager for firefox think the db is junk.
So depending on the medium of creation, that seems to dictate usage.
Yes, I can persist with one method 'scripting from php', however I had assumed I could perhaps use the sqlite manager gui in firefox to design a schema, push a stack of data at the db from a php script, then do a bit of analysis from the cmd line tool. All seemed very logical, and a neat solution, however I am not sure why I may be experiencing this behaviour from sqlite.
I am using win xp.
Any feedback as to why this is so, would be greatly appreciated. Kind regards, Andrew