addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Postgres-XC as a Distributed Key-Value Store

  • Apr 15, 2013 · 6:30 PM

Schema-less design is very appealing to many web developers and that combined with the need to be scalable has led to many NoSQL data stores. Often, developers will use a NoSQL database along with a relational database to get the best of both worlds, but that leads to complexity in managing multiple data stores. But...what if your relational database could could give you some of the same flexibility as the NoSQL alternatives and you only needed a single database?

In this talk, Mason Sharp will provide an overview and discuss how Postgres-XC can leverage hstore and JSON functions to create a distributed key-value store. This approach allows for a PostgreSQL-based alternative to other NoSQL solutions, while ensuring cluster-wide consistency. He will show some benchmarks of Postgres-XC vs MongDB

 

About Mason Sharp

Mason has had a passion for RDBMS systems and data management since he was a student during which time he co-authored a book about dBASE IV. Mason developed a parallel distributed MPP database system targeted towards data warehousing called ExtenDB, which was folded into EnterpriseDB as GridSQL in 2007. He also recently helped architect Postgres-XC, a shared-nothing database system targeted for write scalability and which makes for one of the key technological underpinnings of StormDB.

 

Join or login to comment.

  • john A.

    Two announcements were made at the meetup. Jim noted that Postgres admins should upgrade to the latest Postgres -- 9.2.4 for those using 9.2 -- to plug a major security leak. Jim noted that perhaps 100,000 postgresql installations on the interwebs still have this vulnerability. And Andrew Thompson announced a reception for the start of the NASA Space Apps challenge, this coming Friday, http://www.philasciencefestival.org/event/98-nasa-s-international-space-apps-challenge-opening-reception. This leads into the space apps challenge.

    April 16, 2013

  • Bruce M.

    Sorry, can't attend. I have a tae kwon do test that night and can't miss it.

    April 14, 2013

    • john A.

      Guess everyone has their own way of getting their kicks! :0

      April 16, 2013

  • john A.

    Very solid talk; covered the topic & then stopped. Very fair-minded.

    April 16, 2013

  • A former member
    A former member

    Great talk, nice network.

    April 15, 2013

22 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy