Managing Many-to-Many Relationships with PL/pgSQL (17 tags)
SQL gives you plenty of options for handling relationships--you can use joins and database relations, or you can make multiple queries and write complex logic on the client. What are the benefits and drawbacks of each? David Wheeler recently experimented with moving complex relationship logic into PostgreSQL's PL/pgSQL language; the results were stunning.
Writing PostgreSQL Functions with PL/pgSQL (11 tags)
One of the most powerful features of PostgreSQL is its support for user-defined functions. The language to learn is PL/pgSQL, an unpronounceable but powerful way to write UDFs. David Wheeler introduces the language and demonstrates why UDFs are useful.
Datamining Apache Logs with PostgreSQL (8 tags)
System log files encapsulate a wealth of information for administrators and developers. Teasing that data out of the logs into a format that reveals patterns may be a challenge, though. Robert Bernier shows how to parse, store, and query Apache httpd log data from PostgreSQL to find useful information.
Introducing Slony (8 tags)
Slony is an experimental new feature intended to introduce powerful replication to PostgreSQL. It's a complicated problem, though. Elein Mustain introduces the Slony project, its aims, and the goals of Slony-I, the first milestone.
Batch Updates with PL/pgSQL (8 tags)
Loops are slow, algorithmically speaking. Every time you find yourself looping over data, you have a process that, at best, scales linearly with the number of items to process. SQL gives you options to perform multiple updates at once; David Wheeler demonstrates how to make them work with PL/pgSQL.