simonw/sqlite-utils issues and pull requests

#538 - `table.upsert_all` fails to write rows when `not_null` is present

Issue - State: closed - Opened by xavdid over 1 year ago - 10 comments
Labels: bug

#537 - Support self-referencing FKs in `Table.create`

Pull Request - State: closed - Opened by numist over 1 year ago - 3 comments
Labels: enhancement

#536 - Add paths for homebrew on Apple silicon

Pull Request - State: closed - Opened by eyeseast over 1 year ago - 1 comment

#535 - rows: --transpose or psql extended view-like functionality

Issue - State: closed - Opened by chapmanjacobd over 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 - 1 comment

#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 almost 2 years ago - 1 comment

#518 - flake8 ValueError: Error code '#' supplied to 'extend-ignore' option...

Issue - State: closed - Opened by simonw almost 2 years ago
Labels: bug, ci

#517 - Drop support for Python 3.6

Issue - State: closed - Opened by simonw almost 2 years ago - 1 comment
Labels: ci

#516 - Feature request: output number of ignored/replaced rows for insert command

Issue - State: open - Opened by simonw almost 2 years ago - 4 comments
Labels: enhancement

#515 - upsert new rows with constraints, fixes #514

Pull Request - State: closed - Opened by cldellow almost 2 years ago - 1 comment

#514 - upsert of new row with check constraints fails

Issue - State: closed - Opened by cldellow almost 2 years ago - 5 comments

#513 - Add or document streamlined workflow for importing Datasette csv / json exports

Issue - State: open - Opened by henry501 almost 2 years ago

#512 - mypy failures in CI

Issue - State: closed - Opened by simonw almost 2 years ago - 3 comments
Labels: bug, ci

#511 - [insert_all, upsert_all] IntegrityError: constraint failed

Issue - State: closed - Opened by chapmanjacobd almost 2 years ago - 2 comments

#510 - Cannot enable FTS5 despite it being available

Issue - State: closed - Opened by ar-jan almost 2 years ago - 3 comments

#509 - `sqlite-utils transform` breaks DEFAULT string values and STRFTIME()

Issue - State: closed - Opened by kennysong almost 2 years ago

#508 - Allow surrogates in parameters

Pull Request - State: closed - Opened by chapmanjacobd almost 2 years ago - 2 comments

#507 - conn.execute: UnicodeEncodeError: 'utf-8' codec can't encode character

Issue - State: closed - Opened by chapmanjacobd almost 2 years ago - 1 comment

#506 - Make `cursor.rowcount` accessible (wontfix)

Issue - State: closed - Opened by simonw almost 2 years ago - 3 comments
Labels: enhancement, wontfix, python-library

#505 - Release sqlite-utils 3.30

Issue - State: closed - Opened by simonw almost 2 years ago - 2 comments
Labels: documentation

#504 - db.close() method, calling db.conn.close()

Issue - State: closed - Opened by simonw almost 2 years ago - 1 comment
Labels: enhancement, python-library

#503 - test_recreate failing on Windows Python 3.11

Issue - State: closed - Opened by simonw almost 2 years ago - 10 comments
Labels: bug, ci

#502 - Fix tests for Python 3.11

Issue - State: closed - Opened by simonw almost 2 years ago - 1 comment
Labels: bug, ci

#501 - Tests failing due to updated tabulate library

Issue - State: closed - Opened by simonw almost 2 years ago - 4 comments
Labels: bug

#500 - Turn --flatten into a documented utility function

Issue - State: closed - Opened by simonw almost 2 years ago - 4 comments
Labels: enhancement, python-library

#499 - feat: recreate fts triggers after table transform

Pull Request - State: open - Opened by chapmanjacobd almost 2 years ago - 2 comments

#498 - fix: enable-fts permanently save triggers

Pull Request - State: closed - Opened by chapmanjacobd almost 2 years ago - 2 comments

#497 - column_names

Issue - State: closed - Opened by chapmanjacobd almost 2 years ago - 1 comment

#496 - devrel/python api: Pylance type hinting

Issue - State: open - Opened by chapmanjacobd almost 2 years ago - 4 comments
Labels: help wanted, research

#495 - Support JSON values returned from .convert() functions

Issue - State: closed - Opened by mhalle almost 2 years ago - 3 comments
Labels: enhancement, python-library

#494 - Document how to use Just

Issue - State: closed - Opened by simonw about 2 years ago - 2 comments
Labels: documentation

#493 - Tiny typographical error in install/uninstall docs

Issue - State: open - Opened by simonw about 2 years ago - 4 comments
Labels: bug, help wanted, documentation

#492 - Idea: ability to pass extra variables to `--convert` scripts

Issue - State: open - Opened by simonw about 2 years ago - 1 comment
Labels: research, cli-tool

#491 - Ability to merge databases and tables

Issue - State: open - Opened by sgraaf about 2 years ago - 7 comments
Labels: help wanted, cli-tool

#490 - Ability to insert multi-line files

Issue - State: closed - Opened by jeqo about 2 years ago - 4 comments
Labels: question

#489 - Ability to load JSON records held in a file with a single top level key that is a list of objects

Issue - State: open - Opened by simonw about 2 years ago - 9 comments
Labels: enhancement, cli-tool

#488 - `sqlite-utils transform` should set empty strings to null when converting text columns to integer/float

Issue - State: open - Opened by simonw about 2 years ago - 5 comments
Labels: bug, enhancement, python-library, cli-tool

#487 - Specify foreign key against compound key in other table

Issue - State: closed - Opened by ryanfox about 2 years ago - 2 comments

#486 - progressbar for inserts/upserts of all fileformats, closes #485

Pull Request - State: closed - Opened by MischaU8 about 2 years ago - 7 comments

#485 - Progressbar not shown when inserting/upserting jsonlines file

Issue - State: closed - Opened by MischaU8 about 2 years ago - 1 comment

#484 - Expose convert recipes to `sqlite-utils --functions`

Issue - State: open - Opened by simonw about 2 years ago - 11 comments
Labels: enhancement, cli-tool

#483 - `sqlite-utils install` command

Issue - State: closed - Opened by simonw about 2 years ago - 2 comments
Labels: enhancement, cli-tool

#482 - balanced table default column_order

Issue - State: closed - Opened by chapmanjacobd about 2 years ago - 1 comment

#481 - Idea: `sqlite-utils create-table tablename --sql "select ..."`

Issue - State: open - Opened by simonw about 2 years ago
Labels: enhancement, cli-tool

#480 - search_sql add include_rank option

Pull Request - State: closed - Opened by chapmanjacobd about 2 years ago - 4 comments

#479 - OperationalError: cannot VACUUM from within a transaction

Issue - State: open - Opened by chapmanjacobd about 2 years ago

#478 - `sqlite-utils tables data.db table1 table2`

Issue - State: open - Opened by simonw about 2 years ago - 1 comment
Labels: enhancement, cli-tool

#477 - Conda Forge

Issue - State: closed - Opened by thewchan about 2 years ago - 2 comments

#476 - Release notes for 3.29

Issue - State: closed - Opened by simonw about 2 years ago - 2 comments
Labels: documentation

#475 - table.default_values introspection property

Issue - State: closed - Opened by simonw about 2 years ago - 1 comment
Labels: enhancement, python-library

#474 - Add an option for specifying column names when inserting CSV data

Issue - State: open - Opened by hubgit about 2 years ago - 3 comments
Labels: enhancement, cli-tool

#473 - Support entrypoints for `--load-extension`

Pull Request - State: closed - Opened by simonw about 2 years ago - 1 comment
Labels: enhancement, cli-tool

#472 - Reuse the locals/globals fix from --functions for other code accepting options

Issue - State: closed - Opened by simonw about 2 years ago - 2 comments
Labels: enhancement, cli-tool

#471 - sqlite-utils query --functions mechanism for registering extra functions

Issue - State: closed - Opened by simonw about 2 years ago - 12 comments
Labels: enhancement, research, cli-tool

#470 - Upgrade `--load-extension` to accept entrypoints like Datasette

Issue - State: closed - Opened by simonw about 2 years ago - 6 comments
Labels: enhancement, cli-tool

#469 - sqlite-utils rows --order option

Issue - State: closed - Opened by simonw about 2 years ago - 1 comment
Labels: enhancement, cli-tool

#468 - db[table].create(..., transform=True) and create-table --transform

Pull Request - State: closed - Opened by simonw about 2 years ago - 6 comments
Labels: python-library

#467 - Mechanism for ensuring a table has all the columns

Issue - State: closed - Opened by simonw about 2 years ago - 13 comments
Labels: enhancement, python-library

#463 - Use Read the Docs action v1

Pull Request - State: closed - Opened by humitos about 2 years ago - 1 comment

#460 - Cross-link CLI to Python docs

Pull Request - State: closed - Opened by simonw about 2 years ago - 4 comments
Labels: documentation

#458 - Support custom names for registered functions

Issue - State: closed - Opened by simonw about 2 years ago - 1 comment
Labels: enhancement

#457 - Link to installation instructions

Pull Request - State: closed - Opened by simonw about 2 years ago - 2 comments

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

Pull Request - State: closed - Opened by fgregg about 2 years ago - 3 comments

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

Issue - State: closed - Opened by mungewell over 2 years ago - 5 comments
Labels: bug, help wanted

#433 - CLI eats my cursor

Issue - State: closed - Opened by chapmanjacobd over 2 years ago - 10 comments
Labels: bug, help wanted

#426 - CLI docs should link to Python docs and vice versa

Issue - State: closed - Opened by simonw over 2 years ago - 1 comment
Labels: documentation

#425 - `sqlite3.NotSupportedError`: deterministic=True requires SQLite 3.8.3 or higher

Issue - State: closed - Opened by simonw over 2 years ago - 5 comments
Labels: bug

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

Issue - State: closed - Opened by jlieth over 2 years ago - 1 comment
Labels: bug

#420 - Document how to use a `--convert` function that runs initialization code first

Issue - State: closed - Opened by strada over 2 years ago - 12 comments
Labels: documentation

#409 - `with db:` for transactions

Issue - State: open - Opened by simonw over 2 years ago - 3 comments
Labels: enhancement, python-library

#406 - Creating tables with custom datatypes

Issue - State: open - Opened by psychemedia over 2 years ago - 6 comments
Labels: enhancement

#402 - Advanced class-based `conversions=` mechanism

Issue - State: open - Opened by simonw over 2 years ago - 15 comments
Labels: enhancement, documentation, python-library, spatialite

#399 - Make it easier to insert geometries, with documentation and maybe code

Issue - State: open - Opened by simonw over 2 years ago - 25 comments
Labels: help wanted, documentation, python-library, spatialite

#388 - Link to stable docs from older versions

Issue - State: closed - Opened by simonw over 2 years ago - 7 comments
Labels: documentation

#358 - Support for CHECK constraints

Issue - State: open - Opened by luxint almost 3 years ago - 7 comments
Labels: enhancement

#344 - Support STRICT tables

Issue - State: closed - Opened by simonw almost 3 years ago - 14 comments
Labels: research

#336 - sqlite-util tranform --column-order mangles columns of type "timestamp"

Issue - State: closed - Opened by fgregg almost 3 years ago - 1 comment
Labels: bug

#327 - Extract expand: Support JSON Arrays

Pull Request - State: closed - Opened by phaer about 3 years ago

#297 - Option for importing CSV data using the SQLite .import mechanism

Issue - State: open - Opened by simonw about 3 years ago - 23 comments
Labels: enhancement, cli-tool

#265 - Using enable_fts before search term

Issue - State: open - Opened by prabhur over 3 years ago - 1 comment

#239 - sqlite-utils extract could handle nested objects

Issue - State: open - Opened by simonw over 3 years ago - 17 comments
Labels: enhancement, python-library, cli-tool

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

Issue - State: closed - Opened by kristomi over 3 years ago - 18 comments
Labels: bug

GitHub / simonw/sqlite-utils issues and pull requests