zachmu

9 ms·

61.
by zachmu 2y ago
Dolt's EXPLAIN output prints the execution tree directly. E.g.: explain select * from xy join uv on (x = u and u > 0) where u < 2; Project ├─ columns: [xy.x:2!null, xy.y:3, uv.u:0!null, uv.v:1] └─ LookupJoin
62.
by zachmu 2y ago
Of course the boundless compassion of the kind that permits public spaces to be littered with needles and fentanyl smoke is driven by a political ideology, come on.
63.
by zachmu 2y ago
The comments are full of people buying it completely
64.
by zachmu 2y ago
I'm on the basic plan and usually see about 75mbps. It can drop to 20 or so during peak netflix hours. But that's still plenty fast enough for multiple HD video streams. What we had before was much slower and much, much less relia
65.
by zachmu 2y ago
I just switched from long-range wireless to Starlink basic. It's 50% cheaper and much, much more reliable. Speeds are comparable (when the long-range wifi wasn't down, which it was pretty often). Long-range wifi had a data cap wit
66.
by zachmu 2y ago
The "damages" here come from reduced projected growth rates relative to a scenario without climate change. I.e. people will be richer than they are today in 2050, but poorer than they would have hypothetically been in a world with
67.
by zachmu 3y ago
Reading the fine print a bit more, I see this is limited to single-line completions. Copilot will often write complete blocks for me. Might still be nice to use when I'm on the road though.
68.
by zachmu 3y ago
JetBrains IDES already have copilot integration which works quite well and which I use constantly. This part piques my interest though: > It works locally and is available offline. This means you can take advantage of the feature even if
69.
by zachmu 3y ago
Nothing, it's just quite a bit more complicated to implement a backend that supports writes.
70.
by zachmu 3y ago
Yes, that's the idea. Writing a simple read only database back end is not too tough.
71.
by zachmu 3y ago
I don't think we do have any benchmarks of replication from mySQL, but I am positive there's no chance it can handle 10,000 TPS.
72.
by zachmu 3y ago
If your program integrates with mysql in production, you can use this for much faster local tests. It doesn't have to be a go program, although that makes it easier.
73.
by zachmu 3y ago
We are moving in that direction but it's not a primary goal at this point. Once we have more basic functionality working correctly in doltgres we will examine splitting off a separate package for it. The in memory implementation has a
74.
by zachmu 3y ago
I don't think this is in the cards for vitess, their whole architecture is built around managing sharded mysql instances.
75.
by zachmu 3y ago
Thanks! Let us know if you try it out, we're always interested in feedback. https://discord.com/invite/RFwfYpu
76.
by zachmu 3y ago
The vanilla package can replicate to or from MySQL via binlog replication. But since it's memory only, that's probably not what you want. You probably want to supply the library a backend with persistence, not the built-in memory-
77.
by zachmu 3y ago
Hi, this is my project :) For us this package is most important as the query engine that powers Dolt: https://github.com/dolthub/dolt We aren't the original authors but have contributed the vast majority of its co
78.
by zachmu 3y ago
This is a reasonable point, we'll run some benchmarks and publish them. We expect that it's faster than MySQL for small scale. Dolt is only 2x slower than MySQL and that includes disk access. https://docs.dolthub.com&#x
79.
by zachmu 3y ago
Vitess (a fork of it anyway) provides the parser and the server. The query engine is all custom go code.
80.
by zachmu 3y ago
Not a proxy in the traditional sense, no. go-mysql-server is a set of libraries that implement a SQL query engine and server in the abstract. When provided with a compatible database implementation using the provided interfaces, it becomes
81.
by zachmu 3y ago
Yes, triggers and stored procedures are supported. Concurrency is the only real limitation in terms of functionality. The bundled in-memory database implementation is mostly for use in testing, for people who run against mysql in prod and w
82.
by zachmu 3y ago
We haven't benchmarked the in-memory database implementation bundled in go-mysql-server in a while, but I would be surprised if it's any slower than MySQL, considering that Dolt runs on the same engine and is ~2x slower than MySQL
83.
by zachmu 3y ago
As I understand it, refinement culture has nothing to do with quality per se, rather it's about the elaboration of tropes and other recognizable patterns. Think ornamentation rather than architecture.
84.
by zachmu 3y ago
Interesting to think of this as an analog to refinement culture, where instead of endless elaboration and adding complexity, they are stripping away all unnecessary elements to discover the platonic ideal of marketable music.
85.
by zachmu 3y ago
Because almost nobody actually pays those prices > One key limitation of this study is that most of our analyses used manufacturer gross prices, not manufacturer net prices after rebates and other discounts are applied.16 Given the gene
86.
by zachmu 3y ago
When people complain about being forced to pay thousands a month for insulin, they're talking about the newest synthetic insulins that were developed very recently at substantial costs. They could take the older insulins for $50 a mont
87.
by zachmu 3y ago
The personality cult around her is very off-putting to some people (me). Also the fact that she slept with Larry Page while he was CEO. Sure it was a different time in American culture but it's still gross, and never gets brought up, o
88.
by zachmu 3y ago
Just reporting what I've noticed from my own cats. There's an entire aspect of their personality that doesn't come out when they are restricted to indoors. I don't think it's possible to fully replicate what cats ge
89.
by zachmu 3y ago
> A paper that appeared in Nature in 2013 put the number of birds killed by cats in North America at somewhere between 1.3 and 4.0 billion birds every year, a total that is mostly driven by unowned cats.32 If this figure were accurate —
90.
by zachmu 3y ago
Not in the same way. I've had indoor and outdoor cats. And I've had indoor cats that we started letting outside. The change in their behavior when they have access to the outdoors is palpable. They come alive in a very obvious and

More ›