I need to create an application with prefilled db and periodically refresh data from external api.
Data are about 100000 db row with 10 varchar(150) field.
I think to do it with sql-lite db, and rest api. When user click update button I send remote request, truncate local table and do some insert query for insert new data.
Is the correct solution? I read something about couchdb but I don’t know if it’s the best solution.