We're going to look at a couple approaches for sharing the data in our database. We'll start by exporting data into another format (e.g., CSV), and we'll finish by dumping our data into another file ...

For each of the data requests below, write a single SQL query that will retrieve the requested data. Copy the working query for each request to the file queries.md. If we want to double-check the ...

In my last column, I introduced SQLite, an amazing little database engine written and provided entirely in C source code. I showed you how to begin wrapping it up in modern C++, producing a correct ...

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, ...

Configure and build the source code. I’ll use mipsel-linux-gcc, but any other cross-compiler could be used. At this point the library is correctly configured and installed, so you’d just need to copy ...

What if the database you rely on could handle writes four times faster without sacrificing simplicity or reliability? For years, SQLite’s single-writer limitation has been both its strength and ...