xo VS JSON-to-Go

i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

I use xo https://github.com/xo/xo . It generates CRUD queries by default so i don't have to write basic queries and it has option to write complex queries like sqlx. Only issue is it is not well documented.

SQL is an old, irregular language to work with, but it is better known than HCL and SQL already has it's own Pulumi/CDK in the form of every ORM with introspection (like Javascript's Prisma, Python's Django, Go's XO etc) and QueryBuilder (LINQ, Knex, etc) in whatever programming language you prefer. You probably already know it.

I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.

Sorry for the confusion, we're not generating the database client itself, more like generating an ORM around a database client. The ORM takes these database clients as dependencies. It's very similar to the way XO works with it's multi-database support: https://github.com/xo/xo/tree/master/_examples/northwind

i use xo . Reason is i prefer designing schema first and creating golang scaffolding later. Xo takes schema and gives me basic create/update/delete operations by default and i can also generate gocode for any sql queries that i write.

Thanks for sharing your thoughts! I see that it works best with Postgresql. The other commenter mentioned https://github.com/xo/xo for MySql which might work well.

Thanks for your comment and question @onionisfruit. Top-notch handle too!

>> What are your plans for models and persistence?

I haven't worked out all the details, but it's going to be some blend of https://github.com/xo/xo and https://sqlc.dev/.

Design goals:

1. High-level, type-safe "ORM" that's generated from your database schema.

That site likely uses Matt's lib for that functionality: https://github.com/mholt/json-to-go

https://mholt.github.io/json-to-go/ is a nice tool for generating a struct definition to fit some sample JSON.

json-to-go is your friend.

JSON to struct. I use this about 100 times a day, no joke.

https://mholt.github.io/json-to-go/

Do your best to get static types on everything. Play a game with yourself where interface{} is banned and try to do your work. One of the most common sources of such loosely-typed values in JSON, so I'll point out this automatic struct generator for instance. If you have questions about a specific place you don't see how to avoid interface, feel free to ask. Every once in a while I do have to reach for something like this, but it should be rare.

But given we know ChatGPT can't accurately generate structs from even moderately complex json objects why bother doing all of that legwork of verifying and chiding chatgpt, when you can just drop it into a tool like https://mholt.github.io/json-to-go/ and get a correct struct in a fraction of the time?

I use https://marketplace.visualstudio.com/items?itemName=maracko.json-to-go, which is an extension version of https://mholt.github.io/json-to-go/

I think using struct in such cases is almost always the right approach. There are tools which generates go structs from json this.