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: http://www.teampostgresql.com

Enjoy!


4 comments:

  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.

    ReplyDelete
  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.

    ReplyDelete
  3. This well-liked slot sport options five reels, 20 paylines, and an adventurer (Gonzalo 'Gonzo' Pizzarro) looking for the misplaced metropolis of gold. When it involves enjoying in} slots at a live casino, you can to|you probably can} belief your 메리트카지노 fellow slot players and take a look at|have a look at} how people play. This sport does not feature a progressive jackpot, so you do not actually need to wager the max every time you spin. This online sport is the web model of a traditional well-liked slot you'll find at almost all of the live casinos in Las Vegas and Atlantic City. When you play slots, you can to|you probably can}'t become a multi-millionaire with just 0.01.

    ReplyDelete