Category Archives: Database tools

Pyrseas/PostgreSQL Feature Matrix

Posted on 7 March, 2012 by

In my last post, I wrote—referring to the state of Pyrseas after version 0.5 is released: The only gaps left are TABLESPACE, GROUP/ROLE and the EXTENSIONs added in PG 9.1. I’m afraid I should’ve double checked the list of 9.1 … Continue reading →

Posted in Database tools, PostgreSQL, Version control | Tagged , , | 1 Comment

More Database Tools?

Posted on 5 March, 2012 by

It’s been over year since I started blogging on these pages about Pyrseas and version control. In a month it will also be the first anniversary of the initial commit to GitHub. Much code and many words have flown under … Continue reading →

Posted in Database tools, PostgreSQL, Python, User interfaces, Version control | Tagged , , , , | 4 Comments

Automated Database Augmentation

Posted on 5 February, 2012 by

Suppose you have a PostgreSQL database like the Pagila sample with 14 tables, each with a last_update timestamp column to record the date and time each row was modified, and it is now a requirement to capture which user effected … Continue reading →

Posted in Database tools, PostgreSQL, Python | Tagged , , , , , , , | 6 Comments

Interesting database tool: Adminer

Posted on 24 February, 2011 by

No, it’s not a tool to extract extra revenue from Google Ads. Adminer (which I guess is pronounced admin-er, rather than ad-minor) is a nifty little tool that competes with phpMyAdmin, the web-browser-based MySQL administration tool. What is interesting from … Continue reading →

Posted in Database tools, PostgreSQL | Tagged , | 2 Comments