SQLc is the perfect tool for those who don't like ORMs

Поделиться
HTML-код
  • Опубликовано: 11 янв 2025

Комментарии • 296

  • @dreamsofcode
    @dreamsofcode  3 месяца назад +11

    Click this link sponsr.is/bootdev_dreamsofcode and use my code DREAMSOFCODE to get 25% off your first payment for boot.dev. That’s 25% off your first month or your first year, depending on the subscription you choose.

    • @NickTheCodeMechanic
      @NickTheCodeMechanic 3 месяца назад

      I NEVER use protection.

    • @CppExpedition
      @CppExpedition 2 месяца назад

      please wait a little bit longer for us to read code instead switching to your face xD

  • @edhahaz
    @edhahaz 3 месяца назад +125

    the ORM/SQL guy's laptop of choice is inverted for engagement baiting.

    • @r0ny539
      @r0ny539 3 месяца назад +2

      i wanted to say same thing

    • @astronemir
      @astronemir 2 месяца назад

      No just admit you’re an SQL normie. Embrace the label 🐑.
      😂😂😂

    • @devOnHoliday
      @devOnHoliday 2 месяца назад +2

      missed the banana cursor

  • @endalk200
    @endalk200 3 месяца назад +40

    Very interested in seeing your go backend development stack

  • @jefferymuter4659
    @jefferymuter4659 3 месяца назад +7

    Damn this is perfect! I've heard of sqlc, but didn't understand it.
    I've also been writing all my own code for this, and its been making me feel super sluggish. Thank you for showing me this!

  • @fresonn
    @fresonn 3 месяца назад +58

    I have been using sqlc for two years now. It is definitely one of the best tools for interacting with a database.

    • @AbegazNap
      @AbegazNap 2 месяца назад

      was not friendly with arguments inside case statements so I switched to go jet, but yes one of the best in the biz as they say

  • @HierImNorden
    @HierImNorden 2 месяца назад +19

    We decided to use sqlc a couple months ago and it is the best tool we have found, but I have two gripes with it:
    1. You cannot easily create a drop in replacement interface for two different engines. We wanted to use PG in production and SQlite for testing. Even though the generated types etc are entirely identical they are, at the end of the day, different types. So what we did was write a hacky python script that copies all the parameters and models into a common package and updates the references in the subpackages. It works, but a native way for this would be nice.
    2. It bleeds sql types. Every nullable column turns into a sql.NullXXX field instead of, say, a *string. If I wrote the repository myself, I would convert that to normal types before passing it along, but I have not found a way to do that with sqlc so far.

    • @eyob7232
      @eyob7232 2 месяца назад +4

      You can add a `emit_pointers_for_null_types:true` property to solve your second issue, not sure for your first one though,

    • @benwoodward3446
      @benwoodward3446 2 месяца назад +2

      Why not use pglite? Or postgres via testcontainers?

    • @じょえさん
      @じょえさん 2 месяца назад +8

      Bro, To quote from The Twelve-factor App, the development and production environments should match as much as possible.

  • @timo_b3
    @timo_b3 3 месяца назад +6

    this looks extremely interesting, thanks for showing this

  • @mantovani96
    @mantovani96 3 месяца назад +104

    The only thing missing is a better way to handle queries with dynamic parameters.

    • @sarabwt
      @sarabwt 3 месяца назад

      to-many joins?

    • @RumenNikiforov
      @RumenNikiforov 3 месяца назад +7

      Exactly, i'd like to see how you can have one func that supports conditional filtering e.g. find all players based on their class, or have particular item, or have gold above or below certain value.
      And full text search with ordering based on query relevance e.g. in postgres column 'value'

    • @TheNamakool
      @TheNamakool 2 месяца назад +4

      Yep this hurts the most for endpoints that need to apply lots of optional filters

    • @AbegazNap
      @AbegazNap 2 месяца назад

      @@TheNamakool you can try case when statements with associated booleans to check if the filters are provided since zero values might be a problem

    • @meni181818
      @meni181818 2 месяца назад

      you can mock it with weird sql case.. conditions etc.

  • @erikslorenz
    @erikslorenz 2 месяца назад +14

    If you spend 5 years having to almost exclusively use 3rd party APIs (poorly documented) instead of traditional DBs, any opportunity to use SQL directly is a dream.

  • @GreyDeathVaccine
    @GreyDeathVaccine 11 дней назад

    Very high quality video. I like simple tools. That's why I am using RedBeanPHP.
    RedBeanPHP is an on-the-fly object-relational mapper, this means there is no upfront configuration. The system relies on conventions entirely and adapts the database schema to fit the needs of the program.
    So it's different approach to basic operations, but I still like to combine RedBean with repository pattern 🙂

  • @ErmandDurro
    @ErmandDurro 2 месяца назад +1

    Great video. I didn't know about sqlc, but I am definitely going to try it now. Thanks a lot for such great quality content. And yes, I would love to have that video about your backend stack :)
    Thanks once again!

  • @couch9416
    @couch9416 3 месяца назад +2

    I am on vacation and wanted to look into sqlc for a project when I am back, so this is perfect timing

  • @tkg__
    @tkg__ 3 месяца назад +16

    The only gripe I have with it is that it creates a non-standard SQL. The sqlc.embed() for example makes the SQL query not actually SQL, which was the whole point of using sqlc and not an ORM.

    • @AK-vx4dy
      @AK-vx4dy 3 месяца назад +5

      Those queries templates not literal queries. I know most libraries for SQLs provide replacing $1 or :amount with provided parameters but it this any diffrent ?
      But you are right is should be orthogonal and specfics about arguments shoud be done like comment $1/*amount::bigint*/.

    • @dealloc
      @dealloc 3 месяца назад +6

      It's valid SQL syntax which is important to note. Just as valid as using different SQL flavor depending on which SQL engine you use. This engine just happens to go through sqlc before being passed onto your database directly.
      Consider the SQL being executed within a runtime that has a preprocessor that simply replaces those calls during execution. This is why they are called macros, because they are exactly that.

    • @31redorange08
      @31redorange08 2 месяца назад

      Yeah, kind of defeats its purpose.

    • @theseangle
      @theseangle 2 месяца назад +5

      Bro it's a macro, it produces the same SQL you would've written without it. That's the whole point. And you aren't even forced to use it, nobody's stopping you from raw dogging the conflicting column names and writing boilerplate. It's just QoL.
      The main purpose of SQLc is to strike a balance between DX and control, and it does hit the spot quite well. You also aren't forced to opt in fully, you can use it for part of your queries, it doesn't affect the schema (unlike ORMs), you can still use regular SQL or other tools with it.

    • @31redorange08
      @31redorange08 2 месяца назад +3

      @@theseangle What so you mean by "produces"? If I can't take the string literally and execute it directly, it's not valid SQL.

  • @L0wPressure
    @L0wPressure 2 месяца назад

    Amazing :) We were just talking with a colleague, how we hate codegen, but this tool actually looks nice!

  • @esra_erimez
    @esra_erimez 2 месяца назад +12

    The company I work for tried sqlc, they contributed to the project both with code and funding. Its missing a lot of features. For example, dynamic quueries. Its been an open issue on the issue tracker for *years* now. We moved on to xo.

    • @lambertm9837
      @lambertm9837 2 месяца назад +1

      I second this

    • @kompila
      @kompila 27 дней назад +1

      Thanks for sharing. A lot of people in the comment are talking about dynamic queries.

  • @ericwanyoike-h9l
    @ericwanyoike-h9l 3 месяца назад +7

    sqlc is just a must use tool to use with databases

  • @Darthtrooper14
    @Darthtrooper14 2 месяца назад

    You convinced me to try sqlc. Thanks for showing us this!!

  •  2 месяца назад

    Again, thank you for your work! I've tried to convince some people on my team to use sqlc, they were not fully convinced despite my fantastic persuasion techniques. Guess I'll just share this video so they can finally understand what I extremely articulately tried to say/show at the time xD

    • @spartan_j117
      @spartan_j117 2 месяца назад

      Take a look into go-jet/jet. It is really fantastic, true type safe way to write sql. The thing that author shows in this video is just as retarded as any other. Jet is the future.

  • @05xpeter
    @05xpeter 2 месяца назад +2

    As a developer that constantly have to stop my self from writing raw sql queries, this look amazing. We have a cross language platfrom Python and Typescript maaaaaybe I could sneak it in make our code base a little dry'er.

  • @recarsion
    @recarsion 2 месяца назад

    The BTW part really got me 💀Very relevant video as well, I'm using something called SQLBoiler right now which is one of the better ORMs I've used but I'm still feeling the limitations on a day to day basis especially any time joins are needed so I either end up writing a raw query anyway or querying each table one by one and joining manually, at which point why even use an ORM, or a relational database for that matter... luckily I'm at the point where I can still make a big change like this so I'm fairly sure I'll be converting to sqlc.
    Edit: and I did it already in a couple hours, it went pretty smooth actually (not surprising for a small application like mine) and I'm finding this really easy to use and elegant so far

  • @flameinthedark
    @flameinthedark 3 месяца назад +5

    There are also some inconvenience with this tool, it's impossible to make some filtering requests. For example if you have a search route in your API and you have to insert some WHERE statements in the SQL request. Like, select rows with "active = true" when user set that checkbox, and other filters. But yeah, in general this tool is very cool, and I've used it in the production, but had to switch to plain SQL or something like squirrel to be able to build more flexible requests

    • @AK-vx4dy
      @AK-vx4dy 3 месяца назад

      Are you sure ? You can add WHERE in query with parameted $1 like "WHERE active=$1"

    • @someoneunknown6894
      @someoneunknown6894 3 месяца назад

      ​@@AK-vx4dyI think he means that unless the checkbox is set, you are ok with both active being true and active being false, otherwise you only want to get the active entires

    • @dealloc
      @dealloc 3 месяца назад +10

      First, you know the filters that may or may not be applied, so build the query with those in mind up front. Don't concatenate query strings to form a query dynamically, instead encode the filters into the query itself:
      For example `SELECT * FROM table WHERE
      (@name IS NULL OR name LIKE @name) AND
      (@age IS NULL OR age = @age) AND
      (@active IS NULL OR active = @active) ...`
      This gives you the freedom to choose how filters are applied in compound.
      The benefit of this is that the execution plan can be cached and re-used no matter what inputs are, so there's practically zero overhead unlike stitching random queries together which may be different each time

    • @orterves
      @orterves 2 месяца назад +2

      ​@dealloc you beat me to it - this is correct, and the other style of code that tacks on extra sql is harder to maintain.
      An alternative to doing it this way would be to make multiple queries with different where clauses and choosing which one conditionally in the code

    • @AK-vx4dy
      @AK-vx4dy 2 месяца назад +1

      @@orterves If you need to be so elastic (user provided filtering), indeed good(!) orm can be a better choice.
      But.. I'm not sure but maybe is possible to add sql.embbed(whole_where_section) and bulit this part in code ?

  • @cg219
    @cg219 2 месяца назад +1

    Also I love sqlc. It was the first option I chose when switching to Go. Great choice I see

  • @michawhite7613
    @michawhite7613 2 месяца назад +9

    There's a Rust library called sqlx, which uses the language's macro system to verify SQL commands against your local database at compile-time, and it generates a compiler error if it fails.

    • @tekipeps
      @tekipeps 2 месяца назад

      @@michawhite7613 yeah the original library is sqlx from golang

    • @dreamsofcode
      @dreamsofcode  2 месяца назад +1

      I have a video on sqlx! I'm a big fan of it.

  • @TheRykung
    @TheRykung 3 месяца назад

    perfect timing video lol I was looking into sqlc last night. wasn't sure if I wanted to just go with the standard go database/sql package or use sqlc

  • @anothercrappypianist
    @anothercrappypianist 2 месяца назад +1

    I'm definitely won over by the prospect of less boilerplate, but my first thought was "how does it deal with transient db failures?" After looking through the GitHub issues, unfortunately the answer seems to be be "not very well." There's no explicit retry mechanism, and there's currently no means of adding custom middleware through which to implement common retry logic. So AFAICT implementing retries means wrapping calls, which replaces one kind of boilerplate with another.

  • @lifelover69
    @lifelover69 3 месяца назад +1

    i learned a lot and i'm going to try sqlc now, thanks! squeal ftw

  • @TheKastellan
    @TheKastellan 2 месяца назад +7

    7:30 *Woosh. Woosh. Woosh. Woosh*

    • @MichaelCampbell01
      @MichaelCampbell01 2 месяца назад

      For real; quite distracting. Otherwise great content, too.

  • @mikaeels2691
    @mikaeels2691 2 месяца назад +1

    this is what the squirrel library for Gleam does which is pretty cool, except that one only supports postgres for now

  • @SaltCatcher
    @SaltCatcher 2 месяца назад +3

    I want to see a video about your complete go stack!

  • @ad-coding-gh1lm
    @ad-coding-gh1lm 2 месяца назад +2

    Thanks

    • @ad-coding-gh1lm
      @ad-coding-gh1lm 2 месяца назад +1

      I really loved this tutorial. I saw sqlc tutorial before but was scared to use and I didnt get much out of it. but with this I really find it easy and have already started working on a personal project with this.
      Please also make a full backend app tutorial would love to learn more about golang
      thanks again

    • @dreamsofcode
      @dreamsofcode  2 месяца назад +3

      Thank you so much for the support! I'm glad you found value in the video!!
      I absolutely will make a full backend app tutorial. 😁

  • @ViktorKrejcir
    @ViktorKrejcir 2 месяца назад

    That looks cool :) I'll try it tonight before I Hibernate :)

  • @sagarrout007
    @sagarrout007 2 месяца назад +1

    I am not sure for go but for Java developers, Jdbi brings this thing with more nicer abstraction as well

    • @tienslabien
      @tienslabien 2 месяца назад

      oh good catch, I didn't know about JDBI, thanks for sharing

  • @youssefgamal4625
    @youssefgamal4625 2 месяца назад +1

    In Java Spring Boot there is a solution for db first called JOOQ, it's impressive for any spring boot development

    • @tienslabien
      @tienslabien 2 месяца назад

      I went with querydsl, which is a similarly-minded api. Way lighter and clearer code than jpa/hibernate, whilst also having access to the full sql spec and db-specific dialect operations (try writing a dynamic join or an INSERT SELECT ... query with jpa ... lmao)

  • @duongphuhiep
    @duongphuhiep 2 месяца назад +3

    skeptical! not sure if it makes things easier to debug and to maintain

  • @Metruzanca
    @Metruzanca 3 месяца назад +2

    Oh shit, hopefully a Gleam plugin gets made. Maybe I'll give it a shot.

  • @temperkan3727
    @temperkan3727 2 месяца назад

    Very useful video!

  • @distinctdipole
    @distinctdipole 3 месяца назад

    Thank you... for clearly explaining this helpful tool and for the moments that made me chuckle 🤭

  • @SteveKuznetsov
    @SteveKuznetsov 2 месяца назад

    Consider using bingo to declaratively manage the version of SQL binary you're using at a project level. This is very nice to make the build time environment reproducible for anyone cloning the repair and also to manage the version of the tools in git.

  • @committedcoder3352
    @committedcoder3352 2 месяца назад +1

    Would love to see you talking about the migrations.

  • @felizadoxi
    @felizadoxi 2 месяца назад +2

    Yes, please show us your full stack

  •  2 месяца назад

    Without dynamic queries it was of no use... at least for my projects: p Nice video btw.

  • @MrCatgroove
    @MrCatgroove 2 месяца назад

    I'm sold on sqlc, but I don't think it's a 1:1 replacement for a repository/storage/db/whatever-layer. If you have pure domain models, you'd want to map to those inside of the db-layer before returning. The same goes if you have many-to-many relationships. It's simply not feasible to do all of that with just sqlc. The same goes for if you have dynamic queries. It's not really supported by sqlc in a good way and you will probably have to use something like strings.Builder allow for such queries,. You would want this code to live next to your other db-code. This approach also avoids macros (mostly) and keeps your queries very simple and straightforward.

  • @FlaviusAspra
    @FlaviusAspra 2 месяца назад +1

    SQLc sounds great, but it's missing a lot of things. I'm afraid they don't see enough of the picture to empower users to do a clean separation of concerns.

  • @JaJDoo
    @JaJDoo 2 месяца назад

    just a heads up here, sqlc is real nice and its future looks promising but still has issues with more complex queries and things like dynamic filters
    make sure you check the kinds of queries you have are possible in sqlc before committing to it

  • @yash1152
    @yash1152 2 месяца назад

    0:03 framework systems for the win yayy!!

  • @johnbauer9907
    @johnbauer9907 2 месяца назад

    Very well done video... Thanks.

  • @charleschen4093
    @charleschen4093 2 месяца назад

    love your sharing!

  • @herbertpimentel
    @herbertpimentel 2 месяца назад

    I would love to see more about it.

  • @VardanPogosyan
    @VardanPogosyan 2 месяца назад

    Which browser on 3:55 do you use?

  • @covle9180
    @covle9180 2 месяца назад +2

    "Allowing you to write raw SQL queries" is not really true anymore. Annotations in specific formats, injecting functions in the SQL... You're still learning a new language, it just kinda really looks like SQL but isn't. I'm still on the fence whether this actually makes my life better as a raw SQL enjoyer. 27:30

    • @rev4324
      @rev4324 2 месяца назад

      it’s the closest you can get to raw sql and avoiding massive boilerplate at the same time

  • @johnnydenver-m8r
    @johnnydenver-m8r 2 месяца назад

    Every orm allows for raw sql queries which are mostly protected by default.

  • @coolaj86
    @coolaj86 2 месяца назад

    Note: ossp-uuid should NOT be used for secure uuidv4 (the implementation details do not guarantee security). Instead gen_random_uuid() (from pgcrypto) should be used. HOWEVER, there are performance issues with all uuidv4 varations, and uuidv7 should be preferred (typically generated by the application on insert, but also available as a postgres function if default values are needed).

  • @MadsterV
    @MadsterV 2 месяца назад +8

    Problem achieved! you've replaced boilerplate with even more boilerplate in two different uncommon languages!

  • @DerTim
    @DerTim 3 месяца назад +1

    Im using sqlx and go migrator embedded into my app rn and I'm thinking about moving to sqlc + atlas. But there is one important feature missing to me: how can I migrate default data to my backend? E.g. I have a permissions table and I have certain base permissions. How can I migrate them? Should I use two different migration tools 🤔

    • @dreamsofcode
      @dreamsofcode  2 месяца назад

      You can add default data into your migrations if you are guaranteed to need it!

  • @christopherkim133
    @christopherkim133 3 месяца назад +1

    Could we get a look at that go stack?

  • @herbert9039
    @herbert9039 2 месяца назад

    nice video, thanks! subscribed

  • @rign_
    @rign_ 3 месяца назад +1

    I wrote code in Javascript. I usually use Kysely. It's query builder, I don't know if it's considered ORM or not...

  • @EduardKhiaev
    @EduardKhiaev 2 месяца назад

    I really would like to see your tech stack and the reason why you are using certain tools instead of other tools, for example migrate and goose

  • @AK-vx4dy
    @AK-vx4dy 3 месяца назад +5

    select * is generally bad practice but in this case when total control of database is asssumed, i can grant absolution ;)

  • @Jafeth636
    @Jafeth636 3 месяца назад +1

    Did I see Zen Browser? LET'S GO!

  • @Elkemper
    @Elkemper 2 месяца назад

    That is very cool, but I think it's kinda mistake that they decided to stick with .sql extension. this is registered extension for DBMS-es and pure sql syntax. with all this new sugar from sqlc - it will make those query files unrunnable: you cannot easily debug them in the CLI or DB UI client, you need to traverse the file to understand how this works, etc..
    other than that - pretty interesting approach.
    But do they have a LSP implementation?

  • @giorgioripani8469
    @giorgioripani8469 3 месяца назад +1

    How is this better than Spring JPA Repository named queries?

  • @someshkarmakar47
    @someshkarmakar47 2 месяца назад +1

    we would love to know your GO full-stack.. please make a video on it

  • @RedPsyched
    @RedPsyched 2 месяца назад +1

    We have the same cursor! All hail the banana cursor 🙇

  • @tawandagamedevs
    @tawandagamedevs 3 месяца назад

    Dreams of code video ❤

  • @LongLiveEmrys
    @LongLiveEmrys 2 месяца назад

    FYI the plugins for other languages are missing features and most of them don't appear to be active. I don't think you could feasibly use this tool for anything other than Go, unfortunately.

  • @vitaman02
    @vitaman02 2 месяца назад +1

    It is SQL, not Sequel. :)

  • @Sunpy_Emily
    @Sunpy_Emily 3 месяца назад +7

    I can't focus on the video with the sound effect that is used on almost every zoom and underline edit.

  • @guerra_dos_bichos
    @guerra_dos_bichos 2 месяца назад

    But for me the main advantage of writing your own SQL code is being able to use your preferred database specifics , like postgres jsonc etc

  • @aunjaffery31
    @aunjaffery31 2 месяца назад +2

    The real project will always have multiple joins between tables. how well can SQLC handle these, and map the nested data to struct. you just created a beginner 'hello world' project. go-jet/jet handle these complex data very well...

    • @dreamsofcode
      @dreamsofcode  2 месяца назад

      I showed this in the video my guy...

    • @aunjaffery31
      @aunjaffery31 2 месяца назад +1

      @@dreamsofcode Sorry for misunderstanding. I meant, to produce nested struct. Suppose a user --[hasmany]--products--[hasmany]--images. User struct should have nested product [slice of struct] and each product slice should have nested image slice.

  • @DerTechNick
    @DerTechNick 2 месяца назад +1

    Nice idea, but this doesn't support any kind of dynamic order by clause, only static queries

  • @dewigesrek5651
    @dewigesrek5651 3 месяца назад +6

    after seeing the docs, i’d rather create my own

    • @dewigesrek5651
      @dewigesrek5651 3 месяца назад

      but again, this is my case not urs

    • @Fran-kc2gu
      @Fran-kc2gu 3 месяца назад +2

      waiting for your github repo link :)

  • @litfill54
    @litfill54 3 месяца назад +27

    the banana cursor

  • @MehrshadGolesorkhi
    @MehrshadGolesorkhi 13 дней назад

    Does it have a plugin to convert from/to proto models? or use proto models instead of generating its own models?

  • @CoolestPossibleName
    @CoolestPossibleName 3 месяца назад

    Finnally someone mentioned sqlc

  • @AntonGalitsyn
    @AntonGalitsyn 2 месяца назад +1

    Looks nice, it can save some time. But I personally don't want to use it. 1st reason - I came in Go for simple setup, but now I forced to dive into code generation logic of 3-rd party tool and use yaml config, sql macroses ant etc. I would rather ask chatgpt/claude generate repository methods and provide it Go structs and SQL schemas I made, and keep it as non-generated code. 2nd reason - tests, I usually split storage layer into multiple EntityRepository parts and test them separately against DB in docker container. It's easier to modify code manually than try to find exact config combination needed for code gen tool.
    3rd reason - Go structs not always repeat table columns. These "models" generated by sqlc is not models at all, it's more like helper mapping structs for DB driver. Models, if we use this term in paradigm of clean code, should be free of `db`, `json` tags and don''t have sql field types because this is abstraction leak. If we use pgx, we may have case when you need pgxtype fields for proper mapping, but it's not often. In many cases you can reuse your app level models with small addition of private (storage level) structs for mapping to specific type. Sqlc rely on generated models, not on models defined on app level by developer.

    • @tkg__
      @tkg__ 2 месяца назад

      Go is and always was very heavily leaning into code generation. So it's not really out of its idiomatic approach. I'd prefer to configure it in Go rather than a YAML file, but that's all.

    • @kodedart2311
      @kodedart2311 Месяц назад

      Slam dunk

    • @dougsaylor6442
      @dougsaylor6442 Месяц назад

      @@AntonGalitsyn so you'd rather generate code to avoid generating code?

  • @anarchymatt
    @anarchymatt 10 дней назад

    Persistent + Esqueleto 😀

  • @SriTejaChilakapati
    @SriTejaChilakapati 2 месяца назад

    Hey, great video! However I seem to be facing an issue while overriding types of UUID columns that are a foreign key reference to another table. The primary key field is `uuid.UUID`, but the foreign key field is still `pgtype.UUID`. Any idea where I might be missing something?

    • @SriTejaChilakapati
      @SriTejaChilakapati 2 месяца назад

      Btw I understand that I don't really need foreign keys if everything is a raw query and I can write joins myself, but I'm working with an existing schema here

    • @dreamsofcode
      @dreamsofcode  2 месяца назад

      If you jump on my discord and drop me a message I can take a look! Will need to see what your schema and query look like otherwise. I've managed to get a FK reference to work fine with my join table before.

  • @timonyang
    @timonyang 2 месяца назад +4

    possibly an unpopular opinion, but can you minimize the facecams or offset it to the side and show info/text instead? like your older videos. showing only facecam adds little to the context

  • @jonutoftnielsen2655
    @jonutoftnielsen2655 Месяц назад

    Please make a video about your full dev stack.

  • @seriousjan5655
    @seriousjan5655 2 месяца назад

    Repository pattern does not help you with safety but with decoupling code. "Under" your "repository pattern" still needs to be some SQL so if you feed some unchecked strings or SQL engine will not handle this, you are screwed.

  • @JohanStrandOne
    @JohanStrandOne 2 месяца назад

    ok you win You got me curious. What's your go dev stack?

  • @thestarks685
    @thestarks685 2 месяца назад

    Quick question what font and color scheme are you using ?

  • @dansouza1623
    @dansouza1623 2 месяца назад

    It would be interesting to see how well this plays with instrumentation (opentelemetry). Can sqlc generate instrumented boilerplate?

  • @NarantsatsraltGanchuluun
    @NarantsatsraltGanchuluun 2 месяца назад

    Hi, what is the theme you are using?

  • @iatomic_1
    @iatomic_1 2 месяца назад

    how do u handle validation if its setup this way?
    i don't wanna rewrite the structs just to add the bindings

    • @dreamsofcode
      @dreamsofcode  Месяц назад

      I usually handle validation above this layer, typically during the http handler.

  • @PreetimanMisra
    @PreetimanMisra 3 месяца назад +1

    Bananas near anything related to code/coding always remind me of Joy of Code

  • @deckardcain9012
    @deckardcain9012 2 месяца назад

    Does anybody know what the Browser used in the B-Roll is called?

    • @M3MYS3LF1979
      @M3MYS3LF1979 2 месяца назад

      Think some other comments said it was zen browser. Which wildly enough, I hadn't heard of until today when watching the fireship video on the firefox zero day

  • @dotcom1517
    @dotcom1517 Месяц назад

    Can anyone tell me what theme and font he is using?

  • @kf5268
    @kf5268 2 месяца назад

    Pani Szumlewicz w momencie dyskusji o ebookach i książkach ujawniła, że w sumie to jest solidnie poza tematem i włączyło jej sie coś na zasadzie pięćdziesięcioletniej polonistki, która się odkleiła i będzie w kółko mówić o tym co przeczytała i jakie książki są godne...
    Dalej dygresja o filozofii, z całym szacunkiem niczego nie udowadnia, poza tym, że wywołania pisane przez Panią wyprodukowała nie taki obrazek jaki oba sobie wyobrażała... 😅
    Pani po prostu zupełnie nie rozumie tych konceptów co w sumie jest smutne w przypadku kogos kto zajmuję miejsce ekspera w takiej debacie

  • @djkim24601
    @djkim24601 2 месяца назад

    Thank you so much

  • @triforce42
    @triforce42 2 месяца назад +1

    If you don't mind the feedback, could you reconsider the "whoosh" sound effect? I personally find it quite distracting.

    • @dreamsofcode
      @dreamsofcode  2 месяца назад +2

      Thanks for the feedback! I'll pass this on to my editor

  • @AK-vx4dy
    @AK-vx4dy 3 месяца назад

    "Strong raction" epic ;)

  • @Rein______
    @Rein______ 2 месяца назад +4

    NOT sold in this at all. Sorry. If you want a ORM use a ORM. If you want SQL, use SQL. But this??? It's not as powerfull as a ORM, but more complicated than just SQL. I dont see it.

    • @dreamsofcode
      @dreamsofcode  2 месяца назад

      That was my first reaction as well 😅

    • @Rein______
      @Rein______ 2 месяца назад +1

      ​@@dreamsofcode Haha. It's a fun problem to try to solve: 'orms seem to complicated, i surely can do it better/simpler, right?' I have tried it as well. For now i have landed on using a good orm for read/write scenario's. For 'reads only' direct sql works great. You can use both in the same project.

    • @spartan_j117
      @spartan_j117 2 месяца назад

      @@Rein______ Take a look into go-jet/jet. You'll like it.

  • @theyioel
    @theyioel 2 месяца назад

    What are your thoughts about SQLx and Turso/libSqlite if they come to the ecuation?

  • @cg219
    @cg219 2 месяца назад

    What browser are you using?? 🤔

    • @tkg__
      @tkg__ 2 месяца назад +1

      Zen Browser, a Firefox fork.

  • @bjo004
    @bjo004 2 месяца назад

    What about flyway and liquibase?

  • @samuelborn9004
    @samuelborn9004 2 месяца назад +1

    Those Swoosh sounds when doing an animation are way to bassy and loud for my liking

  • @scriptbot806
    @scriptbot806 25 дней назад

    Does the resulting source code take into account SQL injection?

  • @sascha1461
    @sascha1461 3 месяца назад

    oh i didn't know about this override thing. Gotta check if this works with mysql too :)