Monday, May 21, 2012

TeamPostgreSQL: PostgreSQL web interface

I feel great to announce the release of TeamPostgreSQL, a web interface for the PostgreSQL database, completely free for the community.

This is a product I am particularly proud of as it is, IMHO, a pretty awesome web application in its own right (fully dynamic 100% javascript/AJAX and beautifully designed), but also a very useful tool for PostgreSQL.

Briefly, TeamPostgreSQL is a web application that can be used to access an organization's databases over the intranet (or internet). It can also simply be used locally on a single machine as a regular database client. Just run the installer or unpack the archive and the service is ready.

TeamPostgreSQL was originally planned as a commercial product but for various reasons that effort was never followed through on and we have mostly been using it as an internal tool. Since we are now enveloped in other projects, I decided to put the product out there for anyone to use and enjoy.

Click to zoom

The use case where this app really shines is in browsing and navigating the data in your databases. You can click through foreign key references, jumping straight to referenced rows in other tables, you can even click a row primary key field and get all rows in other tables that reference this one, all in a full featured row view with edit controls for the data. When adding a row, fields with foreign key references have dropdowns with values from the referenced table/column. Binary fields can be populated by simply picking a file using a file chooser control, and can be downloaded from the rows view straight to a file. Date fields have a proper date chooser. Store and load common SQL snippets and share them with your team. One click search for a value across all tables. There's also a handy graphical interface to pgdump to create SQL scripts.

Those are just a few examples of the many features in this product that we personally find indispensable and we hope will be useful to others too.

More info and download at the website:



  1. The King Casino in San Diego, CA - Online Casino Games
    The sbobet ทางเข้า King Casino offers a great range of casino games 더킹카지노 including blackjack, poker, baccarat and more. william hill Play now and start playing for real cash today.

  2. Top 3 slots and casino games to play in Norway - Airjordan13
    A list of top 3 slots from online how can i get air jordan 18 retro toro mens sneakers casinos. Play on air jordan 18 retro men blue online shop top casino games 토토 웹 that are where can i buy air jordan 18 retro toro mens sneakers very buy air jordan 18 retro popular.

  3. Best bets for soccer today - Sports Toto
    Today, we're going to tell you a few key to checking into soccer betting apps. 토토 사이트 도메인 of the most popular soccer betting options and which ones will