sosedoff/pgweb
1
1
Fork 0
mirror of https://github.com/sosedoff/pgweb.git synced 2024-12-14 19:21:46 +03:00
Code Issues Actions Packages Projects Releases Wiki Activity
1,251 Commits 166 Branches 55 Tags 28 MiB
v0.14.3
Commit Graph

433 Commits

Author SHA1 Message Date
Simon Hanna
27a83bdf9e
Do not show other databases if session is locked 
Fixes: #470
 2020-07-15 18:11:05 +02:00
Dan Sosedoff
02ddf85af2 Do not terminate if local authentication failed on start 2020-04-23 15:54:12 -05:00
Dan Sosedoff
678a6fd7cb Show results row context menu on custom query results 2020-03-15 19:50:19 -05:00
Dan Sosedoff
3e4e9c30c9 Release 0.11.6 2020-02-19 20:24:33 -06:00
Dan Sosedoff
6025b7afb2 Remove double click action on cell 
This feature was a source of confusion for new pgweb users for quite
some time now. Most people thought by double-clicking the cell it
would allow them to edit the value since the column is replaced
with textarea. The textarea was there to copy the cell's value, not
for editing. Feature is no longer required due to availability of a
cell context menu, which provides a link to copy the value.
 2020-02-12 13:14:58 -06:00
Dan Sosedoff
e2217e5f71 Add tests for ssl params 2020-02-11 10:58:40 -06:00
Dan Sosedoff
ce4aea8da1 Add ssl cert/key options 2020-02-05 22:09:13 -06:00
Dan Sosedoff
9c7f566d4d Add option to support sslrootcert parameter 2020-02-05 22:01:25 -06:00
Dan Sosedoff
9d0a0e1db1 Release 0.11.5 2019-12-16 17:15:55 -06:00
Dan Sosedoff
43a2945208 Include go version into info response 2019-12-04 20:29:23 -06:00
Dan Sosedoff
5d2ec70476 Autocomplete on all database objects 2019-12-04 19:36:09 -06:00
Jim Smith
e5c53d598c Fix for visual glitch when schema name wider than 250px 2019-12-04 18:28:14 +00:00
Dan Sosedoff
8b1f234b91 Include go version into builds 2019-11-29 13:59:50 -06:00
Dan Sosedoff
bc95e8dced Add extra styling for autocomplete 2019-11-02 13:37:52 -05: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
994ceca1d1 Return error when ssh key does not exist 2019-11-02 11:36:31 -05:00
Dan Sosedoff
059764d015 Release 0.11.4 2019-10-05 12:48:21 -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
Dan Sosedoff
b6f01da232 Drop unsupported pg_dump options from connection string 2019-09-25 20:29:21 -05:00
Sylvain DOIGNON
5bb339e1a2 fix SQL export filename 2019-07-31 14:43:55 +02:00
Dan Sosedoff
c830a55a64 Release 0.11.3 2019-07-24 17:07:27 -05:00
Dan Sosedoff
f31143ba3a Set odd background color for table rows 2019-07-05 17:28:55 -05:00
Dan Sosedoff
5c3b21d711 Expland lists of objects on search 2019-07-05 16:20:46 -05:00
Dan Sosedoff
416cae3101 Add database object filter to the sidebar 2019-07-05 16:18:29 -05:00
Dan Sosedoff
819b13fe55 Restructure sidebar 2019-07-05 15:19:05 -05:00
Dan Sosedoff
2a0fd54855 Remove comments from the query before checking for restricted keywords 2019-02-25 11:43:04 -06:00
Dan Sosedoff
b83f52707a Remove LOCK/SET from restricted keywords 2019-02-20 20:29:28 -06:00
Dan Sosedoff
5bb6378e94 Switch back readonly mode after test finish 2019-02-20 18:22:44 -06:00
Dan Sosedoff
40eb74529e Reject queries that contain restricted keywords in read-only mode 2019-02-20 18:20:27 -06:00
Dan Sosedoff
d3aaf8f5db Release 0.11.2 2019-02-15 14:09:49 -06:00
Dan Sosedoff
65aae5ec95 Add extra test cases for camelCase table names 2019-02-08 14:02:36 -06:00
Dan Sosedoff
5af4332593 Fix SQL query for camelCase tables row estimation 2019-02-08 13:27:40 -06:00
Dan Sosedoff
dc1009cdd8 Release 0.11.1 2019-01-28 17:11:04 -06:00
Dan Sosedoff
44b6932202 Regenerate bindata 2019-01-28 16:45:41 -06:00
Dan Sosedoff
c32d68809b Add extra note 2019-01-28 14:22:05 -06:00
Dan Sosedoff
d48172986e Fix error when automatic user detection fails 2019-01-28 14:03:45 -06:00
Dan Sosedoff
baa587166c
Merge pull request #405 from Nhat002/fix_encode_query_to_base64_in_export 
Add custome base64 encode to handle special characters on query to export result
 2019-01-28 11:47:36 -06:00
Dan Sosedoff
a7959ad0fa Fix startup error when DATABASE_URL is set 2019-01-25 10:29:24 -06:00
Nhat Tran
25304f8229 Fix: missing base64.js in index.html and remove blank space 2019-01-25 12:04:21 +08:00
Nhat Tran
bc0602c523 Add custome base64 encode to handle special character 2019-01-24 15:35:16 +08:00
Dan Sosedoff
ae60604ef1 Fix typo 2019-01-16 22:54:23 -06:00
Dan Sosedoff
53c02d8914 Release 0.11.0 2018-12-24 12:57:39 -06:00
Dan Sosedoff
435a67cb5d Tweak sidebar database object counters styles 2018-12-19 12:40:28 -06:00
Dan Sosedoff
9c07ac356b Do not exit with error if local server is not running 2018-12-18 18:11:56 -06:00
Dan Sosedoff
2bd9f39da5 Fix SSH error: ssh: must specify HostKeyCallback 2018-12-14 19:56:33 -06:00
Dan Sosedoff
c4e63dcc85 Regenerate bindata 2018-12-13 22:36:38 -06:00
Dan Sosedoff
794e5a22c1 Rename command.VERSION to command.Version 2018-12-13 22:35:43 -06:00
Dan Sosedoff
eeb5245cb9 Typo fix 2018-12-13 17:56:57 -06:00
Dan Sosedoff
9c1ce91de1 Scope activity list to current database 2018-12-13 12:14:10 -06:00
Dan Sosedoff
658d14314b Show pgweb version on homep age and check for newer releases 2018-12-12 20:35:07 -06:00
Dan Sosedoff
ad82841eb2 Force switch back to default connection settings view 2018-12-12 18:29:07 -06:00
Dan Sosedoff
c9d94b54d7
Merge pull request #394 from sosedoff/fix-row-estimation 
Fix row estimation bug
 2018-12-12 14:33:06 -06:00
Dan Sosedoff
7917c2ad35 Simplify TableRowsCount func logic 2018-12-12 13:56:08 -06:00
Dan Sosedoff
2db5ce544f Fix row estimation bug 
The variable `table` is mutated from `schema.tablename` to `tablename`
before being passed to other functions, which try to parse the schema
from the name. This results in schema name being `public` because it's
missing from the given table name.
 2018-12-12 13:33:55 -06:00
Dan Sosedoff
474b99c6d5 Print out failed query SQL and args with --debug flag 2018-12-12 13:22:36 -06:00
Dan Sosedoff
d1a7e6ecfe More lint 2018-12-04 12:42:37 -06:00
Dan Sosedoff
a5b8e02a98 Cleanup backend handler 2018-12-01 22:35:11 -06:00
Dan Sosedoff
72af00f1b7 Refactor api package 2018-11-30 21:40:28 -06:00
Dan Sosedoff
54da27ef70 Release 0.10.0 2018-11-28 10:25:37 -06:00
Dan Sosedoff
21d2893292 Fix startup behavior when user did not provide a database name 2018-11-27 17:23:55 -06:00
Dan Sosedoff
1189bdef33
Merge pull request #388 from sosedoff/fix-json-naan-panic 
Fix JSON marshal panic when dealing with NaN values
 2018-11-27 17:00:38 -06:00
Dan Sosedoff
903a265676 Fix JSON marshal panic when dealing with NaN values 2018-11-27 16:51:51 -06:00
Dan Sosedoff
965cf754cf Allow settings url prefix with URL_PREFIX env var 2018-11-27 14:58:50 -06:00
Dan Sosedoff
abb143601b Add test for serverResult func 2018-11-05 17:07:32 -06:00
Dan Sosedoff
29d4b276e2 Do not show row context menu if results are empty 2018-09-14 18:19:24 -05:00
Dan Sosedoff
6ed3d5b501 Add result row context menu to copy value or filter rows 2018-09-14 18:14:18 -05:00
Dan Sosedoff
14037ddad2 Take out failing test due to new sessions behavior 2018-09-14 01:00:47 -05:00
Dan Sosedoff
1ecf18e41c Also flush bookmark under sessions/connect setup 2018-09-14 00:56:16 -05:00
Dan Sosedoff
badcf700b9 Clear out connection settings when running in session/connect mode 2018-09-14 00:54:42 -05:00
Dan Sosedoff
174b2ffdbb Make localhost to be a default db host 2018-09-14 00:04:02 -05:00
Dan Sosedoff
fb7676ab4e Include rows count to numeric stats view on table column 2018-09-13 23:46:33 -05:00
Dan Sosedoff
c9018e843e Regenerate bindata 2018-09-13 23:41:59 -05:00
Dan Sosedoff
31db9658e0
Merge pull request #377 from sosedoff/column-numstats 
Add column context menu item to get numeric stats
 2018-09-13 23:32:43 -05:00
Dan Sosedoff
fc380df8dd Fix failing win test 2018-09-13 23:22:25 -05:00
Dan Sosedoff
dc4e8598f7 Refactor building connection string from options 2018-09-13 22:44:11 -05:00
Dan Sosedoff
b0151ee985 Refactor connection string generator 2018-09-13 22:25:15 -05:00
Dan Sosedoff
b9eba7bfa4 Add column context menu item to get numeric stats 2018-09-13 20:50:33 -05:00
Dan Sosedoff
35641e5957 Remove failing mime types from test 2018-08-31 22:01:51 -05:00
Dan Sosedoff
ad81f666a5 Switch to dep for dependency management 2018-08-31 21:49:24 -05:00
Dan Sosedoff
a6eade1ae1 Automatically set table filter option to 'equals' if its not set 2018-08-20 20:42:38 -05:00
Eric Dagenais
9bb3afe6ce Merge remote-tracking branch 'upstream/master' into itn/tables-quotes-2 
# Conflicts:
#	pkg/client/client.go
 2018-06-20 07:19:34 -07:00
Allisson Azevedo
808f6eea33 Change EstimatedTableRowsCount query 2018-06-16 18:12:11 -03:00
Allisson Azevedo
974570c79e Add more tests 2018-06-16 11:09:37 -03:00
Allisson Azevedo
5ba53d3cbd Add test_EstimatedTableRowsCount 2018-06-14 17:51:16 -03:00
Allisson Azevedo
8748f07167 Use EstimatedTableRowsCount only for postgresql 2018-06-14 16:36:22 -03:00
Allisson Azevedo
d603b293d8 Add EstimatedTableRowsCount to avoid count in large tables 2018-06-14 16:10:59 -03:00
Dan Sosedoff
108754a8c3 Verify that database name is specified when opening the connection 2018-06-05 22:31:22 -05:00
Dan Sosedoff
1cbcb73948 Print a correct database server name when starting 2018-06-05 18:28:22 -05:00
Dan Sosedoff
e09f892442 Fix table info call, just return placeholder for now 2018-06-05 16:38:00 -05:00
Dan Sosedoff
56f3b45a4e Fix activity list 2018-06-05 15:48:16 -05:00
Dan Sosedoff
77770112bd Detect server type and version with regular expression 2018-06-05 15:35:19 -05:00
Dan Sosedoff
b18af0b907
Merge pull request #358 from sosedoff/check-for-pgdump 
Check if pg_dump is available before running database export
 2018-04-26 00:14:17 -05:00
Dan Sosedoff
0b095f43bb Restructure routes 2018-04-25 23:52:22 -05:00
Dan Sosedoff
e2be689a05 Check if pg_dump is available before running database export 2018-04-25 23:29:18 -05:00
Dan Sosedoff
9af721176b Release 0.9.12 2018-04-23 12:07:53 -05:00
Dan Sosedoff
113e2f27fb Regenerate bindata 2018-04-23 11:16:02 -05:00
Eric Dagenais
7b3e99b599 fixes issue that generates an error message when getting table info, getting table schema, and exporting data for tables with uppercase letters 2018-04-11 06:24:56 -07:00
Dan Sosedoff
47500bf92e Specs refactor and tweaks 
- Make ParseOptions func to take an arg and return struct so we can test it
- Refactor and add more tests for options parsing
- Run test suite on postgres 10.x branch
- Change format for connection idle timer from float64 to in
 2018-02-22 14:20:18 -06:00
Dan Sosedoff
121f278713
Merge pull request #343 from sosedoff/list-constraint-name 
Include constraint name under "constraints" tab
 2018-01-30 23:29:54 -06:00
Dan Sosedoff
b0146a5a76 Update test case to handle the constraint result rows 2018-01-30 22:41:12 -06:00
Dan Sosedoff
9c0d887a3c List name and definition for table constraints 2018-01-30 22:34:54 -06:00
Emir Ribić
2b2c76bde9
Update bookmarks.go 
Fix typo
 2018-01-08 10:55:05 +01:00
Dan Sosedoff
43fe84de3a Add link to PG docs about connection strings 2017-12-14 22:49:10 -06:00
Dan Sosedoff
c32784e8ae Release 0.9.11 2017-12-07 22:57:56 -06:00
Dan Sosedoff
898cdd2d65 Bindata gen 2017-12-07 22:56:55 -06:00
Dan Sosedoff
0ea173ffe5 Add views context menu 2017-11-30 23:38:15 -06:00
Dan Sosedoff
02d598f406 Add db prefix for table export files 2017-11-30 22:47:42 -06:00
Dan Sosedoff
4f2fac11d3 Disable autocomplete on the connection url string for security reasons 2017-11-30 22:25:20 -06:00
Dan Sosedoff
d7e5805024 Rename SQL query tab 2017-11-21 15:33:13 -06:00
Dan Sosedoff
97e31b6c47
Merge pull request #321 from sosedoff/cors 
Add support for CORS
 2017-11-18 21:49:07 -06:00
Dan Sosedoff
dc3d7303d7 Reorder table context menu 2017-11-16 23:08:18 -06:00
Dan Sosedoff
cf432e32f7 Hide custom query results counter if query didnt return any rows 2017-11-16 22:21:52 -06:00
Dan Sosedoff
c3435e2ece Change CORS to Cors on CLI options, specify origins as an option 2017-11-16 22:10:14 -06:00
Dan Sosedoff
b52394a166 Add support for CORS 2017-11-15 15:26:31 -06:00
Tyler Long
86acd842b0
Fix sslmode typo 
https://www.postgresql.org/docs/9.1/static/libpq-ssl.html
 2017-11-11 08:12:27 -06:00
Dan Sosedoff
cb4ecb49eb Release 0.9.10 2017-11-03 21:50:25 -05:00
Dan Sosedoff
d51294ce54 Rebuild bindata 2017-11-03 21:49:32 -05:00
Dan Sosedoff
b8fccab33a Fix broken bindata 2017-10-24 22:31:29 -05:00
Dan Sosedoff
ec5a12b0f7 Rename disable connection timeout cli option 2017-10-20 22:18:07 -05:00
ldinc
02df9b519f #282: cleared bindata 2017-10-16 00:12:41 +03:00
ldinc
38a3f01868 #282: set flag idle logic to cli-run phase 2017-10-15 01:39:07 +03:00
ldinc
a120b58dc2 #282: updated bindata 2017-10-14 14:37:20 +03:00
ldinc
33be6b036d Merge branch 'master' into issue#282 2017-10-14 14:34:32 +03:00
Dan Sosedoff
046022221e UI and design tweaks 2017-10-13 23:04:19 -05:00
Dan Sosedoff
ed7557c5da Regenerated bindata 2017-10-13 22:34:16 -05:00
ldinc
d4dde3fe4f #282 fix disabled state per idle timeout 2017-10-14 03:15:31 +03:00
ldinc
3067b06bf6 #282: added timeout flags & tuned client.IsIdle() 2017-10-14 03:08:04 +03:00
Dan Sosedoff
4ad70d5392 Tweak wording 2017-10-07 11:30:12 -05:00
Dan Sosedoff
d8ce8231cc Dot now allow using startup bookmark in multi-session mode 2017-10-07 09:25:00 -05:00
Dan Sosedoff
277e2d6cd8 Add an extra test to verify SSHinfoIsEmpty does not panic 2017-10-03 23:03:02 -05:00
Dan Sosedoff
58ae69de0b Fix panics when sshinfo is not set on bookmarks 2017-10-03 23:00:18 -05:00
Dan Sosedoff
4cacfc253c Release 0.9.9 2017-09-28 20:42:14 -05:00
Dan Sosedoff
b1dd4b5308 Add new CLI option to disable SSH connections 2017-09-26 23:56:27 -05:00
Dan Sosedoff
5e22795828 Allow setting ssh connection key file, fix connection ui 2017-09-26 23:29:28 -05:00
Dan Sosedoff
62d88121cd Automatically close idle sessions 2017-09-22 22:44:32 -05:00
Dan Sosedoff
5d1cc211b0 Add database export test 2017-09-22 22:06:36 -05:00
Dan Sosedoff
83598f4013 Merge pull request #266 from sosedoff/connect-backend 
Add ability to connect with settings from third-party backend
 2017-09-21 20:37:46 -05:00
Dan Sosedoff
92ec968d5e Automatically open pgweb page if its already running 2017-09-21 17:16:09 -05:00
Dan Sosedoff
049aa4ec44 Require --connect-backend flag to be set if any other backend flags are specified 2017-09-21 02:06:14 -05:00
Dan Sosedoff
869fd8c6bc Refactor the third-party connect backend functionality 2017-09-21 01:21:26 -05:00
Dan Sosedoff
d175b0af34 Add descriptions for cli backend options 2017-09-19 00:45:07 -05:00
Dan Sosedoff
0aff72059b Check for response status when fetching credentials 2017-09-19 00:43:21 -05:00
Dan Sosedoff
73816ff2d7 Add ability to connect with settings from third-party backend 2017-09-19 00:43:21 -05:00
Dan Sosedoff
f5f595ac02 Merge pull request #270 from sosedoff/data-export 
Database export
 2017-09-19 00:41:04 -05:00
Dan Sosedoff
26ea9fc1b8 Fix the JSON beautifier flag 2017-09-16 21:57:04 -05:00
Dan Sosedoff
e771d6f49e Export database or table to sql 2017-09-16 20:32:41 -05:00
Dan Sosedoff
28b0840e69 Move some of the util functions to util.js 2017-09-16 14:03:42 -05:00
Dan Sosedoff
81af2a9a27 Add table results headers context menu 2017-09-16 13:50:22 -05:00
Dan Sosedoff
6ab30ed308 Update the client last usage timestamp 2017-09-14 00:16:40 -05:00