I'm working on creating a self-hosted website that connects to a local SQLite database. The goal is to design it with filters and user-friendly GUIs so that my less tech-savvy friends can easily query and extract information from the database. This will be my first website, and I'm planning to use JavaScript for both the backend and frontend, as I want to learn more about this language. I have intermediate SQL experience and some knowledge of Python. What are the key requirements I should focus on to get my project off the ground?
1 Answer
Building this with JavaScript is definitely achievable and not overly complex. You'll need to set up an HTTP server using something like Fastify to get started. Make sure you're also comfortable with basic HTML and CSS since you'll need those for the site layout.
I get that, but I'm kind of nervous about setting up the filters and search functions. How do I even begin turning my SQL queries into user-friendly options?