launchbadge/sqlx

Log queries including bind arguments and execution time

Open

#162 opened on Mar 26, 2020

View on GitHub
 (9 comments) (0 reactions) (0 assignees)Rust (1,307 forks)batch import
enhancementhelp wanted

Repository metrics

Stars
 (13,916 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

TRACE sqlx::query > SELECT …, elapsed: 0.04ms

    SELECT foo, bar, baz
    FROM this_table_over_here
    WHERE foo = $1 AND bar = $2
    ORDER BY baz

    $1 = 50
    $2 = 694

TRACE sqlx::query > INSERT INTO table_name …, elapsed: 12.04ms

Log format is very "let's figure out what we think looks best". Use log. We should new line + indent like error stack traces for the query body. Not sure how to nicely show the bind arguments.

Contributor guide

Research direction
Implement logging of bind arguments and execution time in sqlx queries, possibly using the `log` crate with indented formatting.
Tech stack
rust
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
Rust
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70