Schemaless Postgres

I stumbled across a link on HackerNews that Reddit’s database has two tables. Inside was a blog post from 2012 that referenced a presentation by Steve Huffman from 2010. The interesting thing is how Reddit effectively had no schema for their data, even though they were (at least at the time) using Postgres for storage. The gist is there are two tables. One table has the metadata about every thing that Reddit has: users, subreddits, comments, etc.
Read more...