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
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.
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?
> 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.
I don't think anyone thought they were jsp for the client side... but surely they need some form of server technology for the server side -- and jsp would be perfectly usable for that?
JSP allows mixing client-side (HTML) with server-side code. GWT, and most modern frameworks, use regular servlets as the backend, and some (other) type of templating system with better separation.
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.
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.
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.
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.
There's a dropdown ('Select download') with four options, one of which says 'Mac OSX Installer'. Can you explain what makes it unclear? Thanks in advance!
Yes, it is still being actively developed, at a slowish rate depending on how many other projects are going on at the same time. We release a new build around every two-three weeks, with minor enhancements and bug fixes.
Releasing the source is no big deal, but I would have to spend some time wrapping it up nicely to make it accessible to outsiders.
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.
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.
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.
Just click on the 'Fetch More' button, and 50 more rows will be retrieved. For cloud based _free_ solutions, I haven't found anything better than this.
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?
SSGs are good if you think of them in advance. In the short term, such as when one is unexpectedly on the HN front page, switching on caching is the biggest payoff.
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.
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.
What do you find to be wrong with it? It's always done the job well for me, whereas Sequel Pro, while a prettier face, and useable enough, manages to crash at least once a day.
PGAdmin crashes regularly, and in a very annoying (and stupid!) move blocks the UI for all the windows on some database operations e.g. adding indexes. It also blocks the UI when it's processing the results of a db query, which can be slow if there is a lot of data being returned. The interface is sort-of ok though.
I don't see how that's "unspeakable bad, terrible, terrible". Latest versions crash a lot less and if you really need to use UI during long database queries you can run another instance of pgadmin. It's still very useful and powerful tool.
Well, SequelPro at least started adding support for Postgres[0], but it's hard to tell how far along it is. Most of the commits in that tree seem to be from last September, with a smattering from January and May of this year.
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.
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.)
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.
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)
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)
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.
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.
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.
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?
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.)
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.
Looks like what I wanted is already here. I think I can now learn Postgres on a Chromebook which just has a web browser. (I had created a free database on heroku previously.)
It literally just took me four clicks (one of them a double-click on the database server in the tree pane; so, yes, if you want to get pedantic, I pressed the trackpad five whole times) — inclusive of launching the app — to issue a query:
1. Launch the app
2. Double-click the db host to connect
3. Dismiss the dialog box prompting me to install the server instrumentation tools
4. Click the SQL magnifying glass icon in the toolbar.
That third click could be eliminated from ever being required again with the addition of checking the "don't show this dialog box again" box before dismissing the dialog.
So, best case, three clicks — four if you click on the "OK" button on the password dialog, instead of hitting enter. Yeah, PgAdmin isn't the prettiest tool on the planet, but demonstrably false hyperbole is unbecoming.
1. Launch the app.
2. Click the host. This apparently selects it.
3,4. Double click the host to force it to connect.
5. Click OK on the login screen even though it's set to "Store Password".
6. Click to select the proper database.
7. Click to magnifying glass.
8. Find the query window, which has a tendency to show up in really awkward places if you remove your second screen, click to drag it back somewhere useful, such as visible on your screen.
It feels like ten because of all the steps that are totally unnecessary. Sequel Pro, by contrast, doesn't have a separate query window, you never need to find it, and will connect automatically.
PgAdmin seems to ask an awful lot of stupid questions, and there's no way to turn them off. The "Don't show this dialog again" setting for each, as you mention, would help a lot in this department.
I used it for my book (Instant Postgres Starter) mainly because I wanted to show a cross-platform UI that would look consistent. Day to day I don't use it. Maybe if it was awesome I would but I don't feel hamstrung by the CLI tools--the opposite, really.
I guess being able to see a whole bunch of things at the same time is useful, plus never having learn much SQL, plus being edit things by clicking on them.
[I just realized that my comment may have appeared very harsh, specially from the authors' point of view. My apologies to them, I was _very happy_ to have a good GUI when I started working with databases]
@antihero : Seeing things does help, but in my experience, using scripts and the command line is faster for developpement, because a lot of code can be reused, which is not the case with clicks.
I was being too restrictive though, a lot can be done with a GUI, of course.
(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 (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!
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.
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