Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression. Learn more →
Top 23 Python Database Projects
-
Sounds good, why not try making a simple vulnerability scanner for APIs too? Maybe something similar to SQLMap
-
edgedb
A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
>relational no-sql
Do you mean something like edgeDB?[0]
Or do you mean some non-declarative language completely? I don't see the latter making much sense. The issue with SQL for me is the "natural language" which quickly loses all intended readabilty when you have SELECT col1, col2 FROM (SELECT * FROM ... WHERE 1=0 AND ... which is what edgeDB is trying to solve.
-
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
-
-
Project mention: Does anyone prefer the CLI over the shell, or other way around? If so, why? | /r/mysql | 2023-04-23
Also, check out MyCLI. https://github.com/dbcli/mycli "Terminal Client for MySQL with AutoCompletion and Syntax Highlighting"
-
Project mention: I wrote this iCalendar (.ics) command-line utility to turn common calendar exports into more broadly compatible CSV files. | /r/commandline | 2023-03-24
CSV utilities (still haven't pick a favorite one...): https://github.com/harelba/q https://github.com/BurntSushi/xsv https://github.com/wireservice/csvkit https://github.com/johnkerl/miller
-
Here, we save app settings with Python tinydb and you can also use another simple database options. It is included because Python is used here.
-
dataset
Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
Project mention: What's the best process for scraping w/ the process of: Webpage -> List of Items -> Scrape Each Item Page | /r/webscraping | 2023-01-31I use the package 'dataset' (https://github.com/pudo/dataset), which lets you write a list of dictionaries as a database table. Easy peasy. :)
-
Sonar
Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
DB-GPT
Interact your data and environment using the local GPT, no data leaks, 100% privately, 100% security
Interact your data and environment using the local GPT (https://github.com/csunny/DB-GPT)
-
tencent-ml-images
Largest multi-label image database; ResNet-101 model; 80.73% top-1 acc on ImageNet
-
-
-
Use Ibis and you won't have to worry about migrating to a vendor-specific python framework anymore. It connects to Snowflake, Spark, and many other engines you may want to interact with.
-
Project mention: Trying to deploy a windows based Python & Flask web app | /r/flask | 2023-04-26
-
Project mention: Oops, I wrote yet another SQLAlchemy alternative (looking for contributors!) | /r/pythoncoding | 2023-05-08
First, let me introduce myself. My name is Erez. You may know some of the Python libraries I wrote in the past: Lark, Preql and Data-diff.
-
Flask-Migrate (https://github.com/miguelgrinberg/flask-migrate) is the package that will help us do our migrations
-
PyPika
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
-
Project mention: Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs | news.ycombinator.com | 2022-10-04
https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.
-
CloudFail
Utilize misconfigured DNS and old database records to find hidden IP's behind the CloudFlare network
-
-
codechecker
CodeChecker is an analyzer tooling, defect database and viewer extension for the Clang Static Analyzer and Clang Tidy
Project mention: A Python Script to connect to GitHub and Fetches Search Results | dev.to | 2023-02-10python3 new.py docker-php-extension-installer: https://github.com/mlocati/docker-php-extension-installer codechecker: https://github.com/Ericsson/codechecker SingleFileZ: https://github.com/gildas-lormeau/SingleFileZ china-dictatorship: https://github.com/cirosantilli/china-dictatorship vscode-docker: https://github.com/microsoft/vscode-docker flask-bones: https://github.com/cburmeister/flask-bones ProjectFib: https://github.com/anantdgoel/ProjectFib S3Mock: https://github.com/adobe/S3Mock home: https://github.com/gege-circle/home docker-php: https://github.com/chialab/docker-php dockbix-xxl: https://github.com/monitoringartist/dockbix-xxl wind-layer: https://github.com/sakitam-fdd/wind-layer powerstrip: https://github.com/ClusterHQ/powerstrip selenium-jupiter: https://github.com/bonigarcia/selenium-jupiter gnome-shell-extension-docker: https://github.com/gpouilloux/gnome-shell-extension-docker hacktoberfest-2022: https://github.com/docker/hacktoberfest-2022 azure-docker-extension: https://github.com/Azure/azure-docker-extension pgrocks-fdw: https://github.com/vidardb/pgrocks-fdw docker-php-yii2: https://github.com/dmstr/docker-php-yii2 docker-community-extensions: https://github.com/collabnix/docker-community-extensions alpine-php-fpm: https://github.com/joseluisq/alpine-php-fpm autoview-tradingview-chrome-docker-bot: https://github.com/IAMtheIAM/autoview-tradingview-chrome-docker-bot .config: https://github.com/zszszszsz/.config docker-phpfpm: https://github.com/adhocore/docker-phpfpm coc-docker: https://github.com/josa42/coc-docker china-dictatorhsip-6: https://github.com/cirosantilli/china-dictatorhsip-6 testcontainers-spock: https://github.com/testcontainers/testcontainers-spock Dockery: https://github.com/oslabs-beta/Dockery docker-extension: https://github.com/tailscale/docker-extension volumes-backup-extension: https://github.com/docker/volumes-backup-extension [email protected] chatgpt % vi new.py [email protected] chatgpt % python3 new.py .config: https://github.com/zszszszsz/.config Dockery: https://github.com/oslabs-beta/Dockery docker-extension: https://github.com/tailscale/docker-extension ransomware: https://github.com/abhir98/ransomware jfrog-docker-desktop-extension: https://github.com/jfrog/jfrog-docker-desktop-extension dd-extension-lgtm: https://github.com/cedricziel/dd-extension-lgtm openshift-dd-ext: https://github.com/redhat-developer/openshift-dd-ext k9s-dd-extension: https://github.com/spurin/k9s-dd-extension pgadmin4-docker-extension: https://github.com/marcelo-ochoa/pgadmin4-docker-extension trivy-docker-extension: https://github.com/aquasecurity/trivy-docker-extension drone-ci-docker-extension: https://github.com/harness/drone-ci-docker-extension docker-extension: https://github.com/loopDelicious/docker-extension swagger-editor-docker-extension: https://github.com/n-murphy/swagger-editor-docker-extension wasm-docker-extension: https://github.com/cmrigney/wasm-docker-extension microcks-docker-desktop-extension: https://github.com/microcks/microcks-docker-desktop-extension docker-extension-golang-playground: https://github.com/rumpl/docker-extension-golang-playground diveintoansible-extension: https://github.com/spurin/diveintoansible-extension docker-desktop-extension: https://github.com/okteto/docker-desktop-extension docker-extension-rabbitmq: https://github.com/Yogendra0Sharma/docker-extension-rabbitmq docker-storj-extension: https://github.com/elek/docker-storj-extension github-registry-docker-desktop-extension: https://github.com/peacecwz/github-registry-docker-desktop-extension docker-desktop-extension-issues: https://github.com/mutagen-io/docker-desktop-extension-issues sdw-docker-extension: https://github.com/marcelo-ochoa/sdw-docker-extension vcluster-dd-extension: https://github.com/loft-sh/vcluster-dd-extension extension-docker-desktop: https://github.com/epinio/extension-docker-desktop asyncapi-studio-docker-extension: https://github.com/thiyagu06/asyncapi-studio-docker-extension gefyra-docker-desktop-extension: https://github.com/gefyrahq/gefyra-docker-desktop-extension oraclexe-docker-extension: https://github.com/marcelo-ochoa/oraclexe-docker-extension docker-extensions-101: https://github.com/collabnix/docker-extensions-101 step-ca-docker-extension: https://github.com/hslatman/step-ca-docker-extension
-
baserow
Baserow is an open source no-code database tool and Airtable alternative. This is a mirrored repository, the official one is hosted on https://gitlab.com/bramw/baserow.
Project mention: I want to create sheets that work like Airtable (www.airtable.com) and use it in my django application any suggestions on how it can be done. | /r/django | 2023-06-03And their code is open source: Link
-
pgadmin4
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
Project mention: Is it worth learning sql on windows or should I try to get linux? | /r/SQL | 2023-05-05No need to use Linux to learn SQL. Download Postgres + Pgadmin on Windows - there is no difference with Linux or Macos, except for the file structure. Pgadmin is the GUI to handle the database, which is essentially a web service, and the GUI you see is nothing but a browser.
-
Project mention: Im writing a telegram bot that simulates the Uber apps. I would have to store the orders that receives so I can fulfill them. What’s the best way to store them so I can process them? | /r/TelegramBots | 2023-04-16
If you write in Python, I recommend using the Orator-ORM library, a very handy thing for quickly and safely working with MySQL.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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 2023-06-04.
Python Database related posts
- "How Chronic Illness Patients Are ‘Hacking’ Their Wearables" (HRV)
- Vektor: a mini vector database implementation that intends to be educational and interpretable
- Vektor: A mini vector database implementation that intends to be educational and interpretable
- Last FM is getting to the point where it's not worth the trouble anymore
- How does Last.fm determine an album? billy woods & Kenny Segal - Maps
- GitHub - csunny/DB-GPT: Interact your data and environment using the local GPT, no data leaks, 100% privately, 100% security
- DB-GPT - OSS to interact with your local LLM
-
A note from our sponsor - InfluxDB
www.influxdata.com | 10 Jun 2023
Index
What are some of the best open-source Database projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | SQLMap | 27,234 |
| 2 | edgedb | 11,153 |
| 3 | pgcli | 11,101 |
| 4 | mycli | 10,920 |
| 5 | q | 9,876 |
| 6 | TinyDB | 5,901 |
| 7 | dataset | 4,550 |
| 8 | DB-GPT | 3,551 |
| 9 | tencent-ml-images | 3,017 |
| 10 | arctic | 2,977 |
| 11 | flask-base | 2,887 |
| 12 | ibis | 2,774 |
| 13 | pyodbc | 2,677 |
| 14 | data-diff | 2,351 |
| 15 | Flask-Migrate | 2,205 |
| 16 | PyPika | 2,030 |
| 17 | sandman2 | 1,947 |
| 18 | CloudFail | 1,886 |
| 19 | sqlite-web | 1,855 |
| 20 | codechecker | 1,835 |
| 21 | baserow | 1,567 |
| 22 | pgadmin4 | 1,428 |
| 23 | Orator | 1,399 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com