Top 9 Python Query Projects
-
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: Write an SQL query builder in 150 lines of Python | news.ycombinator.com | 2021-08-27https://github.com/kayak/pypika
Have used in multiple projects and have found it's the right balance between ORMs and writing raw SQL. It's also easily extensible and takes care of the many edge cases and nuances of rolling your own SQL generator.
-
But what about PreQL?
-
JetBrains
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.
-
Project mention: An introduction to the magic of jq - Understanding the basics of jq with a realistic example | reddit.com/r/commandline | 2022-06-01
I'm no expert in any of these tools, but here are some yamlpath and jello examples to match:
-
Project mention: Monitoring data from query using prometheus? | reddit.com/r/PrometheusMonitoring | 2022-02-10
Isn't this an exporter which is able to do what you want? https://github.com/albertodonato/query-exporter
-
DiscordGSM
📺 Monitor your game servers on Discord and tracks the live data of your game servers. Also support one-click deployment to Heroku, self-hosted.
Project mention: Deploying DiscordGSM App to Heroku: Error R10 (Boot timeout) -> Web process failed to bind to $PORT within 60 seconds of launch | reddit.com/r/Heroku | 2022-02-01I'm trying to use DiscordGSM and deployed it on Heroku. So far so good, the script works but always shuts down with the above error message. You can find the Heroku app.js here. Does anyone know what modification i would have to do in order for it to work? Here is the Heroku log
-
-
Project mention: Solving the double (quintuple) declaration Problem in GraphQL Applications | news.ycombinator.com | 2021-08-14
Similar benefits without codegen (based on decorator magic) for a python based stack:
https://github.com/adsharma/fquery
* Use dataclasses for both database schema and the user facing operations
-
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.
-
-
ISRT
ISRT is a python 3.9/PyQt5/SQLite3-based RCON and Query Tool for Insurgency Sandstorm Server Administrators.
Project mention: How do I port forward my server successfully? | reddit.com/r/insurgency | 2022-05-23I also recommend ISRT for RCON administration and monitoring.
Python Query related posts
- Even Babies fear … Fu**ing SQL
- Show HN: PRQL – A Proposal for a Better SQL
- Made a Programing language using python
- A primer on programming languages for data science
- Ask HN: SQL tooling: REPL-likes, Intellisense, etc.
- Preql: A relational language that compiles to SQL
- Preql: A relational language that compiles to SQL
Index
What are some of the best open-source Query projects in Python? This list will help you:
Project | Stars | |
---|---|---|
1 | PyPika | 1,676 |
2 | Preql | 527 |
3 | jello | 297 |
4 | query-exporter | 294 |
5 | DiscordGSM | 142 |
6 | terminusdb-client-python | 62 |
7 | fquery | 9 |
8 | system-intelligence | 6 |
9 | ISRT | 3 |
Are you hiring? Post a new remote job listing for free.