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

Spring Boot R2DBC INSERT batching (Reactive SQL)

Batching is the act of gathering multiple statements together and executing them over a single database connection. Batching has performance benefits since the database can better optimize the batched queries, however it also "saves" having to open individual database connections and reduces connection starvation. Connection starvation in Postgres ends up spitting out errors along the … Continue reading Spring Boot R2DBC INSERT batching (Reactive SQL)