Entries Related to ‘Database’

MySQL isn’t the only mature and feature-rich open source database; rival PostgreSQL can be an equally good choice. And if you know how to manage MySQL, you can learn how to handle PostgreSQL fairly quickly.

One great advantage of open source software is that you can modify your applications’ code to customize it for your needs. If your application uses PostgreSQL on the back end, it’s not hard to access your database from a variety of languages. Here’s how to get started, whether your code is in C, C++, PHP, Tcl, Python, or Perl.

The PostgreSQL relational database management system (RDBMS) extends the standard SQL3 it implements with several conveniences for application development. Among the most useful extensions are window functions, which perform a calculation across a set of table rows that are somehow related to the current row.

By using MySQL replication, you can distribute MySQL queries over multiple servers to improve application performance, provide high availability (HA), and distribute data across diverse physical locations. The process involves one or more master servers, which send databases or tables asynchronously to slave servers.Follow the advice here to get off to a healthy start.

When you’re choosing a database, you’re making a long-term decision, because changing your mind later is difficult and expensive. You want to get it right the first time. Two popular open source databases, MySQL and PostgreSQL, are often the final two candidates when admins are preparing a new rollout. This high-level overview of these two open source powerhouses should help you choose which is more appropriate for your needs.

Database programmers and administrators often need to design SQL queries against database structures with which they’re not intimately familiar. By using a visual query designer, programmers and admins can cut down on coding errors and save time. FOSS tool phpMyAdmin offers a simple builder that can help anyone design MySQL queries. Here’s how to get started designing basic queries visually in phpMyAdmin

While you can install any software on the Linux desktop with just a couple of mouse clicks, enterprise apps are a different story, because they require a lot of infrastructure software, from high-end web and database servers to basic libraries. As a system administrator you may spend hours putting together components before you can deploy an app on the network. Fortunately, some convenient software tools can do the grunt work for you.

Use this comparison matrix to learn about the differences between – and relative benefits of – the popular open source databases MySQL, PostgreSQL, Derby and H2 Database Engine (H2DB).

MySQL 5.1 GA has been released with a number of new features and performance enhancements…