I finally finished writing my blog post on using Dapper for handling Vector data types. But I also had a flash of inspiration so I also went off down a rabbit hole a bit with FluentMigrator and sqlite-vec

But, I had fun writing it, which I've been missing for a while, so this I'm happy

#DotNet #sqlite #Dapper

https://dazfuller.uk/posts/2026-04-12-dapper-vectors/

Handling Vector data with Dapper

It’s been a while since I did something a little bit more fun with C# and DotNet (DROP THE DOT ✊), so I wanted to look at something I’d come across recently with one of the applications I help build, maintain, and deploy at work, lovingly named “Vogon” (because Hitchhiker’s Guide to the Galaxy is everything). I’m not normally one for using Object Relational Mappers (ORMs), mostly because I know what SQL I want to write and tools like Entity Framework don’t let me customise as much as I want to, or at least not without jumping through lots of hoops and wasting time. But… the application does do a lot of reading and writing data, and then mapping the results to and from C# classes. So I relented a little and went half-way by using the Micro-ORM Dapper.

reality.foldLeft