Blog

Headed to Utah Open Source Conference

The Utah Open Source Conference is coming up next week and I will be speaking on PostgreSQL. The presentation I was selected to give is my Dumb Simple PostgreSQL Performance talk.

This talk aims to solve the performance (and maintenance) problems most associated with a default install of PostgreSQL. The depth of the talk is limited and is designed specifically for people who are *not* database people, e.g; Web Developers …

MySQL does what? (Division by integers and 0)

I was sitting in #postgresql today (no not the twitter, the irc) talking to some of the community peeps and I came across this tidbit. MySQL casts integers to float before division[1]. Say what?

mysql> SELECT 3/5;
        -> 0.60

To be honest, I can't fault MySQL for this behavior. It falls in line with the MySQL mantra of make it easy, not "necessarily" correct. A division of 3/5 in a …

PGXN: Are you a benefactor?

O.k. so I have been pushing on everyone I know to support PGXN. Command Prompt, (you know, us) hadn't bothered to donate. Mainly we hadn't donated because we wanted to be a founding sponsor but just didn't have the budget for it, with the whole PostgreSQL Conference thing going on.

Today, we put our money where our rather obnoxious mouth is and became a benefactor (at the tune of …

PgWest 2010: Talk Descriptions are up

The talk descriptions for PgWest 2010 are now up. As you can see, there is a lot of content that will be presented over the three days. There is a great mix of developer and user (DBA) content. If you haven't done so already, now is the time to register.

PgWest, have you booked your room?

If you have not booked your room for PgWest, now is the time. There is a very real possibility that the cost of the hotel will go up in the next week. Now is not the time to be a traditional geek procrastinator.

Oracle MySQL increasing support pricing

Oracle MySQL recently started sending letters to their current clients about upcoming price changes[1]. It is certainly expected that Oracle would increase pricing, but I wonder by how much?

Oracle owns another fairly well known Open Source database, BerkeleyDB. The pricing for BerkeleyDB. suggests that MySQL may be in for a culture shock. MySQL appears to have removed their support pricing from its website (a move that should not provide …

Break out your credit card, support #PGXN

PGXN is the stuff. It is going to enable a whole new ecosystem of software for PostgreSQL complete with easy install, easy search, modular design and yeah unfortunately Perl.

That said, it is time to pony up. David Wheeler has put in some serious effort, well thought out, professionally designed and peer reviewed effort on delivering a new architecture for PostgreSQL software and modules. He needs our financial support.

Go …

Interviewed by Linux.com

So, I broke down at purchased my Linux Foundation membership. Shortly thereafter I was requested to be interviewed. Here it is.

PgWest 2010 Early Bird Registration Open!

We are still finalizing the three days of content but the first tutorials of the conference have been accepted and early bird registration is now open.

Tutorials:

Test Driven
Database Development
Building an Open Geospatial Analysis Technology Stack
Normalization Workshop
GUCs: a Three-Hour Tour
Django and PostgreSQL

Mini-tutorials:

PostgreSQL Backup and Recovery Methods
MVCC Unmasked
The PostgreSQL Query Planner
Writing C Functions and C User Defined Types on Windows Using …

Is your PgWest 2010 presentation submitted?

One of the aspects of the Open Source community I love is the agile, on demand nature of getting things done. If a feature is missing, you can just add it and you can add it on demand, as you need it. If a bug is present, you can fix it yourself or pay someone else like CMD to fix it for you.

Unlike other communities that are closed where …

Postgres and Open Source Experts

Headed to Utah Open Source Conference

MySQL does what? (Division by integers and 0)

PGXN: Are you a benefactor?

PgWest 2010: Talk Descriptions are up

PgWest, have you booked your room?

Oracle MySQL increasing support pricing

Break out your credit card, support #PGXN

Interviewed by Linux.com

PgWest 2010 Early Bird Registration Open!

Is your PgWest 2010 presentation submitted?

Recent posts

Privacy Concerns and Risks with Slack's AI and ML Training

The Essential

PgManage 1.0 Released

Less is More

Getting Started with pgBackRest: Perform Your First Backup

The Importance of Language

PgManage 1.0rc1 released