News for hackers. Stuff that matters.

A comment on Installing and Using PostgreSQL Modules.

Re:Installing and Using PostgreSQL Modules by jacques_chester on Tuesday July 03, 2012 @03:24AM (#4192954)
What modules demonstrate well is PostgreSQL's largely unsung degree of programmability. Most databases tie you to the data types that came out of the box, which leads more complex type modelling to be pushed out into the application code.

But PostgreSQL lets you go in the other direction, pushing type logic closer to the actual data store. This makes data storage smarter and can with a bit of judicious footwork simplify your application code.

[ Parent | on HN ]
Re:Installing and Using PostgreSQL Modules by deafbybeheading on Tuesday July 03, 2012 @03:58AM (#4193033)
Indeed. User-defined aggregates[1] are another great tool, and complement user-defined types very nicely.

[1]: http://www.postgresql.org/docs/9.1/static/xaggr.html

[ Parent | on HN ]
Re:Installing and Using PostgreSQL Modules by jeltz on Tuesday July 03, 2012 @03:52AM (#4193017)
This is what has enabled the creation of PostGIS which is the leading spatial SQL database.
[ Parent | on HN ]