conroy

I did want to address the last point in your comment.

> This works great until you have a query like `SELECT * FROM foos WHERE field = $1`

When sqlc sees a query with a *, it rewrites the query in the generated code to have explicit column references. For example, if you have an authors table with three columns (id, name, bio), the following query:

  SELECT * FROM authors WHERE name = $1;

  SELECT id, name, bio FROM authors WHERE name = $1;

SQLite uses a custom parser generator called lemon[0] to parse SQL queries. Sadly that parser is deeply entwined with SQLite itself; it's not trivial to extract a full AST.

My current plan (still a work-in-progress and by no means final) is to use sqlparser-rs[1] via wasmtime. The AST produced by this crate is very high quality and it supports multiple dialects of SQL.

[0] https://www.sqlite.org/lemon.html [1] https://github.com/sqlparser-rs/sqlparser-rs

This isn't accurate. sqlc is a self-contained binary and does not have any dependencies. Docker is one of the many ways to install and run it, but it is not required. (author of sqlc)

The fact that no one internally was given a heads up about the post shows you how much respect the leadership team has for their employees.

> Full transparency. All salaries, equity, companies financials and so on are visible to everybody in the company.

It’s the only way to ensure that a company’s stated values are accurate.

"With a net worth of $134.7B, Musk recently surpassed Bill Gates as the second-richest person in the world, and he's on track to earn more than $50 billion in stock options. If he remained in California, he’d be facing income taxes on the profits when he exercises them. In Texas, there is no income tax."

https://github.com/orgs/stripe/sponsoring

https://github.com/orgs/cognitect/sponsoring

Why not implement this like a tax bracket? For the first $1 million each year, Apple's commission is 15%. For each dollar after that, the commission rate is 30%. No programs, no application process.

Location: San Francisco, CA

Remote: Yes

Willing to relocate: Maybe?

Technologies: Go, SQL, React, Ruby, gRPC, distributed systems

Résumé/CV: https://conroy.org/ | https://github.com/kyleconroy

Email: kyle@conroy.org

leeoniya, if you’re reading this, please apply to GitHub sponsors so I can give you money.

> For now, this is only available for Workers that are deployed to a “root” hostname like “example.com” and not specific paths like “example.com/path/to/something.” We plan to introduce more optimizations in the future that can preload specific paths.

    type Null(type T) struct {
        Val   T
        Valid bool // Valid is true if Val is not NULL
    }

[0] https://tip.golang.org/doc/go1.15

> I was there last night and it's such a cool pseudo utopian place

> The media coverage of it is WILD

> People on the internet are convinced it's protected by armed guards and people are dying of hunger and instead its...like a music festival campground

> There are speakers, musicians, art walls. I took a group pic for a bunch of black guys last night and they were so proud of what was built because they felt like they fought for it, which in a sense, they did.

> I was there last night and it's such a cool pseudo utopian place

> The media coverage of it is WILD

> People on the internet are convinced it's protected by armed guards and people are dying of hunger and instead its...like a music festival campground

> There are speakers, musicians, art walls. I took a group pic for a bunch of black guys last night and they were so proud of what was built because they felt like they fought for it, which in a sense, they did.

sqlc currently has great support for Go and experimental support for Kotlin. I'm planning on adding TypeScript support in the future, so it's great to see that others in the TypeScript community find this workflow useful.

[0] https://github.com/kyleconroy/sqlc

Work continues on sqlc, my SQL compiler side project. I recently released v1.3.0, which mainly consisted of big fixes.

I’m really excited about the in-browser playground I launched at https://play.sqlc.dev. I hope it gets more people to install sqlc locally.