Live data from Hacker News

PgREST: Node.js in the Database, compatible with MongoLab and Firebase API

pgre.st

31–34 of 34 posts

Re: PgREST: Node.js in the Database, compatible with MongoLab and Firebase API

#31

Earlier quoted context omitted.

I assumed everyone would be encouraged to just convert their json columns to hstore if they wanted the extra speed, being as theyre equivalent. What would be the reason for funding JSON-as-binary?

Traditional databases use complicated indexing and storage structures in part to minimize the need to examine unrelated data. hstore is better than plain text for JSON but a scheme closer to the existing PostgreSQL table/page/row/value hierarchy could be better still. I'd recommend reading the recent post https://news.ycombinator.com/item?id=6813937

Of course if I need it to be eye-wateringly fast I wouldn't be using a document store. I'd use good old relational or something like redis. Often though you just need a sensible place to put some unimportant schemaless key-value data without a half dozen extra dynamically created tables or whatever. EAV makes me very sad.

Re: PgREST: Node.js in the Database, compatible with MongoLab and Firebase API

#33

So, is this a competitor to couchbase (thinking of kanso and couchapp)?

Yes, we're certainly inspired by Kanso.

PgREST was originally designed for a large, in-production Postgres app (i.e. Socialtext), so we can get all the model, validation, view & trigger code in one place, getting the benefits of CouchApps while maintaining the underlying data layer.

For new projects, the main difference is likely familiarity with the toolchain (npm+Pg vs Kanso+CouchDB).

Re: PgREST: Node.js in the Database, compatible with MongoLab and Firebase API

#34
post #33

So, is this a competitor to couchbase (thinking of kanso and couchapp)?

Yes, we're certainly inspired by Kanso. PgREST was originally designed for a large, in-production Postgres app (i.e. Socialtext), so we can get all the model, validation, view & trigger code in one place, getting the benefits of CouchApps while maintaining the underlying data layer. For new projects, the main difference is likely familiarity with the toolchain (npm+Pg vs Kanso+CouchDB).

The word I want to use for this is "refreshing".

Back in the day, I thought Couchapps and Kanso + CouchDB were great and I hoped they would lead an entire new breed of web applications.

Thank you for making it happen!

Post reply on HN