(Geir Hoydalsvik) There are over 250 new features in MySQL 8.0. The MySQL Manual is very good, but verbose. This is a list of new features in short bullet form.
Community
The Cost of Useless Surrogate Keys in Relationship Tables
(lukaseder) What’s a good natural key?
Transaction log backups in a SQL FILESTREAM database
(Rajendra Gupta) In the continuation of our SQL FILESTREAM article series, we’ll be covering transaction log backups
SQL That Meant Well: Applying Conditions in the Subquery vs the Outer Query
(Ember Crooks) This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance.
React.js – Parent Child Component Communication and Event Handling
(Mahesh Sabnis) This React tutorials shows how to read the change event of all inputs using a single method and handle event of child component in the parent component.
I’m Going To Stop Worrying About Tightly-Coupled DOM Access In Angular 7.2.7
(Ben Nadel) I love a clean separation of concerns. Especially when such a separation makes code easier to reason about. Sometimes, however, I find myself stressing way too much about tight-coupling; and, I find that my attempts to decrease coupling can lead to code that is way harder to understand o
Node.js vs Python for a Beginner’s Web App
(Eric Boersma) Learning to build webapps is an exciting process, but it comes with its own set of challenges. As a newer developer, deciding what programming language will bring your big idea to life is a common challenge.
Navigating in Blazor
(Peter Vogel) If you’re moving your application’s client-side code to Blazor, then you’ll want Blazor to manage navigating between pages, too.
How to backup your InnoDB Cluster ?
(Frederic Descamps) MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
Chasm Trap problem in Data Warehouses
(Kubilay) Chasm trap in data warehouses occurs when two fact tables relate into one dimension table. This is a data modelling problem which will cause double-counting and bad data when these tables are joined. SQL and relational databases surprise me every day!