What does this binary format actually look like on disk? Is this documented anyw... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

twic on March 24, 2014 | parent | context | favorite | on: PostgreSQL: Jsonb has committed

What does this binary format actually look like on disk? Is this documented anywhere other than in the code that reads and writes it?

I do remember a description of it in some slides a few months back, but i can't find them now.

rch on March 24, 2014 [–]

Maybe this is what you are looking for:

http://www.sai.msu.su/~megera/postgres/talks/hstore-dublin-2...

How the ideas migrated from hstore to jsonb is briefly described here:

http://obartunov.livejournal.com/177247.html

http://www.postgresql.org/message-id/53304439.8000602@dunsla...

twic on March 24, 2014 | [–]

Yes, that's it, thanks!

I suppose the definitive description of the format is the function JsonbToCString, which is what writes the in-memory structures out as bytes:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact