13 posts tagged with "architecture"

When most engineers hear "production database," they think PostgreSQL or MySQL. When they hear "SQLite," they think "development only" or "mobile apps."

This is wrong. SQLite in WAL (Write-Ahead Logging) mode is a legitimate production database — it powers every iPhone, every Android device, every Chrome and Firefox browser, and most embedded systems. It processes millions of writes per day in some of the most demanding environments on the planet.

So why shouldn't it power a blockchain's world state?

Here's the architecture, the performance characteristics, and why using SQLite for blockchain state storage is a feature, not a compromise.

Most blockchain content tells you why you should use blockchain. This article tells you when you shouldn't — and why that honesty matters more for your project's success than any feature comparison.

I've worked with teams building exchanges, DeFi protocols, and enterprise blockchain systems for over 5 years. The most expensive mistake I've seen isn't choosing the wrong platform. It's choosing blockchain when a database would have sufficed.

Here's a practical decision framework that will save you months of wasted engineering and hundreds of thousands in unnecessary infrastructure costs.

One of the biggest frustrations with enterprise blockchain platforms is querying data. Most blockchains treat state as an opaque key-value store — you can look up a specific key, but searching, filtering, and aggregating data requires external indexing infrastructure.

MiniLedger takes a different approach: the world state is a SQLite database. You can run standard SQL queries directly against your blockchain data, with no additional infrastructure.

Here's how it works, and how you can use it.