December 18, 2014
|Due to the Christmas break, we'll be back on January 8th. Happy Holidays!
|Substitute PostgreSQL for Your NoSQL Needs
SQL, NoSQL, KnowSQL are heavily overloaded terms. Postgres has long taken a liberal approach to datatypes and schema-less datatypes play very well in its world. Here’s a broader article that hints at much of this if you need a case vs. relational/NoSQL because with Postgres you really can have your cake and eat it too.
|Adventures in Searching with Postgres: Part 2
Searching is a common theme lately, specifically text search in Postgres. While not always the most user-friendly feature, it’s undoubtedly powerful and in this article we dive deeper into some of the semantics of text search and how to take advantage of the features.
|Japan PostgreSQL Conference 2014
The number of Postgres conferences seems to just continue growing. Here’s a nice write-up of Japan’s latest Postgres conference and some of the themes that emerged from it.
|SQLnoSQL: pg_shard and JSONB, part 1
We now have a working example and demo of using the pg_shard extension alongside the JSONB format, giving us all the perks of Postgres, solid sharding, and the flexibility of a schema-less datastore all in one.
|Job: Help Chain.com Index the Block Chain
Chain.com is the API for block chain developers. We have an experienced engineering team who is dedicated to building the world’s best Bitcoin platform. We are looking for a PostgreSQL expert to join the Data Engineering team.
|This Week's Issue of Database Weekly
DB Weekly covers general database trends, graph databases, NoSQL, tools, and more. Issue 43 looks at how to choose a database, creating test databases full of fake data, an OS X database management tool, and more.