From the blog

Release notes

Removing our cgo dependency in v1.25.0

sqlc is a command line tool that generates type-safe code from SQL. Today we released sqlc v1.25.0, a smaller release that removes our reliance on cgo.

Announcement

Preview: Generate TypeScript from SQL

We’re so excited to announce the preview release of our TypeScript plugin, sqlc-gen-typescript. TypeScript now joins Go, Python and Kotlin as supported languages. Let’s dive in.

Changelog

Sign in with GitHub

Sign in with GitHub
Changelog

Prevent full table scans in production

We updated sqlc verify to emit a warning if any queries do a full table scan. Full table scans, which PostgreSQL calls a sequence scan, can be disastrous when performed against a large table, as the query will touch every row in the table.
Release notes

Verifying database schema changes in v1.24.0

sqlc is a command line tool that generates type-safe code from SQL. Today we released sqlc v1.24.0 which includes a new feature to verify the correctness of database schema changes.

News

sqlc news, November 2023

Just a quick update this month as we head into the holiday season!
Announcement

Announcing sqlc-gen-go

We’ve extracted the Go codegen package from sqlc and are publishing it as a plugin.

Release notes

Database-backed query analysis in v1.23.0

sqlc is a command line tool that generates type-safe code from SQL. Today we released sqlc v1.23.0, so let’s take a look at what’s new.

News

sqlc news, October 2023

We’ve got a major release coming soon that we’re very excited about, because it will include a new query analysis engine that resolves a ton of outstanding issues. So stay tuned for that.

Release notes

Managed databases with sqlc vet in v1.22.0

sqlc is a command line tool that generates type-safe code from SQL. Today we released sqlc v1.22.0, so let’s take a look at what’s new.

Release notes

sqlc v1.21.0 released

We’ve just released sqlc version 1.21.0 which includes many bug fixes and a few new features, and coincidentally happens to be the first sqlc release built with Go 1.21. Read below for some highlights, or head straight to the sqlc changelog.

Release notes

sqlc v1.20.0 released

Version 1.20.0

Announcement

Working on sqlc full-time

If you haven’t heard of us, sqlc generates fully type-safe idiomatic code from SQL. Think of it as a reverse ORM: you write SQL queries in a text file, run sqlc generate, and then continue writing your code. It works great for Go and additional language support is on the horizon.

Release notes

sqlc v1.19.0 released

Version 1.19.0

Release notes

sqlc v1.18.0 released

Version 1.18.0

Release notes

sqlc v1.12.0 released

Version 1.12.0

Release notes

sqlc v1.8.0 released

Sssssss. Experimental Python support has landed.
Release notes

sqlc v1.7.0 released

sqlc has come to Windows! It’s currently MySQL-only, but I hope to land PostgreSQL support in the coming months.
Release notes

sqlc v1.6.0 released

The new MySQL engine, code-named Dolphin, is now default. The old engine has been removed. Your generated code will be different, but should be easy to adapt. Please open an issue if your code is now broken. If you were using the mysql:beta engine, you’ll need to change that to mysql.
Release notes

sqlc v1.5.0 released

The new MySQL engine, code-named Dolphin, has finally landed. To try it out, use mysql:beta for the engine value in sqlc.json. This uses the same compiler infrastructure as the PostgreSQL engine, giving it feature parity and making it easier to maintain.
Release notes

sqlc v1.4.0 released

This release includes a complete refactor of the compiler internals. The compiler now uses a database-agnostic SQL AST, which the PostgreSQL backend uses by default.
Release notes

sqlc v1.3.0 released

Don’t panic! I’ve fixed a few cases where sqlc was struggling to handle DDL statements. JSON columns are now properly represented as json.RawMessage structs.
Release notes

sqlc v1.2.0 released

This release brings with it an official Docker image for you whale fans out there. A configuration file change allows file systems paths to be a list of paths.