Port details on branch 2022Q2 |
- py-sqlite-utils Python CLI utility and library for manipulating SQLite databases
- 3.28_1 databases =0 3.28Version of this port present on the latest quarterly branch.
- Maintainer: loader@FreeBSD.org
- Port Added: 2022-07-26 10:54:06
- Last Update: 2024-04-13 14:47:51
- Commit Hash: 84a372a
- Also Listed In: python
- License: APACHE20
- WWW:
- https://github.com/simonw/sqlite-utils
- Description:
- Python CLI utility and library for manipulating SQLite databases.
Some feature highlights
* Pipe JSON (or CSV or TSV) directly into a new SQLite database
file, automatically creating a table with the appropriate schema
* Run in-memory SQL queries, including joins, directly against data
in CSV, TSV or JSON files and view the results
* Configure SQLite full-text search against your database tables
and run search queries against them, ordered by relevance
* Run transformations against your tables to make schema changes
that SQLite ALTER TABLE does not directly support, such as
changing the type of a column
* Extract columns into separate tables to better normalize your
existing data
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - There is no configure plist information for this port.
- Dependency lines:
-
- ${PYTHON_PKGNAMEPREFIX}sqlite-utils>0:databases/py-sqlite-utils@${PY_FLAVOR}
- To install the port:
- cd /usr/ports/databases/py-sqlite-utils/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/py-sqlite-utils
- pkg install py39-sqlite-utils
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py39-sqlite-utils listed in the above command, you can pick from the names under the Packages section.- PKGNAME: py39-sqlite-utils
- Package flavors (<flavor>: <package>)
- distinfo:
- TIMESTAMP = 1658735281
SHA256 (sqlite-utils-3.28.tar.gz) = 790b01f4be16c32756b9b5eae07b6b7c905b6613ca538d646877c50b05b0a53a
SIZE (sqlite-utils-3.28.tar.gz) = 188238
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- Test dependencies:
-
- py39-hypothesis>0 : devel/py-hypothesis@py39
- py39-pytest>=7,1 : devel/py-pytest@py39
- python3.9 : lang/python39
- Runtime dependencies:
-
- py39-sqlite-fts4>0 : databases/py-sqlite-fts4@py39
- py39-click>0 : devel/py-click@py39
- py39-click-default-group>0 : devel/py-click-default-group@py39
- py39-tabulate>0 : devel/py-tabulate@py39
- py39-python-dateutil>0 : devel/py-python-dateutil@py39
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- databases_py-sqlite-utils
- USES:
- python
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|