(Dru Lavigne) Tatsuo, from SRA OSS Japan, started pgpool as a personal project in June 2003; the global development group currently working on it was formed in February of 2006. It was created as at the time no general purpose connection pooling software existed and no small to mid scale light weigh
Tag: Open Source
Implementing Additional Methods with mysqli and PHP 5
(Alejandro Gervasio) Welcome to the third installment of the series “Using mysqli in PHP 5.” Comprised of three articles, this series teaches you how to use the most important methods and properties included in the “mysqli” extension, which is bundled with PHP 5, in order to get the most out of the
PostgreSQL Summit: Day 1
(Dru Lavigne) I’m in Toronto, Canada for the 10th anniversary of the PostgreSQL project. There are 131 attendees from 16 countries, many from the USA, Canada and Europe and some from as far away as Japan, China, Australia, Russia, and Turkey. PostgreSQL core is here: Bruce Momjian, Josh Berkus, Dave
MySQL to Draw Curtain on Older Databases
(James Niccolai) MySQL has published its first “end of life” timetable for its open-source database and will no longer provide free updates for some older versions of the product starting next month.
MySQL Cluster 5.0 ALTER TABLE In-Depth
(Martin Skold) In this Developers Zone article we take an in-depth look at how the ALTER TABLE command is implemented in MySQL Cluster 5.0.
Import and export data in MySQL
(Paul Dubois, Stefan Hinz and Carsten Pedersen) This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use MySQL to perform bulk data import and export operations. (R, pdf)
Functions (Sample Chapter)
(W. Jason Gilmore) Even in trivial applications, repetitive processes are likely to exist. For nontrivial applications, such repetition is a given. For example, in an e-commerce application, you might need to query a customer’s profile information numerous times: at login, at checkout, and when veri
Advanced MySQL Database Administration
(Paul Dubois) In some cases, you might want to run multiple mysqld servers on the same machine. You might want to test a new MySQL release while leaving your existing production setup undisturbed. Or you may want to give different users access to different mysqld servers that they manage themselves.
Implementing the commit() and rollback() Methods with mysqli and PHP 5
(Alejandro Gervasio) If you want to use the “mysqli” extension, you’ve come to the right place. This is the second part of the series “Using mysqli with PHP 5.” Welcome back. In three tutorials, this series shows how to use the most important methods and properties included in the “mysqli” extension
SQL Server vs. MySQL
(Serdar Yegulalp) Microsoft SQL Server is far from being the only database management system for Windows. Among SQL Server’s contenders are commercial applications like Oracle and freebies like MySQL. But free availability has left many people questioning how well an open source system stacks up aga