104 Commits

Author SHA1 Message Date
Dan Sosedoff
f5f78eb32e
Add server settings view (#768) 2024-12-15 14:46:01 -08:00
Dan Sosedoff
3a32f531a0
Allow database stats downloads (#738)
* Add button to download database stats
* Return xml as well
2024-05-25 10:59:23 -07:00
Alexandru Gologan
f4e7643e22
Add support for a bookmarks-only mode (#716)
* Add support for bookmarks-only mode

* Add error for missing bookmarks in bookmarks-only mode

* Error when settings url or connect backend together with bookmarks-only

* Add tests for parsing options
2024-03-14 21:36:53 -07:00
Dan Sosedoff
22daaad5a2
Fix unclosed database sessions and tunnels (#688) 2023-09-10 11:46:31 -05:00
Dan Sosedoff
08bbb1537e
Implement process uptime metric (#666)
* Implement process uptime metric
* Add clarification comment
* Add another clarification comment
2023-03-30 12:51:49 -05:00
Dan Sosedoff
41bf189e6b
Local queries (#641)
* Read local queries from pgweb home directory
* Refactor local query functionality
* Allow picking local query in the query tab
* WIP
* Disable local query dropdown during execution
* Only allow local queries running in a single session mode
* Add middleware to enforce local query endpoint availability
* Fix query check
* Add query store tests
* Make query store errors portable
* Skip building specific tests on windows
2023-02-02 16:13:14 -06:00
Dan Sosedoff
5b2d4e4454
Add context menu to display database tables stats (#639)
* Add context menu to display database tables stats

* Move table stats implementation into client
2023-01-23 14:10:26 -06:00
Dan Sosedoff
12a4bf70c0
Add duration_ms to log entries (#628) 2022-12-25 13:24:22 -06:00
Dan Sosedoff
aeb9dc24ad
Fix mutex unlock call 2022-12-21 14:29:44 -06:00
Dan Sosedoff
b31e7f1ea7
Setup basic prom metrics endpoint (#624)
* Setup basic prom metrics endpoint
* Use default prom handler to expose go runtime metrics
2022-12-20 10:13:42 -06:00
Dan Sosedoff
4e3e255575
Configure timeout and retries when testing connection status (#623) 2022-12-19 16:13:43 -06:00
Dan Sosedoff
69233cd769
Establish connections using bookmark ID only (#619)
* Establish connections using bookmark ID only
* Refactor specs
* Extra tests
* Fix homedir assertion for bookmarks path
* Fix newline in the warning message
* Check for bookmark file existence before reading
* Connect code restructure
2022-12-19 12:33:13 -06:00
Dan Sosedoff
afe431c94d
Request logging additions (request id, forwarded user) (#618)
* Add request-id logging
* Missing test file
* Add option to log forwarded user information if available via X-Forwarded-Header
* Format
2022-12-16 12:38:57 -06:00
Dan Sosedoff
e0a748812d
Add support for .pgpass file (#617)
* Add support for .pgpass file
* Support password lookup in /api/connect endpoint
* Restrore removed code for BuildStringFromOptions
* Restructure connection string test and add extra case for pgpass
* Add test for FormatURL method
2022-12-14 13:37:49 -06:00
Dan Sosedoff
4c40eef99a
Perform client version validation before executing pg_dump command (#614)
* Add func to parse out pg_dump version
* Perform client vs server version checking before dump exports
* Fix dump tests
* Add extra test to validate against empty server version
* Fix attachment filenames cleanup function
* Add extra test
* Fix small typos in comments
* Drop third-party package to deal with versions
* Tweak the pg dump incompatibility error message
* Run CI on pull requests
2022-12-12 15:09:12 -06:00
Dan Sosedoff
7557ac854e
Configure client side query timeout (#610)
* Configure client side query timeout
* Update test command on windows
* Make query timeout cli opt an uint
* Fix windows test command
* Check for updates when rendering connection page
* Fix typo
2022-12-08 15:07:40 -06:00
Dan Sosedoff
38051b9465
Add support for user functions (#608)
* Add initial support for functions
* Show functions definitions
* Fix client tests
* Fix schema objects search
* Perform partial matching for functions
* Add function test
* Make sure to close client connections so that database could be dropped in tests
* Fix lint
* Allow to copy the view/functions definitions
* Nits
2022-12-07 11:58:07 -06:00
Dan Sosedoff
66fbc730fe
Only include form for non-get requests 2022-12-06 12:30:43 -06:00
Dan Sosedoff
2f9d737515
Move request parameters logging into api request logger 2022-12-06 12:24:21 -06:00
Dan Sosedoff
dda70352c0
Dont include request path in the log twice 2022-12-06 12:14:55 -06:00
Dan Sosedoff
dbd3b26f6c
Configure logging level and format 2022-12-06 12:09:21 -06:00
Dan Sosedoff
695a99dade
Enable dev assets mode with PGWEB_ASSETS_DEVMODE env var 2022-12-03 18:27:46 -06:00
Dan Sosedoff
1b42caf3a7
Fix flaky backend connection test 2022-12-03 16:42:30 -06:00
Dan Sosedoff
96625916e2
Tweak http message logger format 2022-12-03 15:11:45 -06:00
Dan Sosedoff
07d0010750
Make linter happy 2022-12-02 14:22:50 -06:00
Dan Sosedoff
16726e2461
Add idle timeout into session manager 2022-12-02 14:20:20 -06:00
Dan Sosedoff
0a133dc395
Reorder imports 2022-12-02 14:00:01 -06:00
Dan Sosedoff
73dfcc46c3
Verify client is closed 2022-12-02 13:59:22 -06:00
Dan Sosedoff
bc54c95140
Tweak test run names 2022-12-02 13:57:56 -06:00
Dan Sosedoff
29a6a0df8c
Add session manager tests 2022-12-02 13:56:49 -06:00
Dan Sosedoff
9074d4bfb8
Add internal sessions manager 2022-12-02 13:36:31 -06:00
Dan Sosedoff
e7ac416440
Sanitize connect token in logging 2022-12-02 12:20:58 -06:00
Dan Sosedoff
f19f165afc
Configure logger for connect backend 2022-12-02 11:45:23 -06:00
Dan Sosedoff
f9e376a117
Code cleanup; add make lint task 2022-12-01 16:51:12 -06:00
Dan Sosedoff
dafda4a977
Add VersionInfo struct to render in the /info endpoint 2022-12-01 16:41:46 -06:00
Dan Sosedoff
72ecd20dd1
Handle logger levels 2022-12-01 13:01:32 -06:00
Dan Sosedoff
c996d71378
Implement gin request logger with param filtering 2022-12-01 13:01:32 -06:00
Dan Sosedoff
9bfec11b48
Fix linting errors 2022-11-14 16:10:50 -06:00
Dan Sosedoff
e2f5e06c07
Add connect backend tests (#546) 2022-01-08 14:45:21 -06:00
Dan Sosedoff
0794c642e4
Use HTTP 302 status code for successful backend redirect (#544) 2022-01-08 12:25:24 -06:00
Tim Ings
17e95601ec
Explain analyze dropdown button (#532)
* Adds bootstrap dropdown plugin
* Float dropdown toggle left
* Extract query running message toggles
* Adds analyze function and api call
* Adds analyze api
2022-01-03 19:05:46 -06:00
Dan Sosedoff
ccfa3497f3
GitHub actions migration (#540) 2021-12-25 11:31:41 -06:00
Dan Sosedoff
46935a7a12
Fix broken path prefix 2021-08-10 12:12:05 -05:00
Nikita Kazarian
8e2c826ba3 go 1.16 features
- use go embed instead of go-binary and remove all about old assets (go 1.16 feature)
- pin gox version (go 1.16 feature)
- update ci to go 1.16
2021-03-05 03:47:01 +03:00
Simon Hanna
27a83bdf9e
Do not show other databases if session is locked
Fixes: #470
2020-07-15 18:11:05 +02:00
Dan Sosedoff
43a2945208 Include go version into info response 2019-12-04 20:29:23 -06:00
Dan Sosedoff
8428d268b1 Lint 2019-11-02 13:00:23 -05:00
Dan Sosedoff
7475f398b1 Add support for encrypted ssh keys 2019-11-02 12:44:04 -05:00
Dan Sosedoff
7a6450091a
Code formatting and cleanup (#442)
* Formatting, extract error messages
* More refactor
* Move errors to a separate file
* Add missing file
* Misc
2019-09-29 12:16:42 -05:00
Sylvain DOIGNON
5bb339e1a2 fix SQL export filename 2019-07-31 14:43:55 +02:00