Changed database structure, using labels table rather than store the
pinned and favourite status in the clips table, which will use smaller
disk space, and will increase the query speed.
Changed the sql dependency from sqlx to rusqlite, sqlx to powerful for
this case, using rusqlite, will increase query speed and shrink the
final build size.
As rusqlite only support readonly virtual table, the fast search feature
is removed and all virtual table got migrate to normal table,
which allow the use of foreign key and other sqlite feature, and
simplify the database structure.
Changed database structure, using labels table rather than store the pinned and favourite status in the clips table, which will use smaller disk space, and will increase the query speed.
Changed the sql dependency from sqlx to rusqlite, sqlx to powerful for this case, using rusqlite, will increase query speed and shrink the final build size.
As rusqlite only support readonly virtual table, the fast search feature is removed and all virtual table got migrate to normal table, which allow the use of foreign key and other sqlite feature, and simplify the database structure.