At the Forge - PostgreSQL 9.0
Am I gushing? Yes, absolutely. There are very few pieces of software that give me such pleasure to use and on which I feel I can utterly depend, and PostgreSQL is a select member of that club. It keeps my data safe, offers me a huge number of features, allows me to extend the database in whatever ways I want and need, and it gives me excellent performance with a modest time investment. If you're thinking of switching to an open-source database, or if you have already been using one and want to try something powerful but still rather easy to use, you would do well to try PostgreSQL. Especially with the latest features added in version 9.0, I'm sure you'll find something to like.
The home page for PostgreSQL is www.postgresql.org. From that site, you can download the software, subscribe to a number of (heavily trafficked and extremely friendly) e-mail lists and read through the documentation. There is also a #postgresql IRC channel on Freenode that is generally populated and available for answering questions.
One of the best-known commercial PostgreSQL support and product companies, EnterpriseDB, provides binary packages for a number of operating systems at its Web site, enterprisedb.com. It also offers a number of video and audio podcasts and screencasts, including those by PostgreSQL core contributor Bruce Momjian, which are of high quality.
Finally, two excellent books about PostgreSQL recently were published by Packt Press, filling in a long gap since the excellent (but outdated) PostgreSQL, 2nd edition was written by Korry Douglas a number of years ago. The two new books are PostgreSQL 9 Administration Cookbook by Simon Riggs and Hannu Krosing, and PostgreSQL 9.0 High Performance by Gregory Smith. I have learned a great deal from both books, and although the latter book spends a bit more time than I might have liked on hardware, it also taught me that even a software guy like myself occasionally needs to consider the physical side of software and database design. If you use PostgreSQL on a regular basis, I strongly recommend these books.
Reuven M. Lerner is a longtime Web developer, architect and trainer. He is a PhD candidate in learning sciences at Northwestern University, researching the design and analysis of collaborative on-line communities. Reuven lives with his wife and three children in Modi'in, Israel.
Web Development News
|Making Linux and Android Get Along (It's Not as Hard as It Sounds)||May 16, 2013|
|Drupal Is a Framework: Why Everyone Needs to Understand This||May 15, 2013|
|Home, My Backup Data Center||May 13, 2013|
|Non-Linux FOSS: Seashore||May 10, 2013|
|Trying to Tame the Tablet||May 08, 2013|
|Dart: a New Web Programming Experience||May 07, 2013|
- RSS Feeds
- Making Linux and Android Get Along (It's Not as Hard as It Sounds)
- New Products
- Drupal Is a Framework: Why Everyone Needs to Understand This
- A Topic for Discussion - Open Source Feature-Richness?
- Home, My Backup Data Center
- Validate an E-Mail Address with PHP, the Right Way
- Trying to Tame the Tablet
- Tech Tip: Really Simple HTTP Server with Python
- New Products
- git-annex assistant
4 hours 11 min ago
- direct cable connection
4 hours 33 min ago
- Agreed on AirDroid. With my
4 hours 43 min ago
- I just learned this
4 hours 47 min ago
5 hours 18 min ago
- not living upto the mobile revolution
8 hours 9 min ago
- Deceptive Advertising and
8 hours 44 min ago
- Let\'s declare that you have
8 hours 45 min ago
- Alterations in Contest Due
8 hours 46 min ago
- At a numbers mindset, your
8 hours 48 min ago