Full Web Framework that fully supports PostgreSQL's JSON data type
52 views
Skip to first unread message
DaAwesome P
Dec 21, 2015, 10:54:59 PM12/21/15
to nodejs
Hi all,
I'm looking for a Sails-like framework that currently supports Postgre's JSON data type. I'll be running a single-page Angular app on top, so I really just need something to act as a REST server. I also want it to have users, I'm trying to move away from CouchDB since it's rather rare in application hosting, while Postgre is usually free (i.e. OpenShift and Heroku). Postgre definitely has the potential to act as a document store database now! Take a look at this: http://schinckel.net/2014/05/25/querying-json-in-postgres/
If I absolutely have to type out my own SQL queries (although that's rather clunky, especially as the app scales up), then so be it. I need to be able to use all of the search functions. I really want to take advantage of Postgre's speed, reliability, and efficiency (I gave up on Mongo because of this).
Thanks,
DaAwesomeP
I'm looking for a Sails-like framework that currently supports Postgre's JSON data type. I'll be running a single-page Angular app on top, so I really just need something to act as a REST server. I also want it to have users, I'm trying to move away from CouchDB since it's rather rare in application hosting, while Postgre is usually free (i.e. OpenShift and Heroku). Postgre definitely has the potential to act as a document store database now! Take a look at this: http://schinckel.net/2014/05/25/querying-json-in-postgres/
If I absolutely have to type out my own SQL queries (although that's rather clunky, especially as the app scales up), then so be it. I need to be able to use all of the search functions. I really want to take advantage of Postgre's speed, reliability, and efficiency (I gave up on Mongo because of this).
Thanks,
DaAwesomeP
DaAwesome P
Dec 22, 2015, 10:38:26 PM12/22/15
to nodejs
Well, I've decided to use Sails and simply manually type in queries. They seem to be most on track for true support: https://github.com/balderdashy/sails-postgresql/issues/98
DaAwesome P
Dec 22, 2015, 10:45:23 PM12/22/15
to nodejs
Oops. Correct link: https://github.com/balderdashy/sails-postgresql/issues/212
Reply all
Reply to author
Forward
0 new messages