News for hackers. Stuff that matters.
Re:PostgreSQL 9.2 released by metabrew on Monday September 10, 2012 @09:05AM (#4499536)
Since postgres has basic json type support now, and PL/Javascript exists, it's only a matter of time until an extension appears that lets you deploy javascript applications directly to the database.

Who needs CouchDB or Node.js when you can just say CREATE EXTENSION 'couchnodegres.js'

Re:PostgreSQL 9.2 released by joevandyk on Monday September 10, 2012 @12:42PM (#4500666)
Once the database can start receiving and returning json, then you can treat it as a webservice and not have the client involved in SQL. I think this is huge.
Re:PostgreSQL 9.2 released by calinet6 on Monday September 10, 2012 @01:45PM (#4501001)
Just FYI, this is already half-true:

"With PostgreSQL 9.2, query results can be returned as JSON data types."

It also supports the PL/V8 stored procedure format, which is Javascript http://code.google.com/p/plv8js/wiki/PLV8

It's very, very close.

Re:PostgreSQL 9.2 released by recuter on Monday September 10, 2012 @01:08PM (#4500809)
Can you elaborate a little bit on how an architecture like that would look like? I had great hopes for CouchDB once.
Re:PostgreSQL 9.2 released by y0ghur7_xxx on Monday September 10, 2012 @01:38PM (#4500952)
HTML/JS frontend calls simple node server that does nothing but call a stored procedure like

   spc_handle_request(req_headers, req_body, http_method, ...)
stored procedure does simple routing and does something like

  insert into table (a, b, c) values (to_json(req_body).a, to_json(req_body).b, to_json(req_body).c);
or

  to_json(select * from emp);
Time to implement simple crud app: 10 minutes.
Re:PostgreSQL 9.2 released by dotborg2 on Monday September 10, 2012 @09:34AM (#4499655)
yet it will not cease comparsions of postgres to mysql