Media Summary: In this episode of RECORDABLES, we dig into our ambitious goal of moving from a commingled database to separate Annotations, links and code samples for this talk can be found at Guest Lecture at Saarland University, on June 25th, 2024.

37signals Almost Ditched Sqlite Here - Detailed Analysis & Overview

In this episode of RECORDABLES, we dig into our ambitious goal of moving from a commingled database to separate Annotations, links and code samples for this talk can be found at Guest Lecture at Saarland University, on June 25th, 2024. A CASE statement allows us to map one or more conditions to a corresponding value for each condition. You start a CASE ... A very common task when working with data is filtering for records based on criteria, which can be done with a WHERE statement.

Photo Gallery

Rails Multi-Tenancy with Mike Dalessio
Will Turso Be The Better SQLite? (with Glauber Costa)
Distributed SQLite with Litestream and LiteFS
Breaking Down SQLite Databases
SQLite: Let's read the code
Introduction to Datasette and sqlite-utils
SQLite: How it works, by Richard Hipp
Everyone Is Wrong About SQLite (Here’s When It Beats Postgres)
The Perfect Dependency - SQLite Case Study
Offline-first, multiplayer SQLite
CASE statements with SQLite
WHERE Statements with SQLite
View Detailed Profile
Rails Multi-Tenancy with Mike Dalessio

Rails Multi-Tenancy with Mike Dalessio

In this episode of RECORDABLES, we dig into our ambitious goal of moving from a commingled database to separate

Will Turso Be The Better SQLite? (with Glauber Costa)

Will Turso Be The Better SQLite? (with Glauber Costa)

SQLite

Distributed SQLite with Litestream and LiteFS

Distributed SQLite with Litestream and LiteFS

Want to learn more

Breaking Down SQLite Databases

Breaking Down SQLite Databases

SQLite

SQLite: Let's read the code

SQLite: Let's read the code

We take a look at the

Introduction to Datasette and sqlite-utils

Introduction to Datasette and sqlite-utils

Annotations, links and code samples for this talk can be found at https://simonwillison.net/2021/Feb/7/video/

SQLite: How it works, by Richard Hipp

SQLite: How it works, by Richard Hipp

Guest Lecture at Saarland University, on June 25th, 2024.

Everyone Is Wrong About SQLite (Here’s When It Beats Postgres)

Everyone Is Wrong About SQLite (Here’s When It Beats Postgres)

Is

The Perfect Dependency - SQLite Case Study

The Perfect Dependency - SQLite Case Study

SQLite

Offline-first, multiplayer SQLite

Offline-first, multiplayer SQLite

Want to learn more

CASE statements with SQLite

CASE statements with SQLite

A CASE statement allows us to map one or more conditions to a corresponding value for each condition. You start a CASE ...

WHERE Statements with SQLite

WHERE Statements with SQLite

A very common task when working with data is filtering for records based on criteria, which can be done with a WHERE statement.

SQLite is not weakly typed!

SQLite is not weakly typed!

Want to learn more