sqlc

“SQL is actually pretty great”

[sqlc @sqlcdev]

In sqlc v1.24.0 we introduced a way to verify whether schema changes are safe to apply before they hit production. Let us know what other verification steps would be useful to prevent production database outages before they happen.

https://t.co/qYMLd2ebit

[sqlc @sqlcdev]

@k_omotani If you add more schema update statements, sqlc will have to do more work. But it shouldn't be perceptible because the extra work is so small relative to everything else that sqlc does.

[sqlc @sqlcdev]

@k_omotani Yes, sqlc builds up a catalog from your DDL statements each time it runs.

[sqlc @sqlcdev]

@gorilla0513 The documentation is unfortunately lacking. The plugin interface is essentially gRPC over stdin/stdout. A reasonable place to start is with our plugin SDK for Go (https://t.co/LFzkekZDPT) which implements the interface. And for a full plugin example, see https://t.co/WNzLhNOusc.

[sqlc @sqlcdev]

@itishrishikesh Sorry to hear that. There are critical elements of sqlc that don't build on Windows, although we just merged a workaround using WASM so Windows should be fully supported in the next sqlc release. You can try it now if you go install from the main branch. https://t.co/oI1ytxHbwA

[sqlc @sqlcdev]

Happy holidays! Everyone gets an early gift: our preview release of TypeScript codegen support in sqlc.

https://t.co/GKHK6opV2M

[sqlc @sqlcdev]

@knaka You might try overriding the timestamp database type with `pgtype.Timestamp` which doesn't require changing the database driver from `database/sql`.

https://t.co/ktcISedkYi

[sqlc @sqlcdev]

@hariangr @jamesqquick Could we persuade you to try out our alpha TypeScript plugin and let us know what issues you run into?

https://t.co/tNJmdBiarm

[sqlc @sqlcdev]

@knaka You can use pgx/v5 as a database/sql driver: https://t.co/WXTMHCRoH4. Just make sure to remove `sql_package: pgx/v5` from your sqlc config.

[sqlc @sqlcdev]

@vlod @jamesqquick Could we convince you to try out our TypeScript plugin? It takes your raw SQL as input and generates TypeScript source code to access your database.

https://t.co/lSrZDTjv4p

[sqlc @sqlcdev]

Just added GitHub as an authentication provider to sqlc Cloud, in case you don't have (or don't want to use) a Google account.

[sqlc @sqlcdev]

@toritori0318 It might not be exactly what you want, but sqlc.embed() can give you a little more control over your output struct types.

https://t.co/rX9XGKtDfU

[sqlc @sqlcdev]

@mikeschinkel @eatonphil @sqlc In case it's still relevant, we released sqlc-gen-go which is the sqlc internal Go codegen package extracted for use as an external plugin. Forking and modifying it to support alternative SQLite drivers should be easier than forking the entirety of sqlc.

https://t.co/WNzLhNOusc

[sqlc @sqlcdev]

@extrasalt1 @bunjavascript We have an alpha version of a TypeScript plugin available. Would love to get some early feedback if you're willing to try it out.

https://t.co/lSrZDTjv4p

[sqlc @sqlcdev]

@abayomipo We're working on a TypeScript plugin and would love some feedback if you're willing to try it out.

https://t.co/lSrZDTjv4p

[sqlc @sqlcdev]

We've extracted the sqlc Go codegen package as a separate plugin called sqlc-gen-go. So now you can fork and modify sqlc's Go output without forking the entirety of sqlc.

https://t.co/FRkYFSm375

[sqlc @sqlcdev]

@zztkm Are you writing a plugin in Go or something else? We will likely expose the internal/rpc interface soon so that a Go plugin can actually just implement the gRPC server interface directly and hand that to the sdk.

[sqlc @sqlcdev]

@ko_noike We use Go's os/exec CommandContext() function from the standard library. You can pass environment variables like PATH to your plugin using the `env` key in your configuration.

https://t.co/yWTeQRIfdu

https://t.co/XV0bZL4ijA

[sqlc @sqlcdev]

@voluntas What would supporting gRPC with sqlc look like? There is a community plugin, which maybe does something similar to what you have in mind? https://t.co/xXE1eGUQ3x