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
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.
