I have been googling a few hours for a decent tutorial on how to setup an SQLite database (with user & password). The documentation at the SQLite site is unsatisfactory. From some links, I have learned you have to create a /usr/local/sqlite/var directory where the databases are stored. I also have learned about an sqlrelay.conf file. I didn't learn where that file should be stored. I couldn't figure out how to populate a database.
A while ago, I posted a topic asking about a PostgreSQL tutorial. That tutorial was simple & helpful. With PostgreSQL, all I need is these 3 commands to setup a database:
su - postgres
createuser username -P
createdb databasename -O username
I am hoping someone could provide an SQLite tutorial about what commands to use, directories & files to create and where to create or store them. Thanks.
You may have read this already, but, here's a Howto:
http://umn.dl.sourceforge.net/sourcefor … orial.html
You may have read this already
Yes, but from another link. Like many other links I have seen, it doesn't mention creating a user and password. It doesn't say how or from where the created database will be accessed from, say, a forum (like punBB) or cms. Thanks anyway.
My understanding is: the db file is created where you specify it.
the above creates teh test.db file in the current directory, if it does not already exist.
I would assume that permissions are based on whether or not the file is read/write, much like the *dbm database systems.
"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍