0.14.230 Oct 2023 11:05
NEW: Execute tests using PostgreSQL 16, GH-691.
: Undatabase sessions and tunnels, GH-688.
: Use pg_table_size for table stats query, GH-685.
: Use `HasSuf` to correctly determine URL pre, GH-684.
0.11.910 Oct 2021 08:25
Releases are built on Go 1.17.
Build time correction, GH-521.
broken assets URL path pre, GH-525.
Update docker build image to alpine:3.14, GH-522.
Upgrade gin dependency to v1.7.4, GH-527.
Add FreeBSD startup script, GH-520.
0.11.810 Jul 2021 03:15
Releases are built with Go 1.16.
Add ARM64 v7 build target, GH-497.
Switch to Go modules for dependency management, GH-509.
Switch to Go embed for static assets management, GH-510.
Add Darwin/ARM64 build target (Apple Silicon), GH-513.
0.11.719 Oct 2020 10:25
Releases are built with Go 1.15.
Show results row context menu on custom query results, GH-457.
Do not terminate if local authentication failed on start, GH-463.
Do not show other databases if session is locked, GH-470.
Strip deinformation from binary to reduce size, GH-489.
Disable autocomplete on database search field, GH-492.
Improve windows connection error matching during start, GH-493.
0.11.622 Feb 2020 02:05
Add CLI options for SSL key, cert and root certs GH-452 .
Remove double click action on cell GH-455 .
0.11.517 Dec 2019 18:25
Add basic SQL keyword autocompletion, GH-443.
SSH Private Key handling update (encrypted keys are supported now), GH-445.
Include Go version into pgweb --version output, GH-447.
long table name in the sidebar, GH-448.
Add SQL objects (table,views,etc) autocompletion, GH-449.
Include Go version into info API endpoint, GH-450.
0.11.406 Oct 2019 07:45
SQL export filename, GH-438.
Update Docker image to alpine:3.10, GH-439.
Drop unsupported pg_dump options from connection string, GH-441.
Misc code cleanup and formatting, GH-442.
0.11.325 Jul 2019 03:25
Misc: add script to update homebrew formula version, GH-423.
Destructive keyword restriction in read-only mode, GH-421.
Make database object searchable in sidebar, GH-434.
Update lib/pg to 1.1.1, GH-435.
0.11.129 Jan 2019 03:16
startup error when DATABASE_URL is set, GH-406.
user auto detection when USER env var is not set, GH-408.
Switch bindata dependency to use maintained fork: github.com/go-bindata/go-bindata, GH-409.
0.11.025 Dec 2018 10:05
Tweak sidebar database object counters styles, GH-400.
Do not exit with error if local server is not running, GH-399.
SSH host verification check, GH-398.
Scope activity list to current database only, GH-397.
Show current release version and check for updates, GH-396.
Force switch back to default connection settings view, GH-395.
row count estimation, GH-394.
Print out failed query SQL and args with --deflag, GH-393.
0.10.029 Nov 2018 05:45
relation not found errors when dealing with table names that have uppercase characters, GH-356.
Dockerfile updates, GH-357.
Check if pg_dump is available before running database export, GH-358.
Improvements to CockroachDB integration, GH-365.
Add EstimatedTableRowsCount to avoid count in large tables, GH-366.
Automatically set table filter option to 'equals' if its not set, GH-370.
Dependencies update and switch to dep, GH-375.
Add column context menu item to get numeric stats, GH-377.
with connection string builder, GH-378.
Include rows count to numeric stats view on table column, GH-379.
Make localhost to be a default db host, GH-380.
Clear out connection settings/bookmark on login screen when running in session/connect mode.
Add table row context menu with actions, GH-381.
Allow settings url prewith URL_PREenv var, GH-387.
JSON marshal panic when dealing with NaN values, GH-388.
startup behavior when user did not provide a database name, GH-389.
0.9.1224 Apr 2018 17:05
Add link to view database connection string format on login page.
Include constraint name under "constraints" tab, GH-343.
Misc CI and config changes.
0.9.1109 Dec 2017 03:15
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
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
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
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 .
Require confirmation for the disconnect, GH-246 .
Clean the results table on manual disconnect.
0.9.705 Apr 2017 18:45
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
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
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.301 Jul 2016 19:25
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
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
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
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
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
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
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
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.001 Jun 2015 17:25
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
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
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
Upgrades Gin framework dependency to 0.5.0.
Fixes server crash if another pgweb server is running.
0.5.016 Jan 2015 12:25
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
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
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.