Projects

Curo

Addon to psql to make administrator life easier by providing set of queries/tools to monitor and check database status.

Links:

explain.depesz.com

Tool for helping understanding explain analyze outputs from PostgreSQL.

Links:

first_last

Very simple SQL aggregates that return first or last value from group.

Links:

OmniPITR

Solution for HOT replication/backup/restore.

Links:

paste.depesz.com

Tool for pasting, and pretty-printing SQL queries.

Links:

Pg::SQL::Parser

Perl library/class for parsing SQL queries.

Links:

pg_terminator

Tool for automatically canceling, or terminating offending connections to PostgreSQL databases.

Links:

psql-backslash

Set of database functions that emulate psql's \* commands.

Links:

shell_utils

Collection of scripts that help me when dealing with shells.

Links:

short_ids

A way to generate short, unique, random, textual ID values.

Links:

system_monitoring

Scheduler for commands with precision of up to 1 second (vs. 1 minute in standard cron). Used primarily to monitor and log state of server and PostgreSQL.

Links:

Versioning

Set of functions to provide versioning of tables, functions or other objects in PostgreSQL database.

Links:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.