Open Source Databases

Structured Query Language, or SQL is one of the top-rated computer languages, year after year.

Did you ever need to determine the performance of a query over time?

All opinions expressed in this blog are those of Dave Stokes who is actually amazed to find anyone else agreeing with him

Yes, SCaLE, or the Southern California Linux Expo is back.

One type of databases is pretty much the same as any other type of database base, right?

Looking to get smarter?

I hope to see you next month in Austin at Percona Live.

Percona Live's schedule has very interesting MySQL talks.

In March 2020 I attended the Southern California Linux Expo in Pasadena, California not knowing that I would not be physically present at a computer conference for over two years later.

Percona Live is back and in person May 16th to 18th in Austin, Texas and you not only need to be there but you need to present a talk to share your knowledge.

MySQL Server version 8.0.28 was launched a few days ago and without a lot a fanfare.

SCaLE 19X – the 19th annual Southern California Linux Expo – will take place March 3-6, 2022 in Pasadena, CA.

Functional indexes are way to build indexes on values derived from rather than values in columns, or parts there of.

The start of fall in the northern hemisphere is a time for many of use to prepare for the approaching winter.

Histograms were introduced with MySQL 8.0 and are a valuable way of speeding up queries.

Multi column indexes are a powerful way to speed up queries but they are often misunderstood.

Want to learn MySQL?

This weeks quiz is a little different.

This week's MySQL was a great one for novices looking to level up from beginner level SQL development to a higher level.

This week's MySQL uses the Sakila database (details on how to get this data) and this week's quiz is a great one for those wanting to move from beginner level SQL development to a higher level.

Here are answers to Quiz #1 and please note there are several ways to solve just about any problem so your answer may be different.

I frequently see requests on various web sites from MySQL novices looking for example databases with which to practice.

There will be a MySQL tract at the Southern California Linux Expo 19x (SCaLE) March 3-6, 2022 in Pasadena, California.

One of the things I love about the MySQL Shell is that is saves your authentication credentials (no longer just passwords) in an obfuscated login path file named .mylogin.cnf.

Do yourself a favor and spend ten minutes watching this video on the CER2021 paper Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud study.