Official announcement from PostgreSQL.org: <a href="http://www.postgresql.org/about/news/1485/" rel="nofollow">http://www.postgresql.org/about/news/1485/</a><p><i>OpenSCG is pleased to announce the release of PostgreSQL Studio 1.0. PostgreSQL Studio is an open-source, web-based GUI for PostgreSQL. It allows users to manage and query their database from a browser.</i><p><i>Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License. Some of its key features include:</i><p>- <i>Easy to use AJAX web interface</i><p>- <i>Secure access over HTTPS</i><p>- <i>Robust object wizards</i><p>- <i>Query editor with syntax highlighting</i><p>- <i>Cross platform and easy to install</i><p><i>You can find more information about PostgreSQL Studio at www.postgresqlstudio.org</i>
JavaServer Pages? That's an interesting choice.. and will probably rule it out for a lot of people. I'm not running Java on my web server, sorry. Interesting that a PostgreSQL product licensed under PostgreSQL is using an Oracle technology. Edit - removed the MySQL reference.
We make a similar thing: <a href="http://www.teampostgresql.com" rel="nofollow">http://www.teampostgresql.com</a><p>AJAX/JavaScript powered rich web GUI for PostgreSQL. Looks like this took some inspiration from us too (which is great). TeamPostgreSQL is a side-project but pretty mature, having been around since 2010.
This image gives an idea of UI: <a href="http://www.openscg.com/wp-content/uploads/2013/10/pgstudio_screen-1024x738.png" rel="nofollow">http://www.openscg.com/wp-content/uploads/2013/10/pgstudio_s...</a>
We have a similar Html5/AJAX powered offering[1] as well though in addition to Postgres we also support a number of other database types (MySQL, Oracle, MS SQL Server). Looking forward to trying this out to see how it compares.<p>[1]: <a href="http://www.jackdb.com/" rel="nofollow">http://www.jackdb.com/</a>
I'll eventually try it out, but I have absolutely no idea how to go from this .war file to a running web server. (I see some .war files actually have a web server built in so you can just to java -jar, but not this one.)
I've been thinking about making the switch from MySQL to PostgreSQL.<p>For database design/GUI work SQLyog has been pretty awesome over the years (auto-complete, drag & drop, tabbed editor windows, export query result to csv, etc.). Is there an equivalent for PostgreSQL?<p>When I hear web-based I think phpMyAdmin, which, while functional, pales in comparison to SQLyog (web app in question does look a lot more polished than phpMyAdmin)
Very interested to see this, once the site comes back online. In spite of the previous efforts, I've always found the admin/query tools for Mysql and Postgresql as lacking compared to the ones from the commercial-only vendors. And I've never cared for the non-db-specific sql utilities. An easier tool to work with Postgres would certainly make my clients much happier.
Hey, random internet stranger here -- I like the idea -- maybe you could show some comparisons with the other products on the market (other postgres management programs). Also, I think you should put the screenshot of the dashboard on the front page, will make it instantly clearer what it does, and probably generate interest quicker?
I have to admit, the first thing I thought about when I saw it was "phpMyAdmin" and "security vulnerabilities". I hope I'm simply being uncharitable, but I'd have to have a lot of faith in the product and the underlying stack before I let a web-based GUI anywhere near a production database.
This looks interesting (via the description and screenshot in the comments...the site is down as of this writing), but what does this provide that pgAdmin (<a href="http://www.pgadmin.org/" rel="nofollow">http://www.pgadmin.org/</a>) doesn't?
Currently the site is trying to request this URL
<a href="http://localhost/wordpress/wp-content/themes/alexandria/skins/images/alexandria/page_bg.png" rel="nofollow">http://localhost/wordpress/wp-content/themes/alexandria/skin...</a><p>(I have a local Django server running on 0.0.0.0:80 and the terminal keeps flashing when I browser the site and this image is obviously missing and gives a 404)
I was really excited when Induction (<a href="http://inductionapp.com/" rel="nofollow">http://inductionapp.com/</a>) was announced, but I don't think there's too much development for it. The interface is probably the best I've seen, but functionality is fairly sparse. pgAdmin3 has been my go-to app, but I'm excited try out PostgreSQL Studio!
I'm amazed no on mentioned SQLWorkbenchJ. For postgres on Mac, it is infinitely better than pgAdmin. There are a few usability issues (manually setting the JDBC driver, for one), but once you get the hang of it, it's quick and very fully featured. I use it over Navicat, and it's free.