PostgreSQL Studio Released
Written by Kay Ewbank   
Monday, 07 October 2013

A web-based GUI that lets users connect to PostgreSQL databases through a browser has been released.

 

postgresqlstudioscreen1

 

Writing about the new GUI on the Open Source Consulting Group blog, its creator Jim Mlodgenski explains why it is needed:

“With the growing use of PostgreSQL in the cloud, users are bumping into the challenge of how to interact with their databases. Experienced PostgreSQL users happily ssh into the instance and bring up psql, but there are a ton of new users to PostgreSQL who still aren’t comfortable with psql and want a GUI.”

Until now most Postgre users who wanted a GUI chose pgAdmin, which has recently reached v1.18.0, but that needs a VPN to ensure a secure database connection without the need for opening firewalls.

Mlodgenski says that he came to the conclusion that the best road forward was to just start from a clean slate:

“I decided to write things in Java since that’s what I know well and it lets you create a cross-platform application very easily. I also used the Google Web Toolkit since Google is pretty good at making interactive UIs on the web. There are a number of other UIs out there that have a very good web-based GUI for PostgreSQL, but none of them are open source, which I believe is critical in the success of the project. So… OpenSCG is now releasing PostgreSQL Studio under the PostgreSQL license.”

PostgreSQL Studio has a web-based console that can be used to carry out PostgreSQL database development tasks securely. It supports PostgreSQL 9.2.x and 9.3.x, Postgres-XC 1.0.x and Postgres-XC 1.1.x, and vFabric Postgres 9.2.4. You get a schema browser that shows you the database objects for the currently active connection for your selected schema. A detail browser shows the features of all the database objects and lets you modify them, with object-specific functions such as creating an index or granting security. A SQL worksheet can be used to enter and process individual SQL statements during a database session. Any executed statements can also show the SQL execution plan which provides a detailed outline for how PostgreSQL processes each statement.

 

 

Finally, you get a set of object wizards that let you create database objects without needing to know the PostgreSQL syntax. There are wizards for creating tables, views, indexes, constraints, triggers and sequences.

postgresqlstudio

 

More Information

PostgreSQL Studio

PostgreSQL Studio 1.0 is out

Related Articles

PostgreSQL 9.3 Released

  

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

 

Banner


GR00T Could Be The Robot You Have Always Wanted
27/03/2024

We may not have flying cars, but we could well soon have robots that match up to predictions for the 21st century. Nvidia has announced GR00T, a cleverly named project to build robots using foundation [ ... ]



Open Source Key To Expansion of IoT & Edge
13/03/2024

According to the 2023 Eclipse IoT & Edge Commercial Adoption Survey Report, last year saw a surge of IoT adoption among commercial organizations across a wide range of industries. Open source [ ... ]


More News

Last Updated ( Monday, 07 October 2013 )