• 2 Posts
  • 396 Comments
Joined 2 years ago
cake
Cake day: January 5th, 2024

help-circle






  • Okay, I must confess, I knew about that, as well as the other options in the replies. I never used any of them but I knew they exist. When I asked it was sort of as a rhetorical question. People generally wouldn’t know about these obscure typing options, so I was playing the everyman.

    Even if you do know it, if you don’t use it often enough you forget and have to look it up again next time.










  • I think SQLite is a great middle ground. It saves the database as a single .db file, and can do everything an SQL database can do. Querying for data is a lot more flexible and a lot faster. The tools for manipulating the data in any way you want are very good and very robust.

    However, I’m not sure how it would affect file size. It might be smaller because JSON/YAML wastes a lot of characters on redundant information (field names) and storing numbers as text, which the database would store as binary data in a defined structure. On the other hand, extra space is used to make common SQL operations happen much faster using fancy data structures. I don’t know which effect is greater so file size could be bigger or smaller.