Grades 9-12 feed into a regional high school, which also has its own school district containing just that school. It also has its own superintendent and principal.
I don't think "redundant" is a strong word for this situation.
3,028 karma · joined June 6, 2012
Email: evan @ skeema.io
Grades 9-12 feed into a regional high school, which also has its own school district containing just that school. It also has its own superintendent and principal.
I don't think "redundant" is a strong word for this situation.
This is mainly caused by having a ridiculous number of tiny towns and tiny school districts, each with redundant services and employees.
In a six-minute time period, you posted 10 different comments here, totaling nearly 800 words. I don't believe you are being truthful.
How does this company make money? Is it all just a ZIRP fever dream?
Did you find it worked reasonably well on any portion of the codebase you could throw at it? For example, if I recall correctly, all of MajorMUD's data file interactions used the embedded Btrieve library which was popular at the time. For that type of specialized low-level library, I'm curious how much effort it would take to get readable code.
No, it was 1 to 6 bytes until RFC 3629 (Nov 2003). AFAIK development of MySQL 4.1 began prior to that, despite the release not happening until afterwards.
Again, they absolutely should have addressed it sooner. But people make mistakes, especially as we're talking about a venture-funded startup in the years right after the dot-com crash.
> It literally does not take any more storage because it is a variable width encoding.
I already addressed that in my previous comment: in old versions of MySQL, a number of critical code paths required allocating worst-case buffer sizes, or accounting for worst-case value lengths in indexes, etc. So if a charset allows 6 bytes per character, that means multiplying max length by 6, in order to handle the pathological case.
Season 12 is particularly good though. In my opinion, the first and last episodes of that season are among the funniest they've ever done!
After that, they each wrote an additional Red Dwarf novel individually / separately. Personally I've never come across those last two novels, although I always check for them whenever visiting a used book store. Maybe they were only released in the UK. They're available on Amazon in the US, but I haven't quite given up hope on stumbling across them naturally yet...
My friends and I have found that Patriot phrases make excellent team names in pub trivia, even if no other teams get the references. (Also "double great", "disgraced veterinarians", "pin-flam-fastened pan traps", more I'm forgetting... clearly I need to rewatch the show yet again!)
> I’m not surprised it didn’t get more traction with the general public
I suspect the show would have had a larger audience if it had a better title. That seems to be an instant negative whenever I try recommending it to someone. Hopefully Steven Conrad's new hbo show will raise his profile enough to let more people rediscover Patriot. It's an absolute gem.
Part of my confusion was that this blog post makes no mention whatsoever of any of those things!
It gave me the (incorrect) impression that this observability functionality was the purpose of the product. And it is worded in a way which makes no mention of prior art in built-in DBMS observability.
Looking at the other threads here, I don't think I'm the only one who was confused about that. A couple intro paragraphs to the product might help a lot.
It's great to have that observability functionality, but I don't really understand the purpose of writing a new DBMS from scratch to add this though. Why not get something merged into Postgres core?
[1] https://dev.mysql.com/doc/refman/8.4/en/performance-schema.h...
True, but that's finally solved now.
> I also think that some changes in the database layout could lead to strange things on the replicas.
I've been using MySQL for 23 years and have no idea what you're referring to here, sorry. But it's not like other DBs have quirk-free replication either. Postgres logical replication doesn't handle DDL at all, for example.
What "strange stuff around replication" are you referring to?
There wasn't a clear winner in utf-8 at the time, especially given its 6-byte-max representation back then. Memory and storage were a lot more limited.
And yes while 6 bytes was the maximum, a bunch of critical paths (e.g. sorting logic) in old MySQL required allocating a worst-case buffer size, so this would have been prohibitively expensive.
Also, it's important to consider that replication and backups serve different purposes. Backups alone are insufficient for high availability, change data capture, point-in-time recovery / undoing a bad change, etc.
And once they made that choice, there was no easy fix that was also backwards-compatible. MySQL avoids breaking binary data compatibility across upgrades: aside from a few special cases like fractional time support, an upgrade doesn't require rebuilding any of your tables.
[1] In theory a custom ORM could have some kind of dynamic conditional logic for table or column renames, i.e. some way to configure it to retry a query with the "new" name if the query using the "old" name fails. But that has a huge perf impact, and I'm not aware of any common ORMs that do this. So generally if you want to rename a table or column that is already used in prod, there's no way to do it without causing user-facing errors or having system downtime during the period between the SQL rename DDL and the application code change redeploy.
Grate is also imperative, not declarative.
That last link (david.rothlis.net) is about a declarative tool for sqlite, not Postgres.
I believe they're just referring to having several completely-independent postgres instances on the same host.
In other words: say that postgres is maxing out at 2000 conns/sec. If the bottleneck actually was fork rate on the host, then having 2 independent copies of postgres on a host wouldn't improve the total number of connections per second that could be handled: each instance would max out at ~1000 conns/sec, since they're competing for process-spawning. But in reality that isn't the case, indicating that the fork rate isn't the bottleneck.
The general response from the community often included complaints of there being too much fragmentation / too many forks, and that situation has only gotten worse since then.
Also MariaDB looks increasingly well-positioned to gain marketshare. They're making some strategic steps to improve MySQL compat and ease-of-migration.
I was using a location-related naming scheme in general at that time; similarly my automation library was called Go La Tengo because I was living in the town where the band Yo La Tengo was from.
With row data migrations on large tables, there's also risk of long/slow transactions destroying prod DB performance due to MVCC impact (pile-up of old row versions). So at minimum you need to break up a large data change into smaller chunked transactions, and have application logic to account for these migrations being ongoing in the background in a non-atomic fashion.
That all said, to answer from a mechanical standpoint of "how do companies using declarative schema management also handle data migrations or renames":
At large scale, companies tend to implement custom/in-house data migration frameworks. Or for renames, they're often just outright banned, at least for any table with user-facing impact.
At smaller scale, yeah you can just pair a declarative tool for schema changes with an imperative migration tool for non-schema changes. They aren't really mutually exclusive. Some larger schema management systems handle both / multiple paradigms.
For MySQL/MariaDB with Skeema in particular, a few smaller-scale data migration approaches are discussed in a separate post, https://www.skeema.io/blog/2024/07/23/data-migrations-impera...
Renames aren't compatible with that automation flow though, which is what I meant by "out-of-band". They rely on careful orchestration alongside code change deploys, which gets especially nasty when you have thousands of application servers and thousands of database shards. In some DBMS, companies automate them using a careful dance of view-swapping, but that seems brittle performance-wise / operationally.