How to embed SQLite into a website?

Question

SQLite

Hey! The task seems simple, but I don't know how to approach it. I need the finished database to be in the site. Ideally, give the opportunity to choose a period and based on this, data graphs were built. Or just insert tabular data into the site and have this data automatically updated on the site. Tell me what to look for and read to implement this. Thank you!

Answer 1

Don't use SQLite. There are a lot of reasons for this and the first one is not intended for this !!!
On the server, make a controller that returns json with the results of a query to a normal database, if only reading, then you can use SQLite, but again with caution

Answer 2

Read documentation on how to work with SQLite in the language in which you write the site.