This release is a pre-release and may not be stable for production use.
sqlite-utils-sqlite-dateutil
sqlite-utils plugin that loads the sqlite-dateutil SQLite extension. sqlite-dateutil is a C port of python-dateutil's parser.parse(), about 38x faster than calling dateutil from Python.
Installation
sqlite-utils install sqlite-utils-sqlite-dateutil
Usage
Once installed, the functions are available to sqlite-utils query and sqlite-utils memory:
sqlite-utils memory "select dateutil_parse_fuzzy('Today is January 1, 2047 at 8:21:00AM') as d"
# [{"d": "2047-01-01T08:21:00"}]
They are also available to Python code that uses sqlite_utils.Database().
Each function returns an ISO 8601 string, or NULL where dateutil would raise an exception:
| SQL function | Python equivalent |
|---|---|
dateutil_parse(text) |
parse(text).isoformat() |
dateutil_parse_fuzzy(text) |
parse(text, fuzzy=True).isoformat() |
dateutil_parse_dayfirst(text) |
parse(text, dayfirst=True).isoformat() |
dateutil_parse_fuzzy_dayfirst(text) |
parse(text, fuzzy=True, dayfirst=True).isoformat() |
See the sqlite-dateutil documentation for details and the known differences from dateutil.
1 maintainer
Metadata
1 maintainer
Release files for sqlite-utils-sqlite-dateutil 0.1a0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| sqlite_utils_sqlite_dateutil-0.1a0-py3-none-any.whl | Python 3 | none | any | Details for sqlite_utils_sqlite_dateutil-0.1a0-py3-none-any.whl |
Release files / sqlite_utils_sqlite_dateutil-0.1a0-py3-none-any.whl
| Download URL | sqlite_utils_sqlite_dateutil-0.1a0-py3-none-any.whl |
|---|---|
| Size | 2.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
f960bf64787f8c2c46d11a9d9dba4b8aaa81e8c68d042a7646ef92136bf6d874
|
|
BLAKE2b-256 checksum How to use checksums |
635376e766daa31a7eda308a3d6f165d5e4821baa9044b927b5d5c0fc0c17a33
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.13.0 {"installer":{"name":"uv","version":"0.13.0","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Security for sqlite-utils-sqlite-dateutil 0.1a0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
