Re: [Asterisk-Users] which DB to use? or Why Berkley DB vs. MySQL, etc
> 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] which DB to use? or Why Berkley DB vs. MySQL, etc
On Sun, 25 Jul 2004 11:24:09 -0400, Frank <[EMAIL PROTECTED]> wrote: > What are the criteria you use to select which DB to use with * > Built in DB1/Berkley DB > MySQL add in > Postgres > Unix odbc > Brian's dbodbc > > Beyond just having a relational DB or not. > > Performance? > DB size? > Ease of Access? > Portability? > Gui/browser access IMHO, there's only two (maybe 3) worthwhile options there. One is BerkleyDB. It's simple, it works, no extra work on your part. If you're going to be in a very active environment with LOTS of DB access going on, you go with options 2&3. MySQL or PostgreSQL. With regards to Asterisk, I'd say they're both about equal. It comes down to personal preference for the most part. If you prefer (or are already running) MySQL, use that. If you prefer (or are already running) PostgreSQL, use that. Other than that, I don't think there are really all that many other options. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] which DB to use? or Why Berkley DB vs. MySQL, etc
On Sunday 25 July 2004 11:24, Frank wrote: > What are the criteria you use to select which DB to use with * > Built in DB1/Berkley DB > MySQL add in > Postgres > Unix odbc > Brian's dbodbc If you don't need the relational aspects I'd probably use DB1/Berkely -- it's small, robust and works. odbc shoudl work for anything else -- I very much doubt you'll ever run into performance issues with * and odbc, and by not locking yourself into a specific DB you can always upgrade/try others. My fanatical side would choose postgres. :-) -A. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] which DB to use? or Why Berkley DB vs. MySQL, etc
What are the criteria you use to select which DB to use with * Built in DB1/Berkley DB MySQL add in Postgres Unix odbc Brian's dbodbc Beyond just having a relational DB or not. Performance? DB size? Ease of Access? Portability? Gui/browser access ... Any comments on how to bring this all into focus? ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users