Entries Related to ‘PostgreSQL’

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.

The Walt Disney Internet Group created a language and IDE for use on its own websites. If you know Java, it might just be your cup of Tea.

A directory service stores information about users and other entities in a database that that you can use to simplify network management. Properly implemented, directory services such as OpenLDAP lessen the possibility of chaos and disorder on a large network.

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 Redmine project management system includes Gantt charts, a calendar, a roadmap, and other helpful features you can use to keep track of what’s going on with your software development projects.

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.

File Transfer Protocol (FTP), one of the oldest of Internet protocols, is still widely deployed, but it’s the protocol sysadmins love to hate. Back in FTP’s early days, the Internet was just a small network of computers where everyone knew everyone else, and FTP made little provision for security. Later revisions of the specification tried to add security features, but you can’t fix an amputation with a Band-Aid. Fortunately, as we’ll see, newer alternatives that are easy to deploy can replace FTP and provide the missing security.

Bugs in software are as difficult to avoid as death and taxes, which makes keeping track of known bugs an important task for quality-conscious developers. With many feature-rich open source bug-tracking programs available, choosing a suitable application can be a daunting task. The best bug tracking solution for your organization or project depends upon your specific needs and personal preference. Whether you’re new to bug tracking applications or a pro, small organization or large, you should find what you’re looking for in one of these open source bug tracker applications.

Nowadays, few enterprise websites run without PHP, the dynamic scripting language that serves as the “P” in the LAMP stack. Coding PHP applications is relatively easy thanks to the abundance of high-quality PHP frameworks available. Here’s a high-level overview of several of these open source frameworks, noting their scalability, maturity, licenses, and commercial support. While they may differ in many ways, they have one thing in common: they cost nothing to try and to use.

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.