SQLx vs SQLc

Рет қаралды 27,533

4 ай бұрын

LIVE ON TWITCH: / theprimeagen
Become a backend engineer. Its my favorite site
boot.dev/?promo=PRIMEYT
This is also the best way to support me is to support yourself becoming a better backend engineer.
Get in on Discord: / discord
Get in on Twitter: / theprimeagen
Got Something For Me to Read or Watch??:
/ theprimeagenreact

Пікірлер: 44

@QuentinDurot 4 ай бұрын

20 minutes of missing the point of SQLC ^^ gold

@nooraldeen6637 3 ай бұрын

elaborate?

@edgardevelops 2 ай бұрын

@@nooraldeen6637 sqlc is sql compiler, he only get it after 20 minutes

@jeffreysmith9837 Ай бұрын

@@nooraldeen6637sqlc generates all that code. It's a codegen tool

@betoharres Ай бұрын

tbf I also took that long as well

@UnFiltered1776 4 ай бұрын

HookerSQL has a certain ring to it.

@user-kh5lm5ce7g 2 ай бұрын

SQLC + goose (or any other migration tool you like) is really pure joy. One of the most beautiful go packages built so far

@dimo3611 4 ай бұрын

I used SQLC with postgres and pg-builtin Json-functions to allow batch-upserts whilst returning all entries with its updated (upserted) values. Being able to build these queries and simply using some methods exposed on the queries-struct made my life way easier. Note for Joins: AFAIK - sqlc clever, it will generate output structs if not mapped to the table-definitions. So, they work. Other notes: You can swap out the underlaying sql-driver interface to profit of e.g. (no)cgo, using specialized sql-driver based on db-type, pooling. Also: sql.Null can be replaced by pointer via config. also: sqlx code gotta be written by you. for sqlc, you simply call the generated methods. this aint a useful comparison imo. EDIT: He realized kekw

@lguedes768 4 ай бұрын

That lcravo is a legend bro

@jonathanjacobson7012 4 ай бұрын

SQLc reminds me of the PL/1 SQL preprocessor

@azrafal 3 ай бұрын

i have watched the entire video twice

@stonehat 4 ай бұрын

How will Turso handle working offline and syncing later?

@paxcoder 4 ай бұрын

I heard Ptagen talk about sqlc, so I googled sqlx vs sqlc, and got this video []-[]

@kevinkkirimii 4 ай бұрын

I'd use sqlx for the struct tags and batch inserts when required and sqlc for the code gen to ramp up initial development otherwise I'd just use the low level standard library.

@mo-nf4cr 4 ай бұрын

Yeah for me its more like sqlc for static queries, then reuse sqlc types with sqlx for dynamic queries

@pss_crs Ай бұрын

create your own types and embed the Sqlc generated one the call your interface, I don't understand what you mean low level but sqlc can generate pure idiomatic code without 3rd party dependency just standard libraries

@trebabcock 3 ай бұрын

You should start using the `if err := function(); err != nil {}` syntax on functions that only return an error. Maybe you already do, this is weeks ago and I'm only 15 minutes in.

@JohnDoe-ji1zv Ай бұрын

How does it work with postgis ? Custom types etc ?

@pss_crs Ай бұрын

it took you 20 minutes to understand SQLC, what ever library you use you would write SQL queries even if it's ORM so just generate it more idiomatic Go API's and then use it

@linearz 4 ай бұрын

sqlx enjoyer here, less cognitive load.

@hansmaulwurf8027 4 ай бұрын

Software is not finished, it gets released. Slightly altered quote from wren Weichmann.

@UnFiltered1776 4 ай бұрын

Super duper is the way to be.

@DennisJHarrisonJrHere 4 ай бұрын

I use sqlc in my dayjob. The type safety and compiler checking on both sides is good. I miss eloquent :)

@azrafal 4 ай бұрын

how do you handle migration?

@mayormccheese8673 4 ай бұрын

@@azrafalgolang-migrate

@JohnDoe-ji1zv Ай бұрын

Do you use any custom types or postgis ? Do you think sqlc is able to handle that ?

@mayormccheese8673 Ай бұрын

@@JohnDoe-ji1zv I use Postgres and pgx/v5 with custom composite types. It works great.

@poderosoexcalibur-yp3kl Ай бұрын

@@azrafalatlas works pretty nice

@spartan_j117 4 ай бұрын

What's the point of those sqlc(x) if you still write raw sql? It's ok for very basic queries, agree. But what about a complex ones? I would suggest to have a look into "go-jet". It's a gamechanger, imo.

@stefankyriacou7151 4 ай бұрын

just googled go-jet, and this is exactly what I was looking for, thank you!

@39strife 17 күн бұрын

jet hasn't been updated in months

@Im_Ninooo 4 ай бұрын

52:30 nooooo!! don't use Make, use Taskfile!!

@DavidFregoli 4 ай бұрын

thanks it looks good

@Gigasharik5 3 күн бұрын

pgx.

@guillemgarcia3630 4 ай бұрын

Oh man, I just realized. I can get chatgpt to generate many useful sql queries for each table in a schema. So that gpt generates the queries, and sqlc generates the go code from those queries. Someone should make a cli utility from that. Saas idea cmon

@dandogamer 4 ай бұрын

Theres a nice library called sqlc-grpc which can even generate grpc/http api