[Melbourne-pm] PostgreSQL and indexing with json types

Mathew Robertson mathew.blair.robertson at gmail.com
Tue Oct 9 16:09:41 PDT 2012

> > Just something interesting I noticed today..
> >
> > As you've probably already seen, PostgreSQL 9.2 added support for
> > storing JSON documents in a 'json' type field.
> this is a cool and interesting feature but it will serve to encourage
> even more morons to avoid even basic/minimalist database normalisation
> methods.
> [snipped]

> pg's support for JSON fields isn't a bad thing - overall, it's a good
> thing...it will mitigate some of the problems - but it won't do anything
> to educate web-dev morons about database design.

While having support for more languages within the server, is generally a
good thing... I am generally in agreement that storing JSON directly to the
database, is a bad thing -> as it will encourage developers to no bother to
sanitize their inputs.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/melbourne-pm/attachments/20121010/913c2152/attachment.html>

More information about the Melbourne-pm mailing list