Actian Blog / Tag / SQLite

Tagged Posts: SQLite

SQLite: Not Faster, Not Better, But Cheaper?
  • 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
SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well
  • 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
SQLite’s Serverless Architecture Doesn’t Serve IoT Environments Well Part Two
  • 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
SQLite – The Banana Slug Of Embedded Databases
  • 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
Worried About SQLite Security Vulnerabilities?  Keep Calm And Stay Safe.
  • 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
SQLite Equals ETL Heavy
  • 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
facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo