Visual Studio Magazine

SQLite Queries and Primary Keys

In this third and final installment on using SQLite from C++, I want to begin exploring some of the internals of this amazing little database engine. SQLite does things quite differently than most ...
Analytics Insight

DuckDB vs SQLite: Features, Performance, and How to Choose the Right Database

Overview: SQLite is suitable for apps that require reliable storage and small but frequent updates.DuckDB can handle large ...
TMCnet

Visual DB Partners with SQLite to Bring a Modern UI to the World's Most Widely Deployed Database

"Our mission is to elevate relational databases for everyday users," said Rajeev Karunakaran, co-founder of Visual DB. "SQLite has always been rock-solid infrastructure. By sponsoring SQLite and ...
Visual Studio Magazine

Using SQLite with Modern C++

Microsoft has long offered a compact alternative to the mainstream editions of SQL Server, but the SQL Server Compact Edition appears to be losing steam. It's not particularly compact and has lost ...
Houston Chronicle

How to Convert SQLite to Excel

SQLite, a lightweight database suitable for managing small data systems, might power some of your business' applications and websites. If it does, you might wish to share SQLite's data with your Excel ...
Ars Technica

Deallocating unused data blocks in a file, possible on MacOS?

Ok, this is one for the real MacOS experts. What I want to do is reclaim unused disk blocks from an SQLite file and free those so they can be used for something else. sqlite_sparse on Github does ...