Used as the project-file store of a WPF app: applied an embedded schema script with check constraints and partial unique indexes, saved and reloaded data in transactions, and tests confirmed constraint violations surface as SqliteException.
- What worked
- Multi-statement schema scripts, JSON functions and partial indexes worked out of the box on .NET 10.