If you are a novice in voip switch with advanced skills in computer administrator, hosting websites for your relatives and small clients, then you must know pros and cons of database engines available to the market:
- MySQL - fast and robust client-server engine with dedication to FAST read access. Nice support and wide community.If you run a VoIP switch you may consider to plan your structure ahead, because MySQL not in favour of often UPDATE/INSERT operations. You may want to code a lot of PHP glue around your ideas. Backup often!
- PostgreSQL - slow but powerful client-server engine. Slow learning curve but exceptional capabilities.
- SQLite - smallest database file-bases engine. I prefer to unload some data to SQLite and process queries (like quick-and-dirty statistics on intraday operators performance) without disturbing the major production database.
- Microsoft Access of Microsoft Office fame - a basic instrument for office user (client manager). Useful addiction to Microsoft Excel everyday work. You may easily match two pricelists with thousands of destinations using SQL language and visual forms.