In @MySQL, you can't add a B-tree index to a blob or text column, but you *can* create a generated column that is an MD5 hash of a blob or text column, and put an index on that! 😎
The tech job market has never been more polarized:
Demand for senior tech workers has never been higher, compensation is hitting all-time highs, globally.
New grad and junior folks have never had such a hard time getting that first job.
A thread on what's happening and why:
This is a perfect example of zero-added-value comments. They just repeat the code 1:1. Code already tells us "how", we need to know "why". A high level algorithm description could also be nice to have.
AI based function/class/variable (re)naming would be interesting too.
Database Indexing and Hotel rooms
(a thread)
If you’ve been to a hotel often you would see a sign looking something like this on the way to your room. This helps finding rooms convenient and fast especially if the hotel has many rooms.
The top productivity hack in software development is to build foundations that are dependable enough that you can keep building on top without having to go back and modify them as you go. 100x time saver.
@brunoborges@tagir_valeev And, Lombok perpetuates the problem it was designed to solve -- the misguided pattern that every class should expose mutable state through getters and setters. Lombok makes it too easy to adopt this usually-inappropriate design pattern, thus perpetuating the dependency on it.
When Twitter started solving scalability and reliability problems a decade ago, there was not much to get from the open source.
Engineers here created world-class storage systems, workload schedulers, RPC frameworks etc, and open sourced many of them for the rest of the world.