3,013 karma · joined December 10, 2015
- Swift programming language
- Cryptocurrency
- Vidya gaems
- Unix and macOS (though I don't hate Microsoft/Windows - you do you)
- Instinctively distrusting Google
- East Asia culture, language, politics, and especially food
CREATE TABLE users (
user_id CHAR(36) NOT NULL PRIMARY KEY CONSTRAINT user_id_length CHECK (LENGTH(user_id) = 36),
email_address VARCHAR(255) UNIQUE CONSTRAINT email_address_length CHECK (email_address IS NULL OR LENGTH(email_address) < 256),
role UNSIGNED TINYINT(1) NOT NULL CONSTRAINT role_valid CHECK (role >= 0 AND role <= 9)
)
Note that the column types here are just to describe to the user what the field should be doing and it's the constraints that actually enforce it. Behind the scenes SQLite still creates two "text (supposedly but whatever)" and one "integer (supposedly but whatever)" columns.It's a little frustrating that all this extra cruft is necessary to get the world's most popular RDBMS to take data correctness seriously. I hope that some SQLite fork that behaves more like other RDBMSes when it comes to this stuff catches on some day, but the fact that that hasn't happened yet makes me think that the demand isn't there, somehow, unfortunately.
But all other things are not equal, are they? A vital piece of software written in C that has been battle-tested and optimized throughout its two, three, four decades or more of existence does not magically improve if it gets rewritten in Rust. Not only does that not make sense in theory, we've also seen it in reality with the issues with the coreutils rewrites.
You can make a solid argument that new software written completely from zero would be better served by being written in Rust than C. But the "just rewrite it bro" types are so incredibly obnoxious and out of step with reality.
Except that Odin has been "released" and has been used to ship software for years now. Regardless of Bill's inspirations for his language, I can write code with Odin right now, and that's a huge benefit compared to waiting for Blow to finally be in the mood to release Jai.
I currently live by myself and I bought a pork loin to barbecue for Independence Day as a treat. I bought one of the smallest ones I could find, then ate about a third of it that night. Then I put the rest in the fridge and ate it over subsequent days - one night I had it on its own with some veggies on the side, and another I sliced it up thin and topped some ramen with it. The loin cost me about $5, but to say that the meat for that one meal on Independence Day cost me $5 is baffling logic.
Maybe we can simplify this. Do you eat breakfast cereal? If you buy a box of breakfast cereal for $4 and a gallon of milk for $4, then have a bowl of cereal with milk the next day, do you think that means that one bowl of cereal cost you $8?
Economic literacy is truly dead, isn't it? Good lord.
I have no idea where you're coming from with the "dealing with food waste" part so I'll just ignore it.
Ever since I started playing it in the beta days I've been frustrated with how poorly Minecraft performs relative to what it's showing on the screen. (Not that that stopped me from pouring hundreds of hours into the damn thing.)
On the other hand, Drupal does not have the WordPress ecosystem habits where many modules/plugins have paid upgrades and/or scatter ads all over your site. The WP plugin ecosystem feels so scummy in comparison.
I agree the switch to Drupal 8 really killed its momentum though. (Drupal was reimplemented on top of Symfony and all existing modules/plugins had to be almost entirely rewritten to work with it - which was quite a difficult hurdle for people used to the previous conventions. Also being able to implement a site's configuration entirely in code, a beautiful feature of D7 albeit one that required third-party modules to implement, was still not quite working properly last time I checked.)
As for "original software," how are you defining that? Is software only original if it doesn't use any pre-existing frameworks? Okay, is it all right if I use a pre-existing programming language with a pre-existing standard library, or do I need to build my own? Is it all right if I host on a pre-existing VPS provider, or do I need to start my own hosting company? Can I host in pre-existing datacenters or do I need to build my own? Can I use pre-existing server hardware, or… At the end of the day all programmers who are getting anything practical done are using pre-existing tools at some level to solve their problems, often building new tools along the way. If I use the right tools for the job, build what my client wants, and keep end user experience in mind as much as possible (and I always do), then what's the problem?
Are you actually a web developer? Are you not passionate about it?