4 ms·

For some reason I was having difficulty getting it to connect to our internal servers, though I could connect to one on my local machine. I'm guessing ssl relat

For some reason I was having difficulty getting it to connect to our internal servers, though I could connect to one on my local machine. I'm guessing ssl related. In any event, definitely pretty neat, though it wouldn't really replace my standard database interface. Which brings up the question -- most database tools I've used for ad-hoc queries have been mediocre at best. psql isn't bad, but a text based interface is suboptimal in many cases. On the other hand, SquirrelSQL, which I generally use, is adequate though not particularly friendly. What I'd really love is a UI with some modern sensibilities, like saving all queries in history and providing Sublime Text like cmd-P commands to quickly recall and re-run queries. Auto-limiting, quick scrolling through query history with arrow keys, templated queries/ handling bind params, nice key mappings, SQL formatting, etc... When I was using Oracle, Toad provided some of the above, but it was pretty bloated and provided way more than what I really needed. Tried navicat and it ate 100% of my CPU and crashed repeatedly. I'd be curious if there are any better (free or cheap) alternatives out there, but most of the offerings I've seen look pretty weak.

sosedoff 12y ago
This is just a start, there're lots of features in roadmap (not in repo yet). Im trying to model pgweb after Sequel Pro (http://www.sequelpro.com/ http://www.sequelpro.com/), which is MySQL and OSX only. Some of the features you mentioned will be available in upcoming releases.
- girvo 12y ago
  Modelling it of Sequel Pro? Now you have my attention... Sequel is easily one of the nicest DBA tools I've used, however it's limitation of being MySQL-only means I get frustrated when having to rely on other, lesser tools for Postgres.
  - sosedoff 12y ago
    Same here, that's the reason why pgweb was created.
  - humanfromearth 12y ago
    Can't we give a lot of money to the guy who made Sequel Pro to make a PG version?
    - jakobegger 12y ago
      I'm a former Sequel Pro developer and I wrote a Postgres client for OS X: https://eggerapps.at/pgcommander/ https://eggerapps.at/pgcommander/ I'm currently working on version 2.0 which includes a table structure editor: https://eggerapps.at/pgcommander-prerelease/ https://eggerapps.at/pgcommander-prerelease/
      - gglanzani 12y ago
        So great! Is there a way to register (i.e. pay) for v1 and get v2 when it comes out?
        jakobegger 12y ago
        Yes! All v1 licenses bought on my website after September 1st will be valid for v2. See https://eggerapps.at/pgcommander/faq.html https://eggerapps.at/pgcommander/faq.html
      - tehno 12y ago
        For us, better support for editing hstore and json/jsonb values is a must. Add that and we might become customers.
        jakobegger 12y ago
        This is on my roadmap for next year. Drop me a line at jakob@eggerapps.at and I'll send you a note once it's ready.
        peter91 12y ago
        If you're looking for a general JSON editor - there's a nice online one at: https://json-csv.com/editor https://json-csv.com/editor
- Schweigi 12y ago
  I'm currently using IntelliJs database interface to access PostgreSQL but I would definitely pay for something similar like SequelPro for Postgres.
njs12345 12y ago
IDEA has some pretty slick database features, including some of the things you mentioned: https://www.jetbrains.com/idea/features/database_tools.html https://www.jetbrains.com/idea/features/database_tools.html Only in the Ultimate edition though, so quite pricey..
- takemikazuchi 12y ago
  0xDBE is really nice: https://www.jetbrains.com/dbe/ https://www.jetbrains.com/dbe/ Though it's still in alpha.
- conradfr 12y ago
  I use it a lot, it's great for schema & queries but I don't really like it for data manipulation & export though, a bit cumbersome for my taste.
jackalope 12y ago
Vim users might consider the dbext plugin: http://vim.sourceforge.net/scripts/script.php?script_id=356 http://vim.sourceforge.net/scripts/script.php?script_id=356 It supports a long list of databases, a variety of common development languages, has a command history, prompts for variables in statements, and more features I haven't touched. As a Vim plugin, it's fairly light on the CPU, but with all the expressive power you expect from Vim (including syntax formatting/highlighting and the availability of your other favorite plugins). I like it because I can dedicate a plaintext file to a specific task, develop my queries, save my results, and come back to it at a later date if the need arises. Some of these files are an important part of my workflow. The only thing I'd change is a more secure handling of login credentials, but it sure beats the standard command line tools bundled with most databases and requires less overhead than the GUI or web-based ones.
ianmcgowan 12y ago
Aqua Data Studio (http://www.aquafold.com/ http://www.aquafold.com/) is pretty awesome, and does most of the above. It's far from cheap, unless you're comparing it to Toad. It connects to pretty much anything with a jdbc driver, and provides a relatively uniform interface - I use it regularly with postgres, mssql, oracle and teradata. Tora is free, and open source, but a bit rough around the edges.
- enjoy-your-stay 12y ago
  Aquadata looks like a very interesting application, I'm often surprised that there's so much support for database ddl and querying, but not so much support for actually doing something more with the data, like graphing and other visualisations. And to plug my own little endeavour :-) if you're on Linux and are looking for a quick and easy to use Forms builder, here's my early beta http://www.data-forms-action.com/ http://www.data-forms-action.com/ Supports MySQL and Postgres currently.
  - hamiltor 12y ago
    If you are looking for sql graphing check out http://www.sqldashboards.com/ http://www.sqldashboards.com/ It supports MS-SQL, MySQL, Postgres and allows creating live interactive charts directly from SQL queries. There's also a command line interface for generating static .png images. Disclaimer: I make the software
thorin 12y ago
pl/sql developer is really great on Oracle and more stripped down and developer focused than toad. SSMS for sqlserver I find really good for some stuff and fairly awful for some other stuff (editting data)
sfjailbird 12y ago
TeamPostgreSQL is a web based Postgres interface with many of the features you mentioned. http://www.teampostgresql.com http://www.teampostgresql.com

sosedoff 12y ago

This is just a start, there're lots of features in roadmap (not in repo yet). Im trying to model pgweb after Sequel Pro (http://www.sequelpro.com/ http://www.sequelpro.com/), which is MySQL and OSX only. Some of the features you mentioned will be available in upcoming releases.

girvo 12y ago
Modelling it of Sequel Pro? Now you have my attention... Sequel is easily one of the nicest DBA tools I've used, however it's limitation of being MySQL-only means I get frustrated when having to rely on other, lesser tools for Postgres.
- sosedoff 12y ago
  Same here, that's the reason why pgweb was created.
- humanfromearth 12y ago
  Can't we give a lot of money to the guy who made Sequel Pro to make a PG version?
  - jakobegger 12y ago
    I'm a former Sequel Pro developer and I wrote a Postgres client for OS X: https://eggerapps.at/pgcommander/ https://eggerapps.at/pgcommander/ I'm currently working on version 2.0 which includes a table structure editor: https://eggerapps.at/pgcommander-prerelease/ https://eggerapps.at/pgcommander-prerelease/
    - gglanzani 12y ago
      So great! Is there a way to register (i.e. pay) for v1 and get v2 when it comes out?
      - jakobegger 12y ago
        Yes! All v1 licenses bought on my website after September 1st will be valid for v2. See https://eggerapps.at/pgcommander/faq.html https://eggerapps.at/pgcommander/faq.html
    - tehno 12y ago
      For us, better support for editing hstore and json/jsonb values is a must. Add that and we might become customers.
      - jakobegger 12y ago
        This is on my roadmap for next year. Drop me a line at jakob@eggerapps.at and I'll send you a note once it's ready.
      - peter91 12y ago
        If you're looking for a general JSON editor - there's a nice online one at: https://json-csv.com/editor https://json-csv.com/editor
Schweigi 12y ago
I'm currently using IntelliJs database interface to access PostgreSQL but I would definitely pay for something similar like SequelPro for Postgres.

njs12345 12y ago

IDEA has some pretty slick database features, including some of the things you mentioned: https://www.jetbrains.com/idea/features/database_tools.html https://www.jetbrains.com/idea/features/database_tools.html Only in the Ultimate edition though, so quite pricey..

takemikazuchi 12y ago
0xDBE is really nice: https://www.jetbrains.com/dbe/ https://www.jetbrains.com/dbe/ Though it's still in alpha.
conradfr 12y ago
I use it a lot, it's great for schema & queries but I don't really like it for data manipulation & export though, a bit cumbersome for my taste.

jackalope 12y ago

Vim users might consider the dbext plugin: http://vim.sourceforge.net/scripts/script.php?script_id=356 http://vim.sourceforge.net/scripts/script.php?script_id=356 It supports a long list of databases, a variety of common development languages, has a command history, prompts for variables in statements, and more features I haven't touched. As a Vim plugin, it's fairly light on the CPU, but with all the expressive power you expect from Vim (including syntax formatting/highlighting and the availability of your other favorite plugins). I like it because I can dedicate a plaintext file to a specific task, develop my queries, save my results, and come back to it at a later date if the need arises. Some of these files are an important part of my workflow. The only thing I'd change is a more secure handling of login credentials, but it sure beats the standard command line tools bundled with most databases and requires less overhead than the GUI or web-based ones.

ianmcgowan 12y ago

Aqua Data Studio (http://www.aquafold.com/ http://www.aquafold.com/) is pretty awesome, and does most of the above. It's far from cheap, unless you're comparing it to Toad. It connects to pretty much anything with a jdbc driver, and provides a relatively uniform interface - I use it regularly with postgres, mssql, oracle and teradata. Tora is free, and open source, but a bit rough around the edges.

enjoy-your-stay 12y ago
Aquadata looks like a very interesting application, I'm often surprised that there's so much support for database ddl and querying, but not so much support for actually doing something more with the data, like graphing and other visualisations. And to plug my own little endeavour :-) if you're on Linux and are looking for a quick and easy to use Forms builder, here's my early beta http://www.data-forms-action.com/ http://www.data-forms-action.com/ Supports MySQL and Postgres currently.
- hamiltor 12y ago
  If you are looking for sql graphing check out http://www.sqldashboards.com/ http://www.sqldashboards.com/ It supports MS-SQL, MySQL, Postgres and allows creating live interactive charts directly from SQL queries. There's also a command line interface for generating static .png images. Disclaimer: I make the software

thorin 12y ago

pl/sql developer is really great on Oracle and more stripped down and developer focused than toad. SSMS for sqlserver I find really good for some stuff and fairly awful for some other stuff (editting data)

sfjailbird 12y ago

TeamPostgreSQL is a web based Postgres interface with many of the features you mentioned. http://www.teampostgresql.com http://www.teampostgresql.com