If you have a DB, what is the best way of letting people access it? And managing, limiting and charging for accessing it (for power users). I'd like a kind of API library/package/solution that doesn't have to be designed from scratch. I need to install it in my web-site, so, no 3rd party solutions which would provide me this as a service. The DB is a SQLite, but I am flexible on this, and willing to migrate to another DB. The hosting is still not running, so, I'd pick whatever is needed. I'm wondering if there are any Web API that let's users performs url-encoded call on the data. (and manage the call in the terms above). I will be uploading the DB (25-30 GBs) and letting users, at least several hundreds (who would be using whatever programming language fits them best) to query the DB in the form (www.mysite.com/?a="aaaa"+b+"bbbb"). Think a content management system (CMS), that will be accessed programmatically, not with a web-browser, and would be offering one-liners, not blog texts and the like. It will need to manage (registered) users, if they exceed a threshold. The point is also that it should be implemented with minimal programming (as much as if I wanted to deploy a Python Plone web-portal) and accessed by people with minimal programming skils.
There's a couple different ways you can go with this. The first would involve running an apache distribution like XAMPP on your own server. You would set up a MySQL database and make it accessible from remote computers. XAMPP installs with everything you need.
The second is a little more expensive, but, provides more features and security. There are several NAS (Network Attached Storage) (eg. Synology) devices that allow setting up a web server with full database support and remote access.