<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/f7679791a3e140d3af13a3d9839f0ea2&quot; frameborder=&quot;0&quot; width=&quot;1280&quot; height=&quot;960&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>960</height><width>1280</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>960</thumbnail_height><thumbnail_width>1280</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/f7679791a3e140d3af13a3d9839f0ea2-00001.gif</thumbnail_url><duration>284.205</duration><title>Exploring Point in Time Queries with SQLite Actor + Txn-less SQL reads 📊</title><description>Hey, what&apos;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&apos;t realize until now that you can make queries against older heights of the root state. I&apos;ll demonstrate this feature and also talk about the broadcast async mode, which makes pushing lots of data much easier. I&apos;ll show you how to create a table, insert rows, and perform read-only transactions. It&apos;s pretty cool to be able to do all this without much hassle. Although this video may not be the most exciting demo, it&apos;s all about being able to do real things with SQLite Hector. So, let&apos;s dive in and explore these features together!</description></oembed>