(Slightly) Advanced cache use cases to improve performance

Posted on by David Vassallo

In this article we will explore two related use cases, using caches to improve performance. The use cases are probably very familiar to engineers coming from a front-end background, but I rarely see documentation on the concepts used within a back-end context. The use cases are based off real world scenarios we've encountered in CyberSift. … Continue reading (Slightly) Advanced cache use cases to improve performance

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