PreFilled Db and local update


#1

Hi,

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.

Thanks