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…
Many uses of python involve connections to APIs, databases, or hosted information. Embedding a password in a script is always a bad idea. You can easily forget it is there, and inadvertently share confidential information with others. This is especially important if you regularly are posting content to a public GitHub. CSV files Storing important content doesn’t need to be complicated. Simply creating a CSV file that has the information you need in tabular format will certainly do the job….