mirror of
https://github.com/simonw/sqlite-utils.git
synced 2026-07-26 10:54:32 +02:00
1d584f0c60Documents all breaking changes in 4.0 for both the Python library and CLI: - db["name"] only returns tables, not views - Default float type changed to REAL - convert() no longer skips False values - Table schemas use double quotes - Upsert uses modern SQLite syntax - Type detection now default for CSV/TSV import - sqlite-utils tui moved to plugin - Python 3.10+ required
44 lines
1.7 KiB
ReStructuredText
44 lines
1.7 KiB
ReStructuredText
=======================
|
|
sqlite-utils |version|
|
|
=======================
|
|
|
|
|PyPI| |Changelog| |CI| |License| |discord|
|
|
|
|
.. |PyPI| image:: https://img.shields.io/pypi/v/sqlite-utils.svg
|
|
:target: https://pypi.org/project/sqlite-utils/
|
|
.. |Changelog| image:: https://img.shields.io/github/v/release/simonw/sqlite-utils?include_prereleases&label=changelog
|
|
:target: https://sqlite-utils.datasette.io/en/stable/changelog.html
|
|
.. |CI| image:: https://github.com/simonw/sqlite-utils/workflows/Test/badge.svg
|
|
:target: https://github.com/simonw/sqlite-utils/actions
|
|
.. |License| image:: https://img.shields.io/badge/license-Apache%202.0-blue.svg
|
|
:target: https://github.com/simonw/sqlite-utils/blob/main/LICENSE
|
|
.. |discord| image:: https://img.shields.io/discord/823971286308356157?label=discord
|
|
:target: https://discord.gg/Ass7bCAMDw
|
|
|
|
*CLI tool and Python library for manipulating SQLite databases*
|
|
|
|
This library and command-line utility helps create SQLite databases from an existing collection of data.
|
|
|
|
Most of the functionality is available as either a Python API or through the ``sqlite-utils`` command-line tool.
|
|
|
|
sqlite-utils is not intended to be a full ORM: the focus is utility helpers to make creating the initial database and populating it with data as productive as possible.
|
|
|
|
It is designed as a useful complement to `Datasette <https://datasette.io/>`_.
|
|
|
|
`Cleaning data with sqlite-utils and Datasette <https://datasette.io/tutorials/clean-data>`_ provides a tutorial introduction (and accompanying ten minute video) about using this tool.
|
|
|
|
Contents
|
|
--------
|
|
|
|
.. toctree::
|
|
:maxdepth: 3
|
|
|
|
installation
|
|
cli
|
|
python-api
|
|
plugins
|
|
reference
|
|
cli-reference
|
|
contributing
|
|
changelog
|
|
upgrading
|