sqlc @sqlcdev

“SQL is actually pretty great” sqlc.dev San Francisco Joined October 2023

Tweets

46
Followers

113
Following

2
Likes

229

sqlc @sqlcdev

3 years ago

@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.

1 0 1 101 0

View Details

sqlc @sqlcdev

3 years ago

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

1 0 1 86 0

View Details

@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 (github.com/sqlc-dev/plugi…) which implements the interface. And for a full plugin example, see github.com/sqlc-dev/sqlc-….

0 0 1 88 0

View Details

sqlc @sqlcdev

3 years ago

@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. github.com/sqlc-dev/sqlc/…

1 0 1 59 0

View Details

sqlc @sqlcdev

3 years ago

Happy holidays! Everyone gets an early gift: our preview release of TypeScript codegen support in sqlc. sqlc.dev/posts/2023/12/…

0 0 2 535 0

View Details

sqlc @sqlcdev

3 years ago

@knaka You might try overriding the timestamp database type with `pgtype.Timestamp` which doesn't require changing the database driver from `database/sql`. docs.sqlc.dev/en/latest/howt…

1 0 0 38 0

View Details

sqlc @sqlcdev

3 years ago

@hariangr @jamesqquick Could we persuade you to try out our alpha TypeScript plugin and let us know what issues you run into? github.com/sqlc-dev/sqlc-…

0 0 0 24 0

View Details

sqlc @sqlcdev

3 years ago

@knaka You can use pgx/v5 as a database/sql driver: github.com/jackc/pgx/wiki…. Just make sure to remove `sql_package: pgx/v5` from your sqlc config.

1 0 1 56 0

View Details

sqlc @sqlcdev

3 years ago

@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. github.com/sqlc-dev/sqlc/…

0 0 1 26 0

View Details

sqlc @sqlcdev

3 years ago

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.

0 0 0 379 0

View Details

sqlc @sqlcdev

3 years ago

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

1 0 0 44 0

View Details

sqlc @sqlcdev

3 years ago

@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. github.com/sqlc-dev/sqlc-…

1 0 1 179 0

View Details

sqlc @sqlcdev

3 years ago

@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. github.com/sqlc-dev/sqlc/…

1 0 1 21 0

View Details

sqlc @sqlcdev

3 years ago

@abayomipo We're working on a TypeScript plugin and would love some feedback if you're willing to try it out. github.com/sqlc-dev/sqlc/…

1 0 0 338 0

View Details

sqlc @sqlcdev

3 years ago

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. sqlc.dev/posts/2023/11/…

0 0 4 470 0

View Details

sqlc @sqlcdev

3 years ago

@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.

1 0 1 50 0

View Details

sqlc @sqlcdev

3 years ago

@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. github.com/sqlc-dev/sqlc/… docs.sqlc.dev/en/latest/refe…

0 0 0 60 0

View Details

sqlc @sqlcdev

3 years ago

@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? github.com/walterwanderle…