Commit graph

843 commits

Author SHA1 Message Date
Simon Willison
a5defb684f CREATE INDEX statements on table page, closes #618 2019-11-10 19:15:14 -08:00
Simon Willison
deeef8da96 datasette-csvs on Glitch now uses sqlite-utils
It previously used csvs-to-sqlite but that had heavy dependencies.

See https://support.glitch.com/t/can-you-upgrade-python-to-latest-version/7980/33
2019-11-10 19:15:14 -08:00
Simon Willison
40f9682b23 Improved documentation for "publish cloudrun" 2019-11-10 19:15:14 -08:00
Simon Willison
5481bf6da6 Improved UI for publish cloudrun, closes #608 2019-11-10 19:15:14 -08:00
Simon Willison
b0b7c80571 Removed unused special_args_lists variable 2019-11-10 19:15:14 -08:00
Simon Willison
bccf474abd Removed _group_count=col feature, closes #504 2019-11-10 19:15:14 -08:00
Tobias Kunze
e5dc89a58b Handle spaces in DB names (#590)
Closes #503 - thanks, @rixx
2019-11-10 19:15:14 -08:00
Simon Willison
daab48aaf5 Use select colnames, not select * for table view - refs #615 2019-11-10 19:15:14 -08:00
Simon Willison
d3e9387466 pk__notin= filter, closes #614 2019-11-10 19:15:14 -08:00
Tobias Kunze
fa4d77b01e Offer to format readonly SQL (#602)
Following discussion in #601, this PR adds a "Format SQL" button to
read-only SQL (if the SQL actually differs from the formatting result).

It also removes a console error on readonly SQL queries.

Thanks, @rixx!
2019-11-10 19:15:14 -08:00
Simon Willison
5eaf398592 Fix CSV export for nullable foreign keys, closes #612 2019-11-10 19:15:14 -08:00
Simon Willison
66dd9e00c7 Release notes for 0.30.2 2019-11-10 19:15:14 -08:00
Simon Willison
28ac836b58 Don't show 'None' as label for nullable foreign key, closes #406 2019-11-10 19:15:14 -08:00
Simon Willison
872284d355 Plugin static assets support both hyphens and underscores in names
Closes #611
2019-11-10 19:15:14 -08:00
Simon Willison
566496c146 Better documentation of --host, closes #574 2019-11-10 19:15:14 -08:00
Simon Willison
18ba0c27b5 Don't suggest array facet if column is only [], closes #610 2019-11-10 19:15:14 -08:00
Simon Willison
1fa1c88aec Only inspect first 100 records for #562 2019-11-10 19:15:14 -08:00
Simon Willison
0dde00e7bb Only suggest array facet for arrays of strings - closes #562 2019-11-10 19:15:14 -08:00
Simon Willison
cd0984af2d Use distinfo.project_name for plugin name if available, closes #606 2019-11-10 19:15:14 -08:00
Simon Willison
66ac40be70 Fixed dumb error 2019-11-10 19:15:14 -08:00
Simon Willison
f081bb818d Release 0.30.1 2019-11-10 19:15:14 -08:00
Simon Willison
76eb6047d4 Persist _where= in hidden fields, closes #604 2019-11-10 19:15:14 -08:00
Simon Willison
48054b358a Update to latest black (#609) 2019-11-10 19:15:14 -08:00
chris48s
ca44cc03e3 Always pop as_format off args dict (#603)
Closes #563. Thanks, @chris48s
2019-11-10 19:15:14 -08:00
Simon Willison
a5d4f166a5 Update news in README 2019-11-10 19:15:14 -08:00
Simon Willison
7cbc51e92e Release 0.30 2019-11-10 19:15:14 -08:00
Simon Willison
32d9e2fbc6 Don't auto-format SQL on page load (#601)
Closes #600
2019-11-10 19:15:14 -08:00
Simon Willison
c387b47ec6 Fix for /foo v.s. /foo-bar issue, closes #597
Pull request #599
2019-11-10 19:15:14 -08:00
Simon Willison
a9f877f7bf Fixed bug returning non-ascii characters in CSV, closes #584 2019-11-10 19:15:14 -08:00
Simon Willison
e5308c1ec2 Use --platform=managed for publish cloudrun, closes #587 2019-11-10 19:15:14 -08:00
Simon Willison
b2d0ca3a1d Add Python versions badge 2019-11-10 19:15:14 -08:00
Tobias Kunze
2bd116234b Display metadata footer on custom SQL queries (#589)
Closes #408 - thanks, @rixx!
2019-11-10 19:15:14 -08:00
Tobias Kunze
2ad1f0d34e Sort databases on homepage by argument order - #591
Closes #585 - thanks, @rixx!
2019-11-10 19:15:14 -08:00
Tobias Kunze
cd1b22f100 Button to format SQL, closes #136
SQL code will be formatted on page load, and can additionally
be formatted by clicking the "Format SQL" button.

Thanks, @rixx!
2019-11-10 19:15:14 -08:00
Simon Willison
e2eff14cf9 Allow EXPLAIN WITH... - closes #583 2019-11-10 19:15:14 -08:00
Simon Willison
7c247be4c9 Added /-/threads debugging page 2019-11-10 19:15:14 -08:00
Simon Willison
855c7ed851 Changelog for 0.29.3 release 2019-11-10 19:15:14 -08:00
Simon Willison
5a43d8e3d1 detect_fts now works with alternative table escaping (#571)
Fixes #570. See also https://github.com/simonw/sqlite-utils/pull/57
2019-11-10 19:15:14 -08:00
Simon Willison
d4fd7bb77b Refactored connection logic to database.connect() 2019-11-10 19:15:14 -08:00
Min ho Kim
5945c0cdd4 Fix numerous typos (#561)
Thanks, @minho42!
2019-11-10 19:15:14 -08:00
Simon Willison
5a8c335e5e Fixed CodeMirror on database page, closes #560 2019-11-10 19:15:14 -08:00
Simon Willison
68cf2e3ee8 Release 0.9.2 2019-11-10 19:15:14 -08:00
Simon Willison
86316eef04 Fix plus test for unicode characters in custom query name, closes #558 2019-11-10 19:15:14 -08:00
Simon Willison
159995d11e Fixed breadcrumbs on custom query page 2019-11-10 19:15:13 -08:00
Simon Willison
4d5004f824 News: Single sign-on against GitHub using ASGI middleware 2019-11-10 19:15:13 -08:00
Simon Willison
51e1363179 Bump to uvicorn 0.8.4 (#559)
https://github.com/encode/uvicorn/commits/0.8.4

Query strings will now be included in log files: https://github.com/encode/uvicorn/pull/384
2019-11-10 19:15:13 -08:00
Simon Willison
bce2da7b6d Updated release notes 2019-11-10 19:15:13 -08:00
Simon Willison
65c10d2c64 Release 0.29.1 2019-11-10 19:15:13 -08:00
Simon Willison
d6ce7379bd Removed unused variable 2019-11-10 19:15:13 -08:00
Abdus
82889507ca Fix static mounts using relative paths and prevent traversal exploits (#554)
Thanks, @abdusco! Closes #555
2019-11-10 19:15:13 -08:00