Click the Windows "Start" button and type "cmd" without quotes in the Search text box. Press "Enter" to open the Windows command prompt. Type "sqlite" without quotes to start the command line prompt.

You convert old Sticky Notes StickyNotes.snt data file to the new Sticky Notes plum.sqlite data file so that you can use the Windows 7 legacy Sticky Notes on Windows 11/10.

SQLite supports several datatypes: NULL for empty, INTEGER and REAL for signed integers and floating point values respectively, TEXT for text strings, and BLOB for binary files.

Testing with a database file with a 1.9 GB table and a 800 MB index (yikes!) dropping the index frees up that 800 MB after running sqlite_sparse, but an immediate "get info" doesn't show this.