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.
Help support your Meetup
Chip inWe're about:
Our Sponsors
-
Open Source Consulting Group
OpenSCG is a financial sponsor for the Philly PostgreSQL User Group
-
Azavea
Azavea provides a venue for the Philly PostgreSQL User Group
People in this
Meetup are also in:
-
Philly.NET
1,535 Campers
-
Code for Philly
2,361 Phrends
-
Big Data Developers in Philadelphia
1,727 Members
-
20's & 30's Philly - Cheesesteaks, HappyHours, Hikes, & more
8,965 awesome people
-
Tech in Motion: Philadelphia
4,605 Technologists
-
Philly New Technology Meetup
3,989 Technologists & Innovators
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.