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

* Checkbox GDPR is required

*

I agree

By continuing to browse the site you agree to our use of cookies. Privacy Policy

Privacy Preference Center

Strictly necessary

These cookies are necessary for the site to function.

PHPSESSID: Preserves user session state across page requests.

__cfduid: Used by the content network, Cloudflare, to identify trusted web traffic.

PHPSESSID
__cfduid

Preferences

Remembers the user's submitted data when a comment is submitted in a blog post. The purpose is to aut o-populate form fields for subsequent comments, in order to save time for the user.

wfvt_#

Statistics

Statistic cookies help us to understand how visitors interact with our websites by collecting and reporting information anonymously.

_ga: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

_gat: Used by Google Analytics to throttle request rate.

_gid: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

collect: Used to send data to Google Analytics about the visitor's device and behaviour. Tracks the visitor across d evices and marketing channels.

_ga,_gat,_gid
collect

Security

We use Wordfence to secure our website against hacking attempts: https://www.wordfence.com/

wordfence_verifiedHuman

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?