yesodweb/persistent — Issue #59: Use native PostgreSQL arrays
Author: gregwebs
Created: 2012-02-24 01:08:53+00:00
State: open
Labels: Feature Request

The current technique of serializing embedded objects as JSON is great because it works on every database. However, PostgreSQL actually has native arrays!
http://www.postgresql.org/docs/8.2/static/arrays.html

Also has a Map storage! http://www.postgresql.org/docs/9.0/static/hstore.html

Of course, there are limitations on trying to embed one within another, which is why having JSON available is still great.