Bruno Desthuilliers wrote:
> Greg Dickie wrote:
>> I'm using postgres. Is it much much better than SQLite?
> 
> Depends on what "better" means to you. SQLite is a lighweight embedded
> database, PostgreSQL is one of the most powerful and reliable existing
> RDBMS. From a purely technical POV, Postgres obviously beats SQLite
> hands down.

Define "purely technical" -- SQLite is pretty good as embedded engines
go. The very top link on SQLite website is to the document describing
pretty clearly where and why you should or should not use SQLite.

The "should not" part, specifically, mentions high concurrency (i.e.
frequent "database locked" errors) and scalability (for a long-running
project with huge number of tickets Postgres is likely to perform better).


Dima

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to