[Asterisk-Users] which DB to use? or Why Berkley DB vs. MySQL, etc

Holger Schurig hs4233 at mail.mn-solutions.de
Mon Jul 26 00:37:39 MST 2004


> only two (maybe 3) 

And then you mention:

* BerkleyDB
* MySQL
* PostgreSQL

I'd add, after Berkley DB, but before the "real" SQL databases

* SQLite

SQLite allows databases with no setup, without any server processes 
running, with a good selection of SQL. You don't need to mess with users 
and access right, as with BerkleyDB, you simply use the access rights and 
users of the underlying OS/File system. And yet it's transactional and 
ACID as the more bigger solutions, which also need more setup and 
handholding.

Also, SQLite is twice as fast as MySQL :-)



http://www.sqlite.org




More information about the asterisk-users mailing list