July 2, 2020 SQLite: Not Faster, Not Better, But Cheaper? Understanding SQLite’s Total Cost of Ownership (TCO) Over the past three months this blog series has explored why developers gravitated toward SQLite for embedded data management. Some developers chose SQLite because members of the extended team knew SQL and wanted to leverage that knowledge to support data management or the extraction of data for… Read More
June 17, 2020 SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Three: SQLite, the “Flat File” of Databases Over the past few articles, our SQLite Blog series has been looking at SQLite Serverless Architecture and how it is unsuitable for IoT Environments. Those of you who have been following can jump ahead to the next section, but if you’re new to this discussion, you… Read More
June 11, 2020 SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two Part Two: Rethinking What Client-Server Means for Edge Data Management Over the past few weeks our SQLite Blog series has considered the performance deficiencies of SQLite when handling local persistent data and looked at the performance complications created by the need for ETL when sharing SQLite data with back-end databases. In our last installment—Mobile… Read More
June 11, 2020 SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part One Part One: Mobile may be IoT—but, when it comes to data, IoT is not Mobile Three weeks ago, we looked at the raw performance—or the lack thereof—of SQLite. After that, we looked at SQLite within the broader context of Modern Edge Data Management and discovered that its performance shortcomings were in fact compounded by… Read More
April 29, 2020 SQLite – the Banana Slug of Embedded Databases Earlier this month, I kicked off a series of blogs about SQLite. The first looked at the advantages that SQLite offers over both flat files and the heavier lift of an enterprise-grade SQL databases – and it does offer distinct advantages over both. To a point. And that point was five years ago. Here's… Read More
April 7, 2020 Making the Transition from Flat Files to SQLite – pluses, but what’s missing against requirements? In December, January, and February, I posted a short series of blogs on Flat file systems. The series of blogs focus on the continued use of flat files and why they are no longer viable for use in the future. The first installment focused on flat files and why embedded software application developers readily adopted… Read More
December 19, 2018 Worried about SQLite security vulnerabilities? Keep calm and stay safe. Face the inevitable: Local persistent data at the Edge will happen It’s indisputable that Edge Intelligence will grow, whether that’s mobile applications running on Smartphones, IoT applications running in Smart Cars (or the underlying sensors), in the entertainment center, navigation systems, etc. There will be countless mobile and IoT – taken as a whole,… Read More
May 18, 2020 SQLite Equals ETL Heavy Two weeks ago, I likened the performance of SQLite to that of a Banana Slug. Now, some may consider that a bit of hyperbole (and some UC Santa Cruz alumni may feel that I impugned the good name of their mascot, which was not my intent) but the numbers don’t lie. The measurable difference… Read More