| Postgres Weekly |
Issue 8
May 1, 2013
|
|
|
Featured
| postgression: A PostgreSQL Database for Every Test Case |
|
If you're building your application and have good testing processes you may not want to have to deal with setting up Postgres locally to test. Postgression makes it easy for you to immediately a database within the cloud and use for testing, then throw it away. As its in the cloud you may have some latency when developing locally, but this setup works great for CI.
|
|
From our sponsor
| Heroku Postgres - Fully managed Postgres on EC2 |
There's a lot to worry about when building your application; ensuring your database is secured, backed up, available shouldn't have to be part of that. Let Heroku Postgres focus on keeping your database running so you can take advantage of all the awesome features within Postgres.
Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.
|
|
 |
Other links
| Secure deployment of PostgreSQL functions |
|
While there is often debate about whether to put functionality inside your database in the form of functions sometimes its inevitable. When you do ensuring you're not overwriting others functionality becomes a necessity. Here's how you can securely deploy function changes and diff them after within your database.
|
|
| Rails 4 UUID primary keys with PostgreSQL |
|
If building a distributed app sequentially incrementing ids start to fail you. A simple change thats great to do from the start of any project is to use UUID. You can easily swap our your primary key in rails to use the Postgres UUID datatype.
|
|
|
|
|