David Fetter's blog

My little place on the web...

Where I Work

PostgreSQL Experts, Inc

Wednesday, March 10. 2010

Free Your DBI-Link, and the Rest Will Follow

DBI-Link is now on Github!

Here's how I did it: Continue reading "Free Your DBI-Link, and the Rest Will Follow" »
Posted by
David Fetter
at 19:46 | Comments (0) | Trackbacks (0)

Wednesday, March 3. 2010

Git + bash = win

Modern git comes with a great way to improve your life: git-completion.bash. To use it, just add the following to your .bashrc:

if [ -f /etc/bash_completion ]; then

    . /etc/bash_completion

    export PS1='\h:\u:\w $(__git_ps1 "(%s) ")'

fi

Once you've done this, any time you're in a git subdirectory, the branch name will appear in your PS1.
Any time you're not, it won't.
Simple!
Posted by
David Fetter
at 20:38 | Comments (2) | Trackbacks (0)

Monday, March 1. 2010

Scripting psql for Fun and Profit

Profit?

Yes! Continue reading "Scripting psql for Fun and Profit" »
Posted by
David Fetter
at 23:09 | Comments (0) | Trackbacks (0)

Friday, February 19. 2010

Part(ition)ing Is Such Sweet Sorrow

There are excellent references on partitioning tables that depend on one table, but what happens when you need to partition the referenced table?

Let's find out! Continue reading "Part(ition)ing Is Such Sweet Sorrow" »
Posted by
David Fetter
at 06:21 | Comments (0) | Trackbacks (0)

Sunday, February 7. 2010

PostgreSQL Weekly News vs. Casa Donde

This week's PostgreSQL Weekly news may be rescheduled to Wednesday February 10, evening PST.

Thanks very much to whatever component failed at my home for this.
Posted by
David Fetter
at 11:32 | Comment (1) | Trackbacks (0)

Friday, February 5. 2010

FOSDEM Starting

The herd of blue elephants is gathering for FOSDEM, including several talks in the main track.

I'd like to thank the FOSDEM for making it possible for me to attend this year.

More on this soon...
Posted by
David Fetter
at 09:10 | Comments (0) | Trackbacks (0)

Monday, February 1. 2010

Adding Only New Rows (INSERT IGNORE, Done Right)

Let's say you have a table and a data set, and would like to add only those rows in your data set that aren't already in the table. There are hard ways, but here's an easy one. Continue reading "Adding Only New Rows (INSERT IGNORE, Done Right)" »
Posted by
David Fetter
at 05:04 | Comments (11) | Trackbacks (0)

Saturday, January 30. 2010

ORDER BY column_header

Ever wondered why you can't "just sort" by column when you're looking at an HTML table? Continue reading "ORDER BY column_header" »
Posted by
David Fetter
at 21:02 | Comments (0) | Trackbacks (0)

Wednesday, January 27. 2010

PL/Parrot Needs a Logo

The PL/Parrot Project, long dormant, is shaking off its sleep.

The virtual machine for dynamic languages meets the dynamicest of RDBMSs. Good things are coming soon! Continue reading "PL/Parrot Needs a Logo" »
Posted by
David Fetter
at 00:51 | Comment (1) | Trackbacks (0)

Tuesday, January 5. 2010

Clearing "Commercial" Confusion

According to Webster's first set of definitions, "commercial" means:

  1. occupied with or engaged in commerce or work intended for commerce
  2. of or relating to commerce
  3. characteristic of commerce
  4. suitable, adequate, or prepared for commerce


What's not in that definition?
Continue reading "Clearing "Commercial" Confusion" »
Posted by
David Fetter
at 18:45 | Comments (2) | Trackbacks (0)

The M word

No, it's not the sequel to that wildly popular television show.

It's not some former Swedish company either. It's Continue reading "The M word" »
Posted by
David Fetter
at 07:25 | Comments (3) | Trackbacks (0)

Saturday, December 19. 2009

Trip Detector

Yes, it's an amazing technology. The DSL modem, or some other vital
network component, at my house tends to malfunction some short time
after I leave on any given trip, taking my personal email down with it.

The likeliest result, this time, is that the PostgreSQL Weekly News
will be late this week. I would like to apologize in advance to
readers for the delay.
Posted by
David Fetter
at 00:20 | Comment (1) | Trackbacks (0)

Tuesday, November 24. 2009

Pre-OSDC

Thanks to the Brisbane PHP/MySQL User Group for a lovely evening.

First, we... Continue reading "Pre-OSDC" »
Posted by
David Fetter
at 16:07 | Comments (0) | Trackbacks (0)

PostgreSQL Conference Japan...and onward

Finally, the people doing all kinds of clustering in PostgreSQL have met and sketched out the issues.
Expect great things to come from this...

And that was before the official conference even got started.

Thanks to all the people who made the JPUG 10th Anniversary great! Continue reading "PostgreSQL Conference Japan...and onward" »
Posted by
David Fetter
at 16:03

Monday, November 16. 2009

Removing (Much of) the Suck from ORMs

It really isn't terribly complicated, but the reasoning is a bit subtle. Continue reading "Removing (Much of) the Suck from ORMs" »
Posted by
David Fetter
at 16:54 | Comments (2) | Trackbacks (0)
(Page 1 of 4, totaling 54 entries) next page »

Archives

Syndicate This Blog

Blog Administration

Open login screen