Wykres commitów

815 Commity (no-auto-format-sql)

Autor SHA1 Wiadomość Data
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
Simon Willison 909cc8fbdf New 'datasette plugins' command to list installed plugins 2019-01-26 12:01:16 -08:00
Simon Willison 7950105c27 Python 3.7.2 as base for Docker image 2019-01-13 15:33:50 -08:00
Simon Willison a418c8b44f Expose current git tag to Docker build, closes #399 2019-01-13 15:09:48 -08:00
Simon Willison c3a78eb05c app_client() fixture doesn't need to take **kwargs 2019-01-13 14:23:44 -08:00
Simon Willison 4722acc73c Release 0.26.1 2019-01-10 16:51:38 -08:00
Simon Willison 50d8d8216d Dockerfile now builds SQLite 3.26.0, closes #397 2019-01-10 16:47:54 -08:00
Simon Willison c4c970f3c9 Bump aiohttp to 3.5.3 to fix a warning 2019-01-10 16:47:15 -08:00
Simon Willison 8ce7866312 compile_options output in /-/versions, closes #396 2019-01-10 16:44:50 -08:00
Simon Willison 5b02611512
Corrected import path in plugin docs 2019-01-08 16:25:29 -08:00
Simon Willison 788f218e26 Supress pytest warnings from 3rd party modules 2019-01-05 20:44:34 -08:00
Simon Willison b65d97792a
Switch to using PYPI_PASSWORD env var in Travis 2019-01-02 19:14:21 -08:00
Simon Willison 424e146697 Datasette 0.26 release notes 2019-01-02 18:53:59 -08:00
Simon Willison 996e8822d2 Fix CSV export hidden form fields, closes #393 2019-01-02 18:43:56 -08:00
Simon Willison 8b8ae55e7c Pass --token to 'now alias', if provided 2019-01-01 21:35:16 -08:00
Simon Willison d95b46b09b datasette publish now --alias option
You can now use --alias to attempt to alias after you deploy.

Also updated now.json to use version: 1
2019-01-01 21:15:54 -08:00
Simon Willison a2bfcfc1b1
Fix some regex DeprecationWarnings (#392) 2018-12-28 18:22:27 -08:00
Simon Willison eac08f0dfc
--reload now also reloads if databases change on disk 2018-12-20 07:51:08 -08:00
Simon Willison 48d24c6589
Link to new tutorial from the README 2018-12-18 21:39:35 -08:00
Simon Willison 74ad06e128
Updated notes on FTS5 v.s. FTS4 2018-12-18 13:49:51 -08:00
Simon Willison 595da9054e
Better example commit
This one updates the README news section as well
2018-12-16 14:56:56 -08:00
Simon Willison 1e2db8547b
Improved release process documentation 2018-12-16 13:47:39 -08:00
Jay Graves ed78922ae3 Tiny typo in customization docs (#390)
Thanks, @jaywgraves
2018-12-16 13:32:55 -08:00
Simon Willison b5128fc53f
Release 0.25.2 2018-12-16 13:26:37 -08:00
Simon Willison 84d7890b63
Upgrade pytest to 4.0.2 2018-12-16 13:18:55 -08:00
Simon Willison c5f90dd1b2
Added docs on updating docs + the release process 2018-12-16 13:14:50 -08:00
Simon Willison 54a59b9fdb
Use python-3.6.7 runtime for Heroku deploys 2018-12-16 12:53:00 -08:00
Simon Willison 3de8fac1d3
New make_app_client() pattern
Because next version of pytest discourages calling fixture factories as functions
2018-11-20 09:46:47 -08:00
Simon Willison 5e3a432a0c
How to activate your virtual environment 2018-11-14 16:54:54 -08:00