How to easily create your own SQLite Virtual Table

Posted on by David Vassallo

What is a Virtual Table? "Normal" tables consist of rows and columns. Plenty of data sources - like APIs - don't quite adhere to this format, but with a little "data massaging" can be made to output data into rows/columns. This is exactly what a virtual table does... SQLite can execute your own programs which … Continue reading How to easily create your own SQLite Virtual Table

Golang Gotcha: Modifying an array of structs

Posted on by David Vassallo

Scenario Using Golang, we initialize an array of structs, within which we'd like to change a field by iterating over the initialized array. This would be necessary (for example) to initialize certain struct fields. An initial pass at the code may look something like this: // play with this code here: https://go.dev/play/p/VH0duYxZVZn package main import … Continue reading Golang Gotcha: Modifying an array of structs