Ecosyste.ms: Issues
An open API service for providing issue and pull request metadata for open source projects.
GitHub / simonw/sqlite-utils issues and pull requests
#609 - Enable FTS for attached dbs
Pull Request -
State: open - Opened by petergaultney 6 months ago
#608 - Attached database tables representable by `Table`
Issue -
State: open - Opened by petergaultney 6 months ago
#607 - pyright and mypy showing access error messages for basic sqlite-utils usage
Issue -
State: closed - Opened by geekodour 7 months ago
#606 - str and int as aliases for text and integer
Issue -
State: closed - Opened by simonw 7 months ago
- 2 comments
Labels: enhancement, cli-tool
#605 - Insert fails with `Error: Python int too large to convert to SQLite INTEGER`; can we use `NUMERIC` here?
Issue -
State: closed - Opened by Zac-HD 7 months ago
- 1 comment
#604 - Add more STRICT table support
Pull Request -
State: closed - Opened by tkhattra 7 months ago
- 4 comments
#603 - Pyhton 3.12 Bug report
Issue -
State: open - Opened by constantinedev 8 months ago
- 1 comment
Labels: bug
#602 - `sqlite-utils transform` removes the `AUTOINCREMENT` keyword
Issue -
State: open - Opened by ArsTapatun 8 months ago
#601 - Move plugin directory into documentation
Issue -
State: open - Opened by simonw 8 months ago
Labels: documentation, plugins
#600 - Add spatialite arm64 linux path
Pull Request -
State: closed - Opened by MikeCoats 8 months ago
- 5 comments
#599 - Cannot find spatialite on arm64 linux
Issue -
State: closed - Opened by MikeCoats 8 months ago
- 1 comment
Labels: bug
#598 - Fixed issue #433 - CLI eats cursor
Pull Request -
State: closed - Opened by spookylukey 9 months ago
- 2 comments
Labels: bug
#597 - sqlite-utils insert-files should be able to convert fields
Issue -
State: open - Opened by grimnight 9 months ago
#596 - Fixes mapping for time fields related to mysql, closes #522
Pull Request -
State: closed - Opened by nezhar 9 months ago
- 1 comment
#595 - Cascading DELETE not working with Table.delete(pk)
Issue -
State: closed - Opened by cycle-data 9 months ago
- 1 comment
#594 - Represent compound foreign keys in table.foreign_keys output
Issue -
State: open - Opened by simonw 10 months ago
- 2 comments
Labels: enhancement, python-library
#593 - .transform() now preserves rowid values, refs #592
Pull Request -
State: closed - Opened by simonw 10 months ago
- 1 comment
Labels: bug
#592 - `table.transform()` should preserve `rowid` values
Issue -
State: closed - Opened by simonw 10 months ago
- 6 comments
Labels: bug
#591 - Test against Python 3.12 preview
Pull Request -
State: closed - Opened by simonw 10 months ago
- 3 comments
#590 - Ability to tell if a Database is an in-memory one
Issue -
State: open - Opened by simonw 10 months ago
- 1 comment
Labels: enhancement, python-library
#589 - Mechanism for de-registering registered SQL functions
Issue -
State: open - Opened by simonw 10 months ago
- 3 comments
Labels: enhancement, python-library
#588 - `table.get(column=value)` option for retrieving things not by their primary key
Issue -
State: open - Opened by simonw 10 months ago
- 1 comment
#587 - New .add_foreign_key() can break if PRAGMA legacy_alter_table=ON and there's an invalid foreign key reference
Issue -
State: closed - Opened by simonw 10 months ago
- 3 comments
Labels: bug
#586 - .transform() fails to drop column if table is part of a view
Issue -
State: open - Opened by simonw 11 months ago
- 3 comments
Labels: bug, enhancement
#585 - CLI equivalents to `transform(add_foreign_keys=)`
Issue -
State: closed - Opened by simonw 11 months ago
- 7 comments
Labels: enhancement, cli-tool
#584 - .transform() instead of modifying sqlite_master for add_foreign_keys
Pull Request -
State: closed - Opened by simonw 11 months ago
- 13 comments
Labels: bug
#583 - Get rid of test.utils.collapse_whitespace
Issue -
State: closed - Opened by simonw 11 months ago
- 1 comment
Labels: refactor
#582 - Handling CSV/file input that contains NUL bytes
Issue -
State: open - Opened by betatim 11 months ago
#581 - `sqlite-utils convert --pdb` option
Issue -
State: closed - Opened by simonw 11 months ago
- 1 comment
Labels: enhancement, cli-tool
#580 - Add way to export to a csv file using the Python library
Issue -
State: open - Opened by kevinlinxc 11 months ago
#579 - Special handling for SQLite column of type `JSON`
Issue -
State: open - Opened by asg017 11 months ago
#578 - Plugin hook for adding new output formats
Issue -
State: open - Opened by simonw 11 months ago
- 5 comments
Labels: enhancement, plugins
#577 - Get `add_foreign_keys()` to work without modifying `sqlite_master`
Issue -
State: closed - Opened by simonw 11 months ago
- 9 comments
Labels: research
#576 - Backfill the release notes prior to 0.4
Issue -
State: closed - Opened by simonw 11 months ago
- 2 comments
Labels: documentation
#575 - Python API ability to opt-out of connection plugins
Issue -
State: closed - Opened by simonw 11 months ago
- 2 comments
Labels: enhancement, python-library, plugins
#574 - `prepare_connection()` plugin hook
Issue -
State: closed - Opened by simonw 11 months ago
- 3 comments
Labels: enhancement, plugins
#573 - feat: Implement a prepare_connection plugin hook
Pull Request -
State: closed - Opened by asg017 11 months ago
- 4 comments
#572 - Don't test Python 3.7 against textual
Issue -
State: closed - Opened by simonw 11 months ago
- 2 comments
Labels: ci
#571 - `.transform(keep_table=...)` option
Issue -
State: closed - Opened by simonw 11 months ago
- 1 comment
Labels: enhancement, python-library
#570 - `sqlite-utils install -e` option
Issue -
State: closed - Opened by simonw 11 months ago
Labels: enhancement, cli-tool, plugins
#569 - register_command plugin hook
Issue -
State: closed - Opened by simonw 11 months ago
- 3 comments
Labels: enhancement, plugins
#568 - table.create(..., replace=True)
Issue -
State: closed - Opened by simonw 11 months ago
- 7 comments
Labels: enhancement, python-library
#567 - Plugin system
Issue -
State: closed - Opened by asg017 12 months ago
- 9 comments
Labels: enhancement, plugins
#566 - `--no-headers` doesn't work on most formats
Issue -
State: open - Opened by zellyn 12 months ago
- 2 comments
Labels: bug
#565 - Table renaming: db.rename_table() and sqlite-utils rename-table
Issue -
State: closed - Opened by simonw 12 months ago
- 6 comments
Labels: enhancement, python-library, cli-tool
#564 - Document that running `db.transform()` tidies up the schema indentation
Issue -
State: closed - Opened by simonw 12 months ago
Labels: documentation
#563 - `--empty-null` option when importing CSV
Issue -
State: closed - Opened by simonw 12 months ago
- 1 comment
Labels: enhancement, cli-tool
#562 - Explore the intersection between sqlite-utils and dataclasses
Issue -
State: open - Opened by simonw 12 months ago
- 1 comment
Labels: research
#561 - `--stop-after` option for `insert` and `upsert` commands
Issue -
State: closed - Opened by simonw about 1 year ago
- 1 comment
Labels: enhancement
#560 - Use sqlean if available in environment
Pull Request -
State: closed - Opened by simonw about 1 year ago
- 10 comments
#559 - sqlean support
Issue -
State: closed - Opened by simonw about 1 year ago
Labels: enhancement, documentation
#558 - Ability to define unique columns when creating a table
Issue -
State: open - Opened by aguinane about 1 year ago
Labels: enhancement, python-library
#557 - Aliased ROWID option for tables created from alter=True commands
Issue -
State: closed - Opened by chapmanjacobd about 1 year ago
- 2 comments
#556 - Support storing incrementally piped values
Issue -
State: open - Opened by mcint about 1 year ago
- 1 comment
#555 - Filter table by a large bunch of ids
Issue -
State: open - Opened by redraw about 1 year ago
- 1 comment
#554 - `IndexError` when doing `.insert(..., pk='id')` after `insert_all`
Issue -
State: open - Opened by xavdid about 1 year ago
- 1 comment
#553 - Reformatted CLI examples in docs
Pull Request -
State: closed - Opened by simonw about 1 year ago
- 2 comments
Labels: documentation
#552 - Document how to setup shell auto-completion
Issue -
State: closed - Opened by simonw about 1 year ago
- 1 comment
Labels: documentation
#551 - Make as many examples in the CLI docs as possible copy-and-pastable
Issue -
State: closed - Opened by simonw about 1 year ago
- 6 comments
Labels: documentation
#550 - AttributeError: 'EntryPoints' object has no attribute 'get' for flake8 on Python 3.7
Issue -
State: closed - Opened by simonw about 1 year ago
- 3 comments
Labels: bug, ci
#549 - TUI powered by Trogon
Pull Request -
State: closed - Opened by simonw about 1 year ago
- 3 comments
Labels: enhancement
#548 - analyze-tables should validate provide --column names
Issue -
State: closed - Opened by simonw about 1 year ago
- 1 comment
Labels: bug
#547 - No need to show common values if everything is null
Issue -
State: closed - Opened by simonw about 1 year ago
- 1 comment
Labels: enhancement
#546 - Analyze tables options: --common-limit, --no-most, --no-least
Pull Request -
State: closed - Opened by simonw about 1 year ago
- 2 comments
Labels: enhancement
#545 - Try out Trogon for a tui interface
Issue -
State: closed - Opened by simonw about 1 year ago
- 6 comments
Labels: research
#544 - New options for analyze-tables --common-limit --no-most and --no-least
Issue -
State: closed - Opened by simonw about 1 year ago
- 2 comments
Labels: enhancement
#543 - Tests broken on Windows due to new convert() lambda names
Issue -
State: closed - Opened by simonw about 1 year ago
Labels: bug, ci
#542 - Remove `skip_false=True` and `--no-skip-false` in `sqlite-utils` 4.0
Issue -
State: open - Opened by simonw about 1 year ago
- 1 comment
Labels: enhancement
#541 - Get tests to pass with `pytest -Werror`
Issue -
State: open - Opened by simonw about 1 year ago
- 1 comment
Labels: help wanted, ci
#540 - sphinx.builders.linkcheck build error
Issue -
State: closed - Opened by simonw about 1 year ago
- 4 comments
Labels: bug, documentation, ci
#539 - `--raw-lines` option, like `--raw` for multiple lines
Issue -
State: closed - Opened by simonw about 1 year ago
- 4 comments
Labels: enhancement
#538 - `table.upsert_all` fails to write rows when `not_null` is present
Issue -
State: closed - Opened by xavdid about 1 year ago
- 10 comments
Labels: bug
#537 - Support self-referencing FKs in `Table.create`
Pull Request -
State: closed - Opened by numist about 1 year ago
- 3 comments
Labels: enhancement
#536 - Add paths for homebrew on Apple silicon
Pull Request -
State: closed - Opened by eyeseast about 1 year ago
- 1 comment
#535 - rows: --transpose or psql extended view-like functionality
Issue -
State: closed - Opened by chapmanjacobd about 1 year ago
- 2 comments
#534 - ResourceWarning: unclosed file
Issue -
State: closed - Opened by djhenderson over 1 year ago
- 1 comment
#533 - ReadTheDocs error: not all arguments converted during string formatting
Issue -
State: closed - Opened by simonw over 1 year ago
- 2 comments
Labels: bug
#532 - Show more information when JSON can't be imported with sqlite-utils insert
Issue -
State: closed - Opened by voltagex over 1 year ago
- 2 comments
Labels: enhancement
#531 - Add paths for homebrew on Apple silicon
Pull Request -
State: closed - Opened by eyeseast over 1 year ago
- 4 comments
#530 - add ability to configure "on delete" and "on update" attributes of foreign keys:
Issue -
State: open - Opened by fgregg over 1 year ago
- 2 comments
Labels: enhancement
#529 - Microsoft line endings
Issue -
State: closed - Opened by chapmanjacobd over 1 year ago
- 1 comment
#528 - Enable `Table.convert()` on falsey values
Pull Request -
State: closed - Opened by mcarpenter over 1 year ago
- 1 comment
#527 - `Table.convert()` skips falsey values
Issue -
State: closed - Opened by mcarpenter over 1 year ago
- 5 comments
Labels: bug
#526 - Fix repeated calls to `Table.convert()`
Pull Request -
State: closed - Opened by mcarpenter over 1 year ago
#525 - Repeated calls to `Table.convert()` fail
Issue -
State: closed - Opened by mcarpenter over 1 year ago
- 4 comments
Labels: bug
#524 - Transformation type `--type DATETIME`
Issue -
State: closed - Opened by 4l1fe over 1 year ago
- 15 comments
#523 - Feature request: trim all leading and trailing white space for all columns for all tables in a database
Issue -
State: open - Opened by fgregg over 1 year ago
- 1 comment
#522 - Add COLUMN_TYPE_MAPPING for timedelta
Issue -
State: closed - Opened by maport over 1 year ago
Labels: bug
#521 - Custom JSON encoder
Issue -
State: open - Opened by janrito over 1 year ago
#520 - rows_from_file() raises confusing error if file-like object is not in binary mode
Issue -
State: closed - Opened by simonw over 1 year ago
- 3 comments
Labels: bug
#519 - Fixes breaking DEFAULT values
Pull Request -
State: closed - Opened by rhoboro over 1 year ago
- 1 comment
#518 - flake8 ValueError: Error code '#' supplied to 'extend-ignore' option...
Issue -
State: closed - Opened by simonw over 1 year ago
Labels: bug, ci
#517 - Drop support for Python 3.6
Issue -
State: closed - Opened by simonw over 1 year ago
- 1 comment
Labels: ci
#516 - Feature request: output number of ignored/replaced rows for insert command
Issue -
State: open - Opened by simonw over 1 year ago
- 4 comments
Labels: enhancement
#515 - upsert new rows with constraints, fixes #514
Pull Request -
State: closed - Opened by cldellow over 1 year ago
- 1 comment
#514 - upsert of new row with check constraints fails
Issue -
State: closed - Opened by cldellow over 1 year ago
- 5 comments
#513 - Add or document streamlined workflow for importing Datasette csv / json exports
Issue -
State: open - Opened by henry501 over 1 year ago
#512 - mypy failures in CI
Issue -
State: closed - Opened by simonw over 1 year ago
- 3 comments
Labels: bug, ci
#511 - [insert_all, upsert_all] IntegrityError: constraint failed
Issue -
State: closed - Opened by chapmanjacobd over 1 year ago
- 2 comments
#510 - Cannot enable FTS5 despite it being available
Issue -
State: closed - Opened by ar-jan over 1 year ago
- 3 comments