Database
Installation and configuration of the popular Open Source database servers. For all of the database engines below, I can help you select the right one for your needs (now and in the future), install, configure, and test it, and then create the permissions and tables for your application, perhaps porting over your data from a different server.
MySQL is the most common database server you'll find on commercial ISP hosting platforms. It's fast, has a rich feature set, and works really well with PHP, Perl, and other programming languages. It's your best all-around solution.
PostGreSQL is the most robust and feature-rich database server you'll commonly find. Consider it for larger installations where complicated table operations are required. But for most applications MySQL will do the job handily.
SQLite is a newer, very small-footprint database. Not a server at all, it requires no daemon running and uses no resources when you're not accessing it. Data is stored in a single file in your own directory space, so it's easy for you to back up. SQLite is ideal for small applications where you only need one or two tables and won't be doing any hairy table joins, etc. One set of tests showed SQLite to be about 2x faster than MySQL, and that means less load on your server.
search
