Postgres Weekly |
Issue 48 February 26, 2014
|
|
The Costs of A PostgreSQL Connection |
Contrary to what many believe a connection to Postgres isn’t ‘free.’ Here’s a look at the overhead of connections and some suggestions as to the solution, though in reality there are a few more options available.
|
Hans Hasselberg |
|
DreamFactory: Open Source REST API for Postgres |
DreamFactory provides an open source REST API for any SQL database. Generate a live documented REST API for your Postgres database in minutes. Install the free open source package on EC2, VMWare, Azure, Linux, or OS X.
|
DreamFactory Sponsored |
|
|
Using PostgreSQL Arrays The Right Way |
Arrays in Postgres are very useful and worth looking into, although not without knowing what the performance implications are. Essentially, avoid accessing positions directly in arrays, as there’s a better option.
|
Dan Robinson |
|
Creating Triggers In PostgreSQL |
Need replication of data, auditing of changes in your DB, or enforcement of business rules? Triggers can help and this article highlights how.
|
Shiv Aggarwal |
|
PostgreSQL, Aggregates and Histograms |
Postgres has an abundance of built-in functions, some of these are commonly used, some less so. Taking advantage of some of the mathematical ones you can easily generate histograms directly with SQL.
|
Dimitri Fontaine |
|
|
|