Simon Willison
7d01ca34a1
Added ?_trace=1 option to trace SQL
...
Currently just dumps all SQL statements out on the console.
2019-04-20 22:34:34 -07:00
Simon Willison
31f36e1b97
Added some guidelines
...
Mainly to remind me that master needs to be releasable at all times!
2019-04-20 11:32:40 -07:00
Simon Willison
2b11948d7c
New ConnectedDatabase.mtime_ns property
...
I plan to use this for some clever table count caching tricks
2019-04-20 10:50:45 -07:00
Simon Willison
9c77e6e355
Support multiple filters of the same type
...
Closes #288
2019-04-15 16:44:17 -07:00
Simon Willison
583b22aa28
New ?column__date=yyyy-mm-dd filter
2019-04-15 15:54:54 -07:00
Simon Willison
1c6649b19b
New colname__in=x,y,z filter, closes #433
2019-04-15 15:43:22 -07:00
Simon Willison
2c19a27d15
Documentation for filters, plus new documentation unit test
...
https://simonwillison.net/2018/Jul/28/documentation-unit-tests/
2019-04-15 15:41:11 -07:00
Simon Willison
6da567dda9
Extract and refactor filters into filters.py
...
This will help in implementing __in as a filter, refs #433
2019-04-15 14:51:20 -07:00
Simon Willison
9dc7a1824b
Slightly more interesting example link
2019-04-13 15:49:07 -07:00
Simon Willison
d4bfb8461c
Removed accidental extra default plugins module
2019-04-13 12:33:23 -07:00
Simon Willison
d1075b8259
Cleaned up pylint warnings
2019-04-13 12:20:10 -07:00
Simon Willison
13ee3c222f
Moved BaseView.absolute_url() to Datasette
2019-04-13 12:16:05 -07:00
Simon Willison
274ef43bb7
Moved expand_foreign_keys() from TableView to Datasette
2019-04-13 11:48:00 -07:00
Simon Willison
f2c767c222
Fixed broken link in documentation
2019-04-12 18:57:43 -07:00
Simon Willison
bc6a9b4564
?_where= parameter on table views, closes #429
...
From pull request #430
2019-04-12 18:37:22 -07:00
Simon Willison
e11cb4c664
Persist show/hide state better, closes #425
2019-04-11 22:00:47 -07:00
Simon Willison
db74cf0144
?_fts_table= and ?_fts_pk= arguments, closes #428
2019-04-11 21:21:17 -07:00
Simon Willison
9cd3b44277
Upgrade to Jinja2==2.10.1 ( #426 )
2019-04-10 16:13:30 -07:00
Simon Willison
78e45ead4d
New ?tags__arraycontains=tag lookup against JSON fields
...
Part one of supporting facet-by-JSON-array, refs #359
2019-04-10 08:27:52 -07:00
Simon Willison
3a208a41d4
TableView.data() no longer uses .inspect, refs #420
...
BUT... it does a count(*) against the whole table which may take unbounded time.
Fixing this is part of #422
2019-04-06 20:47:10 -07:00
Simon Willison
36bd6558b0
expandable_columns() no longer uses inspect, refs #420
2019-04-06 20:46:08 -07:00
Simon Willison
db02311ebf
foreign_key_tables no longer uses inspect, refs #420
2019-04-06 20:23:30 -07:00
Simon Willison
f23120a964
RowView.data() no longer uses inspect refs #420
2019-04-06 20:17:47 -07:00
Simon Willison
c882e9262f
display_columns_and_rows() no longer uses inspect, refs #420
2019-04-06 20:11:08 -07:00
Simon Willison
53bf875483
expand_foreign_keys() no longer uses inspect, refs #420
2019-04-06 19:56:07 -07:00
Simon Willison
97331f3435
sortable_columns_for_table() no longer uses inspect()
...
Refs #420
2019-04-06 18:58:51 -07:00
Simon Willison
d8851e0011
Removed rogue print()
2019-04-06 18:54:51 -07:00
Simon Willison
468c6fd953
DatabaseDownload no longer uses .inspect(), refs #420
2019-03-31 19:04:17 -07:00
Simon Willison
29a3896fe1
.database_url(database) no longer needs inspect, refs #420
2019-03-31 16:55:38 -07:00
Simon Willison
7d0f668556
.resolve_db_name() and .execute() work without inspect
...
Refs #420
2019-03-31 16:51:52 -07:00
Simon Willison
0209a0a344
table_exists() now uses async SQL, refs #420
2019-03-31 11:02:22 -07:00
Simon Willison
82fec60481
Fix for TypeError
...
File "../datasette/app.py", line 138, in __init__
self.files = files + immutables
TypeError: can only concatenate tuple (not "list") to tuple
2019-03-17 16:36:35 -07:00
Simon Willison
47032636b5
'datasette serve -i immutable.db' option, refs #419
2019-03-17 16:25:15 -07:00
Simon Willison
6f6d0ff2b4
URL hashing is now off by default - closes #418
...
Prior to this commit Datasette would calculate the content hash of every
database and redirect to a URL containing that hash, like so:
https://v0-27.datasette.io/fixtures => https://v0-27.datasette.io/fixtures-dd88475
This assumed that all databases were opened in immutable mode and were not
expected to change.
This will be changing as a result of #419 - so this commit takes the first step
in implementing that change by changing this default behaviour. Datasette will
now only redirect hash-free URLs under two circumstances:
* The new `hash_urls` config option is set to true (it defaults to false).
* The user passes `?_hash=1` in the URL
2019-03-17 15:55:04 -07:00
Simon Willison
afe9aa3ae0
show/hide link for SQL on custom query page
...
Closes #415
2019-03-14 22:22:35 -07:00
joelondon
9e8c36793b
Update spatialite.rst ( #413 )
...
a line of sql added to create the idx_<table_name> in the python recipe
2019-03-14 22:06:45 -07:00
Simon Willison
2855667908
Fix for test failure with Click 7.0
2019-03-14 22:00:13 -07:00
Simon Willison
b3e7393326
Allow more recent versions of Click
...
Closes #414
2019-03-14 21:41:43 -07:00
Simon Willison
9743e1d91b
Support for :memory: databases
...
If you start Datasette with no files, it will connect to :memory: instead.
When starting it with files you can add --memory to also get a :memory: database.
2019-03-14 20:54:42 -07:00
Simon Willison
bf6b0f918d
about and about_url metadata options
2019-03-14 20:54:42 -07:00
Simon Willison
41744d7690
Added datasette-jellyfish
2019-03-09 10:43:12 -08:00
Simon Willison
4147c388cb
Link to sqlite-utils blog entry
2019-03-07 20:30:21 -08:00
Simon Willison
5b3af3d015
Added sqlite-utils blog entry to news section
2019-02-24 19:47:11 -08:00
Simon Willison
1f91065b20
Added socrata2sql to the ecosystem page
...
A fantastic new tool created by @achavez at the Dallas Morning News.
2019-02-08 08:06:10 -08:00
Simon Willison
d5d39da12b
Expanded section on db-to-sqlite
2019-02-07 22:23:27 -08:00
Simon Willison
4462a5ab28
Show size of database file next to download link, closes #172
2019-02-05 20:58:29 -08:00
Simon Willison
195a5b3634
Heroku --include-vcs-ignore ( #407 )
...
Means `datasette publish heroku` can work under Travis, unlike this failure:
https://travis-ci.org/simonw/fivethirtyeight-datasette/builds/488047550
```
2.25s$ datasette publish heroku fivethirtyeight.db -m metadata.json -n fivethirtyeight-datasette
tar: unrecognized option '--exclude-vcs-ignores'
Try 'tar --help' or 'tar --usage' for more information.
▸ Command failed: tar cz -C /tmp/tmpuaxm7i8f --exclude-vcs-ignores --exclude
▸ .git --exclude .gitmodules . >
▸ /tmp/f49440e0-1bf3-4d3f-9eb0-fbc2967d1fd4.tar.gz
▸ tar: unrecognized option '--exclude-vcs-ignores'
▸ Try 'tar --help' or 'tar --usage' for more information.
▸
The command "datasette publish heroku fivethirtyeight.db -m metadata.json -n fivethirtyeight-datasette" exited with 0.
```
The fix for that issue is to call the heroku command like this:
heroku builds:create -a app_name --include-vcs-ignore
2019-02-05 20:15:46 -08:00
Simon Willison
436b8bc1d1
Datasette 0.27
2019-01-31 19:47:05 -08:00
Simon Willison
b944bcd0f0
Added documentation on the Datasette Ecosystem
...
https://datasette.readthedocs.io/en/latest/ecosystem.html
2019-01-31 19:36:07 -08:00
Simon Willison
b5dd83981a
Export option: _shape=array&_nl=on for newline-delimited JSON
2019-01-27 17:40:23 -08:00