1 Relational Database ACID Transactions (Explained by Example)
2 B-Tree vs B+Tree in Production Database Systems
3 Key vs Non-Key Column Database Indexing
4 SELECT COUNT (*) can impact your Backend Application Performance, here is why
5 Column vs Row Oriented Databases Explained
6 Can you get Eventual Consistency in Relational Databases?
7 Database Indexing Explained (with PostgreSQL)
8 Indexing in PostgreSQL vs MySQL
9 Explain Explained in PostgreSQL - How Databases Prepare Optimal Query Plans to Execute SQL
10 Is SELECT * Expensive?
11 Bloom Filters Explained by Example
12 Database Partitioning Crash Course (with Postgres)
13 Horizontal vs Vertical Database Partitioning
14 Database Replication Crash Course ( with Postgres 13 )
15 Database Engines Crash Course (MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB)
16 Database Sharding Crash Course (with Postgres examples)
17 Avoid premature Database Sharding
18 Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained
19 Two Phase Locking Explained (2PL)
20 Redis In-memory Database Crash Course
21 Spinning MongoDB, MongoShell and Mongo GUI with Docker
22 Database Exclusive lock vs Shared Lock (Explained by Example)
23 Connection Pooling in PostgresSQL with NodeJS (Performance Numbers)
24 Building a Web API with Express and PostgreSQL to Consume from Browser
25 IndexedDB Crash Course with Javascript
26 Postgres Database Cursors in Python with psycopg2
27 Database Dead Locks Explained by Example
28 Step by Step Javascript and Postgres Tutorial using node-postgres
29 Step-by-Step Python and Postgres Tutorial with psycopg2
30 Spinning multiple Postgres instances and PGAdmin with Docker
31 Step by Step Mysql 8.x and Javascript Tutorial (with mysql2 NodeJs)
32 What is a Distributed Transaction in Microservices?
33 How to Avoid Double Booking and Race Conditions in Online Web Applications
34 Multi-player System Game Design - Pros & Cons of Proposed Designs & System Design Interviews Advice
35 When should you shard your database?
36 Can the QUIC Protocol improve Database Performance in Web Applications?
37 URL Shortener System Design (Explained with Two proposed Designs with Pro and Cons of each)
38 How Do Databases Store Tables on Disk? Explained both SSD & HDD
39 Concurrent Requests and Unique Keys on Web Applications
40 Carnegie Mellon University Advanced Database Course Is a GREAT resource for Backend Engineers!
41 Keep your Servers Close and Your Database Closer
42 What is the Largest SQL Query We can Send Before The Database Process Crashes?
43 MariaDB vs MySQL SSD NVMe vs SATA Performance - Discussions on the Percona Benchmark
44 What caused the cold start performance “dip” in MariaDB .. Let us discuss (@Percona Article)
45 Best Practices Working with Billion-row Tables in Databases
46 Index Scan vs Index Only Scan on Database Systems (with Postgres)
47 Why Discord Moved from MongoDB to Apache Cassandra, Let us Discuss
48 PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!
49 Opening Old Wounds - Why Uber Engineering Switched from Postgres to MySQL
50 Why Redis Became the Most Popular Database on the Cloud in 2020
51 Basic Caching Techniques Explained - Spatial, Temporal, Distributed, Write-Through, Write-Back,Aside
52 Will AWS Babelfish Succeed in Moving Developers Away from SQL Server to Postgres?
53 Meet mySQL RAPID - distributed, in-memory, columnar, query processing engine by ORACLE
54 Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL)
55 don’t use “offset” in your SQL
56 Burned by Docker and it was my fault
57 Bitmap Index Scan in Postgres Explained with Examples (Members only)
58 Is EventStoreDB the First Native gRPC Database?
59 Create Index Blocking Production Database Writes? Postgres Solves this with this trick
60 How to Automate Partitioning in Postgres
61 UUIDs are Bad for Performance in MySQL - Is Postgres better? Let us Discuss
62 Redis In-Memory Database Crash Course
63 Phantom Reads in Postgres Explained Compared to Other DBMS
64 Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems
65 How Database Cursors Help in Fetching Large Result sets from your SQL
66 Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them
67 Write Amplification Explained in Backend Apps, Database Systems and SSDs
68 Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show
69 SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
70 Auth0 MongoDB Gets Overloaded Causes an Major Outage
71 The Tale of OLTP, OLAP, and HTAP in Data Warehousing - The Backend Engineering Show
72 Optimizing Communication and Networking in Database Systems - The Backend Engineering Show
73 The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser
74 Primary Key vs Secondary Key - What you probably didn't know (Members ONLY)
75 All Types of Database Replication Discussed
76 My thoughts on the CAP theorem
77 B-tree vs B+ tree in Database Systems
78 Should you go with an Optimistic or Pessimistic Concurrency Control Database?
79 Can Redis be used as a Primary database?
80 Turns out MySQL Statement-based Replication might not be a good idea, Lets discuss why
81 Partial Indexing | The Backend Engineering Show
82 Update your database statistics often or your SQL queries will suffer #shorts
83 Table Clustering in MySQL and Postgres - The pros and cons
84 How Redis efficiently snapshots gigabytes of memory to disk (forking)
85 backend leaking Postgres database connections - what I did to fix it
86 on graph databases
87 On Graph Databases | The Backend Engineering Show
88 The cost rolling back transactions (postgres/mysql)
89 when indexes are useless | The Backend Engineering Show
90 What is the cost of Indexing too many columns - Udemy Q&A November 2021
91 Postgres index bloat | The Backend Engineering Show
92 what is a database index?
93 The limitations of today’s SSDs | The Backend Engineering Show
94 Why this query is fast
95 Redo, Undo and WAL logs | The Backend Engineering Show
96 Sorting in Postgres 15 is 371% faster in certain cases