Remote DB, how best to implement?

Question

Programming

The bottom line is, if there are N users and 1 database, there is a weak communication channel between the user and the database (say 1sec ping and 200kbit speed), the database can contain, say, 10MB and is constantly updated (10 rows per hour), but you need to constantly request different large samples. Because of the channel, regular SQL is no longer an option, it is not an option, you need to somehow cache the database locally and periodically update the local copy. The question is how best to implement this? What to use?

Answer 1

This is called replication .

Answer 2

It is not entirely clear what is meant by
as I understand it, not the query language itself, but the specific implementation of the database.
There is nothing wrong with SQL databases, you just need to really add a cache on the client, for example using SQLite or regular files.