SQLBits 2022

3 things you don’t want to store in a database (but sometimes have to)

Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Some types of data are a very bad fit for a database. For instance, if you ever tried to save logs, pictures or entities with dynamic attributes in a database, you probably have one or two horror stories to share. However, sometimes there is nothing you can do and that data will have to live in your database, like it or not.
Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.

Feedback link https://sqlb.it/?7048