BedquiltDB – A JSON document store for PostgreSQL

Home » Blog » Software » Enterprise Software » BedquiltDB – A JSON document store for PostgreSQL

BedquiltDB is a recently released PostgreSQL extension (written mostly in PL/pgSQL) that leverages PostgreSQL’s relatively new jsonb column type (available since version 9.4) to provide a MongoDB-like NoSQL document store and API on top of a PostgreSQL database.

There are a few benefits to this approach. First, this allows you to start a project with a comparatively simple document-oriented API that lends itself to many use cases in terms of modern web applications.

While you get this with your usual NoSQL, document-oriented databases as well, BedquiltDB sports the additional upside of being able to draw upon all the features of a SQL database like constraints and transactions. Moreover, it allows to gradually transition from a no-schema (or loose schema), NoSQL approach to a strict schema, SQL / RDBMS one if required without having to change the underlying database technology, which is a pretty powerful selling point in my opinion.

I really like the idea of more or less automatically providing a simply API on top of a SQL database. Software like PostgREST or my very own ZenQuery allows you to easily create REST API endpoints for existing SQL database tables. This saves a lot of boilerplate code and repetitive work that usually comes with with creating CRUD web applications.

A fine example of how this can be put to work is Ng-admin + PostgRest, which allows you to easily create a fully-fledged admin interface for an SQL database.

Leave a Comment

By continuing to use the site you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or if you click "Accept" below then you are consenting to this.