Gilles Ganault wrote: > > So the options are: > 1. use the old SQLite2 sqlite_() functions (or some class that turns this > into OO) > 2. PDO to use the SQLite3 linked-in library > 3. PDO to access the SQLite3 DLL > > ... with 2 being the recommended choice. >
I'm new to sqlite (started to play with it something around two days ago) but I already stumbled on some gotchas that I'd like to warn you about. If you work with sqlite and php under linux and you want to issue queries that change database (like UPDATE) your database file must be writable by server, and also directory where this file is located must be writable by webserver. Otherwise you are gonna get cryptic error "SQL logic error or missing database" that hardly indicates what is wrong. -- View this message in context: http://www.nabble.com/-Linux-%2B-PHP--Recommended-way-to-access-SQLite--tp14244097p14899825.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
