Python Query

Open-source Python projects categorized as Query Edit details
Related topics: #Python #Python3 #Database #SQL #Data

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 | | 2021-08-27

    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.

  • Preql

    An interpreted relational query language that compiles to SQL.

    Project mention: Even Babies fear … Fu**ing SQL | | 2022-06-23

    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.

  • jello

    CLI tool to filter JSON and JSON Lines data with Python syntax. (Similar to jq)

    Project mention: An introduction to the magic of jq - Understanding the basics of jq with a realistic example | | 2022-06-01

    I'm no expert in any of these tools, but here are some yamlpath and jello examples to match:

  • query-exporter

    Export Prometheus metrics from SQL queries

    Project mention: Monitoring data from query using prometheus? | | 2022-02-10

    Isn't this an exporter which is able to do what you want?

  • 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 | | 2022-02-01

    I'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

  • terminusdb-client-python

    TerminusDB Python Client

  • fquery

    A graph query engine (by adsharma)

    Project mention: Solving the double (quintuple) declaration Problem in GraphQL Applications | | 2021-08-14

    Similar benefits without codegen (based on decorator magic) for a python based stack:

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

  • system-intelligence

    Query your system for all hardware and software related information.

  • 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? | | 2022-05-23

    I also recommend ISRT for RCON administration and monitoring.

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

Python Query related posts


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
Find remote jobs at our new job board There are 4 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.