pgweb 0.9.11

pgweb is a web-frontend in Go to browse PostgreSQL 9.x databases. It easily connects to a running local or remote server, shows tables and rows, can detail the table and column type attributes, run SQL queries, and export results to CSV. It's cross-platform and easily started from the console and then be accessed per browser.

Tags go postgresql database browser web-based
License MITL
State stable

Recent Releases

0.9.1109 Dec 2017 03:15 minor feature: ssl mode for the connection url in the bookmarks, GH-320. Add support for CORS, GH-321. custom query results counter for empty queries, GH-322. Reorganize the table context menu, GH-323. Disable database connection string text field autocomplete, GH-327. Add db preto the table export files, GH-329. Add database view context menu with export actions, GH-330.
0.9.1005 Nov 2017 06:45 minor feature: Make idle connection timeout configurable, GH-282 . panics when sshinfo is not set on bookmarks, GH-296 . Dot now allow using startup bookmark in multi-session mode, GH-300 . Add ability to copy table name from the sidebar, GH-301 .
0.9.929 Sep 2017 15:25 minor feature: Automatically format JSON data exports, GH-255 . Update Docker image to alpine:3.6, GH-256 . Print out PostgreSQL server version on start in a single-session mode, GH-264 . Record last query timestamp for the client connection, GH-265 . Add context menu for table headers in browse mode (copy name, see unique values), GH-268 . Add ability to export current database dump, GH-270 . Automatically open pgweb in browser on start if its already running, GH-272 . Connect to the database with credentials provided by a third-party backend, GH-266 . Automatically idle sessions (no activity in 24), GH-275 . Allow connecting via SSH with a custom private key and other, GH-277 . Add options to disable SSH connections, GH-279 .
0.9.805 Aug 2017 11:25 minor feature: error checking in the API, GH-234 . activity tab to support PG 9.x versions, GH-237 . Remember sort column and order for pagination, GH-240 . Use sslmode=disable for bookmarks without sslmode option, GH-244 . Javascript for IE9-11, GH-245 . Require confirmation for the disconnect, GH-246 . Clean the results table on manual disconnect.
0.9.705 Apr 2017 18:45 minor feature: in query base64-encoding, GH-186. rows pagination visibility, GH-190. with query order escaping, GH-191. invalid query selection for explain command, GH-198. with empty sidebar, now it shows empty state, GH-202. Added new flag --readonly to enable read only transaction mode, GH-193. Added ability to kill any running query, GH-194. Added session database connection locking, GH-195. Added ability to switch between databases, GH-196. Added feature to keep last selected tab when switching between tables, GH-197. Added new flag --bookmark (-b) to specify server connection from bookmark, GH-201.
0.9.620 Nov 2016 00:45 minor feature: in query base64-encoding, GH-186 . rows pagination visibility, GH-190 . with query order escaping, GH-191 . invalid query selection for explain command, GH-198 . with empty sidebar, now it shows empty state, GH-202 . Added new flag --readonly to enable read only transaction mode, GH-193 . Added ability to kill any running query, GH-194 . Added session database connection locking, GH-195 . Added ability to switch between databases, GH-196 . Added feature to keep last selected tab when switching between tables, GH-197 . Added new flag --bookmark (-b) to specify server connection from bookmark, GH-201.
0.9.503 Oct 2016 06:45 minor feature: Only view schema with USAGE privileges, GH-167 . broken export to CSV/JSON/XML if hashmark in URL, GH-175 . Added example service configuration for systemd, GH-177 . Allow setting auth user and pass using variables.
0.9.431 Jul 2016 02:45 minor feature: CSV/JSON/XML export buttons when pgweb is running with url pre GH-170 .
0.9.301 Jul 2016 19:25 minor feature: Use Go 1.6 for development, GH-155 . timestamp formatting in CSV export, GH-163 . Include PostgreSQL 9.6 for integration testing. Switch docker image to Alpine to reduce image size. Add support for ARMv5.
0.9.203 Mar 2016 07:05 minor feature: With unsafe base64 encoded sql queries. With session id not being included in multi-session mode. Visual with long table names in sidebar. Visual with a scrollbar in table information widget. With database connection form being reset by clicking on 'cancel' button. Adds ability to connection. Adds display message for number of affected rows for update/delete queries, GH-133 . Adds web server url preas a CLI option, GH-135.
0.9.126 Jan 2016 19:25 minor feature: With tables context menu. JS when query returns no rows. With switching between different connection modes. Adds AJAX timeout to 5s. Adds sidebar reload action on any CREATE/DROP action.
0.9.020 Jan 2016 15:05 minor feature: Adds support for multiple schemas. GH-112 . Adds support for native ssh tunnes. GH-114 . Adds materialized views to list of schema objects. Adds a few design tweaks and cleanups. with nil result set when fetching rows.
0.8.012 Jan 2016 10:25 minor feature: with bigint conversions in javascript. Now bigints are encoded as strings. GH-109 . Adds pagination and simple column filtering to table rows browser. GH-110 . Adds ability to use pgweb with multiple database sessions. GH-111 . Adds a few design tweaks and cleanups.
0.7.006 Jan 2016 10:25 minor feature: Adds sequences to the sidebar panel - GH-100 . Adds table constrains view - GH-104 . Adds ability to export table and query rows as JSON/XML - GH-107 . Updates to UI theme and SQL editor.
0.6.317 Aug 2015 04:25 minor feature: Adds PostgreSQL password escaping in web ui, GH-96 . Adds base64 query encoding for CSV export, GH-95 . Adds automatic saving of last executed query to localStorage. Adds request middleware to log incoming form params in debug mode.
0.6.217 Jul 2015 03:25 minor feature: Adds ability to specify connection strings prefixed by postgresql://, GH-92 . Updates configuration for Heroku, GH-89 , GH-90 . Updates postgresql library dependency to latest, GH-91 . Fixes password field to not display plaintext passwords, GH-87 .
0.6.121 Jun 2015 07:25 minor feature:
0.6.001 Jun 2015 17:25 minor feature: Adds ability to execute only selected SQL query in run command view, GH-85 . Adds ability to delete/truncate table via context meny on sidebar view. Adds ability to export table contents to CSV via context menu on sidebar view. Changes sidebar color scheme to a lighter and better looking one.
0.5.323 May 2015 23:05 major bugfix: Changes default server port from 8080 to 8081 to avoil conflict with RethinkDB. Changes styles for table rows and connection settings window. Adds highlighting styles for columns with sort order. Adds git sha into program version output. Add new endpoint /api/info to get build details.
0.5.214 Apr 2015 07:05 minor feature: Adds a new endpoint /activity that retuns active queries. Adds tab to view active queries. Adds column sorting when browsing table contents. Fixes SQL query view when switching to table structure view.
0.5.125 Feb 2015 02:05 minor bugfix: Upgrades Gin framework dependency to 0.5.0. Fixes server crash if another pgweb server is running.
0.5.016 Jan 2015 12:25 minor feature: Adds Go 1.4 support Adds connection string printing in debug mode Adds initial bookmarks support Adds /api prefix for all API calls Adds makefile usage task Adds windows CI to verify build process Adds example sql database to codebase Adds timestamped filenames when exporting results to CSV GH-75 Adds connection checking on each request to prevent api panics Adds timestamps to query history records Adds current database name to the sidebar Adds button to refresh tables list to the sidebar Updates all application dependencies Changes /api/info endpoint to /api/connection Fixes issues with connection string/options parsing Fixes capitalized column names in table view Fixes connection string validation in /api/connect endpoint
0.4.102 Dec 2014 15:05 minor feature: Adds pgweb version on start GH-65 Adds user detection from OS environment Adds simple memory profiles with --debug option Adds the session user and search path in connection info GH-67 Adds table list reloading after CREATE/DROP TABLE queries GH-69 Adds font awesome icons for the sidebar Removes query recording for internal queries GH-67 Fixes default sslmode. Its not longer set to "disable" Fixes cells cropping on table indexes view Fixes connection URL generation using web interface Fixes SQL statements for table row count GH-67 Fixes /tables JSON response if database does not have any tables
0.4.014 Nov 2014 10:45 major feature: Adds query escaping when exporting results to CSV. Adds keyboard shortcut (ctrl+e, command+e on mac) for query explain action. Adds HTTP basic authentication with --auth-user and --auth-pass flags. Adds -skip-open/-s flag to disable automatic browser launch. Adds --bind option to specify server listen hostname/ip. Adds ssl mode parameters to url if ssl flag is set and not defined in the url. Adds dependency management with Godep. Adds Docker support. Adds Heroku support. Adds ability to connect to databases with no tables. Adds precompiled assets into repository to simplify development. Adds a connection details view. Adds a new interface to specify connection settings or make a new connection. Adds page favicon. Adds ability to present cell data as text area by double clicking on it. Fixes styles for query explain results. Fixes sidebar navigation scrolling styles. Fixes sidebar table name styles to support long names.