Function migrateIsNewColumn

main.js:1758–1776

Add isNew column for "new until edited" badge; existing rows are not new.

()

      ORDER BY LENGTH(thumbnail) DESC
    `).all(THUMBNAIL_MAX_STORED_CHARS);

    if (rows.length === 0) return;

    const batch = rows.slice(0, THUMBNAIL_MIGRATION_MAX_PER_SESSION);
    const remaining = rows.length - batch.length;
    console.log(
      `Migrating ${batch.length} legacy thumbnail(s) (${reason || 'startup'})` +
      (remaining > 0 ? `; ${remaining} deferred to a later session` : '') +
      '...'
    );

    let updated = 0;
    for (const row of batch) {
      try {
        const allowOversized = row.thumbLen > THUMBNAIL_ABSOLUTE_MAX_LOAD_CHARS;
        const thumbnail = readThumbnailColumn(row.filePath, { allowOversized });
        if (!thumbnail) continue;

        const parts = thumbnail.includes('::') ? thumbnail.split('::').filter(Boolean) : [thumbnail];
        const needsWork = parts.some((part) => needsCompression(part));
        if (!needsWork) continue;