Once your application or service is running in production you have a lot more to consider when making database changes. It can be tricky, here are a few things to keep in mind that should reduce or eliminate downtime. Renaming Columns If you need to rename a column, to reduce downtime you cannot do …

This simple command can be run from a terminal to export data (and schema) to a local file from the Docker database container. This assumes that data only lives within the container and is not persisted using a Docker Volume. You might have a configuration like this for local development or testing. …

If you’re using a database, any database really, and you need to track the number of something, have an incrementing counter might do the trick. Seems incredibly easy, so I’ll give some reasons for the solution. I’ve been building a lot of API services and need a way to track usage …