Post details
Recently, we wanted to know which of our repos had Renovate installed, which is a use case several folks have now shared with us! This post showcases some of the queries we put together around our use of Renovate.
Recently, we wanted to know which of our repos had Renovate installed, which is a use case several folks have now shared with us! This post showcases some of the queries we put together around our use of Renovate.
What's everyones' favourite resources for how to best find which column(s) to index in your database?
Anyone know a good place to ask #sqlite or #sql questions?
I'm trying to convert rows (produced by a big query that then uses a GROUP BY advisory_type
) that produces data like:
-- the `advisory_type` can be one of multiple values, i.e. SECURITY, DEPRECATED, UNSUPPORTED
repo advisory_type total_advisories
------ ------------- ----------------
jvt.me SECURITY 10
jvt.me DEPRECATED 5
And I'm trying to convert this to:
repo total_security total_deprecated total_unmaintained
------ ------------- ---------------- ----------------
jvt.me 10 5 0
Any clue how I'd go about doing so? Happy to provide more details / some data for you to query too, but been playing around with it on and off and not really having any luck.
Attached: 1 image I am not monetizing my SQL-writing abilities properly
Checking the migration status with golang-migrate
(1 mins read).
How to check what version of the schema is curently applied when using golang-migrate
.
Upgrading a Go project from pgx v4 to v5, and more specifically, from sqlc’s <code>pgx/v4</code> to <code>pgx/v5</code> driver (the hard part).
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick.
Generate type-safe code from SQL. Contribute to kyleconroy/sqlc development by creating an account on GitHub.
You're currently viewing page 1 of 1, of 10 posts.