Get a listing of postgres databases

psql -U postfix -h localhost -l -t | awk ‘/^ [a-zA-Z]+/ { print $1; }’ | grep -v ‘^\(template0\)’ | while read DBNAME do … done   #! /bin/sh # Keep n days worth of backups GENERATIONS=180 BACKUP_DIR=”/var/backups/generational/pgsql”; BACKUP_CURRENT=”/var/backups/pgsql”; DATE=`date +’%Y%m%d’` HOSTNAME=`hostname` DBUSER=”postgres” # load defaults, over-riding script supplied values [ -f /etc/default/pgbackup ] && . …

More

MongoDB Gotchas & How To Avoid Them

A lot of people hate on MongoDB. In my opinion they’re misguided – the main reason so many people think like this is a lack of understanding. Everyone should be able to benefit from MongoDB’s power and simplicity, and so as a follow up to David’s article I have outlined some common and not-so-common things …

More

firstworks: SQL Relay – sqlrelay persistent database connection pool pooling proxy load balance balancing odbc oracle mysql msql postgresql sybase db2 interbase sqlite access c++ perl DBD DBI python php zope ruby tcl java jni unix linux persistant

With SQL Relay, you can speed up and enhance the scalability of database-driven web-based applications, access databases from unsupported platforms, throttle database access, distribute access to clustered or replicated databases, route queries and migrate applications from one database to another. via firstworks: SQL Relay – sqlrelay persistent database connection pool pooling proxy load balance balancing …

More

Top JavaScript MVC Frameworks

As more and more logic ends up being executed in the browser, JavaScript front-end codebases grow larger and more difficult to maintain. As a way to solve this issue developers have been turning to MVC frameworks which promise increased productivity and maintainable code. As part of the new community-driven research initiative, InfoQ is examining the …

More

How Netflix Deploys Code

Netflix, the popular movie streaming site, deploys a hundred times per day, without the use of Chef or Puppet, without a quality assurance department and without release engineers. To do this, Netflix built an advanced in-house PaaS (Platform as a Service) that allows each team to deploy their own part of the infrastructure whenever they want, …

More