10 ms·

PostgreSQL Studio

276 points by moreati 13y ago

hardwaresofton 13y 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 13y ago
Official announcement from PostgreSQL.org: http://www.postgresql.org/about/news/1485/ 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
untog 13y ago
..and the site has gone down. Sounds fantastic, though- pgSQL has always been lacking in admin tools compared to MySQL.
- jacques_chester 13y 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 13y 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?
    - jacques_chester 13y ago
      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.
- TylerE 13y 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.
  - astrodust 13y ago
    This thing? http://www.pgadmin.org/ 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.
    - reactor 13y ago
      If you dont mind using eclipse, you can use 'toad' eclipse plugin, which is really good.
  - untog 13y 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.
    - TylerE 13y ago
      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.
      - jordanthoms 13y ago
        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.
symfoniq 13y ago
I'm seeing a blank site.
ameoba 13y 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?
deleted 13y ago
[deleted]
jalan 13y ago
This image gives an idea of UI: http://www.openscg.com/wp-content/uploads/2013/10/pgstudio_screen-1024x738.png http://www.openscg.com/wp-content/uploads/2013/10/pgstudio_s...
- neovive 13y 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 13y ago
Clearly there is a pain point with PostgreSQL and GUI front-ends. Wish I could see the site.
- antihero 13y ago
  Honestly I found the sooner one gives up and just uses the command line, the better.
  - petit_robert 13y 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?
    - antihero 13y ago
      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.
      - petit_robert 13y ago
        [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.
jackmaney 13y 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/ http://www.pgadmin.org/) doesn't?
- burntsushi 13y 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 13y ago
  pgadmin is a postgres adoption prevention mechanism, hopefully this tool will be developer friendly, and stable.
  - fein 13y ago
    I have to be the only person on the planet that actually likes pgadmin.
    - ExpiredLink 13y ago
      Nope.
    - astrodust 13y ago
      The biggest problem with PGAdmin is it prioritizes the least used features, pushes them in your face, while burying the things you probably use most. It's about ten clicks to make a simple query. It's nearly as many just to see what columns a table has. The same thing in Seqeuel Pro? Two or three clicks. Max.
      - rosser 13y ago
        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.
jroseattle 13y 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.
johnyzee 13y ago
We make a similar thing: http://www.teampostgresql.com 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.
- jaytaylor 13y 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?
  - johnyzee 13y 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.
    - jaytaylor 13y ago
      I downloaded the Mac version, ran the installer, and it immediately said it required Java 1.6 and launched a JRE 6 install. $ java -version java version "1.7.0_25" Java(TM) SE Runtime Environment (build 1.7.0_25-b15) Java HotSpot(TM) 64-Bit Server VM (build 23.25-b01, mixed mode)
      - vinceguidry 13y ago
        Which one is the Mac version? Usability fail.
        13y ago
Miyamoto 13y 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 13y ago
  Where do you see anything about MySQL?
  - kcorbitt 13y 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 13y ago
  Given your apparent hate for the JVM, I guess you only run C web servers?
- eropple 13y 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?
  - icebraining 13y ago
    Maybe the objection is running the JVM on the server just for this tool?
    - chris_wot 13y ago
      As opposed to running rails or PHP just for any particular application?
mercurial 13y 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.
- johnyzee 13y 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 13y ago
    IP whitelist... secure? O'RLY?
sehrope 13y 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/ http://www.jackdb.com/
- fredsanford 13y ago
  Note the above is not open source though it does have a crippled "free" option.
  - sehrope 13y 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.
    - ghiculescu 13y ago
      And the limit on the number of rows per query. It does sound slightly crippled in that sense.
      - moinnadeem 13y ago
        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.
afiler 13y 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.)
- radiowave 13y 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 13y 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. :-(
- afiler 13y 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/ http://localhost:8080/manager/ and uploaded the .war file. Et voilà.
  - dagurp 13y ago
    I assume that you could also use glassfish
bockris 13y ago
Currently the site is trying to request this URL http://localhost/wordpress/wp-content/themes/alexandria/skins/images/alexandria/page_bg.png 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 13y ago
This looks amazing for people who want to install and maintain their database client as a webapp on their production database server.
- SkyMarshal 13y 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/supportdocumentationinstallation-guide/ http://www.postgresqlstudio.org/support/documentation/suppor...
ninjazee124 13y 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 13y ago
Surface comment of the day - What an excellent, clean website. From the color scheme to the font choices. Excellent.
hansy 13y ago
I was really excited when Induction (http://inductionapp.com/ 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!
virtualwhys 13y 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 13y 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 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.
  - virtualwhys 13y 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.
- SkyMarshal 13y ago
  Quite a few: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ... http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html 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/ http://www.navicat.com/
nodata 13y ago
Screenshot? Demo?
mrmondo 13y ago
Ugh, java... Really? I really don't want to have to run a java server just to host this.
free652 13y ago
Personally I started to use valentina studio, it has diagrams which I love. But mysql workbench is a lot better.
gknapp 13y 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.

276 points by moreati 13y 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 13y ago

Official announcement from PostgreSQL.org: http://www.postgresql.org/about/news/1485/ 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

untog 13y ago

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

jacques_chester 13y 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 13y 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?
  - jacques_chester 13y ago
    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.
TylerE 13y 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.
- astrodust 13y ago
  This thing? http://www.pgadmin.org/ 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.
  - reactor 13y ago
    If you dont mind using eclipse, you can use 'toad' eclipse plugin, which is really good.
- untog 13y 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.
  - TylerE 13y ago
    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.
    - jordanthoms 13y ago
      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.

symfoniq 13y ago

I'm seeing a blank site.

ameoba 13y 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?

deleted 13y ago

[deleted]

jalan 13y ago

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

neovive 13y 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 13y ago

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

antihero 13y ago
Honestly I found the sooner one gives up and just uses the command line, the better.
- petit_robert 13y 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?
  - antihero 13y ago
    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.
    - petit_robert 13y ago
      [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.

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

burntsushi 13y 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 13y ago
pgadmin is a postgres adoption prevention mechanism, hopefully this tool will be developer friendly, and stable.
- fein 13y ago
  I have to be the only person on the planet that actually likes pgadmin.
  - ExpiredLink 13y ago
    Nope.
  - astrodust 13y ago
    The biggest problem with PGAdmin is it prioritizes the least used features, pushes them in your face, while burying the things you probably use most. It's about ten clicks to make a simple query. It's nearly as many just to see what columns a table has. The same thing in Seqeuel Pro? Two or three clicks. Max.
    - rosser 13y ago
      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.

jroseattle 13y 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.

johnyzee 13y ago

We make a similar thing: http://www.teampostgresql.com 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.

jaytaylor 13y 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?
- johnyzee 13y 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.
  - jaytaylor 13y ago
    I downloaded the Mac version, ran the installer, and it immediately said it required Java 1.6 and launched a JRE 6 install. $ java -version java version "1.7.0_25" Java(TM) SE Runtime Environment (build 1.7.0_25-b15) Java HotSpot(TM) 64-Bit Server VM (build 23.25-b01, mixed mode)
    - vinceguidry 13y ago
      Which one is the Mac version? Usability fail.
      - 13y ago

Miyamoto 13y 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 13y ago
Where do you see anything about MySQL?
- kcorbitt 13y 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 13y ago
Given your apparent hate for the JVM, I guess you only run C web servers?
eropple 13y 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?
- icebraining 13y ago
  Maybe the objection is running the JVM on the server just for this tool?
  - chris_wot 13y ago
    As opposed to running rails or PHP just for any particular application?

mercurial 13y 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.

johnyzee 13y 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 13y ago
  IP whitelist... secure? O'RLY?

sehrope 13y 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/ http://www.jackdb.com/

fredsanford 13y ago
Note the above is not open source though it does have a crippled "free" option.
- sehrope 13y 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.
  - ghiculescu 13y ago
    And the limit on the number of rows per query. It does sound slightly crippled in that sense.
    - moinnadeem 13y ago
      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.

afiler 13y 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.)

radiowave 13y 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 13y 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. :-(
afiler 13y 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/ http://localhost:8080/manager/ and uploaded the .war file. Et voilà.
- dagurp 13y ago
  I assume that you could also use glassfish

bockris 13y ago

Currently the site is trying to request this URL http://localhost/wordpress/wp-content/themes/alexandria/skins/images/alexandria/page_bg.png 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 13y ago

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

SkyMarshal 13y 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/supportdocumentationinstallation-guide/ http://www.postgresqlstudio.org/support/documentation/suppor...

ninjazee124 13y 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 13y ago

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

hansy 13y ago

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

virtualwhys 13y 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 13y 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 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.
- virtualwhys 13y 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.
SkyMarshal 13y ago
Quite a few: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ... http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html 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/ http://www.navicat.com/

nodata 13y ago

Screenshot? Demo?

mrmondo 13y ago

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

free652 13y ago

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

gknapp 13y 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.