Show HN: Sqlbind a Python library to compose raw SQL

1. sqlbind

   1 5 119 6.9 Python

   Lightweight text-based SQL parameter binds

   

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. django-query-profiler

   2 3 140 0.0 Python

   Django query profiler - one profiler to rule them all. Shows queries, detects N+1 and gives recommendations on how to resolve them

   

   But that's still not backend-specific SQL?

   There should be an interface method for this. Why does psycopg call it mogrify?

   https://django-debug-toolbar.readthedocs.io/en/latest/panels... :

   > debug_toolbar.panels.sql.SQLPanel: SQL queries including time to execute and links to EXPLAIN each query

   But debug toolbars mostly don't work with APIs.

   https://github.com/django-query-profiler/django-query-profil... :

   > Django query profiler - one profiler to rule them all. Shows queries, detects N+1 and gives recommendations on how to resolve them

   https://github.com/jazzband/django-silk :

   > Silk is a live profiling and inspection tool for the Django framework. Silk intercepts and stores HTTP requests and database queries before presenting them in a user interface for further inspection

4. django-query-profil

   3 2 - -

   But that's still not backend-specific SQL?

   There should be an interface method for this. Why does psycopg call it mogrify?

   https://django-debug-toolbar.readthedocs.io/en/latest/panels... :

   > debug_toolbar.panels.sql.SQLPanel: SQL queries including time to execute and links to EXPLAIN each query

   But debug toolbars mostly don't work with APIs.

   https://github.com/django-query-profiler/django-query-profil... :

   > Django query profiler - one profiler to rule them all. Shows queries, detects N+1 and gives recommendations on how to resolve them

   https://github.com/jazzband/django-silk :

   > Silk is a live profiling and inspection tool for the Django framework. Silk intercepts and stores HTTP requests and database queries before presenting them in a user interface for further inspection

5. django-silk

   4 16 4,621 7.9 Python

   Silky smooth profiling for Django

   

   But that's still not backend-specific SQL?

   There should be an interface method for this. Why does psycopg call it mogrify?

   https://django-debug-toolbar.readthedocs.io/en/latest/panels... :

   > debug_toolbar.panels.sql.SQLPanel: SQL queries including time to execute and links to EXPLAIN each query

   But debug toolbars mostly don't work with APIs.

   https://github.com/django-query-profiler/django-query-profil... :

   > Django query profiler - one profiler to rule them all. Shows queries, detects N+1 and gives recommendations on how to resolve them

   https://github.com/jazzband/django-silk :

   > Silk is a live profiling and inspection tool for the Django framework. Silk intercepts and stores HTTP requests and database queries before presenting them in a user interface for further inspection

6. Norm

   5 3 22 0.0 Python

   The SQL generation library you already know how to use. (by justinvanwinkle)

   

7. sqlc

   6 181 14,490 9.0 Go

   Generate type-safe code from SQL

   

   I came across this yesterday for golang: https://sqlc.dev which is somewhat like what you want, maybe.

   Not sure it allows you to parameterize table names but the basic idea is codegen from sql queries so you are working with go code (autocompletion etc).

8. sql-athame

   7 2 14 7.2 Python

   Python tool for slicing and dicing SQL

   

   I had my own take on this concept[1], though with considerably less language magic involved. I imagine there's a lot of these kind of things running around. My criteria were:

   a) let me write actual SQL, not a python DSL that generates SQL

   b) be placeholder-safe

   c) be composable

   [1] https://github.com/bdowning/sql-athame

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

Suggest a related project