[Melbourne-pm] PostgreSQL and indexing with json types

[Mathew Robertson]

>
> > 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.

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