I have a project, where I need to fetch data from an SQLite database and show it to an user on HTML. There is some interaction (e.g. button clicks) with which the user changes some data. What can I use "between" HTML and SQLite for the logic? I thought of JavaScript, but i dont find an easy way to include the sqlite module such that it works via the browser. Can I just make a nodejs server and exchange data via xmlhttp request? I can imagine php is a good idea, but i have no clue how to link php with html (and tbh not of php in general).
I can imagine this is a very common scenario - but I really have no idea what my options are. I can programm JavaScript (and Java, and Python) but never made anything like this before. I dont know who I can ask and I did not find anything helpful with google, so Im asking here, hoping for some help. I just want to know which programming language(s) are "common"/"good practice" to use in this scenario - I will work myself into the details of the language on myself of course.
PS: its just an sqlite file for now, not a whole database server
Thanks in advance!