Systems | Development | Analytics | API | Testing

Databases

Video: Database Optimization

Most modern web applications are heavily reliant on persisting data with relational databases, and so it’s no surprise that a large part of application performance monitoring relates to keeping an eye on database performance to ensure that our SQL queries are as efficient as possible. With this in mind, Scout features a Database Addon module, and in this video we are going to take a closer look at what it has to offer.

Databases Demystified Lesson Distributed Databases Part 3

In this episode of Michael Kaminksy's Databases Demystified, he explores: What does “consensus” mean and why is it important? Learn about the two-generals problem and what it teaches us about reaching consensus Learn about the main consensus algorithms in distributed databases: Raft & Paxos

Databases Demystified Lesson 1 Introduction to Databases and SQL

In the first episode of Databases Demystified with Michael Kaminsky, we give a high-level overview of the most important concepts in databases. We start with a brief history of databases going from the invention of relational databases through present day and we talk about the differences between analytical and transactional databases, distributed and single-node databases, and in-memory vs on-disk databases We finish up talking briefly about SQL and what makes it special.

Databases Demystified Lesson 4: Transactions Part 1

In this episode of Michael Kaminksy's Databases Demystified, we learn all about what a transaction is, and what ACID means. Learn why database constraints are important, and what the commands "begin" "commit" and "rollback" mean. We talk about atomicity, consistency, isolation, and durability and why transactions are so important.