[Backend #4] Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx & sqlc

[@TECHSCHOOLGURU]

Hello guys, if you're using Windows, you can use sqlc inside a Docker container: docs.sqlc.dev/en/latest/overview/install.html#docker And generate code using this command: docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc generate I think you will need to replace the $(pwd) with your current folder because it's kind of volume mapping.

[@mustafaemin7389]

Open powershell in your project directory then paste that: docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc generate That worked on my system.

[@cariyaputta]

I'm on Windows 11 and facing another issues, any idea on this: project-folder> docker run --rm -v :/src -w /src kjconroy/sqlc generate error parsing sqlc.json: file does not exist make: *** [Makefile:17: sqlc] Error 1

[@cariyaputta]

I have resolved it. The issue is that when run it inside make, it will ignore the ${pwd} part If some one run into this issue with the Makefile. add these lines into your file: makeFileDir := $(dir $(abspath $(lastword $(MAKEFILE_LIST)))) sqlc: docker run --rm -v $(makeFileDir):/src -w /src kjconroy/sqlc generate

[@mfc1190]

@@cariyaputta Thanks, this was helpful!

[@thorfinnthegoatmc]

@@mustafaemin7389 Thank you so much bro

[@jarriabidi1438]

this is gold. i have been very confused about how to add type safety to my db code while maintaining performance and not learning a ton of new syntax. this sqlc thing is amazing

[@TECHSCHOOLGURU]

yes, it's really is amazing :)

[@Dzikrullah_999]

you are a talented and patient teacher. The world is better with you Tech School !

[@CiroSilvano-yn7ow]

Thank you for this amazing content! I'd like to add that the pq driver is less maintained and hence may not be the best choice anymore. After following the lecture I migrated to pgx version 4, which is now well supported by sqlc (v5 is still experimental).

[@vonmutinda4888]

Even with months of writing Go code, I still find these videos super useful. Would you kindly touch on Design Patterns in later videos. Thanks.

[@TECHSCHOOLGURU]

Thanks von. Great suggestion, I will try to make some videos about it in the future.

[@berkekaancetinkaya8721]

Following this with a windows machine is a nightmare :) Besides the series is awesome!!

[@vedantshinde2277]

Did you manage to get it running? I'm getting an error while executing this command: "docker run --rm -v C:/Users/vedant/src -w /src kjconroy/sqlc generate" It either says that "error parsing sqlc.json: file does not exist" or schema.sql doesn't exist.

[@berkekaancetinkaya8721]

@@vedantshinde2277 No i have found an another solution which is switching to Linux 😂

[@MrVirusbkhn]

i found new horizon, all of your tutorial which exactly is my orientation. Thank for your effort, hope you will product quality videos, like this :D

[@TECHSCHOOLGURU]

Glad I could help!

[@sekirandahamza1260]

I feel sad that such an informative video (series) has over 13989 views and just few likes. Like the damn video, it's the only payment you're going to make for this free awesome information. Thanks TECH SCHOOL ,keep it up.

[@TECHSCHOOLGURU]

Thanks a lot, Sekiranda!

[@AdityaFingerstyle]

18:16, rows.Close() is already deferred and then called again.

[@TECHSCHOOLGURU]

nice catch :D

[@GmanGavin1]

Wow, I'm very surprised by how informative this video is.

[@TECHSCHOOLGURU]

Glad you think so!

[@dwiwahyudi9698]

Hi, Thanks for the video, this really help me a lot. Btw, For parameters (CreateAccountParams, etc...), Are there any reason not used parameters in models.go (Account, Entry, etc..) like Account models object in return, ex: > func (q * Queries) CreateAccount(ctx context.Context, arg Account) (Account, error) Because, I already try to use Account models as input and return for CreateAccount function, and the result is still the the same. Thanks.

[@budipr6448]

Hi, I was trying it and got this message : the PostgreSQL engine does not support Windows. Any advice would be appreciated, thanks

[@Saulsotog]

this series of videos are really great

[@TECHSCHOOLGURU]

Thanks, Saul Soto!

[@hoonj2500]

Nice utilization of Makefile

[@shellixupdates6125]

If you should not edit the generated files manually, then how do you use `json:",omitempty"` with sqlc ?

[@orkhanrustamli2039]

Hey, great tutorial as always. Question, in my work usually db comes with pre defined schema which is defined by db engineers which means I do no have schema at hand to feed sqlc. What would be your approach in this case?

[@TECHSCHOOLGURU]

Hey Orkhan, I think sqlc automatically queries the database to know its schema. You can give it a try and please let me know if it's not the case.

[@orkhanrustamli2039]

@@TECHSCHOOLGURU I could not find property to show database address so that sqlc will try to fetch schema from db. I think this is the only major downside of sqlc,

[@user-sk4nt5bm5r]

Could you update this to reflect sqlc version 2 config file? It is quite different. Thanks for the course btw. I think v2 sqlc.yaml should look like this: version: "2" sql: - schema: "./db/migration/" queries: "./db/query/" engine: "postgresql" gen: go: package: "db" emit_json_tags: true out: "./db/sqlc"

[@AhmedAli-jx9ie]

up

[@aliadel1723]

Thank you bro

[@apoorvamishra5952]

slqc.yaml is different in the latest version 1.17.2 and with lesser options

[@rishabhagrawalzra]

Hi @TECH SCHOOL, what is the meaning of context.Context, and why we are passing this. Can you pls elaborate on this? Thanks loved your content

[@TECHSCHOOLGURU]

We use context to control the lifetime of a process, so we can easily stop processing if the context has been canceled. For example, if the client calls your API and only waits for 1 second, but your API takes 5 seconds to complete => then after 1 second, the client has already canceled the request => so the server can stop working on it immediately.

[@MorbidPasta]

@@TECHSCHOOLGURU lol that's the easiest way i've ever heard someone explain it, thanks for that.

[@Mona001-01g]

Are there any pre requisite video to this lesson 4 video that I can follow to understand the file contents of files generated with sqlc generate command?

[@panggilmeiam]

Damn bro! Thank you very much!!! I learn a lot!

[@toledot]

sqlc v1.20.0 on MacOS will not generate the file named "account.sql.go". Is it correct? or do I do anything wrong?

[@apramaysingh1291]

You have to add comments above your query file's instruction like so: #Here the "-- name: createUser' is the name of the function and ":one" indicates a returning of a single schema INSERT into users ( username, hashed_password, full_name, email ) VALUES ( ?1, ?2, ?3, ?4 ) RETURNING *; This way SqlC know how to actually generate the function

[@nityanandagohain4154]

hands down, this is amazing. Thank you for making this

[@TECHSCHOOLGURU]

Glad you liked it!

[@pakersmuch3705]

Love it! Thanks.

[@kyphanquoc6824]

I wonder a extension for .sql file of your vscode? I try install some extensions but it don't work (ex: SQL SERVER (mssql), Prettier SQL VSCODE). Please, help me :^^

[@robertommmin5]

Gold Mine! Thank you

[@afiqurrahman2884]

I found this problem the postgresql engine requires cgo.please set CGO_ENABLED=1. I try export in makefile but still same

[@HelloWorld-tn1tl]

version 2 is preferred now.

[@DrPanesar]

Hi, I've used sqlc for the first time. I wonder can you use it to write your one more complex SQL statements such as If and multicolon operations. It does not build go functions then using the sqlc generate command. I wonder if you can write it manually and then have sqlc run your own function / code?

[@TECHSCHOOLGURU]

Hi Paramjit, sqlc can generate code for many different types of complex queries. You can try it on your own to see if it works for your specific case or not. In case it doesn't work, you can always write your own code using the standard db/sql library, and use it together with other functions generated by sqlc.

[@budi0580]

You should add sqlboiler into the list

[@ThapakornTantirattanapong]

MySQL is now usable?

[@tradealert3802]

Why not use sqlc to also handle the creation of the tables rather than using go migrate? Is there a way to also do migration with sqlc

[@TECHSCHOOLGURU]

Each tool has its own purpose. Sqlc was not designed to run DB migrations.

[@akashrajvanshi6362]

What is diff btw this playlist and udemy course???

[@TECHSCHOOLGURU]

Hi Akash, Several people have asked this question in Tech School's discord server. discord.com/invite/BksFFXu Here's my answer: The content is the same. The only difference is, there are ads on KZbin videos, and on Udemy you will get a certificate of completion if you finish the course. I created Tech School with the purpose of providing free education, so anyone who can't afford to buy the course can still learn for free on KZbin. A lot of students who already watched youtube videos also purchased the course on Udemy as a way of supporting my mission.

[@LewisFlorezRenza]

I can't installed on Windows, I got a message about dll library is not found. any solution?

[@mcgam3r_tv809]

Amazing thanks brother!

[@Llanilek]

How do you nest foreign key data into the sql query?

[@viktorkot992]

for windows docker run --rm -v "%cd%:/src" -w /src kjconroy/sqlc

[@TECHSCHOOLGURU]

Thank you!

[@idirdev3729]

Thanks for these great videos, Could you Pls show us the best way to make a bulk insert?

[@TECHSCHOOLGURU]

Great suggestion, Idir! I will try to make a video about it in the future.

[@Nexjsdeveloper]

Worth as gold. I don't now how can i thank you

[@TECHSCHOOLGURU]

Thank you! You can support us by liking & sharing the videos, or buy us a coffee. ^^

[@pol3na]

Did anyone have issue with installing sqlc on linux? installed it using snap, when i typed sqlc version it said that command not found.

[@xerofit1397]

Hi Quang, thanks for the vid! sqlc is really amazing. I have a question though, when we're writing a query for generating sqlc code that involves more than one table and requires a join let's say table A and B, where is the best practice to store that query? A.sql, B.sql, or create a new A-B.sql (Sorry if the example lacks in context, I can't think of a real case). Thank you!

[@TECHSCHOOLGURU]

Hi Xerofit, I think where to store the query might depend on the context of the use-case. If the data you're querying is more of A (and just some additional data from B), then you can put it in A.sql (and vice-versa) For some specific use-case, you might even put the query in its own separate file if you want.

[@xerofit1397]

@@TECHSCHOOLGURU Thank you!

[@introvert9639]

Sqlc doc doesn't says about writing native queries or complex queries including multiple table joins etc. ....any idea?

[@TECHSCHOOLGURU]

Good question! You can write any complex queries and generate code for it with sqlc. For example: -- name: GetEntryWithAccount :one SELECT e.*, a.owner, a.balance FROM entries as e JOIN accounts as a ON e.account_id = a.id WHERE e.id = $1 LIMIT 1;

[@hafizmfadli]

this is amazing course !!!!!!!!!!!!

[@TECHSCHOOLGURU]

Thank you!

[@muhammadsesay7487]

This is very amazing.

[@devfun3032]

Hey bro. Sqlc release version 1.10. Now, What should version use? Thanks

[@TECHSCHOOLGURU]

Hey, I think you can go with the latest version.

[@ddlelo8489]

Please make video to create a REST API continuing this process

[@TECHSCHOOLGURU]

Sure, Elo. Coming up next week!

[@rizkimuntohary7350]

Thankyou this is amazing

[@TECHSCHOOLGURU]

Thank you!

[@jeremyjohns9615]

How much would be the difference if we use sqlx instead of sqlc? Because I am facing issues while installing sqlc on my computer (using Windows 10 Home). Can we still follow your tutorial while using sqlx?

[@TECHSCHOOLGURU]

Hi Jeremy, you can use sqlx if you want. The only difference is that if you use sqlx then you have to implement all the CRUD yourself, while if you use sqlc then they're automatically generated for you. If you have docker running on your Windows machine, then you can try this to generate sqlc code with docker run: github.com/kyleconroy/sqlc#docker docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc generate

[@jeremyjohns9615]

@@TECHSCHOOLGURU if the only difference is implementing the CRUD functionality, I will give it a go when I give up installing sqlc. I have pulled an image using docker pull, but when I run the docker run command, it shows an error. Do you need to replace "pwd" command with something else while running docker run?

[@TECHSCHOOLGURU]

Sorry I don't have a Windows machine so I don't know. It seems like developing on a Windows machine is not very easy. So perhaps you can try to switch to linux or mac instead?

[@parvineyvazov]

You can run like this: docker run --rm -v "%cd%:/src" -w /src kjconroy/sqlc generate

[@sajirmohd]

I didnt have error even without 'go mod init' Why we are initializing go mod then?

[@TECHSCHOOLGURU]

Hi Sajir, That's a good question! The command `go mod init` creates a `go.mod` file to keep track of all external modules that your project depends on. So if you don't have any dependencies, then you probably don't need it. Besides, if you're writing a library module (like an open-source library for example), then it's very important that you run `go mod init` with a valid path from which your module can be downloaded by Go tools. You can read more about how to create a module here: golang.org/doc/tutorial/create-module

[@daryalazareva9664]

Hi! Thanks for the videos, they're amazing! I have an error while running 'sqlc init': Error: open sqlc.yaml: permission denied. Does anyone know how to fix it?

[@daryalazareva9664]

it helped to use sqlc inside a container running command docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc init using ubuntu by the way

[@faizulla5838]

Author is hear ? How work without GORM?

[@milanpanic3755]

is this out of date in 08 Oct 2024 ?

[@jcolindres001]

Hi Sir, Excellent training! Do you know a tool / library like sqlc for generating graphql in go? Regards, JA

[@pawelprusinski5251]

So it sounds that best way (speed) is to use std library and do 4 functions for CRUD.

[@TECHSCHOOLGURU]

Yeah, the best way for speed is to use sqlc to generate code that use standard db/sql package. We can also combine sqlc with other package like db/sql or db/sqlx for some cases that sqlc cannot generate codes (because the query is too complex for example)

[@connorjcantrell]

@@TECHSCHOOLGURU This is an interesting concept. I am curious to see an example of this

[@huunam1001]

I have problem when query LIKE OR ILIKE with SLQC. Is any body here to help me. Other, I wonder if SQLC use normal SQL statement?

[@TECHSCHOOLGURU]

Yes, you can use LIKE or ILIKE as normal query. If you want to discuss more, feel free to join Tech School's Discord group to chat directly with me and other student: bit.ly/techschooldc

[@XuanQuynhLexuanquynh]

thank for sharing.

[@TECHSCHOOLGURU]

Thank you for watching!

[@bishanrasaili7246]

After I write the query file and run the command 'sqlc generate', I get the error simple_bank\db\migration\000001_init_schema.up.sql:1:1: the PostgreSQL engine does not support Windows. Can someone please help me resolve this issue ?

[@TECHSCHOOLGURU]

Hi Bishan, Some of my students have successfully generated the code using sqlc on Windows with this approach: - Setup WSL and run the linux binary of sqlc like you would normally run an executable. docs.microsoft.com/en-us/windows/wsl/install-win10 Maybe you can give it a try? Or another approach using docker: First, pull the sqlc image. docker pull kjconroy/sqlc Then run the specific commands in the PowerShell as follows: docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc version docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc init docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc generate

[@namhuynh126]

R u Vietnamese. Thank u a lot for this video. It help me so much.

[@TECHSCHOOLGURU]

Yes I am. Thank you, Nam!

[@TheSatyrical]

For Window users: if other options don't work, try downloading WSL2 kzbin.info/www/bejne/jH69eWyGn5eXjtk Make sure to redownload (onto WSL2) Go, GCC, and make. You can use Go to install sqlc and everything should work. Also, you can download windows terminals (the base WSL2 terminal isn't good). And try out zsh.

[@TECHSCHOOLGURU]

Thanks a lot for the tip, Atropolith!

[@nitishsaini972]

But on windows, only MySQL is available and when you run sqlc generate it tells postgres not available for windows, any solution for that

[@michaelumeokoli]

@@nitishsaini972 I'm facing this same issue

[@phongnguyenthanh9577]

How to close database connection after done

[@TECHSCHOOLGURU]

Hi Phong, As per documentation of the database/sql package, we don't have to close the db connection: pkg.go.dev/database/sql#Open "The returned DB is safe for concurrent use by multiple goroutines and maintains its own pool of idle connections. Thus, the Open function should be called just once. It is rarely necessary to close a DB."

[@edarha7183]

how to create connection pool between golang and sql?

[@TECHSCHOOLGURU]

Hi Edar Ha. That's a good question! Actually when you use the standard database/sql package, there's already a basic connection pool implemented under the hood. There are several methods you can use to control the number of connections and their lifetime, such as db.SetMaxIdleConns(N), db.SetMaxOpenConns(N), db.SetConnMaxLifetime(duration) I will definitely make a video about this in one of the lecture. For now, you can read more about it here: go-database-sql.org/connection-pool.html www.alexedwards.net/blog/configuring-sqldb golang.org/pkg/database/sql/#DB.SetConnMaxIdleTime

[@edarha7183]

@@TECHSCHOOLGURU yep, thanks for your reply. What are you think about mongodb and driver mongodb in golang?

[@angnat05]

Got an error error, generating code: source error: 99:14: expected ';', found sql (and 1 more errors) , thanks for kind help

[@TECHSCHOOLGURU]

Hi @angnat, I can't help without seeing your codes first. Can you share your codes on a GitHub repo? And perhaps you can join Tech School's discord channel to chat directly with me and other students: discord.com/invite/BksFFXu It's faster and much more convenient to communicate than KZbin comments.

[@angnat05]

@@TECHSCHOOLGURU sure, would you mind to share invitation to discord?

[@TECHSCHOOLGURU]

yeah it's the link i posted in the previous comment: discord.com/invite/BksFFXu

[@sajirt2069]

After installing sqlc (verified with 'sqlc version'), i tried 'sqlc init' inside the project folder and i am getting an error, user@user-HP-Laptop-15-db0xxx:~/Projects/go-simplebank$ sqlc init Error: open : no such file or directory How to fix this?

[@TECHSCHOOLGURU]

Hi Sajir, This is really strange. I've never faced this error before. What version of sqlc are you using?

[@sajirt2069]

@@TECHSCHOOLGURU Thanks for the response sqlc version: v1.7.0 Also i didnt have error without 'go mod init' Why we are doing it?

[@TECHSCHOOLGURU]

Hey Sajir, I'm using slqc 1.6.0, so maybe there's something different. But someone pointed out in other comment that it may work if you run: sqlc init -f "sqlc.yaml" Maybe it's worth a try! Regarding your question about go mod init, I also answered in other comment, but will repost it again here: The command `go mod init` creates a `go.mod` file to keep track of all external modules that your project depends on. So if you don't have any dependencies, then you probably don't need it. Besides, if you're writing a library module (like an open-source library for example), then it's very important that you run `go mod init` with a valid path from which your module can be downloaded by Go tools. You can read more about how to create a module here: golang.org/doc/tutorial/create-module

[@bittom]

## **Generate CRUD Golang code from SQL | Compare db/sql, gorm, sqlx & sqlc** 关键是是用 SQLC 替代自己手写命令做 CRUD，目前仅仅支持 postgre Mac 上用 homebrew 安装 在之前文件夹中使用 sqlc init 创建 yaml 文件，然后 code . 打开，根据 github 1.4.0 版本设置相关配置 关键在于修改路径，很多文件都放到 db 单一文件夹下面的许多其他文件 后面几个参数是有具体含义，但是现在没全理解的时候暂时不考虑，注意后面的 exact_table_name 仍然设置为 false 还是关键表示方法 ### Create 使用 sql generate，在新的文件夹生成后建立 .sql 数据库文件 在 github 文件当中找到 start 相关配置，注意此时 primary key 和其他 default 相关字段会自动生成，此处给出自己要做的内容就好 首次使用 sqlc generate 后，在 sqlc 文件夹生成三个文件，models.go 会自动生成数据库字段相关结构的文件，也是跟 yaml 文件规定的格式相关，比如 json 字段是否显示 注意此时的 db.go 文件使用 DBTX 相关操作，主要是用 db 或者 TX 来使用查询 最后看到 account.go 文件，其中数据结构和方法如何实现 go mod init 到 github，生成文件之后 go mod tidy 目前还没有各种外部包 注意不能修改 sqlc 生成的 go 文件，每次都是 sqlc generate 根据 .sql 生成新文件就行 ### Read 此处有 Get 和 List 两种方法，从 start 文件找到后根据自己数据库字段对应修改 ### Update 此处是不返回只是执行的 :exec 标签，但是最后还是加上 RETURN 可以返回相关信息 ### Delete 此处也是执行，但是结构比较简单

[@mechtarin]

I used database/sql in my project if anyone with windows dont try to use sqlc it does not work what ever you do it works only with mysql and that's not a good idea to use experimental thing

[@TECHSCHOOLGURU]

I don't think what you said is true. SQLC works for Postgres, no mater if you're on Windows or not. You can try using Docker on Windows to generate the code: docs.sqlc.dev/en/latest/overview/install.html#docker

[@mechtarin]

@@TECHSCHOOLGURU i have tried it gave me this error the PostgreSQL engine does not support Windows I used docker with docker run --rm -v ${pwd}:/src -w /src kjconroy/sqlc generate

[@vedantshinde2277]

-- name: ListTransfers :many SELECT * FROM transfers WHERE from_account_id = $1 OR to_account_id = $2 ORDER BY id LIMIT $3 OFFSET $4; filtering using 'AND' keyword instead of 'OR' would make more sense, no? -- name: ListEntries :many SELECT * FROM entries WHERE account_id = $1 ORDER BY id LIMIT $2 OFFSET $3; Is it okay if the entries are ordered in descending order of account_id?

[@TECHSCHOOLGURU]

1. It depends on the use case. If you just want to list all transfers from account 1 to account 2 then use AND. In this case, I want to list all transfers of the same account (either going in or out), so I use OR, and if you look at the TestListTransfer function, you will see that I pass the same account ID into the function. 2. This query list all entries of 1 specific account (in the WHERE clause), so it doesn't make sense to order by account id, since there is only 1 account ID in the result, right?

[@vedantshinde2277]

@@TECHSCHOOLGURU Sorry, I meant order by created_at in a descending fashion.

[@davidontiveros2895]

ughhh crap. Got stuck until this point. Using Windows 😥

[@TECHSCHOOLGURU]

Hi David, have you tried using Linux Subsystem on Windows 10? docs.microsoft.com/en-us/windows/wsl/install-win10

[@davidontiveros2895]

@@TECHSCHOOLGURU yes, actually I kept reading and saw the docker comment. So I am running sqlc on a container. It works fine. Thanks for replying and btw your videos are top notch! Congratulations!

[@vedantshinde2277]

@@davidontiveros2895 Hey... I'm getting an error while executing this command: "docker run --rm -v C:/Users/vedant/src -w /src kjconroy/sqlc generate" It either says that "error parsing sqlc.json: file does not exist" or schema.sql doesn't exist. I can barely find any help on forums and the documentation just sums it up in a line. Any help would be appreciated

[@davidontiveros2895]

@@vedantshinde2277 I ended up using the linux binary of sqlc like techschool mentioned. If you are running Windows you can setup WSL and run the binary like you would normally run an executable.

[@vedantshinde2277]

@@davidontiveros2895 I did that exact thing and it worked like a charm! Thank you!!

[@mannerism6286]

Has anyone come across 'panic: runtime error: invalid memory address or nil pointer dereference' after running make sqlc?

[@bobnicholson1011]

I have the same problem and cannot figure out what’s causing it. It occurs on “sqlc generate”. I’m on a mac trying to use 1.8 sqlc.

[@mannerism6286]

@@bobnicholson1011 i think you should check typos in the fields. My issue was the typo.

[@bobnicholson1011]

@@mannerism6286 I figured it out. Somehow I had commas at the end of my migration file names. It appears that it did not affect the migrations. But, it seems to cause a problem for "sqlc generate”. Thanks to your response, I continued looking.

[@buacomgiadinh1]

Please make text bigger, thank you

[@TECHSCHOOLGURU]

Hi Ha Do, Thanks for the suggestion. It's quite readable to my eyes. Can you try to watch the video in HD or 4K to see if it's clearer to you?

[@buacomgiadinh1]

TECH SCHOOL thank you for your answer, i use smart tv and iPhones to watch your video. Thank you for your great work

[@jeremyjohns9615]

Did someone successfully installed sqlc on Windows? (using Windows 10 Home)

[@TECHSCHOOLGURU]

Perhaps you can try running sqlc with docker: github.com/kyleconroy/sqlc#docker

[@vedantshinde2277]

Did you manage to get it running? I'm getting an error while executing this command: "docker run --rm -v C:/Users/vedant/src -w /src kjconroy/sqlc generate" It either says that "error parsing sqlc.json: file does not exist" or schema.sql doesn't exist.

[@kzm694]

source code on github??

[@TECHSCHOOLGURU]

Hi Bardia, it's in the description: github.com/techschool/simplebank

[@mechtarin]

the PostgreSQL engine does not support Windows yeey

[@visa2256]

yo I am having this prob rn lol

[@TECHSCHOOLGURU]

Hi guys, I think you can try using Docker to generate the code: docs.sqlc.dev/en/latest/overview/install.html#docker

[@mechtarin]

@@TECHSCHOOLGURU i tried it does not work

[@davidle5711]

Hi is sqlc not supported on Windows ? the first time I run go get github.com/kyleconroy/sqlc/cmd/sqlc it was okay. But when I run go install github.com/kyleconroy/sqlc/cmd/sqlc I got the error lfittl\pg_query_go\parser\include/port.h:17:10: fatal error: netdb.h: No such file or directory Anyone encounter the same error as me ?

[@TECHSCHOOLGURU]

Hi Leong, can you try to run sqlc using docker run as described here? github.com/kyleconroy/sqlc/#docker

[@jeremyjohns9615]

@@TECHSCHOOLGURU I have pulled an image using docker pull, but when I run the docker run command, it shows an error. Do you need to replace "pwd" command with something else while running docker run?

[@vedantshinde2277]

Did you manage to get it running? I'm getting an error while executing this command: "docker run --rm -v C:/Users/vedant/src -w /src kjconroy/sqlc generate" It either says that "error parsing sqlc.json: file does not exist" or schema.sql doesn't exist.

[@until_4ever362]

sqlc does not support windows, unhappy

[@TECHSCHOOLGURU]

Hi Ezzz, sqlc is written in Go, so I'm pretty sure it can run on Windows. Can you try to install it using go get? go get github.com/kyleconroy/sqlc/cmd/sqlc Otherwise, you can still run it within a docker container: github.com/kyleconroy/sqlc#docker docker pull kjconroy/sqlc docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc generate

[@until_4ever362]

@@TECHSCHOOLGURU go get or use git clone for go build，the same error： No such file or directory

[@TECHSCHOOLGURU]

How about run it with docker? docker run --rm -v $(pwd):/src -w /src kjconroy/sqlc generate Or perhaps try to build a binary of sqlc from source github.com/kyleconroy/sqlc#building, then use it to generate the codes?

[@namhuynh126]

U can try wsl2 for window. Wsl2 is very simple for install and it strong right now. I don't have install dual os anymore.

[@LarryWEitel]

Has anyone resolves sqlc not running on windows?

[@michaelumeokoli]

Hello I keep getting this # package bankdb C:\Users\user\Desktop\GO-STUFF\BANK-APP\db\migration\000001_init_schema.up.sql:1:1: the PostgreSQL engine does not support Windows

[@TECHSCHOOLGURU]

Hi Mikey, On Windows, you can run sqlc using Docker as suggested in their documentation page: docs.sqlc.dev/en/latest/overview/install.html#docker

[@aliadel1723]

anyone facing the problem of error parsing sqlc.yaml: yaml: unmarshal errors: line 2: field packages not found in type config.Config make: *** [Makefile:19: sqlc] Error 1 sloving with: version: "2" sql: - schema: "./db/migration/" queries: "./db/query/" engine: "postgresql" gen: go: package: "db" emit_json_tags: true out: "./db/sqlc" and makeFileDir := $(dir $(abspath $(lastword $(MAKEFILE_LIST)))) sqlc: docker run --rm -v $(makeFileDir):/src -w /src kjconroy/sqlc generate

[@BasicInfo-gg1lo]

my all query is running but insert query is not running what I do if am unable to make account