I just use the sqlite3 command line interface to do small work, and for larger things I use the PHP PDO package to access the db. Sqlite has programming interfaces for a number of common languages. It's true that intensive work will intermittently lock the db for others, as sqlite3 uses file locking to ensure integrity, but it's very easy to write your code so that the lock is only for a short time. The usual way of dealing with a db lock is to merely retry the operation. You do not have to leave the db to unlock it, just have the select or update or whatever transaction you are in end.
Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 [email protected] www.aiminstitute.org ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Scott Mead Sent: Sunday, January 10, 2010 10:16 AM To: [email protected] Subject: Re: [Trac] Access the SQLite database outside Trac On Sun, Jan 10, 2010 at 2:59 PM, pederalm <[email protected]> wrote: I'm used to MySQL. With MySQL (like many db engines) you can access the db outside the server where the db engine is installed using a db client and a SQL command. I want to access the SQLite db in that way, but I don't know if it works. Does it? Or is there any other way to access the db? Or do I have to change the Trac db engine to MySQL? You can do that, BUT if you are doing writes to the database, nobody else can read from it at the same time. So your trac and reporting program will 'bump' into each other. If you have the ability to switch to mysql or postgresql and you think it's worth the effort, I'd personally say go for it. It will make things much easier if you're going to be doing a lot of data-intensive work. --Scott--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
