Re:Why HStore2/jsonb is the most important patch of PostgreS...
by dorfsmay on Sunday February 23, 2014 @11:03AM
(#7286241)
No. Adding support for a json NoSQL like interface doesn't remove the SQL access. You could let the front end guys do Create Update Retrieve by primary key using the json interface, while the backend analysis guys use SQL through the normal SQL driver.
[ Parent
| on HN ]
Re:Why HStore2/jsonb is the most important patch of PostgreS...
by einhverfr on Sunday February 23, 2014 @08:25PM
(#7288607)
I think you misunderstood my point. The "modern" way seems to be to avoid SQL using either NoSQL or something like an ORM.
Personally I prefer to tackle this from the other side with stored procedures and service locators so my application code is free of SQL (aside from the service locator), and all my SQL is in .sql files.....