Top 23 Python Sqlite Projects
a small, expressive orm -- supports postgresql, mysql and sqliteProject mention: Top python libraries/ frameworks that you suggest every one | reddit.com/r/Python | 2022-03-28
q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)Project mention: q VS trdsql - a user suggested alternative | libhunt.com/r/harelba/q | 2022-06-25
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
An open source multi-tool for exploring and publishing data
A terminal spreadsheet multitool for discovering and arranging data
Pony Object Relational MapperProject mention: This Week in Python | dev.to | 2022-05-20
pony – Pony Object Relational Mapper
Familiar asyncio ORM for python, built with relations in mindProject mention: Using Django ORM in asyncio project without Django? | reddit.com/r/django | 2022-06-06
Does anybody have any experience with that? Can I use Django in my asyncio application without *actually using Django? Or should sth like Tortoise ORM be preferred?
Async database support for Python. 🗄Project mention: Django 4.1 alpha 1 released | reddit.com/r/django | 2022-05-18
To take an example: I switched a service over from doing synchronous (plain def everywhere) to async (async def and await everywhere, with async DB, and saw… basically no performance improvement.
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
Expressive analytics in Python at any scale. (by ibis-project)Project mention: This Week in Python | dev.to | 2022-03-25
ibis – Python data analysis framework for Hadoop and SQL engines
CLI for SQLite Databases with auto-completion and syntax highlighting
Web-based SQLite database browser written in Python
Transparent persistent cache for python requestsProject mention: Web Scraping with Python: from Fundamentals to Practice | reddit.com/r/Python | 2022-06-23
For anyone who goes with requests as your HTTP client, I would highly recommend adding requests-cache for a nice performance boost.
Python CLI utility and library for manipulating SQLite databases
Persistent dict, backed by sqlite3 and pickle, multithread-safe.
A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)Project mention: Piccolo - a modern, async query builder / ORM for Postgres | reddit.com/r/PostgreSQL | 2022-01-08
Hi, I'm a big fan of Postgres, and have been working on Piccolo for the last few years.
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of useProject mention: Show HN: Prisma Python – A fully typed ORM for Python | news.ycombinator.com | 2022-02-21
Thanks for the suggestion, I've created an issue to track this as I do agree that `ANY` conveys the operation more clearly.
Convert CSV files into a SQLite databaseProject mention: Turning database into a searchable dashboard? | reddit.com/r/datascience | 2021-10-21
Oh what's that you say, your data is in CSV and you don't want to write code to load them up into a database, well try this https://github.com/simonw/csvs-to-sqlite
asyncio bridge to the standard sqlite3 moduleProject mention: Using GraphQL with Strawberry, FastAPI, and Next.js | dev.to | 2022-06-15
Aiosqlite — This provides async support for SQLite
Check out pytablewriter: https://github.com/thombashi/pytablewriter
Save data from Twitter to a SQLite databaseProject mention: Using Datasette for an ELT Personal Twitter Data Warehouse | dev.to | 2021-12-26
Keep in mind that all of this is automatically generated from a sqlite table (which itself was automatically generated by running twitter-to-sqlite), greatly reducing the bar for GUI-based, SQL-based EDA.
WarcDB: Web crawl data as SQLite databases.Project mention: GitHub - Florents-Tselai/WarcDB: WarcDB: Web crawl data as SQLite databases. | reddit.com/r/sqlite | 2022-06-23
Save data from GitHub to a SQLite database
Transparent and persistent cache/serialization powered by type hints
Python Sqlite related posts
Need a database that can hold 16 million records and export any 2000 non-sequential records to Excel within 10 seconds.
2 projects | reddit.com/r/Database | 25 Jun 2022
Sync Watch History/Stats between Users
2 projects | reddit.com/r/PleX | 24 Jun 2022
Show HN: Easily Convert WARC (Web Archive) into Parquet, Then Query with DuckDB
3 projects | news.ycombinator.com | 24 Jun 2022
Web Scraping with Python: from Fundamentals to Practice
1 project | reddit.com/r/Python | 23 Jun 2022
GitHub - Florents-Tselai/WarcDB: WarcDB: Web crawl data as SQLite databases.
1 project | reddit.com/r/sqlite | 23 Jun 2022
Best way to deploy an app developed with Python, Flask and SQLite
1 project | reddit.com/r/flask | 21 Jun 2022
Web crawl data as SQLite databases
1 project | reddit.com/r/programming | 20 Jun 2022
What are some of the best open-source Sqlite projects in Python? This list will help you:
Are you hiring? Post a new remote job listing for free.