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
Automatic SQL injection and database takeover toolProject mention: Are these good projects to have? (appsec) | /r/cybersecurity | 2023-06-04
Sounds good, why not try making a simple vulnerability scanner for APIs too? Maybe something similar to SQLMap
A graph-relational database with declarative schema, built-in migration system, and a next-generation query languageProject mention: DuckDB 0.8.0 | news.ycombinator.com | 2023-05-17
Do you mean something like edgeDB?
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.
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.
Postgres CLI with autocompletion and syntax highlighting
A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.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"
q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)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
TinyDB is a lightweight document oriented database optimized for your happiness :)Project mention: How to make a GUI translator app with Python Tkinter | dev.to | 2023-02-16
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.
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-31
I use the package 'dataset' (https://github.com/pudo/dataset), which lets you write a list of dictionaries as a database table. Easy peasy. :)
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.
Interact your data and environment using the local GPT, no data leaks, 100% privately, 100% securityProject mention: (2/2) May 2023 | /r/dailyainews | 2023-06-02
Interact your data and environment using the local GPT (https://github.com/csunny/DB-GPT)
Largest multi-label image database; ResNet-101 model; 80.73% top-1 acc on ImageNet
High performance datastore for time series and tick dataProject mention: arctic: NEW Data - star count:2864.0 | /r/algoprojects | 2023-01-14
A simple Flask boilerplate app with SQLAlchemy, Redis, User Authentication, and more.
The flexibility of Python with the scale and performance of modern SQL.Project mention: Thoughts About Snowpark? | /r/dataengineering | 2023-05-16
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.
Python ODBC bridgeProject mention: Trying to deploy a windows based Python & Flask web app | /r/flask | 2023-04-26
Compare tables within or across databasesProject 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.
SQLAlchemy database migrations for Flask applications using AlembicProject mention: flask + postgres + sqlalchemy migrations dockerized intro | dev.to | 2022-08-31
Flask-Migrate (https://github.com/miguelgrinberg/flask-migrate) is the package that will help us do our migrations
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.
Automatically generate a RESTful API service for your legacy database. No code required!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.
Utilize misconfigured DNS and old database records to find hidden IP's behind the CloudFlare network
Web-based SQLite database browser written in PythonProject mention: WAL Mode in LiteFS | news.ycombinator.com | 2023-01-04
CodeChecker is an analyzer tooling, defect database and viewer extension for the Clang Static Analyzer and Clang TidyProject mention: A Python Script to connect to GitHub and Fetches Search Results | dev.to | 2023-02-10
python3 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 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-03
And their code is open source: Link
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-05
No 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.
The Orator ORM provides a simple yet beautiful ActiveRecord implementation.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 - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python Database related posts
"How Chronic Illness Patients Are ‘Hacking’ Their Wearables" (HRV)
1 project | /r/QuantifiedSelf | 9 Jun 2023
Vektor: a mini vector database implementation that intends to be educational and interpretable
1 project | /r/LargeLanguageModels | 7 Jun 2023
Vektor: A mini vector database implementation that intends to be educational and interpretable
1 project | /r/vectordatabase | 7 Jun 2023
Last FM is getting to the point where it's not worth the trouble anymore
1 project | /r/lastfm | 5 Jun 2023
How does Last.fm determine an album? billy woods & Kenny Segal - Maps
1 project | /r/lastfm | 24 May 2023
GitHub - csunny/DB-GPT: Interact your data and environment using the local GPT, no data leaks, 100% privately, 100% security
1 project | /r/codegen | 23 May 2023
DB-GPT - OSS to interact with your local LLM
1 project | /r/programming | 23 May 2023
A note from our sponsor - InfluxDB
www.influxdata.com | 10 Jun 2023
What are some of the best open-source Database projects in Python? This list will help you: