undefined | Better HN

0 pointspoincaredisk1y ago0 comments

It really depends on the project. For a CRUD application? Sure. For an application that processes hundreds of events per second, stores them, and makes them wueryable using various filters? Can get tough real quick.

0 comments

bsenftner1y ago

That's where SQLite really shines - used it in a massively scaled facial recognition system, with several hundred simultaneous cameras, a very large FR database with over 10K people, each having dozens of face entries, and all the events that generates from live video viewing large public venues. SQLite was never a bottleneck, not at all.

leosanchez1y ago

Single sqlite db or did you shard it ?

bsenftner1y ago

Single SQLite db embedded within the FR server, with some crazy huge database size of 75+ million faces too. This system is now deployed in a huge percentage of the western world's airports.

j / k navigate · click thread line to collapse

0 pointspoincaredisk1y ago0 comments

0 comments

bsenftner1y ago

leosanchez1y ago

Single sqlite db or did you shard it ?

bsenftner1y ago

Single SQLite db embedded within the FR server, with some crazy huge database size of 75+ million faces too. This system is now deployed in a huge percentage of the western world's airports.

j / k navigate · click thread line to collapse