7 ms·
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
by jacques_chester 14y ago
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.
- jeltz 14y agoThis is what has enabled the creation of PostGIS which is the leading spatial SQL database.
- deafbybeheading 14y agoIndeed. 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 http://www.postgresql.org/docs/9.1/static/xaggr.html