Databasesoup - databasesoup.com - Database Soup
General Information:
Latest News:
PostgreSQL plus Vertica on Tuesday: SFPUG Live Video 24 Aug 2013 | 04:11 am
This upcoming Tuesday, the 27th, SFPUG will have live streaming video of Chris Bohn from Etsy talking about how he uses PostgreSQL and Vertica together to do data analysis of Etsy's hundreds of gigaby...
Fancy SQL Monday: ON vs. NATURAL JOIN vs. USING 13 Aug 2013 | 04:44 am
First, there was the SQL89 JOIN, where there was no JOIN statement, and joins were performed by adding WHERE clauses. To wit: SELECT users.name, count(*) FROM users, comments WHERE users.user_id = c...
Another reason to set pg_hba.conf restrictively 9 Aug 2013 | 05:55 am
pg_hba.conf can be a pain in the neck. You're expecting some burst traffic, you deploy 8 new virtual appservers, fire them up, and ... they can't connect to Postgres. Gah! That kind of experience m...
Speaker Boot Camp at LinuxCon 7 Aug 2013 | 08:54 am
Are you technically expert but locutionarily inept? Are you giving your first or second talk this year? Do you present frequently, but don't feel like you're "connecting" with your audience? Are yo...
Fancy SQL Monday: generate_series() and cross joins 6 Aug 2013 | 08:22 am
So, here's the situation: you want to create a report which shows totals of registrations by day and by category, and shows zeros for each day and category you don't have any registrations for. Your...
9.4 Commitfest 1 Wrap-up 2 Aug 2013 | 05:30 am
The first CommitFest of the 9.4 development cycle involved an unprecedented number of patch submissions. As of today, 9.4CF1 is still open because of one patch which apparently only Tom Lane can comm...
Dimitri talks about Skytools tonight at SFPUG 18 Jul 2013 | 11:32 pm
Tonight's SFPUG will feature visiting contributor Dimitri Fontaine talking about Skytools3. Assuming we can make it work, live video will be available on the SFPUG video channel starting at 7:20PM PD...
Accidental DBA and More at OSCON next week 17 Jul 2013 | 12:02 am
O'Reilly OSCON is next week, and I'll be attending for the first time since 2009. I'll be teaching the Accidental DBA tutorial, for which I've just uploaded the preparation materials. There's also l...
Kyoto Tycoon FDW for Postgres 10 Jul 2013 | 03:04 am
The cool folks at Cloudflare, next-generation CDN for web applications, have created a Foreign Data Wrapper (FDW) for Kyoto Tycoon. This lets them distribute cache content across their network while ...
Connection Pooling vs. Persistent Connections 10 Jul 2013 | 02:51 am
The distinction between connection pooling and persistent connections recently came up again with a client, and I realized that there's a significant amount of confusion in the industry due to decepti...
