Databases are amazing tools which we often overlook for simple forms of storage. Cue our json, csv, excel and yes the dreaded text files. I get it, it’s easy and usually efficient for a single analysis. If you find yourself dumping a lot of files to just be ingested later, consider setting up a database.

Why MySQL?

Simply put, it’s easy and agrees with most connection packages I use. You don’t need crazy driver setups, or complicated connection objects in code. Is it just as good as Maria DB, Postgres, and SQLite? Yes, it’s just my preference.