Database replicata
I'm having few issues with the db (sqlite powered) behind this blog. So it's necessary to migrate it to another DBMS (like PostgreSQL). The problem is that SQLite is a bit too light :) Fortunately, Alinea is using SQLObject to manage its database. So migration is trivial and can be done using a little script which takes two db URIs and handle the data replication from a db to another.
#. phil on Wed Oct 6 17:36:03 2004
Since the blog appeared on PythonPlanet, it crashed twice ... because of sqlite.ProgrammingError .. So it appears that sqlite doesn't work well when the application is under heavy load (high number of requests)#. Jkx on Wed Oct 6 22:19:01 2004
In fact Alinea run on Webware + SQLObject. Webware use threads, and SQLObject is thread safe. But the sqlite DB python API isn't thread safe..
PyPi have quite the same issues. I really don't we should use sqlite if you should handle simultaneous requests.
#. Tim Lesher on Wed Oct 6 16:38:57 2004
What kind of problems are you having? I'm considering SQLite for a small project, and I'd like to hear about the downside.