SQLite and the N+1 (no) problem

preview_player
Показать описание
Most databases are susceptible to the N+1 problem, with the exception of embedded databases like SQLite. If you're curious why SQLite doesn't suffer from the N+1 problem, watch this video and learn why.

  1. Mycelial
Рекомендации по теме
SQLite and the 0:08:30

SQLite and the N+1 (no) problem

N + 1 0:01:00

N + 1 Queries: The Easiest Way To Improve Performance

justanotherdot• Let's explore 1:50:11

justanotherdot• Let's explore SQLite! no.1

SQLite vs PostgreSQL 0:06:48

SQLite vs PostgreSQL - Which One Should You Really Use?

SQLite for beginners: 0:10:04

SQLite for beginners: Full Text Search

The Perfect Dependency 0:19:32

The Perfect Dependency - SQLite Case Study

N+1 Query problem 0:01:00

N+1 Query problem in hibernate and other disadvantages of hibernate

N=10 - SQLite 0:38:46

N=10 - SQLite persistent storage (N+1 days of MvvmCross)

SQLite in Production 0:06:37

SQLite in Production - Master Course

SQLite 3 & 0:06:21

SQLite 3 & Python Tutorials : #1 Creating DB & Establish Connection

SQLite for beginners: 0:08:52

SQLite for beginners: Vacuuming

Offline-first, multiplayer SQLite 1:21:25

Offline-first, multiplayer SQLite

The SQLite Rewrite 0:22:15

The SQLite Rewrite In Rust

Python SQLite Creating 0:08:15

Python SQLite Creating a Digital Memory Database | #47 (SQLite #1)

35-SQLite swift#1.Install SQLite 0:05:54

35-SQLite swift#1.Install SQLite for Xcode project in Swift 4

DjangoCon Europe 2023 0:29:45

DjangoCon Europe 2023 | Use SQLite in production

GraphQL Explained in 0:02:22

GraphQL Explained in 100 Seconds

How to Add 0:01:17

How to Add the Not Null Constraint in SQLite : Using a Mac

SQLite Basics | 0:09:30

SQLite Basics | SQLite tutorial for beginners - Introduction and Installation of SQLite

Tutorial SQLite3 2023 0:16:44

Tutorial SQLite3 2023 N° 30 sqlite sequence

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

SQLite can seriously 0:01:00

SQLite can seriously simplify your app stack #mysql #postgresql #database

Netstat -anoob OUTPUT 0:02:26

Netstat -anoob OUTPUT to sqlite using powershell Part 1

SQLite and its 0:04:30

SQLite and its weird new fork “libSQL”

Комментарии
Автор

Great video! Thanks for explaining the difference. It's unreasonable for this to have only 97 views! Subscribed.

philipptanlak
Автор

How do I find more local-first architecture content like this? This is exactly what I am looking for!

christianlessard
Автор

Great video, I appreciate the comparison at the end, because I kept wondering about the optimized postgres version. Did you use connection pooling for the three queries?

HVossi
Автор

Complex query are still worth it even if there is no network latency. If we don't do join they we have to write code for doing this and it would become more error prone and complex code where as a single query could have done it.

Until there is some memory concern, I don't see a point why not to have complex query for sqlite.

Graveness
Автор

you are using second timing for comparison, but I think that's not right, first query directly goes and fetches data from disk, second query is. misleading and fast because first slow query was cached...

sekomer