3 ms·
I might be mistaking things here but I believe that Apple's CoreData and Android's equivalent are both powered by SQLite under the hood. Messages on macOS stor
by dmlittle 6y ago
I might be mistaking things here but I believe that Apple's CoreData and Android's equivalent are both powered by SQLite under the hood.
Messages on macOS stores all your message in a SQLite file under ~/Library/Messages/chat.db
- duskwuff 6y agomacOS and iOS both use SQLite pervasively. There's tons of little databases all over. Chrome uses SQLite heavily for history, cookies, bookmarks… etc. So does Firefox. SQLite is everywhere. :)
- regularfry 6y agoIt's everywhere to the extent that I find it hard to believe it's not lurking somewhere on a default Windows install. I would very much like to be able to say to people "do not use excel for that. It will make you cry" and not have the response "corporate IT won't let me install anything better."
- duskwuff 6y agoIt definitely exists within Edge, as that's Chromium-based. Not sure it's available in a standalone form, though.
- regularfry 6y agohttps://renenyffenegger.ch/notes/development/databases/SQLite/VBA/index https://renenyffenegger.ch/notes/development/databases/SQLit... gives me some limited hope.
- sgt 6y agoIt must be easy for SQLite developers to apply for jobs. Let me into your company, you've already let me into your home, your office, your data center, and your pocket.
- caspar 6y agoAs amusing at it is to imagine, their team page only lists 3 developers[0], so I bet that turnover does not happen particularly frequently! [0]: https://sqlite.org/crew.html https://sqlite.org/crew.html
- Cloudef 6y agoCoreData is such a awfully engineered piece of software with bunch of pitfalls that you are much better just using SQLite directly.
- closeparen 6y agoTip: you must grant your terminal application "Full Disk Access" in Security & Privacy settings in order to poke around this directory.