If you work with research compounds, you quickly end up with a mess of spreadsheets: product names, CAS numbers, molecular weights, batch numbers, purity results from Certificates of Analysis (COAs), and storage notes. Spreadsheets break the moment two people edit them or you need to ask a question like "which batches are below 98% purity?"
In this tutorial we'll build a small, fast, zero-setup peptide research database with Python's built-in sqlite3 module. No server, no ORM, no extra installs.
By the end you will have:
A clean relational schema (peptides β batches β test results)
A script to import data from CSV
Useful queries (purity filters, latest batch per peptide, averages)
A tiny command-line search tool
Why SQLite?
It ships with Python β import sqlite3 and you're done.
The whole database is one file you can back up or commit.
It handles millions of rows easily, which is far more than a research catalog needs.
Real SQL means real queries, joins and constraints.
1.β¦