PostgreSQL: An elephant wearing a hula skirt and I find it sexy
27 comments Latest by replica watches Mon, 30 Aug 2010 08:28:29 GMT
Last week, I gave a live presentation to ~250 people, which was basically me walking through the process of using Ruby on Rails to talk to a legacy database1. For my example, I used the Dell DVD database... the PostgreSQL version. You can review some comments about my presentation by reviewing this entry on the blog of Ryan Davis. I wrapped quite a bit of the database in a few minutes and then showed what another 45 minutes of work could do with Rails. I’ll tarball that code and post it online soon.
Alex Bunardzic found it practical. I’ll take that as a compliment. ;-)
Earlier, I noticed this blog entry by Chris… where he said, “PostgreSQL also seems to be growing more briskly among the database category, while MySQL declines modestly. I guess that’s good news for Robby.” What exactly made me happy? This bullet made by Tim O’Reilly on Radar in his post, State of the Computer Book Market, Part 2.
“A surprise to many may be the strong growth of PostgreSQL, up 84% over a year ago. We’ve also been hearing some signs of growth in the Postgres market from our “alpha geek” radar, with reasons given including better support for geo data, and better handling of very large data sets. New companies like Greenplum and EnterpriseDB have also brought a little focus to this market. We’re updating our PostgreSQL book, and watching this market closely.”
That’s awesome! Go PostgreSQL!
Then to my surprise, I was contacted by CRN (again) to get my thoughts on MySQL’s awesome storage-engine plugin system... which showed up a few hours later in this article. The writer of that article managed to goof my last name (Robby Hill?)... and hopefully that gets resolved soon. ;-)
As I said at Canada on Rails in front of 250 people, “I find databases… sexy.”
(free desktop wallpaper!)
Why Rails? Why PostgreSQL?
Rails.. that’s a no-brainer.
PostgreSQL? Well.. they have compatible licenses… no dual-license smell when your trying to sell your application as a complete solution… and as Rails is database agnostic... there is no reason not to give PostgreSQL a try.
Who uses PostgreSQL on Rails?
- CDBaby
- Shopify
- PLANET ARGON (on almost every project we work on…)
- you…?
If your using PostgreSQL on Rails… email me... I’d love to hear and share your story on my O’Reilly blog, like I did with Derek Sivers and Jeremy Kemper of CDBaby a few months ago, which you can read here.
again… I find databases sexy...
If your a PLANET ARGON hosting customer… you can follow these instructions to install PostgreSQL on your PLANET ARGON hosting account.
1 According to the Rails convention (and by me)... any database created pre-Rails or doesn’t follow the conventions is considered legacy. ;-)
Enjoying the content? Be sure to subscribe to my RSS feed.
Guess that makes you an “alpha-geek”?
You guys at PA are the ones who turned me on to Postgres – so I owe you a big thank you! Glad to hear your talk went well.
For me, both Rails and PostgreSQL are no-brainers. I use them for every project I can, and would recommend them to anyone interested in web development. :)
I’ve been a PostgreSQL administrator for almost 4 years now, and I love it. Our “Enterprise” applications support 1000+ users and large datasets, which PostgreSQL handles just fine.
My team works in a very agile development environment utilizing mostly open source tools. Unfortunately, we have not adopted Rails as much as I would like. While I can’t divulge much information regarding these applications, I can give details on this very rewarding volunteer project using Rails and PostgreSQL.
http://blog.rezra.com/articles/2006/04/21/pushing-the-limits-of-rails
That was my first “production” Rails application, and I haven’t looked back. :)
Is the code for acts_as_legacy open source?
What is the best tool for working with PostgreSQL on os x? Do you use one?
Cesar,
Yes, it’ll be under a MIT or BSD license.
Randy,
I use
psqlfrom the terminal. Most of my development time-especially with Ruby on Rails-is spent working inscript/consoleand when I do work directly with PostgreSQL, I use the command line tool. It works great. :-)Robby, you’ve always been an advocate of PostgreSQL. Coming from a PHP background i’ve always been a big MySQL user… what would you say the greatest benefits would be for someone like myself to switch to using Postgres?
I’m allergic to MySQL.
Postgres or bust! I’m surprised that many Rails-popular hosts (Site5, Dreamhost, others) don’t offer Postgres. Cheers to Planet Argon for getting it right. I have been constantly surprised that people who choose Rails over PHP don’t also make the jump from My to Postgres.
BTW, Postgres powers all my personal and client sites:
BTW, Robby, I’ve been thinking a lot about the ideas of doing more workshops in the future. I’ll email you with more thoughts later this week.
-Jeff
And that’s what I get for not previewing. Fixed links…
That wallpaper is just wrong. Wrong.
I’ve been thinking a lot about the ideas of doing more workshops in the future Abercrombie & Fitch Abercrombie Fitch Abercrombie
eeyr tyg tgh gtfry Abercrombie & Fitch Abercrombie Fitch Abercrombie
I wrapped quite a bit of the database in a few minutes and then showed what another 45 minutes of work could do with Rails. I’ll tarball that code and post it online soon.
RTY RT
chi hair straightener, chi hair straightener
dty re t
trytr tr
uyi
TRY
max air 360
Robby, you’ve always been an advocate of PostgreSQL. Coming from a PHP background i’ve always chi straightenersbeen a big MySQL user… what would you say the greatest benefits would be for someone like myself to switch to using Postgres?
Crisp Audio and Video Guides: Just like having a piano teacher sitting in front of you, a piano lesson on IT TAKES A THIEF comes with audio and video guides to help you learn the songs you want to play in IT TAKES A THIEF DVD . The beauty of using this method is that you can replay the videos over and over again as many times as you like until you perfect IT TAKES A THIEF DVD COLLECTION yourself. You’d drive your piano teacher nuts if you asked them to do this for you. And you would be lucky to get one example out of them, rather than as many times as you may need.
There are kinds of uk Tiffany , including the one with beads and another with pearls in the shape of smooth water drops. Wearing Tiffany pendants , the attraction of nature flows slowly. silver pendants is more innovative and quite different from the above traditional ones. The cute beads in different colors decorate the bracelet, making a wonderful version in the Tiffany bracelets .
Louis Vuitton Brazza Wallet M66540 Louis Vuitton Brazza Wallet Louis Vuitton Billfold M60929 Louis Vuitton Billfold Louis Vuitton Multiple Wallet M60895 Louis Vuitton Multiple Wallet Louis Vuitton Billfold M60930 Louis Vuitton Billfold Louis Vuitton Keys Pouch M63800 Louis Vuitton Keys Pouch Louis Vuitton Round Key Holder PM M60115 Louis Vuitton Round Key Holder Louis Vuitton Round Key Holder GM M60116 Louis Vuitton Round Key Holder Louis Vuitton Key Pouch M62650 Louis Vuitton Key Pouch Louis Vuitton 4 Key Holder Fleuri M60238 Louis Vuitton 4 Key Holder Fleuri Louis Vuitton 4 Key Holder Fleuri M60239 Louis Vuitton 4 Key Holder Fleuri Louis Vuitton 4 Key Holder Fleuri M60240 Louis Vuitton 4 Key Holder Fleuri Louis Vuitton 6 Key Holder M62630 Louis Vuitton 6 Key Holder Louis Vuitton 4 Key Holder M62631 Louis Vuitton 4 Key Holder Louis Vuitton Multicles rabat M60029 Louis Vuitton Multicles rabat
This is such a great resource you are providing.
a href= http://www.uggaustraliafashionboots.com/ugg-argyle-knit-5879-boots-c-14.html > ugg 5879
Jordan retro XIII,Jordan retro XIII
Jordan retro XIV,Jordan retro XIV
Jordan retro XV,Jordan retro XV
Air Flight Condor Basketball,Air Flight Condor Basketball
Air Jordan Fusion 17.5,Air Jordan Fusion 17.5
Air Jordan Fusion 14,Air Jordan Fusion 14
Air Max 97,Air Max 97
cramping and emporio armani watch nausea would’ve drowned it out. louie vaton purses After I went back to hermes jewelry sleep for a while, I louis vuitton knockoffs felt a bit better. From replica wsop bracelet the bed I shared with omega speedmaster professional Carrie, I grabbed the large dior ring comforter and my pillow and d&g belt traipsed out to the front designer pendants room to lie on the dg jewellery couch.
replica Christian Dior replica Montblanc replica Cartier Jaquet droz watches replica chopard Maurice Lacroix for sale Piaget replica Longines for sale Christian Dior watches Bvlgari watches Maurice Lacroix replica replica IWC Panerai for sale replica Tag Heuer movado for sale Alain Silberstein watches Baume & Mercier watches