How can I securely host a Node.js app with SQLite?

I’d recommend looking into containerizing your app with Docker, and really think hard about using a more powerful database like MySQL or MariaDB if you intend to scale effectively. SQLite can become a bottleneck if you have multiple users accessing the app simultaneously. For security, always keep a 'least privilege' approach in mind—restrict access to only what's necessary.

You might want to consider using NGINX in front of your Node.js app. If possible, think about switching to MySQL instead of sticking with SQLite. It can be hosted on a single VM or even set up in a Docker swarm for scalability. Also, ensure to secure your host system by following CIS benchmarks.

I suggest you look into building a Docker image for your Node.js and SQLite app, which can simplify deployment and scaling. Don't forget to create a specific user for running your service with minimal permissions to increase your security.

While SQLite has its advantages, it's really more suited for single-user applications. If you're considering reliability, make sure to pay attention to Node.js's memory management. It’s essential to monitor memory usage and employ proper unit testing. Using prepared statements is a must to safeguard against SQL injection attacks.