Python Sqlite

Open-source Python projects categorized as Sqlite Edit details
Related topics: #Python #Database #datasette-io #datasette #datasette-tool

Top 23 Python Sqlite Projects

  • Peewee

    a small, expressive orm -- supports postgresql, mysql and sqlite

    Project mention: Top python libraries/ frameworks that you suggest every one | reddit.com/r/Python | 2022-03-28

    peewee

  • q

    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

  • SonarQube

    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.

  • datasette

    An open source multi-tool for exploring and publishing data

    Project mention: Need a database that can hold 16 million records and export any 2000 non-sequential records to Excel within 10 seconds. | reddit.com/r/Database | 2022-06-25

  • visidata

    A terminal spreadsheet multitool for discovering and arranging data

    Project mention: Xlite: Query Excel, Open Document spreadsheets (.ods) as SQLite virtual tables | news.ycombinator.com | 2022-06-25

    Sweet. Here’s my open issue with VisiData about this: https://github.com/saulpw/visidata/issues/1398

    There’s a sample file at the end of that thread.

  • PonyORM

    Pony Object Relational Mapper

    Project mention: This Week in Python | dev.to | 2022-05-20

    pony – Pony Object Relational Mapper

  • tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    Project 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?

  • databases

    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.

  • Scout APM

    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.

  • ibis

    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

  • litecli

    CLI for SQLite Databases with auto-completion and syntax highlighting

  • sqlite-web

    Web-based SQLite database browser written in Python

  • requests-cache

    Transparent persistent cache for python requests

    Project 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.

  • sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    Project mention: Need a database that can hold 16 million records and export any 2000 non-sequential records to Excel within 10 seconds. | reddit.com/r/Database | 2022-06-25

  • python-diskcache

    Persistent dict, backed by sqlite3 and pickle, multithread-safe.

  • piccolo

    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-py

    Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use

    Project 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.

    https://github.com/RobertCraigie/prisma-client-py/issues/293

  • csvs-to-sqlite

    Convert CSV files into a SQLite database

    Project 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

  • aiosqlite

    asyncio bridge to the standard sqlite3 module

    Project mention: Using GraphQL with Strawberry, FastAPI, and Next.js | dev.to | 2022-06-15

    Aiosqlite — This provides async support for SQLite

  • pytablewriter

    pytablewriter is a Python library to write a table in various formats: AsciiDoc / CSV / Elasticsearch / HTML / JavaScript / JSON / LaTeX / LDJSON / LTSV / Markdown / MediaWiki / NumPy / Excel / Pandas / Python / reStructuredText / SQLite / TOML / TSV.

    Project mention: Github style table | reddit.com/r/learnpython | 2022-02-19

    Check out pytablewriter: https://github.com/thombashi/pytablewriter

  • twitter-to-sqlite

    Save data from Twitter to a SQLite database

    Project 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

    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

  • choochoo

    Training Diary

  • github-to-sqlite

    Save data from GitHub to a SQLite database

    Project mention: Store SQLite in Cloudflare Durable Objects | news.ycombinator.com | 2022-01-25

    My application Datasette can serve this need: https://datasette.io/

    Lots of live demos - two of my favourites are https://github-to-sqlite.dogsheep.net/ and https://global-power-plants.datasettes.com/

  • cachew

    Transparent and persistent cache/serialization powered by type hints

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2022-06-25.

Python Sqlite related posts

Index

What are some of the best open-source Sqlite projects in Python? This list will help you:

Project Stars
1 Peewee 9,243
2 q 9,122
3 datasette 6,241
4 visidata 5,602
5 PonyORM 2,950
6 tortoise-orm 2,933
7 databases 2,920
8 ibis 1,857
9 litecli 1,638
10 sqlite-web 1,534
11 requests-cache 964
12 sqlite-utils 915
13 python-diskcache 846
14 piccolo 778
15 prisma-client-py 697
16 csvs-to-sqlite 695
17 aiosqlite 660
18 pytablewriter 494
19 twitter-to-sqlite 321
20 WarcDB 308
21 choochoo 210
22 github-to-sqlite 201
23 cachew 181
Find remote jobs at our new job board 99remotejobs.com. There are 3 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.

Sponsored
Developer Ecosystem Survey 2022
Take part in the Developer Ecosystem Survey 2022 by JetBrains and get a chance to win a Macbook, a Nvidia graphics card, or other prizes. We’ll create an infographic full of stats, and you’ll get personalized results so you can compare yourself with other developers.
surveys.jetbrains.com