One of the things you should acquaint yourself with if you enjoy using sqlite, is the without rowid feature. It reduced the many to many table's size by nearly 2.4 Gb in a 3 gb file that we have.
It also improved performance significantly, so uh, if you can use it, then you should :D
@violet This is interesting. Have you reported this upstream?
Server run by the main developers of the project It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!