PostgreSQL Studio

http://www.postgresqlstudio.org/

by moreati • 13 years ago

276 94 13 years ago

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?

estebank• 13 years ago

Official announcement from PostgreSQL.org: http://www.postgresql.org/about/news/1485/

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.

Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License. Some of its key features include:

- Easy to use AJAX web interface

- Secure access over HTTPS

- Robust object wizards

- Query editor with syntax highlighting

- Cross platform and easy to install

You can find more information about PostgreSQL Studio at www.postgresqlstudio.org

untog2• 13 years ago

..and the site has gone down. Sounds fantastic, though- pgSQL has always been lacking in admin tools compared to MySQL.

jacques_chester2• 13 years ago

From the URL of the screenshot linked to, it's a Wordpress installation.

A lazier sort of wag might point out that Wordpress runs on MySQL, but that would be a cheap shot unbecoming of our noble selves here at HN.

A more helpful sort might encourage the site owners to turn off the HTTP server, install WP Supercache or W3 Total Cache, then turn it back on.

oomkiller• 13 years ago

Or just use a static site generator? It amazes me how many rarely updated sites use Wordpress when the people who run them are more than capable of using something like jekyl. I guess the themes ecosystem etc around Wordpress is just too big to pass up?

TylerE2• 13 years ago

Huh? There's the great free PGAdmin which is WAY better than any of the web-based tools, and it has built-in SSH tunneling so it's easy to use against a remote server.

astrodust3• 13 years ago

This thing? http://www.pgadmin.org/

This is why I hate using Postgres despite it being such an amazing database internally.

PGAdmin is everything that's wrong with database tools rolled into an executable.

untog2• 13 years ago

PGAdmin is unspeakably awful. I run a Mac and it was very painful going from the world of Sequel Pro (for MySQL) to the awful, awful, terrible pgAdmin.

I ended up buying NaviCat Essentials, which is considerably better but still not perfect.

nobleach• 13 years ago

I'd say it _almost_ has SSH tunneling built in. They're 95.418% there. It's still hardcoded to only use port 22. You can't specify another port. In my case, I have to hop through other machines and if I have SSHd running on my local box, I can't use their SSH tunneling.

symfoniq• 13 years ago

I'm seeing a blank site.

ameoba• 13 years ago

Server's down - anyone got a mirror, announcement or enough experience with the project to give a good rundown of what it is and what it does?

jalan2• 13 years ago

This image gives an idea of UI: http://www.openscg.com/wp-content/uploads/2013/10/pgstudio_s...

neovive• 13 years ago

Thanks for the image link. At a quick glance, it reminded me of PHPMySQL, but I guess most, good, web-based admin UI's will have a similar layout and functionality.

jreposa• 13 years ago

Clearly there is a pain point with PostgreSQL and GUI front-ends. Wish I could see the site.

antihero2• 13 years ago

Honestly I found the sooner one gives up and just uses the command line, the better.

petit_robert2• 13 years ago

Indeed. I really have no idea why so much energy is spent on GUI tools.

What do these things provide that one can't get from the command line, I wonder?

jackmaney• 13 years ago

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 (http://www.pgadmin.org/) doesn't?

burntsushi• 13 years ago

I certainly don't know what PostgreSQL Studio is like, but I think there's a lot of room for improvement in user-interface with pgAdmin. I tried using it but quickly gave up. It requires way too many mouse clicks to see the things I want to see.

(By comparison, I tend to enjoy using phpMyAdmin for MySQL.)

njudah• 13 years ago

pgadmin is a postgres adoption prevention mechanism, hopefully this tool will be developer friendly, and stable.

fein• 13 years ago

I have to be the only person on the planet that actually likes pgadmin.

jalan2• 13 years ago

As per OpenSCG: http://www.openscg.com/2013/10/postgresql-studio-1-0-is-out/

The standard bearer for PostgreSQL GUIs is pgAdmin, but that requires people to make a database connection across the internet which they may be reluctant to do if they don’t have a VPN of some sort set up. The right thing is to have a web-based GUI allowing users to connect to their database through a browser. PhpPgAdmin is an option, but many of the new PostgreSQL users I’ve talked to like the newer look and feel of sites like Heroku and are turned off by the UI of phpPgAdmin.

radiowave2• 13 years ago

Current version of pgAdmin adds support for connecting via ssh, though I haven't had cause to try using it yet.

marcosdumay• 13 years ago

So, instead of making a database connection through the internet, you tunnel it over http? What can you gain by doing that?

asdasf• 13 years ago

You don't need a VPN, pretty much any server running postgresql is also running sshd.

jroseattle• 13 years ago

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.

johnyzee9• 13 years ago

We make a similar thing: http://www.teampostgresql.com

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.

jaytaylor2• 13 years ago

It seems it only works with Java 6 (at least according to the Mac installer), which is too bad, because I don't want yet another version of Java on my machines.

Is the source code publicly available?

johnyzee9• 13 years ago

I believe the installer packages bundle a JRE (which runs in isolation from your other Java installations) so that shouldn't be a problem.

Only the cross-platform archive assumes you have a Java (6+) installed. Off the top of my head I can't remember if backporting to 5 would be a possibility but considering that Java 5 is almost ten years old, it may be too much effort to be worth it.

The source code isn't public anymore than my dirty underwear is :) Seriously though, I might open source it if I thought anyone would be able to get anything out of it.

Miyamoto• 13 years ago

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.

bobobjorn• 13 years ago

Where do you see anything about MySQL?

kcorbitt• 13 years ago

I think he's just trying to make the Java->Oracle->MySQL connection. I don't see how using Java is in any way a vote of confidence for MySQL though, so the point seems moot.

tensor• 13 years ago

Given your apparent hate for the JVM, I guess you only run C web servers?

eropple• 13 years ago

I'm not running Java on my web server, sorry.

This attitude is interesting to me, because I use Play Framework and Dropwizard quite heavily. What exactly is the objectionability of a JVM versus, say, running PHP-FPM?

icebraining2• 13 years ago

Maybe the objection is running the JVM on the server just for this tool?

SkyMarshal3• 13 years ago

You don't have to run this on your web or db or any other prod server.

Run it on a separate server or vm and point it at your db server.

http://www.postgresqlstudio.org/support/documentation/suppor...

zmmmmm• 13 years ago

JavaServer Pages? That's an interesting choice..

It's a GWT app. Some of the most awesome web tools I've ever used were written in GWT. Far from holding that against it I would see it as a promising sign that's going to be a high quality piece of work.

johnyzee9• 13 years ago

For what it's worth, TeamPostgreSQL is also a GWT app. Also, GWT apps are not JSP based, they are pure HTML and JS for the client-side.

mercurial• 13 years ago

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.

johnyzee9• 13 years ago

As the author of a comparable tool (TeamPostgreSQL), most of our users use an IP whitelist in their firewall to access the web client. Of course, you can also use the tool on your local network only as a substitute for a regular admin tool.

Ziomislaw• 13 years ago

IP whitelist... secure? O'RLY?

sehrope2• 13 years ago

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.

[1] http://www.jackdb.com/

fredsanford• 13 years ago

Note the above is not open source though it does have a crippled "free" option.

sehrope2• 13 years ago

To clarify, our free cloud version is a complete product. The only difference between it and the paid plans is the number of simultaneous connections and the organization, team, and audit management features.

afiler2• 13 years ago

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

radiowave2• 13 years ago

The total absence of any information on the site about what it is you're downloading, what it's requirements are, or how to install it, is rather unhelpful. I downloaded the zip file just to find out what was inside it.

I haven't tried installing it yet, but in principle installing .war files can be very simple. You need an application server (such as Apache Tomcat), you log into the admin section of that in your browser, and somewhere in there there's a form where you just upload the .war file, and it gets automatically unpacked, installed, services started up, and so on.

Edit: I take it all back. Well, most of it. They have an install guide, which you can find via Support, Documentation.

stesch• 13 years ago

Yeah, simple. And then the Java app tells you that you don't have the right version of Tomcat and do need at least an 0.0.1 update. (Yes, I was forced to run JIRA on Ubuntu 10.04 LTS)

Stupid Java environment. :-(

afiler2• 13 years ago

OK, this turned out to be not that hard, just completely unfamiliar for me (having last used Tomcat in 2002).

apt-get install tomcat7 tomcat7-admin; sudo $EDITOR /etc/tomcat7/tomcat-users.xml # add user with role manager-gui

Then I just went to http://localhost:8080/manager/ and uploaded the .war file. Et voilà.

dagurp• 13 years ago

I assume that you could also use glassfish

bockris• 13 years ago

Currently the site is trying to request this URL http://localhost/wordpress/wp-content/themes/alexandria/skin...

(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)

alexatkeplar• 13 years ago

This looks amazing for people who want to install and maintain their database client as a webapp on their production database server.

SkyMarshal3• 13 years ago

You don't run it on a production server, you can configure it to point at any db server in your network. They use localhost as an example only.

http://www.postgresqlstudio.org/support/documentation/suppor...

ninjazee124• 13 years ago

They should have wrapped it with jetty-runner or something that makes it easy to run it without having to fire up Tomcat.

th3byrdm4n• 13 years ago

Surface comment of the day - What an excellent, clean website. From the color scheme to the font choices. Excellent.

hansy• 13 years ago

I was really excited when Induction (http://inductionapp.com/) 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!

virtualwhys2• 13 years ago

I've been thinking about making the switch from MySQL to PostgreSQL.

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?

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)

asnyder• 13 years ago

These apps are nice, but the best PostgreSQL editor and GUI I've seen is EMS PostgreSQL Manager, http://www.sqlmanager.net/en/products/postgresql/manager. It even has a pretty nice query builder. Though I believe it's windows only, and also costs money. I use it every day and vastly prefer it over every other tool I've used.

virtualwhys2• 13 years ago

Linux workstation here but run a couple of Windows VMs for browser testing and Windows only apps.

EMS looks pretty feature rich, thanks for the tip.

SkyMarshal3• 13 years ago

Quite a few:

http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ...

http://www.postgresonline.com/journal/index.php?/archives/13...

Navicat is a good one if you don't mind paying $80-$250 for the personal version. http://www.navicat.com/

nodata• 13 years ago

Screenshot? Demo?

mrmondo• 13 years ago

Ugh, java... Really?

I really don't want to have to run a java server just to host this.

free652• 13 years ago

Personally I started to use valentina studio, it has diagrams which I love. But mysql workbench is a lot better.

gknapp• 13 years ago

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.

PostgreSQL Studio

Related Stories