Author	SHA1	Message	Date
Andrew Nesbitt	1a814c7e1f	Use shared integrity verification (#260) ... * Use shared integrity verification * Finish integrity migration	2026-08-17 09:20:11 +01:00
Andrew Nesbitt	6fcc57c994	Optimize cached artifact serving (#245)	2026-08-13 08:06:41 +01:00
Andrew Nesbitt	e45706d808	Track applied migrations to skip column checks on startup (#60) ... * Track applied migrations to skip column checks on startup Add a migrations table that records which migrations have been applied. On boot, load the set of applied names in one query and only run new ones. A fully migrated database now does 1 query instead of ~12 HasColumn/HasTable checks. Fresh databases created via CreateSchema record all migrations as already applied. Old databases get the migrations table on first MigrateSchema call and each migration is recorded after it runs. Closes #54 * Add benchmark for MigrateSchema on fully migrated database * Optimize MigrateSchema to single query for fully migrated databases Skip HasTable/HasColumn checks when the migrations table already exists. A fully migrated database now does one SELECT instead of ~12 individual column and table checks. * Add migration docs and link from architecture * Add test for upgrade from fully migrated database without migrations table	2026-04-06 13:06:45 +01:00
Andrew Nesbitt	8ddf07587c	Fix golangci-lint errors (errcheck, staticcheck, unused)	2026-02-16 10:53:21 +00:00
Andrew Nesbitt	2d7cb8eae5	Refactoring and features	2026-02-03 22:40:40 +00:00
Andrew Nesbitt	1eb9d71bd7	Align database schema with git-pkgs for compatibility ... The proxy can now use an existing git-pkgs database as a starting point. Packages and versions tables match git-pkgs schema, using PURL-based references instead of integer IDs. The proxy adds its own artifacts table for caching functionality.	2026-01-29 16:44:01 +00:00
Andrew Nesbitt	41aa11ab66	Add sqlx with SQLite default and PostgreSQL option ... Replace raw database/sql with jmoiron/sqlx for cleaner query handling. Support both SQLite (default) and PostgreSQL as configurable backends. Configuration via: - CLI flags: -database-driver, -database-path, -database-url - Environment: PROXY_DATABASE_DRIVER, PROXY_DATABASE_PATH, PROXY_DATABASE_URL - Config file: database.driver, database.path, database.url Tests run against both databases when PROXY_DATABASE_URL is set.	2026-01-29 16:06:56 +00:00
Andrew Nesbitt	7b22638ef7	Hello world	2026-01-20 22:00:31 +00:00