Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb?

• litebox

  2 5 0.0 Python

  Container for finding Python objects by attributes, using SQLite (by manimino)

Yep. I even wrote a container called LiteBox to make it quicker syntax-wise.

• sqlite-utils

  35 1,498 8.4 Python

  Python CLI utility and library for manipulating SQLite databases

https://sqlite-utils.datasette.io is the Python CLI tool and library I wrote to speed up this kind of work. Here's a recent tutorial I wrote about it: https://datasette.io/tutorials/clean-data

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• datasette

  187 8,934 9.3 Python

  An open source multi-tool for exploring and publishing data

https://datasette.io is my larger open source project around building tools for analyzing and publishing data with SQLite

Suggest a related project