mjibson

7 ms·

1.
by mjibson 3y ago
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 project was not yet open source, just a
2.
by mjibson 5y ago
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, allowing me to get enough of the way through figur
3.
by mjibson 5y ago
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 exist because many programmers observed that what you descri
4.
by mjibson 6y ago
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 maybe more than one) to devote a lot of time designing an
5.
by mjibson 6y ago
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.
6.
by mjibson 6y ago
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.
7.
by mjibson 6y ago
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 it's like "wait so I
8.
by mjibson 6y ago
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 optimizer that makes much better choices. Each release now has sig
9.
by mjibson 6y ago
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, not many are willing to write infrastructure that can handl
10.
by mjibson 7y ago
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 (but lots of new bugs!) for like 2-4 years and the compa
11.
by mjibson 7y ago
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 using pumped ocean water, one about south
12.
by mjibson 7y ago
As a former Mormon, this is exactly correct and scary for that reason. I am ashamed that I used to think this way.
13.
Randomized SQL Testing in CockroachDB(cockroachlabs.com)
15 points by mjibson 7y ago|0 comments
14.
by mjibson 8y ago
We have a conference room named Tardigrade.
15.
by mjibson 8y ago
sqlfmt gets pretty close to this: https://sqlfum.pt/?n=30&indent=4&spaces=1&simplify=1&align=2...
16.
by mjibson 8y ago
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.
17.
by mjibson 8y ago
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.
18.
by mjibson 8y ago
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.
19.
by mjibson 8y ago
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 "$1" for placeholders instead of "?". A
20.
by mjibson 8y ago
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 having to care about formatting. I didn&#x27
21.
by mjibson 8y ago
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.cockroachlabs.com/docs/releases/v2.1.0-b
22.
by mjibson 8y ago
See my other comment. There are a few options for a local binary.
23.
by mjibson 8y ago
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 standalone version at https:&#x2F
24.
Sqlfmt: an opinionated online SQL formatter(cockroachlabs.com)
207 points by mjibson 8y ago|89 comments
25.
by mjibson 8y ago
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 yubikey anywhere I am. My previous problem (when I owned
26.
by mjibson 8y ago
Yes. I won't use U2F on services that don't allow multiple keys because of this. I have two keys in different places so it's easy to use.
27.
by mjibson 8y ago
Enterprise allows access to various features like distributed backup and restore.
28.
by mjibson 9y ago
In Postgres, beyond the SQL PREPARE commands, there is also a protocol for executing prepared statements. Their client drivers almost certainly use this protocol, which would mean the normal placeholder safety applies. I think this is just
29.
CockroachDB Bulk Ingest from CSV(cockroachlabs.com)
2 points by mjibson 9y ago|0 comments
30.
by mjibson 9y ago
There were Jepsen tests done on Cassandra a few years ago: https://aphyr.com/posts/294-jepsen-cassandra that showed various failures. Some of these haven't been fixed yet: https://news.ycombinator.com&#

More ›