Eric Hodel

witness the destruction of mysql (read all 3 entries…)
Rewrites 4 years ago

I just rewrote all our in-code SQL queries to be easily recognizable. They now all live in

FOO = <<-SQL
    SELECT blah
    FROM there
    WHERE x = 1
SQL

This will help us with moving away from MySQL.

Bob has also been exploring Postgres performance, but his results are preliminary

Jul 15, 2005, 03:45PM PDT


Comments:

bravenewlinda

move away from MySQL already?
but but but..

I just learned it not too long ago? It hasn’t even been a year yet.

Jul 17, 2005, 02:11PM PDT | Thread | Respond to this

Eric Hodel

MySQL scares me

It does funky things with your data if you don’t bother to read the manual.

I also ran into a really nasty threading bug in MySQL that doesn’t let it be as performant as it should be. (It ground to a halt by locking against itself.)

Once you know SQL, it only takes a few extra minutes in the manual to learn new parts for a new platform.

Jul 17, 2005, 02:25PM PDT | Respond to this

(This comment was deleted.)

Sep 01, 2006, 10:15PM PDT

Eric Hodel

I don't know

Its something I’d like to forget as much as possible.

Postgres is much better, especially because its console doesn’t quit if you press ^C. The Postgres console also has interactive help and tab-completes everything.

Much, much, much better user experience.

Sep 02, 2006, 04:23PM PDT | Thread | Respond to this

(This comment was deleted.)

Sep 03, 2006, 07:44AM PDT


 

I want to:

The world wants to...

Start my own business live go to nursing school vote Volunteer work on my monologues until they are brilliant and solid Design my dream house funniculee wants to eat healthily drive across the country watch forrest gump be in love relax get in shape have adventures instead of relationships enjoy every day fall in love with someone who loves me too Work out 3 times a week love unconditionally. legalize marijuana Karles wants to Be a better friend write a book and have it published fall in love again get somebodys bebo password win the lottery Pick a theme song for myself raise my son to not be afraid to try new things Let go of the past
43 Things Login