Ronald Bradford - Data Architect, MySQL Expert, Author & Speaker on Enterprise Data Architect | Principal Data Strategist | MySQL Subject Matter Expert | Author | Speaker

If you were following the AWS Re:invent keynote yesterday there were several data specific announcements including Aurora DSQL and S3 Tables .

The ongoing drama between Wordpress v WP Engine continues to cross my reading list, but I have permanently removed WordPress from my website.

I recently became aware of WeSQL .

SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system.

Yesterday I detailed an incompatible breakage with RDS MySQL Aurora 3.06.0 , and one option stated is to upgrade to the just released 3.07.0.

We know that SQL statement compatibility can change with major database version upgrades and that you should adequately test for them.

Recently, I noticed a second AWS RDS MySQL 5.7 version available 5.7.44-rds.20240408.

MySQL warnings are an anti-pattern when it comes to maintaining data integrity.

I started 2024 with several goals.

Falsehoods programmers believe about time zones If I told you there was a timezone 30 minutes past the hour, would you believe me?

In his Newsletter Solopreneur Ian Nuttal writes, “I sold my startup (again).”

Google advances with vector search in MySQL, leapfrogging Oracle in LLM support As the title states, GCP is the first MySQL-managed service to offer “vector” support.

As an entrepreneur, pricing is an important consideration in any evaluation, development, and customer testing.

The One Billion Row Challenge Shows That Java Can Process a One Billion Rows File in Two Seconds Well, it’s way under 2 seconds for the 1brc .

Everything you need to know about seed funding for startups A recent call with a startup founder funded by TinySeed led me to learn about MicroConf and Rob Walling.

MySQL Belgian Days 2024 and FOSDEM 2024 In this past week, I’ve been able not just to read or watch digital content online but to meet people in person.

Because the world needs better dashboards While my professional interests in Building Better Data Insights Faster rely on using visuals and narratives to show data-driven results, “Starting from first principles” is the question you have to ask.

NoOps and Serverless solutions I was reminded of an upcoming expiry of a test website that I have on PythonAnywhere .

Lessons from going freemium: a decision that broke our business As an entrepreneur always considering how to produce a sustaining passive revenue, what licensing model to use, and how to acquire and retain customers, the allure of a freemium model is ever…

Indie Newsletter Tool Generates $15,000 a Month There are so many different email newsletter sites you could wonder if there is market saturation.

The Tiny Stack (Astro, SQLite, Litestream) I spent many years in the LAMP stack , and there are often many more acronyms of technology stacks in our evolving programming ecosystem.

InstanceHunt identifies the instance (families/types/classes) available for a cloud service across all the regions of that cloud.

In a recent podcast on Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 I discuss with my colleague Adam North not only the technical issues that become a major migration but also key business and management requirements with having a well-…

I continue to dig up and share this simple approach for production data masking via SQL to create testing data sets.

Observability (o11y) is a critical pre-requisite component in software architecture when advocating for and preparing organizations for making informed decisions on the success of their application.

I’ve had this list on a post-it note on my monitor for all of 2022.

The recent re-announcement of the Cancer Moonshot highlighted a common enemy to many endeavors to improve our society as a whole, and that is using common sense and already known methods.

While this is a catchy title, if you use Software as a Service (SaaS), or an online cloud provider, do you actually own and have total control of your business data and its infrastructure?

A question without a definitive answer.

Data visualization, data storytelling, and data lineage are all ways to better describe and visualize a specific situation for a set of data.

In recent weeks I have been sharing more informal thoughts and in the upcoming weeks, there will be a period of greater radio silence.

A very succinct description of the responsibilities of leadership by Jawad Nagda (infographic below) shows a number of key features of management that are also needed in data storytelling such as empathy, integrity, and listening.

A large part of my work week was spent u-hauling across 1/3 of the country.

This week I wanted to share more about Observability and the CNCF foundation project Open Telemetry .

——— We should all take a moment to reflect that going to school should be a safe, happy, and memorable part of everybody’s life.

The Linux Foundation came across my reading path two separate times this week.

As I reflect on this week of my technology journey with the conversations I had, what I learned, and what I wanted to do and write about, I decided what better way to work on multiple blog posts than write about what I’d like to write about.

If you have worked with an RDBMS for some time, you will likely have come across the statement SELECT 1.

During a recent Aurora MySQL 8 upgrade process, a number of validation checks have failed.

With Aurora MySQL 8 now generally available to all, you may want to consider the plan for an upgrade path if you would like to take advantage of the new features for your application, for example, Common Table Expressions (CTE).

The end of the year is often a time to review the progress of your yearly goals and to set new goals for the next year.

AWS has just announced the general availability of Aurora MySQL 8 compatibility (known as Aurora Version 3).

Spaces or tabs.

This week I learned two valuable aspects of Terraform I did not know.

The AWS ledger database (QLDB) is an auditors best friend and lives up to the stated description of “Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time.

The RDS Aurora MySQL/PostgreSQL capabilities of AWS extend the High Availability (HA) capabilities of RDS read replicas and Multi-AZ.

In the late 1990s I learned MySQL and Java at approximately the same time.

I am pleased to have been selected to present at Percona Live 2021 May 12-13.

This week I was evaluating AWS QLDB .

When you work with AWS Aurora you have limited admin privileges.