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. Learn more →
Top 23 Python SQL Projects
Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elastic, Network, Virtualization. DevOps Interview QuestionsProject mention: Kubernetes Labs for learning | reddit.com/r/kubernetes | 2022-11-27
q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)Project mention: sqly - execute SQL against CSV / JSON with shell | reddit.com/r/SQL | 2022-11-10
Apparently, there were many who thought the same thing; Tools to execute SQL against CSV were trdsql, q, csvq, TextQL. They were highly functional, hoewver, had many options and no input completion. I found it just a little difficult to use.
Close all those tabs. Zigi will handle your updates.. Zigi monitors Jira and GitHub updates, pings you when PRs need approval and lets you take fast actions - all directly from Slack! Plus it reduces cycle time by up to 75%.
SQL databases in Python, designed for simplicity, compatibility, and robustness.Project mention: Best ORM to use with FastAPI? | reddit.com/r/Python | 2022-05-21
I have not used it myself but the creator of fastapi has made https://github.com/tiangolo/sqlmodel
Modin: Scale your Pandas workflows by changing a single line of codeProject mention: Working with more than 10gb csv | reddit.com/r/datascience | 2022-10-05
Modin should fit. It implements Pandas APIs with e.g. Ray as backend. https://github.com/modin-project/modin
An open source multi-tool for exploring and publishing dataProject mention: Sunday Daily Thread: What's everyone working on this week? | reddit.com/r/Python | 2022-11-20
Specifically the new chapter on SQLite (and also Datasette.)
The Database Toolkit for PythonProject mention: Snowflake and SQLAlchemy tutorial: From installation to example queries | dev.to | 2022-11-23
SQLAlchemy is one of the most popular libraries to interface with relational databases in Python. Its distinguishing feature is the object-relational mapper (ORM), which allows software engineers to develop classes and automatically map them to a database.
Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
Truly a developer’s best friend. Scout APM is great for developers who want to find and fix performance issues in their applications. With Scout, we'll take care of the bugs so you can focus on building great things 🚀.
Simple and rapid application development framework, built on top of Flask. includes detailed security, auto CRUD generation for your models, google charts and much more. Demo (login with guest/welcome) - http://flaskappbuilder.pythonanywhere.com/Project mention: ROLE BASED AUTHENTICATION IN FLASK | reddit.com/r/flask | 2022-02-23
There's the Flask-Security extension for example. Or the Flask-Appbuilder framework, which does a whole lot more.
Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQProject mention: data engineering in web3 | reddit.com/r/dataengineering | 2022-05-20
I'm surprised this is the only good response in this thread so far. Blockchain data is completely open but requires some organization in order to perform analytics. Nansen for example is a product that is built on top of ethereum-etl which you can checkout here
Expressive analytics in Python at any scale.
Easily share data across your company via SQL queries. From Grove Collab.Project mention: Saving Filtered Querysets for Future Access | reddit.com/r/django | 2022-10-04
pg_activity is a top like application for PostgreSQL server activity monitoring.Project mention: pg_activity | reddit.com/r/devopspro | 2022-11-08
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.
Python SQL Parser and TranspilerProject mention: MySQL-mimic - Python implementation of the MySQL server wire protocol. | reddit.com/r/Python | 2022-10-31
\Note - mysql-mimic is just the wire protocol. We use* sqlglot to parse/optimize SQL.
Django and MongoDB database connectorProject mention: Where can I find the ORM documentation for Djongo (mongodb library for django)? | reddit.com/r/django | 2022-03-06
A database migrations tool for SQLAlchemy.Project mention: Understanding a Data Model | dev.to | 2022-07-20
SQLAlchemy ORM should support comments if you're using it to create database objects.
Light-weight Python OLAP framework for multi-dimensional data analysis
Jet Admin – No-code Business App builderProject mention: Show HN: No-code alternative to Retool, Appsmith, Internal, etc. | news.ycombinator.com | 2022-02-14
My bad, just got caught up in pondering about the second part. You can choose from 3 deployment options: cloud, on-premise, and hybrid. The first and the last are pretty self-explanatory and in hybrid you can host the open-source backend part(https://github.com/jet-admin/jet-bridge) on your servers and we host the interface
Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb (to which we are not affiliated in any way) movie database about movies, people, characters and companiesProject mention: [OC]IMDB Top 30 movies: cast death rate | reddit.com/r/dataisbeautiful | 2022-01-17
A unified interface for distributed computing. Fugue executes SQL, Python, and Pandas code on Spark, Dask and Ray without any rewrites.Project mention: [P] Open data transformations in Python, no SQL required | reddit.com/r/MachineLearning | 2022-03-01
This looks similar to fugue, am I right? How do they compare?
Entity Relation Diagrams generation toolProject mention: Tools that help to explore and navigate database tables | reddit.com/r/dataengineering | 2022-11-21
sometging like this, maybe https://github.com/Alexis-benoist/eralchemy
Python library for using dplyr like syntax with pandas and SQLProject mention: Method Chaining in Pandas: Bad Form or a Recipe for Success? | news.ycombinator.com | 2022-11-02
A dynamic FastAPI router that automatically creates CRUD routes for your modelsProject mention: why when I search for Python jobs I find alot! but when I search for Django (the most used Python framework ) I get few compared to spring or nodejs ? | reddit.com/r/Python | 2022-08-21
FastAPI does have an equivalent. Something like this? https://github.com/awtkns/fastapi-crudrouter
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Data Platform where developers build real-time applications for analytics, IoT and cloud-native services in less time with less code.
Python SQL related posts
Implementing the Repository pattern in Python using SqlAlchemy as a backend
1 project | dev.to | 16 Nov 2022
How do I showcase my SQL skills?
2 projects | reddit.com/r/SQL | 15 Nov 2022
ETL question (noob)
1 project | reddit.com/r/dataengineering | 14 Nov 2022
1 project | reddit.com/r/devopspro | 8 Nov 2022
Command-line data analytics made easy with SPyQL
5 projects | dev.to | 6 Nov 2022
This Week In Python
5 projects | dev.to | 4 Nov 2022
Method Chaining in Pandas: Bad Form or a Recipe for Success?
1 project | news.ycombinator.com | 2 Nov 2022
A note from our sponsor - Sonar
www.sonarsource.com | 29 Nov 2022
What are some of the best open-source SQL projects in Python? This list will help you: