| Postgres Weekly |
Issue 78
October 21, 2014
|
|
| Monitoring Postgresql with a Background Worker |
|
While there are more and more options for monitoring Postgres, it’s still not a perfectly solved problem. Here’s a great post on monitoring it with background workers using two open source tools.
|
| Robert Berry |
|
| Postgres Skills are in Demand - Add to your skill set and get certified |
|
2000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with expert training courses. The EDB certification program sets the global standard for Postgres professionals, and is definitive proof of your Postgres skills.
|
| EnterpriseDB Sponsored |
|
 |
| Pagination Done the PostgreSQL Way |
|
Some examples of performing pagination with SQL on Postgres, working from a simple but inefficient example through to an interesting ‘seek’ based approach.
|
| Alexey Vasiliev |
|
| How to Start using Arrays in Rails with PostgreSQL |
|
Arrays are super powerful and convenient for when you need them in Postgres. There’s often no good reason you shouldn’t use them when you want and your framework such as Rails shouldn’t limit you.
|
| Kamil Lelonek |
|
| Introducing Flexible Freeze |
|
Often times there’s a need to freeze tables when there’s a lull on your database. Now there’s a project focusing on just that, at this time as a simple easy to use script.
|
| Database Soup |
|
|
|
|