SQL-tap
Dev tools
database query debugging
SHOW HN2026
How HN took it
9 positive, 10 neutral or asking, 0 mixed, 5 critical, out of 24 comments about the project. Thread score +0.17.
Idea: 3 for, 2 againstPerformance: 1 for, 2 againstExecution: 2 for, 0 againstDesign: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Easy drop-in proxy that works smoothly
From 3 comments
Just tried it out. Works fine. Love it! I tried it with a wordpress site. It is showing hundreds of sql queries in one request (thats probably why that wordpress site is so slow…
qxxx on HNNice. I like how you made it an easy to drop in proxy. Will definitely use this when debugging issues!
nwellinghoff on HNThis is very neat! IMO inspecting the queries the agents run on the database is a better approach to understand how the code works, even more than reviewing the code. I just…
buremba on HN
Objections
Proxy adds latency and is a worse approach than passive capture or logging
From 3 comments
Why do you need a proxy? Pull the queries off the network. You’re adding latency to every query! https://github.com/circonus-labs/wirelatency
camel_gopher on HNIMO transparent proxies for observability are not the best pattern. And I speak from experience, we developed the Postgres plugin for Envoy [1], [2] and we use it in StackGres…
ahachete on HNI prefer to just turn on query logging in the db server. I don't understand why you would use anything else.
stephenr on HN
Requests
Sorting and search/filter of queries, such as by execution time
From 1 comment
Just tried it out. Works fine. Love it! I tried it with a wordpress site. It is showing hundreds of sql queries in one request (thats probably why that wordpress site is so slow…
qxxx on HN
Show how often the same query runs
From 1 comment
Just tried it out. Works fine. Love it! I tried it with a wordpress site. It is showing hundreds of sql queries in one request (thats probably why that wordpress site is so slow…
qxxx on HN
Questions
Why use this instead of enabling MySQL general log or Postgres log_statement
From 2 comments
Can you explain how this is a better option than just enabling the general log for MySQL as needed?
stephenr on HNOr log_statement = 'all' in Postgres.
ahoka on HN
What are the latency implications of the proxy
From 1 comment
what are the latency implications of going through this proxy? looks good
hankchinaski on HN
Alternatives named
eBPF-based query capture
From 2 comments
I prefer to use eBPF; no additional software, proxy or configuration needed. https://eunomia.dev/tutorials/40-mysql/
ranger_danger on HNeBPF will: https://eunomia.dev/tutorials/40-mysql/
ranger_danger on HN
Database query logging
From 2 comments
Can you explain how this is a better option than just enabling the general log for MySQL as needed?
stephenr on HNOr log_statement = 'all' in Postgres.
ahoka on HN
Envoy proxy filters for MySQL and Postgres
From 2 comments
https://www.envoyproxy.io/docs/envoy/latest/configuration/listeners/network_filters/mysql_proxy_filter…
phrotoma on HNIMO transparent proxies for observability are not the best pattern. And I speak from experience, we developed the Postgres plugin for Envoy [1], [2] and we use it in StackGres…
ahachete on HN
sqltap
From 1 comment
Not to be confused with sqltap which is also great for debugging queries: https://github.com/inconshreveable/sqltap
odiroot on HN