PickVidsBest Databases & storage Videos
「Databases & storage」下面有72部被不同的人、在不同月份推荐过的视频。挑的时候先看对象：入门5部，适合还没学过的人；进阶39部，适合已经懂术语的人；普通向9部，按兴趣就能看；更硬的19部，留给想看推导或细节的人。这一类数量最多的是演讲，所以它们的共同点是一位讲者把一个判断讲完，例子是为了撑住这个判断。常出现的频道包括Strange Loop Conference、GOTO Conferences、Amazon Web Services。目录给这个主题划的范围是：Databases and storage: SQL, SQLite, Postgres, NoSQL, query engines, indexing, transactions, filesystems, storage engines, data modeling, stream processing, event sourcing.如果只看三部，就从《"Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson》开始，它负责把问题讲出画面；然后看《The Value of Values with Rich Hickey》，换一种讲法或例子；最后看《AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)》，留给已经有基础的人。页面按每页24部切开，顺序看的是被推荐跨越了多少个月，不是播放量。每条标题下面那一句是这部片子自己的内容说明，用来区分它在讲定义、过程、演示还是观点。点进去能看到推荐原话、原文链接和适合谁看。看的时候把强烈推荐当成有人明确叫你去看，把引用当成只是拿来举例，把批评留下来对照，不要把每条评论都当成同一力度。
What is in a Lucene index? Adrien Grand, Software Engineer, Elasticsearch
Elasticsearch engineer and Lucene committer Adrien Grand explains the design decisions inside a Lucene index and what problems it can and cannot solve.
Bryan Cantrill on ARC: A Self-Tuning, Low Overhead Replacement Cache [PWL SF] 10/2017
Bryan Cantrill presents the ARC (Adaptive Replacement Cache) paper by Megiddo and Modha at Papers We Love.
Avi Bryant demos Dabble db
Avi Bryant demos Dabble DB, a web-based spreadsheet-like database for building apps without code.
"Swift as C++ Successor in FoundationDB" by Konrad Malawski (Strange Loop 2023)
Konrad Malawski's Strange Loop 2023 talk shows how the FoundationDB team adopted Swift incrementally in a C++ codebase.
Richard Hipp - Git: Just Say No
SQLite author Richard Hipp's talk at SouthEast LinuxFest criticizing Git's workflow and introducing Fossil as an alternative.
How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder
Lukas Eder's Devoxx talk on how modern cost-based SQL optimizers rewrite and plan queries in ways developers would not expect.
Four Languages from Forty Years Ago - Scott Wlaschin
Scott Wlaschin's NDC Oslo talk on four 1970s languages, SQL, Prolog, ML and Smalltalk.
A Tour of Prolog
Markus Triska tours Prolog's most distinctive features, including its use as a database and query language, rule processing, constraint solving and compile-time rewriting.
Bringing the Unix Philosophy to Big Data by Bryan Cantrill: FutureStack13
Bryan Cantrill presents Manta, an object store with in-situ compute that lets tools like grep, awk, and sed run map-reduce style over huge data.
"Transactions: myths, surprises and opportunities" by Martin Kleppmann
Martin Kleppmann's Strange Loop talk on database transactions, covering why they were dropped by NoSQL, their reputation for being slow, and newer algorithms that make serializable transactions perform and scale.
Dabble DB demo
A short product demo of Dabble DB, a web tool for importing, entering and manipulating structured data with little effort.
XFS: Recent and Future Adventures in Filesystem Scalability - Dave Chinner
Dave Chinner's linux.conf.au 2012 talk on XFS scalability, covering pain points with large numbers of files and complex metadata, and the work to fix XFS metadata performance.
The Maximal Graph - Wilker Silva
A Clojure/conj 2019 talk by Wilker Silva on how namespace-qualified keywords and context-free federated names can be used pragmatically for data modeling, drawn from his experience at Nubank.
The Worst Typo I Ever Made
Tom Scott recounts the worst typo he ever made, a subtle mistake in code with destructive consequences at a previous job.
Seattle Conference on Scalability: YouTube Scalability
Cuong Do of YouTube describes how a handful of engineers scaled the site, covering hardware, software and database scalability challenges during its rapid growth.
BetrFS: A Right-Optimized Write-Optimized File System
A Microsoft Research talk on BetrFS, a file system built on B-epsilon trees, a write-optimized data structure.
ZFS Native Encryption by Tom Caputi
Tom Caputi presents the design of native encryption for ZFS at the OpenZFS Developer Summit, including design decisions and how authentication uses checksum fields.
"Datafun: a functional query language" by Michael Arntzenius
Michael Arntzenius's Strange Loop talk on Datafun, a functional query language that brings database-style querying into a general-purpose language.
Rust at speed — building a fast concurrent database
A guest lecture Jon Gjengset gave at Two Sigma on using Rust for large, high-performance systems.
Foundry 2022 Operating System Demo
A 49-minute demo of Palantir Foundry by its chief architect.
Modern SQL: A lot has changed since SQL-92 by Markus Winand
Markus Winand shows how SQL has evolved since SQL-92, comparing old-style solutions to modern features such as window functions and system versioning, and notes that many developers never learn them.
June 2021 FreeBSD Developer Summit: Raid-Z Expansion
Matt Ahrens presents the FreeBSD Foundation sponsored RAID-Z Expansion project for ZFS at the June 2021 FreeBSD Developer Summit.
AWS re:Invent 2018: Amazon DynamoDB Under the Hood: How We Built a Hyper-Scale Database (DAT321)
An AWS re:Invent 2018 session on how DynamoDB was built as a hyper-scale NoSQL database.
Your web app but good: Aaron Boodman (Local-First Conf)
Aaron Boodman of Replicache asks why sync engines have not yet fixed web app complexity and what is missing for them to go mainstream.