It is an SQLite client for web browsers and a fork of sql.js. Sql.js-httpvfs is the pet name of the open-source component built by phiresky. We will therefore only be able to do read operations, which is what I actually need, but perhaps not for all readers of these lines. Warning: The rest of this article assumes that we will query the database from a simple static server. And I'm going to do the test with reac-admin. But I discovered this excellent article by phiresky, "Hosting SQLite databases on Github Pages", which made me want to test this solution based on a real database rather than on simple export files. Of course, a small project means a small database that can be easily exported in JSON or CSV. It would only move the "real" server to a third party, which is not justified in terms of infrastructure (and therefore ecological impact) for my small project. But if the interest to test these services is still there, it didn't really answer my goal. Until now, I was thinking of trying a slightly innovative DBaaS, like PlanetScale, Prisma, Back4App or OrbitDB. Or, perhaps, you’ll adopt the approach of creating serverless tools with vanilla JS and GitHub API.I've been looking for a way to easily share a database for a small project that doesn't warrant a "real" database server. Try SQLime for yourself - see if you find it useful. Since there is no build stage, I didn’t even have to set up GitHub Actions. The playground is hosted on GitHub Pages, and the deployment is a basic git push. A real frontend developer will wince probably, but I’m fine.
#SQLITE BROWSER GITHUB CODE#
And there are command shortcuts for the desktop.Īt the same time, the code turned out to be quite modular, thanks to native JS modules and web components - they are supported by all modern browsers. I took care of the mobile layout: the playground is perfectly usable on the phone. It seems to be quite acceptable for a small project. So I deliberately did not use UI frameworks and did everything with vanilla HTML + CSS + JS. Honestly, I’m not interested in it at all (I’m not a JS developer).
#SQLITE BROWSER GITHUB FULL#
Modern frontend projects are full of tooling and infrastructure stuff. Conveniently, the token is scoped exclusively to work with gists - it has no access to repositories, so is guaranteed to do no harm. produce an SQL script with db schema and contentsĪll the user needs is to specify the Github API token. Get the file from the user via input, read it with the FileReader, convert into an 8-bit array, and upload to SQLite: Sql.js is the perfect engine for an online playground. It is a full-fledged SQLite instance that works in the browser (and quite a small one - the binary takes about 1Mb). In 2019, Ophir Lojkine compiled SQLite sources into WebAssembly (the ‘native’ browser binary format) for the sql.js project. After that, browser data storage went along the NoSQL path (Indexed Database, Cache API). That’s how Web SQL standard appeared, supported by Apple (Safari), Google (Chrome), and Opera (popular at the time). Many browser vendors thought so at the end of the 00s.
Seems only logical to access it through the browser API. It implements the SQL-92 standard (and a large part of later standards). So I’ve built SQLime - an online SQLite playground for debugging and sharing SQL snippets.įirst I’ll show the results, then describe how everything works:Īll browsers - both mobile and desktop - have an excellent DBMS is already built-in - SQLite.
An online playground to quickly test an SQL query and share it with others. What I’ve always lacked is something similar to JSFiddle, but for SQLite.
0 kommentar(er)
