21 Mar '12, 10am

The Durable Document Store You Didn't Know You Had, But Did

December 6, 2011 Tagged: postgres database xml Comments (View) The Durable Document Store You Didn’t Know You Had, But Did As it turns out, PostgreSQL has a number of ways of storing loosely structured data — documents — in a column on a table. hstore is a data type available as a contrib package that allows you to store key/value structures just like a dictionary or hash. You can store data in JSON format on a text field, and then use PLV8 to JSON.parse() it right in the database . There is a native xml data type, along with a few interesting query functions that allow you to extract and operate on data that sits deep in an XML structure. XML Storage is the topic of this post. The XML data type has been Postgres core since version 8.3 (and as part of a contrib package prior to that). Documents that span more than one data block will be TOASTed as usual, so storing big doc...

Full article: http://robots.thoughtbot.com/post/13829210385/the-durable...

Tweets

You may or may not know more on "Euro Debt May ...

leewatch.info 21 Mar '12, 6am

Investment tips from Lee Kuan Yew. Wall Street Journal : Singapore’s founding statesman, Lee Kuan Yew, has long been criti...

Consult page here:

ipos.gov.sg 22 Mar '12, 4am

Public Consultation on Proposed Amendments to Singapore's Patents Rules in relation to Positive Grant System and Miscellan...

Check out the cool gadget on sale at GDS store!...

greatdeals.com.sg 20 Mar '12, 6am

Founded in 2008, Great Deals Singapore is the number one source for news in shopping deals and promotions. Great Deals Sin...

@SamEdelmanShoes let your fans know we've got b...

footnotesonline.com 27 Mar '12, 4pm

Dolce & Gabbana Sunglasses Gucci Sunglasses Liz Claiborne Sunglasses Prada Sunglasses Rayban Sunglasses Roberto Cavalli Su...

Hoping to improve your half PR? How to know whe...

Not surprised to see a quick turnaround in posting a new article after the frenzy from yesterday. Surely the best advice o...

Mobil 1 Know Your Oil Contest – 3 winners selec...

paultan.org 21 Mar '12, 4pm

Related stories you might be interested in reading: Proton Power of 1 I-Race winners heading to Europe for a priceless exp...

HIDDEN SINGAPORE | Discover a side of our city ...

timeoutsingapore.com 21 Mar '12, 10am

From hidden hot springs to secret bars, restaurants tucked away in parks and shrines hidden in forests, discover a side of...

MIT Study Finds Ample Room in United States to ...

spectrum.ieee.org 20 Mar '12, 11pm

Researchers associated with MIT published a study today assessing how much space would be available if the United States w...

Last Call before interviews start - we're hirin...

seerinteractive.com 23 Mar '12, 9pm

Innovative – Does the phrase “outside the box” make you cringe because it’s too inside the box? Are you comfortable thinki...

New NOW YOU KNOW ep! Flying man a hoax, Justin ...

clicknetwork.tv 23 Mar '12, 9am

News for the week: Man fools everyone into believing he could fly, Justin Bieber takes a beating, and singers Jessie J and...

3 Things You Need to Know About Forests and Cli...

buildinggreen.com 22 Mar '12, 4pm

To state that "trees and forests have much to offer [to us]" and that "forests…are complex systems that are crucial to hum...

Formula One: Hamilton steals show in Malaysia. For more updates on the F1, head on to The Big Story

Formula One: Hamilton steals show in Malaysia. ...

straitstimes.com 23 Mar '12, 7am

Hamilton sets pace in opening practice in Malaysia SEPANG, Malaysia (AFP) - Britain's Lewis Hamilton set the pace in openi...

Who’s Hee ? Get to know your MP | #Malaysia

harismibrahim.wordpress.com 24 Mar '12, 1pm

A little under 2 weeks ago, I was invited to join a meeting of a group of PJ Selatan voters who wanted to initiate an effo...

Massa’s diary – I know I can count on a second ...

ferrari.com 29 Mar '12, 4pm

One day to be with the team, to analyse in detail every moment of these first two Grands Prix of 2012, to understand how a...