Data Storage

Don't abuse databases

data, database, storage

3 posts in this saga
Updated at Nov 02 2019 at 16:11 UTC

  • Why I Do Not Store UUID as CHAR or VARCHAR

    1 of 3 |
    Updated at

    Misunderstandings

    UUIDs.... Such a widely badly stored and used form of identification. Would you believe that people store UUIDs are in MySQL as not only primary key, but CHAR and VARCHAR?! Poor MySQL, poor B-Tree and poor computers that are abused by incompetence.

    Did you know that UUIDs have 6 versions? Did you know that UUIDs are 128bit random numbers? Did you also know that UUID stored as ASCII doubles the character length and storage space? Do you know why? Did you know that MySQL has to encode and deco...

  • Terrible Ideas #1: Database Model as a Service

    2 of 3 |
    Updated at

    Had a go thinking about abstracting database access into a service and the question I have is why? Why bother abstracting this access? What benefit does one get when abstracting the database away from an application? Let's have a go at it shall we?

    Imagine starting with a monolithic application that accesses a few databases and their tables. Life is great and everytime you update version x to version x+1, you update that application to support both version until fully migrated. Lets say you start hiring peop...

  • Data Collection, Monitoring and Visualization

    3 of 3 |
    Updated at
    For the past two years, I've been focused on the problem of moving data from sensors on networked equipment to data sinks for aggregation, monitoring and visualization purposes. The process is what I call a pipeline that achieves the goals of monitoring and visualization.

    Some terminology I use are measurement which can be substituted with metric. Observations which are a collection of measurements.

    Data Collection



    Collecting observations is done by agents. Agents can setup a receiving server (stream), poll da...