sqlite-utils

sqlite-utils copied to clipboard

Read the Docs repository was renamed from `readthedocs/readthedocs-preview` to `readthedocs/actions/`. Now, the `preview` action is under `readthedocs/actions/preview` and is tagged as `v1` ---- :books: Documentation preview :books:: https://sqlite-utils--463.org.readthedocs.build/en/463/

humitos

Extract columns cannot create foreign key relation: sqlite3.OperationalError: table sqlite_master may not be modified

5

Thanks for what seems like a truly great suite of libraries. I wanted to try out Datasette, but never got more than half way through your YouTube video with the...

kristomi

Cross-link CLI to Python docs

3

Work in progress, partly to test the ReadTheDocs preview link action. Refs: - #426 ---- :books: Documentation preview :books:: https://readthedocs-preview--460.org.readthedocs.build/en/460/

simonw

Consider including animated SVG console demos

1

I recorded this one using https://github.com/nbedos/termtosvg - with `pipx install termtosvg` and then `termtosvg` - execute demo - `exit` to save.  ```json [ { "id": 1, "name": "Catimus" },...

simonw

Trying to follow the tutorial for sqlite-utils and datasette https://datasette.io/tutorials/clean-data on Windows 11 OS `Microsoft Windows [Version 10.0.22622.440]`, with sqlite-utils and datasette installed using pipx. ``` pipx list package datasette...

shakeel

in extract code, check equality with IS instead of = for nulls

2

sqlite "IS" is equivalent to SQL "IS NOT DISTINCT FROM" closes #423

fgregg

.extract() doesn't set foreign key when extracted columns contain NULL value

1

I've run into an issue with `extract` and I don't believe this is the intended behaviour. I'm working with a database with music listening information. Currently it has one large...

jlieth

feature request: pivot command

5

pivoting long-format table to wide-format tables is pretty common and kind of pain. would love to see this feature in sqlite-utils!

fgregg

Reading rows from a file => AttributeError: '_io.StringIO' object has no attribute 'readinto'

3

Attempting to run the example given here (without extra bracket ;-): https://sqlite-utils.datasette.io/en/stable/python-api.html#reading-rows-from-a-file ``` from sqlite_utils.utils import rows_from_file import io rows, format = rows_from_file(io.StringIO("id,name\n1,Cleo")) print(list(rows), format) # Outputs [{'id': '1', 'name':...

mungewell

CSV `extras_key=` and `ignore_extras=` equivalents for CLI tool

5

> I forgot to add equivalents of `extras_key=` and `ignore_extras=` to the CLI tool - will do that in a separate issue. _Originally posted by @simonw in https://github.com/simonw/sqlite-utils/issues/440#issuecomment-1155767915_

simonw