A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

This is a foreign data wrapper (FDW) to connect PostgreSQL to SQLite database file. This FDW works with PostgreSQL 13, 14, 15, 16, 17 and confirmed with SQLite 3.49.0 ...

TL;DR: SQLite isn’t just a lightweight SQL engine—it’s a killer embedded document store. With built‑in JSON/JSONB, generated columns, expression indexes, and WAL, you can model and query complex JSON ...

Deciding how to store JSON data often involves choosing between a database, a file system, or an object store. Each option comes with unique strengths and limitations, and the right choice depends on ...

Lift the hood on most business applications, and you’ll find they have some way to store and use structured data. Whether it’s a client-side app, an app with a web front end, or an edge-device app, ...

For background on this project, see Google Drive to SQLite on my blog. If you use Google Drive, and especially if you have shared drives with other people there's a good chance you have hundreds or ...

A mistake in the process used by the Signal Desktop application to encrypt locally stored messages leaves them wide open to an attacker. When Signal Desktop is installed, it will create an encrypted ...