Thread: sqlite3 GUI?
View Single Post
Posts: 529 | Thanked: 46 times | Joined on Sep 2007
#2
Originally Posted by bizshop View Post
I've got sqlite3 running fine from commandline. However using php on n800 through browser, it appears to not work because db written/used are old sqlite2 format

Does anybody know of another way than PHP tto have browser HTML form feed into sqlite3 database? Even a non-browser GUI would work, where you don't have to manually remember fields and type in complete SQL syntax each time I want to add items?

I have faint memories of ptograming input screens in basic, but...
To parse html form need you need to install Apache www server.
Python stand-alone application seems to be a nice solution.
I am just trying to write my own to inject data into POI database.
It make take me 2 days to write a test application as I am novice to Python and sqlite3 is a downgraded MySql database and not every function works.
There are extensions to sqlite3 to make it work like MySQL but code is long and to much complicated for me to use.

Darius