simonw sqlite-utils issues

simonw / sqlite-utils

Python CLI utility and library for manipulating SQLite databases

https://sqlite-utils.datasette.io

Apache License 2.0

1.56k stars 105 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Documented the use of `delete_where`

#630 learning4life opened 5 days ago
1
Should upsert() work with compound primary key?

#629 jclark-dot-org opened 3 weeks ago
1
add `include_rank` parameter to `Table.search`

#628 liunux4odoo opened 2 months ago
0
Allow mytable.create_index() to ignore an already existing index

#627 tobych opened 2 months ago
0
Allow an index to be dropped

#626 tobych opened 2 months ago
0
Doublebyte content is unicode-escaped in JSON output

#625 oli opened 3 months ago
0
Query with duplicate output column names drop/overwrites duplicate colums

#624 andig opened 3 months ago
0
Fix test to pass `pytest -Werror`

#623 lbellomo opened 3 months ago
4
Command to generate a visual schema diagram?

#622 epicwhale opened 3 months ago
0
insert-files accept multiple --pk

#621 simonw closed 3 months ago
1
create-table command does not handle compound primary keys

#620 simonw closed 3 months ago
2
Test against Python 3.13 pre-release

#619 simonw closed 3 months ago
9
Use context managers for file writes in tests

#618 kbaikov closed 3 months ago
2
Drop support for Python 3.7

#617 simonw closed 5 months ago
1
Drop support for Python 3.7

#616 simonw closed 5 months ago
1
Run tests against ARM macos-14

#615 simonw closed 5 months ago
2
sqlite-utils command fails when used with xargs

#614 danielhoherd closed 5 months ago
2
Windows: Correct way to initialize spatialite?

#613 AL89 opened 5 months ago
0
Automatic JSON de-serialization

#612 rsyring opened 5 months ago
0
`.transform()` effect on triggers and indices

#611 vkz opened 5 months ago
0
`table.upsert/upsert_all` fails to write row when `not_null` is absent and the schema definition includes `not_null`

#610 alexwlchan opened 6 months ago
3
Enable FTS for attached dbs

#609 petergaultney opened 6 months ago
1
Attached database tables representable by `Table`

#608 petergaultney opened 6 months ago
0
pyright and mypy showing access error messages for basic sqlite-utils usage

#607 geekodour closed 6 months ago
0
str and int as aliases for text and integer

#606 simonw closed 7 months ago
2
Insert fails with `Error: Python int too large to convert to SQLite INTEGER`; can we use `NUMERIC` here?

#605 Zac-HD closed 7 months ago
1
Add more STRICT table support

#604 tkhattra closed 7 months ago
4
Pyhton 3.12 Bug report

#603 constantinedev opened 8 months ago
2
`sqlite-utils transform` removes the `AUTOINCREMENT` keyword

#602 ArsTapatun opened 8 months ago
0
Move plugin directory into documentation

#601 simonw opened 8 months ago
0
Add spatialite arm64 linux path

#600 MikeCoats closed 8 months ago
5
Cannot find spatialite on arm64 linux

#599 MikeCoats closed 8 months ago
1
Fixed issue #433 - CLI eats cursor

#598 spookylukey closed 8 months ago
2
Feature request: sqlite-utils insert-files should be able to convert fields

#597 grimnight opened 9 months ago
0
Fixes mapping for time fields related to mysql, closes #522

#596 nezhar closed 8 months ago
1
Cascading DELETE not working with Table.delete(pk)

#595 cycle-data closed 9 months ago
1
Represent compound foreign keys in table.foreign_keys output

#594 simonw opened 10 months ago
2
.transform() now preserves rowid values, refs #592

#593 simonw closed 10 months ago
1
`table.transform()` should preserve `rowid` values

#592 simonw closed 10 months ago
6
Test against Python 3.12 preview

#591 simonw closed 8 months ago
3
Ability to tell if a Database is an in-memory one

#590 simonw opened 10 months ago
1
Mechanism for de-registering registered SQL functions

#589 simonw opened 10 months ago
3
`table.get(column=value)` option for retrieving things not by their primary key

#588 simonw opened 10 months ago
2
New .add_foreign_key() can break if PRAGMA legacy_alter_table=ON and there's an invalid foreign key reference

#587 simonw closed 10 months ago
3
.transform() fails to drop column if table is part of a view

#586 simonw opened 10 months ago
5
CLI equivalents to `transform(add_foreign_keys=)`

#585 simonw closed 10 months ago
7
.transform() instead of modifying sqlite_master for add_foreign_keys

#584 simonw closed 10 months ago
13
Get rid of test.utils.collapse_whitespace

#583 simonw closed 10 months ago
1
Handling CSV/file input that contains NUL bytes

#582 betatim opened 11 months ago
0
`sqlite-utils convert --pdb` option

#581 simonw closed 11 months ago
1