News for hackers. Stuff that matters.
Re:SQLite 3 Fiddle by simonw on Thursday May 26, 2022 @10:53AM (#31519065)
If you find this useful, you may also benefit from the fact that Python compiled to WASM (by Pyodide) also includes a working build of SQLite in the sqlite3 standard library module.

You can try that out in a REPL here: https://pyodide.org/en/stable/console.html

    import sqlite3
    db = sqlite3.connect(":memory:")
    db.execute("select 4 * 5").fetchall()
Or in a full client-side WASM Jupyter notebook interface using https://jupyterlite.readthedocs.io/en/latest/try/lab

I also used Pyodide to get my Datasette SQLite Python web application running entirely in the browser at https://lite.datasette.io - more details on how that works here: https://simonwillison.net/2022/May/4/datasette-lite/

Re:SQLite 3 Fiddle by g3 on Thursday May 26, 2022 @11:31AM (#31519591)
Or, if you want to go one level deeper, v86 has a complete Linux environment with both python and sqlite running locally: https://copy.sh/v86/?profile=archlinux&c=python%20-ic%20%27i...
Re:SQLite 3 Fiddle by kzrdude on Thursday May 26, 2022 @02:40PM (#31521938)
That's pretty trippy, I have my caps lock globally disabled (mapped to ctrl) in X config, but inside that v86 window, caps lock works. And it uses some hardcoded (US) keymap, too.

I'm surprised, I didn't think browsers would receive those detailed keycodes.

Re:SQLite 3 Fiddle by dorianmariefr on Thursday May 26, 2022 @05:32PM (#31523609)
`event.key` returns the key with the mappings, e.g. "E"

`event.keyCode` returns the physical key, e.g. "KeyE"

Re:SQLite 3 Fiddle by kungfufrog on Thursday May 26, 2022 @11:03AM (#31519200)
Holy smokes, all of this is very cool! Nice work!