Anders posted a blog post about adding a new JSON
data type to MariaDB. This made me remember my very first MySQL
User conference, well, that and the next couple conferences
actually. Why? Because at every conference (for awhile) I
remember Brian Aker getting everybody into a room to discuss how
to add a data type to MySQL. It was considered pretty much the
quintessential example of how to start developing for MySQL
because it touches a lot of the basic guts of the server.
The example that Brian always gave was a "hex" data type, so that
you can store MD5 numbers using 128 bits of storage instead of
256. A human readable MD5 is a 256 bit string (32 characters)
representing 128 bits of actual data. So storing MD5 values in
the database (a very common thing) requires twice as much space
as it should.
Now, …
Showing entries 1 to 1
May
27
2013
Showing entries 1 to 1