Build your own data warehouse for personal analytics with SQLite and Datasette

PyCon AU25.5K subscribers

About this video

Hand-picked by a BrighterTube curator · found via round-3 back catalogue of a channel Lumen picks video by video · 82% confidence

Teaches building a personal analytics data warehouse using SQLite and Datasette. Concrete tutorial on database design and tooling for self-tracking applications.

A 24-minute video from PyCon AU: “Build your own data warehouse for personal analytics with SQLite and Datasette”.

Programming & CS Skills

Video by PyCon AU, played through YouTube's embedded player.

Part of PyConline AU 2020

Related

""Git hook[ed]” on images & up your documentation game" - Veronica Hanus (PyCon AU 2019)PyCon AUProgramming & CS

"Assurance of Learning Through Testing" - Stephen Tierney, Alison Wong (PyCon AU 2023)PyCon AUProgramming & CS

Lecture 6: Version Control (git) (2020)Missing SemesterProgramming & CS

752K views

How to Do 90% of What Plugins Do (With Just Vim)thoughtbotProgramming & CS

991K views

But what is a neural network? | Deep learning chapter 1 3Blue1BrownScience & Math

Intro25.1M views

Let's build GPT: from scratch, in code, spelled out.Andrej KarpathyProgramming & CS

8.21M views

The spelled-out intro to neural networks and backpropagation: building micrograd Andrej KarpathyProgramming & CS

Intro4.41M views

Transformers, the tech behind LLMs | Deep Learning Chapter 5 3Blue1BrownProgramming & CS

Intro11.6M views

How to Speak MIT OpenCourseWareSkills

23.5M views

The Beauty of Bézier Curves Freya HolmérProgramming & CS

2.23M views

CS50x 2024 - Lecture 0 - Scratch CS50Programming & CS

Intro2.2M views

CS50x 2024 - Lecture 1 - C CS50Programming & CS

Intro1.41M views

""Git hook[ed]” on images & up your documentation game" - Veronica Hanus (PyCon AU 2019)

A 28-minute video from PyCon AU: “""Git hook[ed]” on images & up your documentation game" - Veronica Hanus (PyCon AU 2019)”.

"Assurance of Learning Through Testing" - Stephen Tierney, Alison Wong (PyCon AU 2023)

A 29-minute video from PyCon AU: “"Assurance of Learning Through Testing" - Stephen Tierney, Alison Wong (PyCon AU 2023)”.

Lecture 6: Version Control (git) (2020)

Missing Semester

752K views

MIT's Missing Semester lecture on Git: the data model of blobs, trees, commits and references, then the commands built on it.

How to Do 90% of What Plugins Do (With Just Vim)

991K views

Max Cantor shows how to get fuzzy file finding, tag jumping, autocomplete and build integration in Vim using only built-in features.

But what is a neural network? | Deep learning chapter 1

Intro25.1M views

Builds up what a neural network actually is — neurons as numbers, layers, weights and biases — using handwritten-digit recognition as the running example.

Let's build GPT: from scratch, in code, spelled out.

Andrej Karpathy

8.21M views

Building a GPT-style language model from scratch in code, following 'Attention Is All You Need'.

The spelled-out intro to neural networks and backpropagation: building micrograd

Andrej Karpathy

Intro4.41M views

Building micrograd, a tiny autograd engine, to understand backpropagation completely.

Transformers, the tech behind LLMs | Deep Learning Chapter 5

Intro11.6M views

How transformer models (the 'T' in GPT) turn text into vectors and predict the next token, step by step.

How to Speak

MIT OpenCourseWare

23.5M views

Patrick Winston's MIT lecture on how to speak: openings, structure, slides and closings.

The Beauty of Bézier Curves

2.23M views

Freya Holmér builds Bézier curves from linear interpolation up, covering de Casteljau's algorithm, derivatives, arc length and their use in games and graphics.

CS50x 2024 - Lecture 0 - Scratch

Intro2.2M views

CS50x 2024 lecture 0: how computers represent information, algorithms, and first programs in Scratch.

CS50x 2024 - Lecture 1 - C

Intro1.41M views

CS50x 2024 lecture 1: an introduction to C — syntax, types, conditionals, loops and compiling.