mirror
/
datasette
kopia lustrzana https://github.com/simonw/datasette
1
0
Forkuj 0
Kod Zgłoszenia Packages Projekty Wydania Wiki Aktywność
2 591 Commity
131 Gałęzie
148 Tagi
75 MiB
Wykres commitów

137 Commity (main)

Autor SHA1 Wiadomość Data
Simon Willison 5f4aeb1f19 Removed documentation for Zeit Now v1, refs #710 2020-03-24 15:45:24 -07:00
Simon Willison 7e357abbc3 Release 0.38 2020-03-08 16:26:50 -07:00
Simon Willison 7508477a96
Link to Datasette Writes blog entry 2020-03-08 10:23:51 -07:00
Simon Willison c9e6841482 News and release notes for 0.37 2020-02-25 17:22:02 -08:00
Simon Willison b031fe9763 Updated README news for 0.36 2020-02-21 19:04:46 -08:00
Simon Willison e7f60d2a9b Release notes for Datasette 0.34, plus news updates 2020-01-29 16:09:01 -08:00
Simon Willison 59e7014c8a Release 0.33 2019-12-22 16:27:04 +00:00
Simon Willison dc98b0f41d Link to JSK Medium post from news 2019-12-22 16:16:58 +00:00
Simon Willison 2039e78e58
Added Niche Museums to News 2019-12-02 22:53:59 -08:00
Simon Willison 8fc9a5d877
Datasette 0.32 and datasette-template-sql in news 2019-11-14 15:46:37 -08:00
Simon Willison bbd00e903c
Badge linking to datasette on hub.docker.com 2019-11-12 18:38:13 -08:00
Simon Willison c633c035dc Datasette 0.31 in news section 2019-11-11 21:26:56 -08:00
Simon Willison cf7776d36f
Support Python 3.8, stop supporting Python 3.5 (#627) 
* Upgrade to uvicorn 0.10.4
* Drop support for Python 3.5
* Bump all dependencies to latest releases
* Update docs to reflect we no longer support 3.5
* Removed code that skipped black unit test on 3.5

Closes #622
 2019-11-11 21:09:11 -08:00
Simon Willison ffae2f0ecd Better documentation of --host, closes #574 2019-11-01 14:57:49 -07:00
Simon Willison 8050f9e1ec Update news in README 2019-10-18 18:08:04 -07:00
Simon Willison 9366d0bf19
Add Python versions badge 2019-10-14 15:29:16 -07:00
Simon Willison afc2e4260a
News: Single sign-on against GitHub using ASGI middleware 2019-07-13 18:42:35 -07:00
Simon Willison 81fa8b6cdc
News: Datasette 0.29, datasette-auth-github, datasette-cors 2019-07-07 21:36:27 -07:00
Simon Willison 34e292d24d
Porting Datasette to ASGI, and Turtles all the way down 2019-06-23 22:28:37 -07:00
Simon Willison 3fe21b91bb Typo 2019-05-27 11:27:21 -07:00
Simon Willison c902590ada
Stack Overflow survey added to news 2019-05-21 11:47:28 -07:00
Simon Willison f12220b17d
Link to blog post about 0.28 2019-05-21 09:33:57 -07:00
Simon Willison e518f76c5f README for Datasette 0.28 release 2019-05-19 14:37:49 -07:00
Simon Willison afd0480d3f
Tidy up README, reducing duplication with docs 
Refs #451
 2019-05-19 14:31:03 -07:00
Simon Willison bfa2ae0d16
Promote Glitch instead of Datasette Publish 
Datasette Publish is currently broken due to Zeit API and platform changes.
 2019-05-08 17:02:47 -07:00
Simon Willison 55643430f7
Added Code style: black badge 2019-05-03 22:21:21 -04:00
Simon Willison efc93b8ab5 Entirely removed table_rows_count table property 
We were not displaying this anywhere, and it is now expensive to calculate.

Refs #419, #420
 2019-05-01 22:29:47 -07:00
Simon Willison 5b3af3d015
Added sqlite-utils blog entry to news section 2019-02-24 19:47:11 -08:00
Simon Willison 436b8bc1d1 Datasette 0.27 2019-01-31 19:47:05 -08:00
Simon Willison 4722acc73c Release 0.26.1 2019-01-10 16:51:38 -08:00
Simon Willison 424e146697 Datasette 0.26 release notes 2019-01-02 18:53:59 -08:00
Simon Willison 48d24c6589
Link to new tutorial from the README 2018-12-18 21:39:35 -08:00
Simon Willison 5debabd3fb
More human friendly 'what is Datasette' intro text 2018-11-04 22:04:23 -08:00
Simon Willison 24cea27196
Link to "The interesting ideas in Datasette" 2018-10-03 19:40:04 -07:00
Simon Willison 57a71377c9
Releasing Datasette 0.25 2018-09-19 19:48:12 +02:00
Simon Willison 28872a1fa7
Release notes for 0.24 release 2018-07-23 21:34:38 -07:00
Simon Willison 9281a4a804
New tagline: 'A tool for exploring and publishing data' 2018-07-10 19:05:41 -07:00
Simon Willison 24af1004a4
Added datasette-vega to news section 2018-06-29 09:53:36 -05:00
Simon Willison e7566cc59d
Link to 0.23.1 release notes from news 2018-06-21 09:01:38 -07:00
Simon Willison e04f5b0d34
Release notes for 0.23 2018-06-18 08:11:57 -07:00
Simon Willison c25c3e51c9
Link to latest.datasette.io from README 2018-06-17 15:02:20 -07:00
Simon Willison db1e6bc182
--version-note for datasette, datasette publish and datasette package 
This is a relatively obscure new command-line argument that helps solve the
problem of showing accurate version information in deployed instances of
Datasette even if they were deployed directly from source code.

You can pass --version-note to datasette publish and package and it will then
in turn be passed to datasette when it starts:

    datasette --version-note=hello fixtures.db

Now if you visit /-/versions.json you will see this:

    {
        "datasette": {
            "note": "hello",
            "version": "0+unknown"
        },
        "python": {
            "full": "3.6.5 (default, Jun  6 2018, 19:19:24) \n[GCC 6.3.0 20170516]",
            "version": "3.6.5"
        },
        ...
    }

I plan to use this in some Travis CI configuration, refs #313
 2018-06-17 14:19:39 -07:00
Simon Willison 538565de3a
datasette publish now --token=X argument 
Lets you specify the auth token to use when deploying to Now.

Tokens can be created at https://zeit.co/account/tokens
 2018-06-17 14:16:08 -07:00
Simon Willison b18e451585
datasette publish/package --spatialite, closes #243 
New command-line argument which causes SpatiaLite to be installed and
configured for the published Datasette.

	datasette publish now --spatialite mydb.db
 2018-05-31 07:16:50 -07:00
Simon Willison 5d62527882
0.22.1 bugfix release 2018-05-23 07:00:01 -07:00
Simon Willison 558d9d7bfe
Datasette 0.22: Datasette Facets 2018-05-20 16:41:47 -07:00
Simon Willison f6183ff5fa
Renamed --limit to --config, added --help-config, closes #274 
Removed the --page_size= argument to datasette serve in favour of:

    datasette serve --config default_page_size:50 mydb.db

Added new help section:

    $ datasette --help-config
    Config options:
      default_page_size            Default page size for the table view
                                   (default=100)
      max_returned_rows            Maximum rows that can be returned from a table
                                   or custom query (default=1000)
      sql_time_limit_ms            Time limit for a SQL query in milliseconds
                                   (default=1000)
      default_facet_size           Number of values to return for requested facets
                                   (default=30)
      facet_time_limit_ms          Time limit for calculating a requested facet
                                   (default=200)
      facet_suggest_time_limit_ms  Time limit for calculating a suggested facet
                                   (default=50)
 2018-05-20 10:01:49 -07:00
Simon Willison cef9a9a870
--limit= mechanism plus new limits for facets 
Replaced the --max_returned_rows and --sql_time_limit_ms options to
"datasette serve" with a new --limit option, which supports a larger
list of limits.

Example usage:

	datasette serve --limit max_returned_rows:1000 \
		--limit sql_time_limit_ms:2500 \
		--limit default_facet_size:50 \
		--limit facet_time_limit_ms:1000 \
		--limit facet_suggest_time_limit_ms:500

New docs: https://datasette.readthedocs.io/en/latest/limits.html

Closes #270
Closes #264
 2018-05-17 22:08:26 -07:00
Simon Willison 8e0f072847
Added Datasette 0.21 to News 2018-05-05 20:24:55 -03:00
Simon Willison 7f44d31782
Link to register-of-members-interests tutorial 2018-04-25 10:40:48 -07:00
Simon Willison ea0a761303
Link to documentation from README 2018-04-20 17:20:56 -07:00
lsb a971718d2a Fix a typo (#232) 2018-04-20 17:19:07 -07:00
Simon Willison 05bdf53358
Added missing hyphen 2018-04-20 14:15:13 -07:00
Simon Willison ae02e9f4ac
Added datasette-cluster-map blog entry to news 2018-04-20 14:14:35 -07:00
Simon Willison 3a5d7951ce
Added Datasette 0.20 to news 2018-04-20 07:36:29 -07:00
Simon Willison 7581320823
Documentation for --install option, refs #223 2018-04-18 08:05:06 -07:00
Simon Willison bf5ec2d611
Updated PyPI link to pypi.org 2018-04-16 19:24:36 -07:00
Simon Willison ba9bfa5831
Datasette 0.19: plugin preview (with release notes) 2018-04-16 19:12:21 -07:00
Simon Willison 1652a9707e
Apache 2.0 license badge 2018-04-16 16:10:12 -07:00
Simon Willison 904f1c75a3
Initial documentation for plugins, closes #213 
https://datasette.readthedocs.io/en/latest/plugins.html
 2018-04-16 08:12:09 -07:00
Simon Willison 8d394586f5
Added 0.18 to news 2018-04-14 09:04:38 -07:00
Simon Willison bfb4e45a7b
Datasette Publish in readme 2018-04-11 07:43:28 -07:00
Simon Willison 67982b6ecb
Added Datasette 0.15 to news 2018-04-09 09:01:03 -07:00
Simon Willison a290f28caa
table_rows => table_rows_count, filtered_table_rows => filtered_table_rows_count 
Renamed properties. Closes #194
 2018-04-08 22:24:24 -07:00
Simon Willison 0abd3abacb
New ?_shape=objects/object/lists param for JSON API (#192) 
New _shape= parameter replacing old .jsono extension

Now instead of this:

	/database/table.jsono

We use the _shape parameter like this:

	/database/table.json?_shape=objects

Also introduced a new _shape called 'object' which looks like this:

	/database/table.json?_shape=object

Returning an object for the rows key:

	...
	"rows": {
		"pk1": {
			...
		},
		"pk2": {
			...
		}
	}

Refs #122
 2018-04-03 07:52:54 -07:00
Simon Willison 0e5f51adfe
Three more news items 2018-03-30 00:03:45 -07:00
Simon Willison 56623e48da
News: Datasette Publish 2018-01-17 07:50:10 -08:00
Simon Willison 4f08fc092f
Updated news 2017-12-12 08:52:19 -08:00
Simon Willison 702829f808
Added Datasette 0.14: customization edition to news 2017-12-09 18:10:30 -08:00
Simon Willison 6bdfcf6076
Added Heroku to README, updated --help output examples 
Refs #157
 2017-12-09 10:50:08 -08:00
Simon Willison 0539905806
Renamed "datasette build" command to "datasette inspect" 
Closes #130
 2017-12-07 08:57:31 -08:00
Simon Willison f9c32e717f
Linked to csvs-to-sqlite 2017-12-06 07:09:56 -08:00
Simon Willison 23a4575818
Added News section to Readme 2017-11-25 13:40:43 -08:00
Simon Willison efb82da927
datasette => Datasette 2017-11-24 19:46:24 -08:00
Simon Willison ddc808f387
Added --build=master option to datasette publish and package 
The `datasette publish` and `datasette package` commands both now accept an
optional `--build` argument. If provided, this can be used to specify a branch
published to GitHub that should be built into the container.

This makes it easier to test code that has not yet been officially released to
PyPI, e.g.:

    datasette publish now mydb.db --branch=master
 2017-11-19 10:20:17 -08:00
Simon Willison b7c4165346 Added --load-extension argument to datasette serve 
Allows loading of SQLite extensions. Refs #110.
 2017-11-16 08:48:49 -08:00
Simon Willison 5bfb23b949
Added Read The Docs badge 
Closes #109
 2017-11-16 08:13:55 -08:00
Simon Willison ea183b2ae3 Default to 127.0.0.1 not 0.0.0.0 
Closes #98
 2017-11-14 21:08:46 -08:00
Simon Willison 7fe1e8b482 Added extra metadata options to publish and package commands 
You can now run these commands like so:

    datasette now publish mydb.db \
        --title="My Title" \
        --source="Source" \
        --source_url="http://www.example.com/" \
        --license="CC0" \
        --license_url="https://creativecommons.org/publicdomain/zero/1.0/"

This will write those values into the metadata.json that is packaged with the
app. If you also pass --metadata= that file will be updated with the extra
values before being written into the Docker image.

Closes #92
 2017-11-14 21:02:11 -08:00
Simon Willison 075d422c0a
Fixed typo 2017-11-13 21:28:02 -08:00
Simon Willison 98ae6d6a40
Added link to examples 2017-11-13 21:27:21 -08:00
Simon Willison fc7c04fe0b Added 'datasette publish now --force' option 
This calls now with --force - which is useful as it means you get a fresh copy of
datasette even if now has already cached that docker layer.
 2017-11-13 17:48:03 -08:00
Simon Willison bdfb6d4f13
Fixed package output example 2017-11-13 14:18:44 -08:00
Simon Willison 1e698787a4 Added --sql_time_limit_ms and --extra-options 
The serve command now accepts --sql_time_limit_ms for customizing the SQL time
limit.

The publish and package commands now accept --extra-options which can be used
to specify additional options to be passed to the datasite serve command when
it executes inside the rusulting Docker containers.
 2017-11-13 14:00:53 -08:00
Simon Willison 452c5f047e
Added Travis CI badge to README 
Closes #77
 2017-11-13 13:24:14 -08:00
Simon Willison 8252e71da4 Limit on max rows returned, controlled by --max_returned_rows option 
If someone executes 'select * from table' against a table with a million rows
in it, we could run into problems: just serializing that much data as JSON is
likely to lock up the server.

Solution: we now have a hard limit on the maximum number of rows that can be
returned by a query. If that limit is exceeded, the server will return a
`"truncated": true` field in the JSON.

This limit can be optionally controlled by the new `--max_returned_rows`
option. Setting that option to 0 disables the limit entirely.

Closes #69
 2017-11-13 11:33:01 -08:00
Simon Willison e838bd743d Added README and improved help for 'datasette serve' 2017-11-13 10:41:59 -08:00