News for hackers. Stuff that matters.
Re:How We Went All In on sqlc/pgx for Postgres and Go by pstuart on Wednesday September 08, 2021 @06:40PM (#28463943)
Hopefully they'll get SQLite working on it soon and I'll be all over it.
Re:How We Went All In on sqlc/pgx for Postgres and Go by LVB on Wednesday September 08, 2021 @07:52PM (#28464483)
I'm certainly eager to see official SQLite support as well. In the mean time, the overlap between postgres and SQLite syntax is enough that a lot of my "postgres" definitions in sqlc work just fine in SQLite. The recent addition of "RETURNING" (https://www.sqlite.org/lang_returning.html) to SQLite was a big help since that was a standard part of sql used for postgres with sqlc if you wanted the last insert ID.