10/2/2023 0 Comments Sqlite3 browserThe results can be displayed in the context of that component, or embedded into the DOM (that is, anywhere in the web page) as inline content. The Phiresky blog post also includes a rather nifty web component for embedding, editing and executing SQL queries over the (remote) database, as well as displaying the results. The techique used is described in Phiresky’s blog post Hosting SQLite databases on Github Pages (or any static file hoster) (for a full demo, use the netlify hosted version of the post). This means that you can host an arbitrarily large SQLite database on a (static) file hoster and then query the database from the browser without needing to download the whole database. Via I learned of the phiresky/sql.js-httpvfs package, a fork of sql.js that “provide a read-only HTTP-Range-request based virtual file system for SQLite”. If the database is large, however, this could cause a delay as the database is downloaded, or knock your browser over completely if the database file is very large. If the database you want to query is hosted via a web URL, sql.js can load the database from the URL. If you know of such an example, please let me know via the comments. It would be handy if a simple template for creating sql.js apps with custom queries and database and query persistence using IndexedDB were available. Packages such as dexie.js provide a convenient wrapper around it and tools such as manics/jupyter-offlinenotebook can use it to persist items in the browser from otherwise transient web application sessions, such as MyBinder powered Jupyter notebook sessions. IndexedDB is a NoSQL storage solution that is supported inside contemporary browsers. In the case of sql.js, the minimal demo UI does not persist the database, nor provide any means for saving and reusing queries: it is just a minimal, temporary UI. But there is another huge issue that is perhaps currently a blocker for using in-browser apps in an educational setting: if you edit content in the app – for example, a SQL query you spent ages crafting – you lose it when you close the web page: there is nowhere you can save it to and then reload it, nowhere you can persist it, unless you export it / downlad it to the desktop, and then import it / upload it from the desktop next time you run the application. Fortunately, applications such as v make it possible to run a webserver in your web browser to serve content held locally by uploading it to the browser and serving it from there:įor running simple applications, installing something like v as an app so you can run it offline is really handy when it comes to not requiring a user to run their own webserver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |