sqlcommenter

Most applications require persistent data yet when database performance goes awry, it is next to impossible to easily correlate slow queries with source code.

  • It helps provide observability and can help correlate your source code with slow queries thus guiding you in performance optimization

See the root of this project

When developing sqlcommenter, we’ve tested it with a couple of databases. Please see /databases for an authoritative list but here are some:

If you are using a supported ORM/framework, it shouldn’t be a hassle at all to use. Just pick any of the ORMs in your favorite language

How do I examine the augmented SQL statements?

If you manage your databases or have access to database server logs, the statements will be logged there. Examine databases for more information how.

Where is the specification?

The specification is available here.

What are the default fields

Integration action controller framework route
ActiveRecord/Marginalia
Hibernate+ Spring
knex.js+ express.js
Django
psycopg2 + Flask
sqlalchemy+ Flask
sequelize.js+ express.js

What ORMs support OpenTelemetry ?

Node.js ORMs(Knex, Sequelize, Express) support OpenTelemetry.