DBeaver free, multi-platform universal SQL client. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
You can do all crud operations as well as Advances operations from here. Supports N number of database types (Relational/NoSQL)
pgAdmin III, the "official" GUI client for PostgreSQL is available for OSX, too.
At least the Windows version supports SSH tunneling so I'm pretty sure the OSX version does so, too. Listing databases and running queries are standard features for any database frontend so those features are supported, too.
At work I am using DB Visualizer. This is a database manipulation tool that supports a large number of database systems, including PostgreSQL. It is written in Java, which means it is cross-platform compatible. I have experience with the free Linux version of it, but the website states it supports the 3 major OS-es.
Here is how it fits your requirements:
You may use "Microolap Database Designer for PostgreSQL" aka PgMDD
It's a commercial software with 30-day trial though. Personal\Educational license will cost $124.95, however you may get a free license also (details on the order page).
Here is a quick tutorial on how to Reverse Engineer (Import) PostgreSQL database: https://www.youtube.com/watch?v=pj3-...
If you want to minimize dependencies on the server, your best bet is sure to be enabling an SSL-only connection over the PostgreSQL protocol from your desktop/laptop. You can then use any software of your choice via the remote network protocol.
If you don't want to expose PostgreSQL to the wider Internet, even SSL-only with a limited range of permitted ...
You can use SQL Power Architect:
Most features are free, including the ER schema generation
Microsoft Windows / Mac OS X / Linux
Supports most commonplace DBMS suggest MySQL and PostgreSQL
You just need to drag-and-drop to generate the visual schema:
You may try nginx HTTP server in conjunction with ngx_postgres module. ngx_postgres allows nginx to communicate with PostgreSQL database. Your basic requirements are satisfied as far as I see:
No programming needed. Only ngx_postgres configuration shall be specified to map URLs to DB queries.
At least SELECT with WHERE clause support (see examples on ...
Syncfusion Dashboard Platform is an option to consider.
Dashboards need to be designed using the Dashboard Designer (windows application) and published using the Dashboard Server (web application). Self hosted is the only option for now.
The dashboard platform and more are available for free through the community license program if you qualify. The ...
I would use MySQL as RDBMS and MySQL Workbench as IDE:
works on Windows/Linux/Mac
straightforward to install (to make it simpler you could even install MySQL on some server, and just have your interns connect to it)
SQL documentation on the side
in addition to the SQL Editor, you can design visually database (usual ...
You may like my app SQLPro for Postgres (App Store).
The app supports the features you requested (SSH Tunnelling, listing databases and running queries).
It also includes some nice features such as:
Auto-completion (sometimes called intellisense).
Exporting and import data.
A multi-tabbed based editor (run multiple queries at once).
There is a seven day ...
Egger Apps released Postico, “A Modern PostgreSQL Client for OS X”. Available on directly and on the Apple Mac App Store. This is a Mac-only app.
Both SSL and SSH can be used for secure connections.
Supports PostgreSQL 8.0, 8.4, 9.1, 9.2, 9.3, 9.4, and 9.5.
The earlier generation of this app is now free-of-cost, PG Commander. Postico is the ...
I'd give them sqlite - it's perfect for beginning situations like this:
The DB is in a single file, making it really easy to start using, and really easy to reset if you screw it up.
The DB engine is a single executable - just type sqlite3 <db file name> to get started.
Imports from CSV are pretty easy.
Supports the usual set of SQL operations.
I would recommend phpMyAdmin - works with MySQL (also MarioDB & Drizzle though I can't comment on the those). It does require PHP and MySQL/MarioDB/Drizzle - WAMP has it pre-setup through the installer if you want a simple Windows installation solution.
With phpMyAdmin you have full console abilities and also a very very easy to play with learn from/use ...
There are several tools for this. Personally I would not recommend pgAdmin. It has a clumsy user interface which is OK for technical people, but for someone who has no experience with databases it is most definitely not the right choice (this will probably change with the upcoming new version of pgAdmin which is a complete rewrite)
There are two web-based ...
Sandman2 does exactly what you want, in python and advertises itself as Automatically generate a RESTful API service for your legacy database. No code required!
It uses SQLAlchemy for database interactions (and support any of its many supported DB) and offers not only a REST API but also a decent web Admin Interface.
Once, configured you should be able to ...
RestifyDB (http://restifydb.com) is one solution. Its opensource and can be used free (unless you need patching etc for which there is a commercial version available. Though i have not used slash DB (https://www.slashdb.com/) is another solution which works on similar lines.
I recommend you to give DBxtra a try, it connects to Postgres directly, it's self hosted, and can be accessed from any computer with just a web browser, also, it's easy to use and have interactivity options (Dashboards) as well as pixel perfect reports.
P.S.: I'm a DBxtra evangelist.
I've tried to interpret your question, you mention self-hosted (in a tag) and also web-based, so I'm actually going to suggest a couple of SaaS solutions - one with a self-hosted option:
Tableau - a powerful, enterprise-class data reporting and visualzation tool http://www.tableau.com/products
QueryTree - a more entry-level data reporting tool that does ...
pgAdmin is the best option because it is built for PostgreSQL only.
I am using pgAdmin and Database .NET, Database .NET is my favorite since it has many good features which pgAdmin doesn't. It is very lightweight (free and commercial versions are available) and portable.You can connect many databases with this.
If you are looking for a solution that works in a web interface (to allow edits in a browser to be added to your server based database) you should look at GIS server software that provides Transactional Web Feature Service capabilities (WFS-T).
For example you could use GeoServer, or TinyOWS
You can use WFS-T services in conjunction with desktop GIS ...
pgAdmin could be the tool of your choice:
pgAdmin (source: pgAdmin; click image for larger variant)
As the screenshot shows, it should match your needs quite fine:
a form layout to add and modify entries: Yupp (see lower-right)
a table layout for viewing an entire table: Yupp (see lower-left)
recognise the foreign key constraints and provide drop down ...
I was on the same boat as you and then I found Metabase.
is free - Yes, it's Open Source
can be deployed on premise (not in a cloud) - Yes it has 5 minute installation and it's true
can work with PostgresDB - Yes it can and with a bunch of others as well
allows to create reports simply from SQL query - Either you can run your query or design one with their ...
I would suggest taking a look at Python plus Pandas
is free both Gratis & Open Source
can be deployed on premise (not in a cloud) Yes
can work with PostgresDB Yes - just about any DB
allows to create reports simply from SQL query (as spreadsheet or csv), without using bulky & complicated report designers There is a lot of support fo,r and choice of, ...
There is a tool called pgtricks which does this.
From the docs:
pg_dump_splitsort is a handy script for pre-processing PostgreSQL's pg_dump output to make it more suitable for diffing and storing in version control.
The script splits the dump into the following files:
0000_prologue.sql: everything up to the ...
Your web actually runs on the server while ...
I hate paying for software, so when I do, I make sure there isn't anything free that can do the job. In the case of PostgreSQL, a lot of free software exists that claim they are GUI but for a simple task of creating a table, you need to know the Syntax of SQL. My favorite which is great for MySQL is HeidiSQL has an experimental version for Postgres. The ...