Get unlimited public & private packages + package-based permissions with npm Pro.Get started »

libpiggy

0.11.2 • Public • Published

libpiggy Build Status npm version

Use a PostgreSQL database like a JSON document store.

Why?

On the surface using a relational database as a JSON document store might seem silly. Still, I think there are great reasons to choose this approach over something like Mongo.

  • You like PostgreSQL
  • Postgres JSON querying and indexing is powerful and capable
  • You like the option of using PostgreSQL queries, in addition to some of the more ORM-like abstractions incorporated here
  • You like the idea of prototyping data objects with the flexibility of schema-less JSON, but imagine yourself making changes to a more relational model in the future
  • For some reason you only have access to PostgreSQL, but prefer this approach
  • You like the watchTable functionality, and being able to create an easy, lightweight reactive database

Documentation

For now please look at the tests, and at the hapi-piggy module which implements this.

Testing

You'll need Docker and docker-compose available.

$ docker-compose up
$ npm test

Requirements

  • Node.js >= 6.0
  • PostgreSQL >= 9.5 (local tests use 9.6, Travis uses 9.5)

Todo

  • Documentation
  • Support nested btree indexes
  • Proper tests

Install

npm i libpiggy

DownloadsWeekly Downloads

0

Version

0.11.2

License

MIT

Unpacked Size

70.5 kB

Total Files

41

Last publish

Collaborators

  • avatar