SQLite 官方提供的網頁版 playground
source link: https://blog.gslin.org/archives/2024/01/25/11612/sqlite-%e5%ae%98%e6%96%b9%e6%8f%90%e4%be%9b%e7%9a%84%e7%b6%b2%e9%a0%81%e7%89%88-playground/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQLite 官方提供的網頁版 playground
Hacker News 上看到「Sqlite3 Utility in the Browser (sqlite.org)」這個，看了一下是官方提供的 playground：「SQLite3 Fiddle」。
從 https://sqlite.org/fiddle/fiddle.js 這邊可以看到 2022 年就有的東西，在 Internet Archive 上也可以看到也是差不多時間被記錄下來的：「Saved 21 times between August 12, 2022 and January 24, 2024.」。
看起來是用 WebAssembly 包起來的，不過如果是自己的機器，本機跑 sqlite3 好像會方便一些...
Related
讓 git diff 可以直接顯示 SQLite3 裡面的差異
從「Tracking SQLite Database Changes in Git」這邊看到的，然後作者 Simon Willison 又是從 Lobste.rs 的「Tracking SQLite Database Changes in Git databases」這邊看到的，而原文在「Tracking SQLite Database Changes in Git」。 一般 SQLite 檔案的 diff 會出現這樣： diff --git a/a.sqlite3 b/a.sqlite3 index a4a8cfa..714f34a 100644 Binary files a/a.sqlite3 and b/a.sqlite3 differ 作者想要透過 sqlite3 的指令加工，讓 git-diff 的演算法可以展現出像是這樣的指令： diff --git a/a.sqlite3 b/a.sqlite3 index…
November 2, 2023In "Computer"
SQLite 官方自己下來搞 WASM/JS 計畫
先前在「把 SQLite 的 VFS 掛上 WebTorrent 的 PoC Demo」有提過 sql.js 這個專案，把 SQLite 移植到網頁上，這些都算是非官方的社群弄出來的專案。 現在官方直接跳下來玩，宣佈自己也要搞 WASM/JS 了：「sqlite3 wasm docs: About the sqlite3 WASM/JS Subproject」。 Folks have been building sqlite3 for the web since as far back as 2012 but this subproject is the first effort "officially" associated with the SQLite project,…
October 31, 2022In "Browser"
在 Shell 下一行用 SQLite 查詢 CSV 內的資料
從 Simon Willison 這邊看到 command line 下用 SQLite 的技巧：「One-liner for running queries against CSV files with SQLite」。 範例指令是這樣 (整理了一下排版)： sqlite3 :memory: \ -cmd '.import -csv taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' 可以看出來這個方式是將 csv 檔先讀到 in-memory database (:memory:)，再用 SQLite 下指令處理，另外也可以自己變化，應該可以透過 /dev/stdin 這樣的方式讀 pipe 的東西。 拿來簡單跑一些東西應該還不賴？
June 23, 2022In "Computer"
Leave a Reply
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Notify me of follow-up comments by email.
Notify me of new posts by email.
To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)
Post navigation
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK