8/6/2023 0 Comments Sqlite browser online![]() Or, perhaps, you’ll adopt the approach of creating serverless tools with vanilla JS and GitHub API. ![]() 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. ![]() It was first released in 2000 and has since become a widely used database engine that can be found in a. What is a SQLite database SQLite is a popular open-source relational database management system that is known for being lightweight, fast, and easy to use. The playground is hosted on GitHub Pages, and the deployment is a basic git push. Use Gigasheet as SQLite browser online, without a database or command line tools. A real frontend developer will wince probably, but I’m fine. 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). 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: In 2022 the SQLite team delivered an official WebAssembly build, so I switched to it. 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). lets you run thousands of apps online on all your. 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. Run SQLite Database Browser online on your browser, Mac, PC, and tablets with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |