Skip to main content

sqlite3_hat is a small, pure Python wrapper to improve the sqlite3 module from the standard library.

sqlite3_hat adds (or changes):

  • Nested transaction support, using SQLite savepoints

  • Autocommit is on (see why autocommit)

  • Foreign key enforcement is on

  • Non-standard double-quoted string syntax is disabled by default

  • Convenient way to open a database read-only

  • Parameters can be supplied in t-strings, or as *args rather than tuples

  • Shortcut .queryone() method for getting a single row

The API is very similar to sqlite3, but it’s not a complete drop-in replacement.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlite3_hat-0.1.tar.gz (11.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sqlite3_hat-0.1-py3-none-any.whl (11.7 kB view details)

Uploaded Python 3

File details

Details for the file sqlite3_hat-0.1.tar.gz.

File metadata

  • Download URL: sqlite3_hat-0.1.tar.gz
  • Upload date:
  • Size: 11.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: python-requests/2.33.1

File hashes

Hashes for sqlite3_hat-0.1.tar.gz
Algorithm Hash digest
SHA256 5da2ce6f53d8baeea7f33f153050e719f7edadb6165d3054dcd4133a07297053
MD5 cd4fc8a3a745c7112c64dd3bba931443
BLAKE2b-256 506de2d1ece3832f6e0238bb4212cbb5297ab2f1882ebdff3c2419e624de1b18

See more details on using hashes here.

File details

Details for the file sqlite3_hat-0.1-py3-none-any.whl.

File metadata

  • Download URL: sqlite3_hat-0.1-py3-none-any.whl
  • Upload date:
  • Size: 11.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: python-requests/2.33.1

File hashes

Hashes for sqlite3_hat-0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 048236e8f2fb1759dff5c5ba42d4b8232bcd6c16b59e88660eba0b9f1e03d740
MD5 cee91a81968e772e242f772ff13c5763
BLAKE2b-256 7f863fd77074ed62a42a42d07ad27453b52e28cf00cdca5016761fc90bbe9dd0

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

0.1 This release

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page