facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideofacebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo
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
Real-Time Decision-Making Use Cases In The Retail Industry – Part 3
  • May 26, 2020

Real-Time Decision-Making Use Cases in the Retail Industry – Part 3

In the first part of my blog on Real-Time Decision-Making (RTDM) highlighting Retail industry use cases, we discussed how combining existing historical data patterns with disparate new sources of data completes the Common Operational Picture (COP).  To illustrate the use-case, we used an Actian customer, Kiabi, and how they used RTDM strategic capabilities to…

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
Real-Time Decision-Making Use Cases In The Retail Industry – Part 2
  • May 18, 2020

Real-Time Decision-Making Use Cases in the Retail Industry – Part 2

In my last blog on Real-Time Decision-Making (RTDM), I shifted from a theoretical discussion of what RTDM is to uses cases that highlight key aspects of the value it can bring to business in periods of market uncertainty. I'm using the Retail Industry because its an Industry everyone knows something about coupled with the…

Read More
Real-Time Decision-Making Use Cases In The Retail Industry
  • May 14, 2020

Real-Time Decision-Making Use Cases in the Retail Industry

In the last blog on Real-Time Decision-Making (RTDM), we discussed exactly what it is and why it matters.  Before proceeding with more theoretical discussions, though, it’s probably worthwhile to give you some practical examples of RTDM and how data management, integration, and analytics support, build RTDM strategic capabilities that significantly impact business operations. Retail:…

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
An Embedded Software Developers Flat File Migration Check List
  • January 24, 2020

An Embedded Software Developers Flat File Migration Check List

This is the final installment on the series of blogs I wrote 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 them.  Then in the second installment, I discussed why embedded…

Read More
It’s Back To The Future For Flat Files … Part Three
  • November 25, 2019

It’s Back to the Future for Flat Files … Part Three

Why embedded software application developers should dump flat files before they have to run dump on them I wrote an initial blog a few weeks ago on flat files and why embedded software application developers readily adopted them.  Then in the next blog, I covered why embedded developers are reluctant to use databases.  In…

Read More
It’s Back To The Future For Flat Files … Part Two
  • November 11, 2019

It’s Back to the Future for Flat Files … Part Two

Why Embedded Software Application Developers Loath Databases Last week I wrote an initial blog on flat files and why embedded software application developers readily adopted them.  Simply put, they’re always there – if you’ve got an Operating System that’s more than a bare-bones executive kernel it’s there and it’s free.  Also, flat files are…

Read More
It’s Back To The Future For Flat Files … Part One
  • November 6, 2019

It’s Back to the Future for Flat Files … Part One

Why embedded software application developers adopted flat files Recently, my colleague here in Actian Product Marketing, Pradeep Bhanot, wrote a great blog on Data Historians in which he called for their retirement in favor of more modern databases to support time-series data processing and analytics.  But, in some ways, historians are not as historic…

Read More
  • 1
  • 2