Posts tagged with "postgresql"

"Emacs brings REPL-driven development to SQL using sql-mode, so you can have a SQL buffer running and send commands to it. Today however sql-mode didn’t show a prompt when connecting to my local dev database. It turns out that sql-mode has a regexp looking for the prompt, which expects the database name to be all alphanumerics for some reason. It seems to be fixed but is not in the version I get from Arch Linux."

"My suspicion that Sun will not continue to support PostgreSQL after purchasing MySQL was unfounded: From Jonathan Schwartz blog:: What happens to your commitment to PostgreSQL? It grows. The day before we announced the acquisition, and within an hour of signing the deal, I put a call into Josh Berkus, who leads our work with Postgres inside of Sun. I wanted to be as clear as I could: this transaction increases our investment in open source, and in open source databases."

"There is one thing that strikes me in the Sun MySQL thingy - what about Sun’s previous commitment to PostgreSQL, where they say stuff like: “PostgreSQL for Solaris 10 is the open source enterprise database platform of choice”? Tim Bray comments on the deal and totally dismisses any alternatives: MySQL, you know, in my experience, it, well, Just Works. Runs great on our hardware and OS. Well, OK, GNU/Linux too. What else is there?"

"I just noticed that the mapping between PostgreSQL’s Time Without TimeZone column type maps to Rubys standard Time class. Which gives the following behavior in script/console: :::ruby >> t = TimeEntry.find(1) >> t.time => Sat Jan 01 23:00:00 +0100 2000 >> t.time = Time.now => Wed May 09 19:02:07 +0200 2007 >> t.save => true >> t = TimeEntry.find(1) >> t.time => Sat Jan 01 19:02:07 +0100 2000 Am I very anal to find this … sloppy?"