A Catalog Is Not A Library

This file is 82,100 bytes and 3,652 lines. It carries schema 1, 1 root, a generated stamp of 2026-09-14T16:13:48 and 158 rows inside a single videos array. Every row carries the same 18 fields in the same order, 2,844 cells in total. There are no duplicates: 158 paths, 158 distinct. Every row reads kind root. The codec is h264 on 158 of 158, which is the only field in the file with no variation at all. The scan is the most complete description of this library that exists anywhere. It knows the frame rate of every clip, the exact byte count and the second each file was written to disk. It also never once says what any of them is for.

The 18 fields split cleanly. 13 of them measure the file: duration, width, height, fps, codec, bytes, size, mtime, the key pair, the path, the filename and the stem. 5 were put there to record judgment, and 4 of those 5 sit inside the 632 cells that were meant to answer 1 question: has this file already been spent. Read them row by row and the answer never arrives. use_count reads 0 on 158 of 158 rows. last_used reads null on 158. note reads null on 158. tags reads as an empty list on 154, and on the other 4 it holds the same word, bug. Those 4 rows are the proof that the column works. The schema did not fail. It was never filled.

1,855,881,339 bytes, which is 1.856 gigabytes, an average of 11,746,084 bytes per row. The library spans 10 projects and the weight does not sit evenly across them. Sal_y_Miel holds 67 rows and 633,031,429 bytes. Salvador holds 10 rows and 621,044,597. Together those 2 projects are 77 rows and 1,254,076,026 bytes, which is 67.6 per cent of everything on the disk. The longest file runs 206.166667 seconds. The shortest runs 0.6. There are 43 distinct durations. 6 rows pass 200 seconds and 110 rows sit at 8.041667 seconds or under, which is 69.6 per cent of the library under 9 seconds. One line of the index can tell you that. Nothing in it can tell you which of the 110 you have already cut.

12 distinct resolutions across 158 rows: 44 at 1920x1080, 36 at 1280x720, 26 at 848x480, 12 at 1344x768, 11 at 720x1280, 9 at 1080x1920, 8 at 768x1364, 4 at 1366x768, 4 at 1284x716, 2 at 1270x726, then 1 each at 1364x768 and 720x480. 130 rows are landscape and 28 are vertical, so 28 rows exist for a 9:16 frame and 130 do not, and nothing in the file marks which 28 can be reused without a rebuild. Frame rates split 120 at 24, 37 at 30 and 1 at 8. The newest file dates 2026-09-11 and the oldest 2026-04-22, 142 days apart. 4 rows of the 158 carry a tag, the tag is bug, and it was typed on 4 files in 1 archive folder. That is the entire human commentary in 82,100 bytes.

82,100 bytes. 3,652 lines. 158 rows.

The reuse-first rule says to pull from what exists before you render anything new. To obey it you need 2 things: an index of what exists and a record of what has been spent. This file is the first and not the second. 632 cells across 158 rows are reserved for reuse. 158 of them read 0. 470 read empty. 4 read bug. Set that against the measurement columns, which never missed a row: fps on 158, codec on 158, resolution on 158, bytes on 158, mtime on 158. The columns that describe the object are perfect. The columns that describe the spend are empty. A catalog is a description of a shelf. A library is a description of what has been taken off it, and this one carries 4 lines of history on 158 items.

The probability that a folder of 158 finished files gets re-rendered from scratch because nobody can see which ones were already spent is not zero, and most people price it at zero. The bill arrives as duplicate renders, and a duplicate is a render you cannot spend twice. The fix is not a better index. It is 4 columns filled at the moment of use: a tag when you cut it, a note when you reject it, a count, a date. 210 energy systems were deployed across Africa and Asia on the same rule, each unit carrying its own service record, because a fleet counted from memory is a fleet you will rebuild. It answered 158 questions and skipped the one that decides reuse. A catalog is not a library. Keep more of yourself, for longer.