Inserting, reading, and updating JSON data in postgres using Golang GORM

This is a "Frankenstein" approach which worked well using a combination of methods found online (see references). On their own, each approach had a limitation, but together they ticked all the boxes. Assuming you have the following table defined as a struct within you Go program: type User struct { Name string Email string Attributes … Continue reading Inserting, reading, and updating JSON data in postgres using Golang GORM

How to easily create your own SQLite Virtual Table

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