Simon Willison

Results 1833 comments of Simon Willison

Could you provide full steps to reproduce plus a SpatiaLite database file that triggered this for you? I'm not able to recreate the problem.

This is so weird! What version of Datasette do you get from `datasette --version` there - and what's your Docker version / operating system version?

You get: ``` => [internal] load metadata for docker.io/library/python:3.11.0-slim-bullseye 0.9s => [internal] load build context 2.3s => => transferring context: 72.38MB 2.3s => CACHED [1/6] FROM docker.io/library/python:3.11.0-slim-bullseye@sha256:1cd45c5dad845af18d71745c017325725dc979571c1bbe625b67e6051533716c 0.0s ``` I...

The code for this can go here: https://github.com/simonw/datasette/blob/7818e8b9d15a3d50c16f080dc7fe4b5e8eb3d241/datasette/database.py#L460-L519 It will need to gracefully handle that missing pragma.

We're going to change something here too: we're going to NOT hide FTS virtual tables (or indeed any other virtual table) by default any more. Reason is that FTS tables...

Confirmed an error with Pint: ``` /opt/hostedtoolcache/Python/3.13.0-alpha.6/x64/lib/python3.13/site-packages/pint/delegates/txt_defparser/common.py:21: in @dataclass(frozen=True) /opt/hostedtoolcache/Python/3.13.0-alpha.6/x64/lib/python3.13/dataclasses.py:1289: in wrap return _process_class(cls, init, repr, eq, order, unsafe_hash, /opt/hostedtoolcache/Python/3.13.0-alpha.6/x64/lib/python3.13/dataclasses.py:1044: in _process_class raise TypeError('cannot inherit frozen dataclass from a '...

It passed! ![CleanShot 2024-08-20 at 19 14 23@2x](https://github.com/user-attachments/assets/1022f873-877d-44ae-a14b-7d9e8fd35246)

The test failure was that intermittent unrelated failure we haven't solved yet.

It looks like this is the code at fault: https://github.com/simonw/datasette/blob/86335dc722d31dbf44c6d4bbffd7c5d2d11b1290/datasette/default_permissions.py#L175-L230 Also of note: since that's called by this parent function a related issue is that `root` gets a `True` for...

https://devguide.python.org/versions/ says that Python 3.13 is scheduled for release in October 2024.