![]() Just had the same need as the op and found the app on github. DRF (django rest framework), flask restfull, google firebase, etc.ĭisclaimer: I am not affiliated with the author of the app. ❗️ It depends on your use case but probably the best answer to the original question is "don't do it!" If you need to access the data programmatically over the net then export the sqlite tables to something like JSON files and put them on a webserver, or expose the database via a more secure mechanisms like e.g. The UI has an option to export CSV or JSON and if you look at the request being made in the browser devtools you'll see that you can get the data directly as JSON by doing a POST request with an SQL query ( very neat for playing and debugging in your intranet but worst nightmare ever if you expose that over the internet ❗️□ ❌ - you have been warned❗️): Example POST request to get JSON data curl -data-raw 'sql=SELECT * FROM mytable limit 42 &export_json=' ![]() For remote access on a public host you might want for example to bind it to 127.0.0.1 and then forward the port over ssh. While running with -host 0.0.0.0 might be fine on your own home or corporate network, it's a really bad idea to do it on a public host (even though the app allows setting a password). To make it visible on your LAN/WAN start it with: sqlite_web -host 0.0.0.0 my_database.db datasette: Datasette is a tool for exploring and publishing data.Starts up a server that provides a web interface to your SQLite data. Beekeeper Studio: Open Source SQL Editor and Database Manager DB Browser for SQLite: Desktop-based browser. ![]() Once installed, start the web interface with: sqlite_web my_database.dbīy default it runs on ie is only accesible from the localhost. See the docs directory for full documentation. While sqlite itself does not provide any network endpoints you can use a web gui such as sqlite-web.Īssuming you have python installed you can install it with pip install sqlite-web
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |