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

#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

#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

#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

#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

#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

#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

#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

#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