Tooling got easier for contributing to #Henhouse thanks to @erik

https://codeberg.org/limeleaf/henhouse/pulls/11

#GoLang #sqlc #goose #templ

This is pretty sweet. #litehug, a #SQL library for #lua which lets you write your queries directly in SQL. Think #SQLc, but for lua. 😎

https://git.sr.ht/~technomancy/litehug

• https://sqlc.dev
• https://github.com/sqlc-dev/sqlc-gen-python

When building CRUD apps with capability for partial updates in #Go & #PostgreSQL with #sqlc , how do you tell the difference between "field omitted" and "field was set explicitly to zero-value"?

Go pointers solve that issue but carrying it all the way to the database requires bridging three type systems.

I explored reflection, generics, and code generation as possible solutions.

Here's the write-up:
https://laelapa.dev/blog/001-the-three-value-problem--a-journey-from-json-to-go-pointers-to-postgres-native-types

---

Replies to this thread show up in the article's comment section.

Меньше кода, больше результата: применяем sqlc для работы с БД

Привет, Хабр! Инструмент, который генерирует производительный и безопасный код для работы с базой данных — миф или реальность? В этой статье обсудим, что такое sqlc, откуда он появился и какие идеи в него заложены. Разберём его возможности и ограничения, а также кейсы, когда он подходит лучше всего.

https://habr.com/ru/companies/uzum/articles/890654/

#go #sqlc #golang #postgresql #uzum #uzumtech

Here's an sqlc + postgres query, used to fetch a list of posts to be displayed on a user's profile:

-- name: GetPostsByAuthor :many
SELECT * FROM posts WHERE author = $1;

Can you spot the problem with this query? ;)

#SQL #PostgreSQL #Postgres #SQLC #Go #GoLang

Yet another article on #sqlc #go

https://zemfira.me/posts/things-i-wish-i-knew-about-sqlc/

I am generating db use with #sqlc, api with #gqlgen, and page renders with #templ.

The last thing I'm actually writing is my test with #ginkgo. Which dictate how everything else is built.

Feels like my #golang workflow has gotten pretty productive. Once I stopped trying to bikeshed. 😅