Considering a database for your project

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.

 

2 Responses to “Considering a database for your project”

  1. auto shipping companies Says:

    Thanks on your marvelous posting! I certainly enjoyed reading it, you’re a great author.I will remember to bookmark your blog and will often come back down the road. I want to encourage that you continue your great work, have a nice holiday weekend!

  2. source Says:

    Do you have a spam issue on this website; I also am a blogger, and I was questioning your scenario; weve got developed some great approaches and were searching to trade options with other individuals, be positive to blast me an e-mail if serious.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>