This release is a pre-release and may not be stable for production use.
datasette-sqlite-dateutil
Datasette 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
datasette install datasette-sqlite-dateutil
Usage
Once installed, the functions are available in every SQL query, for example:
select dateutil_parse('Thu, 25 Sep 2003 10:49:41 -0300');
-- 2003-09-25T10:49:41-03:00
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 datasette-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 |
|---|---|---|---|---|
| datasette_sqlite_dateutil-0.1a0-py3-none-any.whl | Python 3 | none | any | Details for datasette_sqlite_dateutil-0.1a0-py3-none-any.whl |
Release files / datasette_sqlite_dateutil-0.1a0-py3-none-any.whl
| Download URL | datasette_sqlite_dateutil-0.1a0-py3-none-any.whl |
|---|---|
| Size | 2.1 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
6f59aa9a932f2668fb62a4559313bf23ad990b1b99c7e7b4e897c1727ab0b0d0
|
|
BLAKE2b-256 checksum How to use checksums |
2e6a8d19a0da6b1d47198e8ac591f543eb4a32d856f95b0aec25691385af13fd
|
| 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 datasette-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.
