Tag: mysql

Relational Database Query Optimization

We’re discussing query optimization techniques for relational databases, covering both common and uncommon strategies across various database management systems. These techniques range from basic practices like indexing to advanced methods like bitmap indexing and adaptive cursor sharing. Continue reading →

MariaDB & SkySQL DBAAS

Starting to use, or interested in using MariaDB? This is a getting started post that will get you started with MariaDB and SkySQL. Prerequisite knowledge of SQL is helpful, but I step through every single little detail in this post to get you up and running, with a good context of what you’re getting. Continue reading →

Survey of Go Libraries for Database Work

Over the past few months I’ve picked up a number of libraries in the Go ecosystem to help me get work done around database engineering. These libraries are ones that I have used to do a range of work primarily around Apache Cassandra, DataStax Enterprise, PostgreSQL, and to a lesser degree MS SQL Server, MySQL,... Continue reading →

One OS-X Tip and One MySQL Dev Tip

I’ve downloaded and installed MySQL recently. I was doing a few things to make it easier to work with and thought, “I ought to document this, it isn’t real intuitive without pages of documentation being read.” So here’s some tips. 1. Make sure you can view all of your files in OS-X, especially if you... Continue reading →