Viewing profile — mjibson

CockroachDB uses it as well (and is almost certainly the reason Materialize does): https://www.cockroachlabs.com/blog/efficient-documentation-u... Nice story: around 2016 the OP pr…

Having programmed in both Rust and Go: I mostly didn't need what this does in Go because my problem was usually solved by panic'ing, which prints a stack trace of each go routine, …

The setup you describe is very much not simple. I worked at a place with very good DBAs and our replication setup caused us more downtime than anything else. Cockroach and Spanner …

I'll guess: money. Postgres is decades old and was designed when the internet was smaller. Doing a large, fundamental change like this requires an already experienced person (or ma…

I wrote one of the listed tools (github.com/mjibson/esc) and am thrilled about this proposal. I think it's great and solves all the problems in a great way.

It's a single click. There's no double clicks in acme. Did you watch the youtube video? Acme is about 5% usable with a keyboard.

I've been using acme for ~6 years now and it's still my daily editor. I wrote a LSP client for it ( https://github.com/mjibson/acre ). acme is so weird because when you start out i…

Which version of CockroachDB was that? A few years ago it had a rudimentary heuristic optimizer that made plenty of poor choices. Today it has a quickly improving cost-based optimi…

Money prevents it. It takes money to host things and pay people to work on infrastructure. While people often volunteer to contribute to OSS products because they like or use them,…

Super mega ultra hard. It would take so much time for us to learn rust, port everything including all tooling, and fix new bugs we introduce that we wouldn't add any new features (…

The Control of Nature ( https://en.wikipedia.org/wiki/The_Control_of_Nature ) is a book that contains this essay and two others (one about Iceland attempting to divert lava flows u…

As a former Mormon, this is exactly correct and scary for that reason. I am ashamed that I used to think this way.

We have a conference room named Tardigrade.

sqlfmt gets pretty close to this: https://sqlfum.pt/?n=30&indent=4&spaces=1&simplify=1&align=2...

https://www.cockroachlabs.com/blog/sql-fmt-online-sql-format... was on here last week. It's a sql formatter based on the same paper prettier is.

As CockroachDB matures these kinds of things will slowly get added. But sqlfmt doesn't (currently) have a goal to format all SQL, just cockroach SQL.

Is that a thing? The Java driver must actually parse those and convert them. Java is crazy. https://github.com/mjibson/sqlfmt/issues/25 is the issue to track '?' as placeholders.

The formatter adheres to CockroachDB rules which is why it acts like you describe. Case is insensitive in names unless you double quote it. Postgres-style (CockroachDB is one) uses…

sqlfmt is inspired by the style of gofmt ( https://blog.golang.org/go-fmt-your-code ). The reason a tool having an opinion about formatting is useful is that it removes humans from…

Author here. Based on feedback I am going to make a sqlfmt binary for easy editor integration. You can currently already do this by using the CockroachDB binary ( https://www.cockr…

See my other comment. There are a few options for a local binary.

It's available as part of the cockroach binary ( https://www.cockroachlabs.com/docs/releases/v2.1.0-beta.2018... ) as a subcommand. And an external contributor has made a more stan…

I have one key permanently plugged in to my desktop at home. I have another on my keychain that I can use at work or if I'm travelling or whatever. This allows quick access to a yu…