I'm logging traffic data (IP-pairs and packet+byte-count) into a SQLite database on a couple of machines, and what bothers me is that I'm unable to query them whenever I want. So the files end up being rotated whenever I want to inspect one closer.
While it's good to have a simple storage solution, it does have its drawbacks.
Then again, yesterday I was working a bit with MBTiles, which are SQLite databases with per-z,x,y-protobuf-blocks of vector data, and in that case it does make sense to use SQLite. Or the things browsers use them to store bookmarks and stuff.
While it's good to have a simple storage solution, it does have its drawbacks.
Then again, yesterday I was working a bit with MBTiles, which are SQLite databases with per-z,x,y-protobuf-blocks of vector data, and in that case it does make sense to use SQLite. Or the things browsers use them to store bookmarks and stuff.