{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/f7679791a3e140d3af13a3d9839f0ea2\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/f7679791a3e140d3af13a3d9839f0ea2-00001.gif","duration":284.205,"title":"Exploring Point in Time Queries with SQLite Actor + Txn-less SQL reads 📊","description":"Hey, what's up guys? In this video, I wanted to show you a couple of interesting things I discovered over the weekend. One of them is using point in time queries with the SQLite Hector. I didn't realize until now that you can make queries against older heights of the root state. I'll demonstrate this feature and also talk about the broadcast async mode, which makes pushing lots of data much easier. I'll show you how to create a table, insert rows, and perform read-only transactions. It's pretty cool to be able to do all this without much hassle. Although this video may not be the most exciting demo, it's all about being able to do real things with SQLite Hector. So, let's dive in and explore these features together!"}