CHANGELOG.md

Changelog

Current release is 0.16.2.

0.16.2 - 2024-11-02

• FIX Build a new Docker image with PostgreSQL 17 support
• FIX Run CI against PostgreSQL 17, GH-758
• FIX Rename master to main branch, GH-750

0.16.1 - 2024-09-07

• FIX Remove linux/arm/v5 from docker release action, GH-742

0.16.0 - 2024-06-04

• NEW Allow database stats downloads, GH-738
• NEW Add analyze table action, GH-737
• NEW Bump postgres version used in docker compose to 15, GH-729
• NEW Build on Go 1.22, GH-726
• FIX SSH tunnel cleanup and parse fixup, GH-731
• FIX Drop linux/arm/v5 from docker build, GH-728
• FIX Propagate CGO_ENABLED environment variable to docker build, GH-724

0.15.0 - 2024-03-14

• NEW Add support for a bookmarks-only mode, GH-716
• FIX Fix missing indexes by quoting schema/table name to ::regclass, GH-711
• FIX Continue on parseJSON error, GH-708

0.14.3 - 2024-01-28

• NEW Allow retrying a connection on startup, GH-695
• NEW Allow setting readonly mode in bookmarks, GH-707
• FIX Add UPDATE to list of restricted keywords in read-only mode, GH-697

0.14.2 - 2023-10-29

• NEW Execute tests using PostgreSQL 16, GH-691
• FIX Unclosed database sessions and tunnels, GH-688
• FIX Use pg_table_size for table stats query, GH-685
• FIX Use HasSuffix to correctly determine URL prefix, GH-684

0.14.1 - 2023-06-17

• NEW Add process start time metric, GH-675
• NEW Configure pgweb user for docker container, GH-674
• NEW Updated dockerfile, GH-645
• FIX Fix typo in the healthy metric, GH-657
• NEW Use entrypoint instead of cmd in in dockerfile, GH-654

0.14.0 - 2023-02-21

• FIX History page query loading fixup, GH-632
• NEW Display cell content via context menu, GH-634
• NEW Handle support/permissions errors in info call, GH-635
• NEW Show error message when API calls fail, GH-636
• NEW Add bookmark options to load username/password from env vars, GH-638
• NEW Add context menu to display database tables stats, GH-639
• NEW Added Local Queries feature, GH-641
• FIX Ensure that objects are sorted by schema and name, GH-648
• FIX Fetch local queries on db connect, GH-650

0.13.1 - 2022-12-27

• Fix connect flow when ~/.pgweb/bookmarks directory is not available, GH-631

0.13.0 - 2022-12-25

• Add support for .pgpass file, GH-617
• Request logging additions (request id, forwarded user), GH-618
• Establish connections using bookmark ID only, GH-619
• Display empty schemas on the sidebar, GH-621
• Configure timeout and retries when testing connection status, GH-623
• Setup basic prom metrics endpoint, GH-624
• Add default connect_timeout option to connection string, GH-626
• Add duration_ms to log entries, GH-628
• Add query execution stats to api endpoint, GH-629

0.12.0 - 2022-12-13

• Deprecate usage of Gox for binary builds, GH-571
• Add netcat install in dockerfile to provide a way to healthcheck, GH-572
• Install latest postgres client in docker image, GH-577
• Add support for PGWEB_ prefix environment variables, GH-585
• Fix export URL generation, refactor export code, GH-588
• Add logrus-based request logger, GH-589
• Configure logger for connect backend, GH-591
• Set LDFLAGS for make build/release commands, GH-592
• Add internal sessions manager, GH-593
• Include index size on the index list view, GH-595
• Fix flaky backend connection test, GH-596
• Add ability to view and copy views/materialized views definitions, GH-594
• Enable dev assets mode with PGWEB_ASSETS_DEVMODE env var, GH-597
• Make query input box resizable, GH-599
• Deprecate Heroku demo deployments and switch to Fly, GH-600
• Handle returning values in update/delete queries, GH-601
• Fix panic with invalid time marshaling, GH-602
• Configure logging level and format, GH-605
• Use go embed to load queries from static files, GH-607
• Switch go build target to 1.19, GH-603
• Add support for user functions, GH-608
• Implement global query timeout option, GH-609
• Switch windows tests from Appveyor to Github Actions, GH-611
• Fix activity endpoint panic when server version is not detected, GH-612

0.11.12 - 2022-07-05

• Update base docker image (alpine), update deps, GH-558
• Refactor docker images building, include ARM, GH-568

0.11.11 - 2022-03-29

• Auto-detect the query from the query source based on user selection, GH-547
• Added binary codec base58 as well as improving the help for --binary-codec flag, GH-548
• Change binary codec back to none, GH-555

0.11.10 - 2022-01-20

• Removes alert on column copy value, GH-536
• Migrate test suite to Github Action, GH-540
• Serialize binary bytea cols into hex/base64, GH-537
• Include build time into version string, GH-541
• Explain analyze dropdown button, GH-532
• Switch to go 1.17, GH-543
• Use HTTP 302 status code for successful backend redirect, GH-544
• Add connect backend tests, GH-546

0.11.9 - 2021-11-08

• Releases are built on Go 1.17
• Build time correction, GH-521
• Fix broken assets URL path prefix, 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.8 - 2021-07-07

• 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.7 - 2020-10-18

• 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 debug information 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.6 - 2020-02-19

• Add CLI options for SSL key, cert and root certs, GH-452
• Remove double click action on cell, GH-455

0.11.5 - 2019-12-16

• 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
• Fix long table name bug 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.4 - 2019-10-05

• Fix 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.3 - 2019-07-24

• 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.2 - 2019-02-15

• Fix table row estimation query for camelcase schemas, GH-414

0.11.1 - 2019-01-28

• Typo fixes
• Add Base64 javascript encoder/decoder to replace deprecated window.atob call, GH-405
• Fix startup error when DATABASE_URL is set, GH-406
• Fix 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.0 - 2018-12-24

• Tweak sidebar database object counters styles, GH-400
• Do not exit with error if local server is not running, GH-399
• Fix 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
• Fix row count estimation bug, GH-394
• Print out failed query SQL and args with --debug flag, GH-393

0.10.0 - 2018-11-28

• Fixes 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
• Fix issues 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 prefix with URL_PREFIX env var, GH-387
• Fix JSON marshal panic when dealing with NaN values, GH-388
• Fix startup behavior when user did not provide a database name, GH-389

0.9.12 - 2018-04-23

• 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.11 - 2017-12-07

• Fix ssl mode for the connection url in the bookmarks, GH-320
• Add support for CORS, GH-321
• Fix 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 prefix to the table export files, GH-329
• Add database view context menu with export actions, GH-330

0.9.10 - 2017-11-03

• Make idle connection timeout configurable, [GH-282]
• Fix 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.9 - 2017-09-28

• 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 close idle sessions (no activity in 1 hour), GH-275
• Allow connecting via SSH with a custom private key and other fixes, GH-277
• Add options to disable SSH connections, GH-279

0.9.8 - 2017-08-04

• Fixed error checking in the API, GH-234
• Fixed 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 fixes for IE9-11, GH-245
• Require confirmation for the disconnect, GH-246
• Clean the results table on manual disconnect

0.9.7 - 2017-04-04

• Fixed issue with locked session and empty db url, GH-206
• Fixed path rewrite on DB change, GH-212
• Upgraded dependencies, GH-217
• Added ability to specify bookmarks path, GH-218
• Added counter for the number of rows from a custom SQL query, GH-224
• Added new behavior for removing table rows view on custom SQL query page, GH-225

0.9.6 - 2016-11-18

• Fixed bug in query base64-encoding, GH-186
• Fixed rows pagination visibility bug, GH-190
• Fixed issue with query order escaping, GH-191
• Fixed invalid query selection for explain command, GH-198
• Fixed issue 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.5 - 2016-10-01

• Only view schema with USAGE privileges, GH-167
• Fixed 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.4 - 2016-07-29

• Fixes CSV/JSON/XML export buttons when pgweb is running with url prefix, GH-170

0.9.3 - 2016-06-30

• Uses Go 1.6 for development, GH-155
• Fixes timestamp formatting in CSV export, GH-163
• Included PostgreSQL 9.6 for integration testing
• Switches docker image to Alpine to reduce image size
• Adds support for ARMv5

0.9.2 - 2016-03-01

• Fixes bug with unsafe base64 encoded sql queries
• Fixes issue with session id not being included in multi-session mode
• Fixes visual issue with long table names in sidebar
• Fixes visual issue with a scrollbar in table information widget
• Fixes issue with database connection form being reset by clicking on 'cancel' button
• Adds ability to close connection
• Adds display message for number of affected rows for update/delete queries, GH-133
• Adds web server url prefix as a CLI option, GH-135

0.9.1 - 2016-01-25

• Fixes bug with tables context menu
• Fixes JS bug when query returns no rows
• Fixes bug with switching between different connection modes
• Adds AJAX timeout to 5s
• Adds sidebar reload action on any CREATE/DROP action

0.9.0 - 2016-01-19

• Add support for multiple schemas. GH-112
• Add support for native ssh tunnes. GH-114
• Add materialized views to list of schema objects
• Adds a few design tweaks and cleanups
• Fixes bug with nil result set when fetching rows

0.8.0 - 2016-01-11

• Fixes bug 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.0 - 2016-01-05

• 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.3 - 2015-08-16

• 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.2 - 2015-07-15

• 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.1 - 2015-06-18

• This release is repackage-release targeted to fix binary downloads

0.6.0 - 2015-05-31

• Adds ability to execute only selected SQL query in run command view, [GH-85]
• Adds ability to delete/truncate table via context many 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.3 - 2015-05-06

• 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.2 - 2015-04-13

• Adds a new endpoint /activity that returns 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.1 - 2015-02-23

• Upgrades Gin framework dependency to 0.5.0
• Fixes server crash if another pgweb server is running

0.5.0 - 2015-01-13

• 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.1 - 2014-12-01

• 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.0 - 2014-11-11

• Adds query escaping when exporting results to CSV [GH-38]
• 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 [GH-12]
• Fixes sidebar table name styles to support long names

0.3.1 - 2014-10-28

• Adds proper exit code when printing version via -v/--version flag
• Adds --version and --debug long flag names
• Adds double quotes for table name when fetching table contents
• Adds support for DATABASE_URL environment variable if no --url is set
• Adds proper usage of jQuery .prop method
• Adds --pass flag to specify connection password
• Fixes --ssl flag usage, previous value was hardcoded

0.3.0 - 2014-10-26

• Renamed make deps to make setup and fix issues with bootstrapping
• Removed hardcoded url for CSV export, it now detects application host:port
• Improved query history view table styles
• Moved table information view to the sidebar
• Added --listen flag to specify web server port, still defaults to 8080

0.2.0 - 2014-10-23

• Design tweaks
• Automatically opens browser on OSX systems
• Adds query explain functionality
• Adds export to CSV

0.1.0 - 2014-10-14

• Initial release