This project performs a simple but production-ready ETL pipeline that processes multiple CSV sales files, transforms the data, stores it in a SQLite database, and exports a monthly summary.

This Python script ingests a CSV-formatted text file containing track metadata and populates a normalized SQLite database (trackdb.sqlite). It implements a relational schema with referential integrity ...

The SQLite database is a wildly successful and ubiquitous software package that is mostly unknown to the larger IT community. Designed and coded by Dr. Richard Hipp, the third major revision of SQLite ...

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