Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
sequelize learnings

What are we using :

NPM:

  • pg
  • pg-hstore
  • sequelize
  • sequelize-cli ( for migrations pretty nifty )

So for adding any migrations which has an attribute with a dataType of HSTORE we need to enable it in the Postgresql database ( we need to find a way to automate this - thoughts ? ). Now this seemed to be a nice way so that whenever you create a database it enables HSTORE. Now this worked for me might not work for others.

sudo -u postgres psql template1 -c 'create extension hstore;' create the database with psql sudo -u postgres psql <database_name> -c 'create extension hstore;'

This is nice but there should be an automatic way for doing this ? Lets see ...

Querying

I found this to be very nice : link to gist

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment