Tag sql
Post details
OpenTelemetry instrumentation for database/sql. Contribute to XSAM/otelsql development by creating an account on GitHub.
by 
Jamie Tanna
.
#opentelemetry
#sqlite
#sql.
Dependency Management Data can now use sql-studio for database browsing (1 mins read).
Announcing the availability of the sql-studio database browser for dependency-management-data's web application.
Post details
Quick thoughts on whether sqlc is still the direction for Go projects now that we’ve been using it for three years.
by Jamie Tanna
.
#sql
#go.
Dependency Management Data's web application can now be deployed as a single static binary (2 mins read).
Announcing dependency-management-data's embedded SQL browser interface.
Post details
So you have a server storing objects in a relational database, and an API, nowadays probably HTTP but it does not matter. Clients can fetch objects using the API. Obviously you do not want them…
by Jamie Tanna
.
#sql
#api.
My workflow for writing SQL(ite) queries (2024 edition) (4 mins read).
Writing about my recent workflow for writing, executing, and sharing SQL queries with others.
by Jamie Tanna
.
#blogumentation
#sql
#sqlite
#neovim
#datasette
#lsp.
Post details
Neovim plugin for sqls that leverages the built-in LSP client - nanotee/sqls.nvim
by Jamie Tanna
.
#neovim
#sql.
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.
by Jamie Tanna
.
#renovate
#sql.
Post details
by Jamie Tanna
.
#sql
#databases.
What's everyones' favourite resources for how to best find which column(s) to index in your database?
by Jamie Tanna
.
#sql
#sqlite
#databases.
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.
by Jamie Tanna
.
#sqlite
#sql.
Post details
Attached: 1 image I am not monetizing my SQL-writing abilities properly
by Jamie Tanna
.
#sql.
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.
by Jamie Tanna
.
#blogumentation
#go
#sql.
Post details
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).
by Jamie Tanna
.
#go
#postgres
#sql.
Post details
Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick.
by Jamie Tanna
.
#go
#sql.
Post details
Generate type-safe code from SQL. Contribute to kyleconroy/sqlc development by creating an account on GitHub.
by Jamie Tanna
.
#sql
#go.
You're currently viewing page 1 of 1, of 18 posts.