Database Review 2021
My prediction: SQLite will keep gaining popularity.<p>Especially among pragmatic software builders who run their own business and do not work for the man. A demographic that I expect to grow.<p>Talking about SQLite: Is there any downside to partitioning an SQLite db into multiple files?<p>For example one of my systems has a table &#x27;details&#x27; which is not vital for the system to work. It&#x27;s just a nice to have, to have data in this table. And it is pretty big, growing fast.<p>When I copy the DB over to another system, I don&#x27;t need that table. So it would be nice to have like primary.db and secondary.db. With &#x27;details&#x27; in secondary.db. Any downside to this approach? Are JOINS slower across two files than across two tables in the same file?