Using the sqlite3 Python module in Pyodide - Python WebAssembly#

1
Welcome to the Pyodide terminal emulator 🐍
2
Python 3.9.5 (default, Sep 16 2021 11:22:45) on WebAssembly VM
3
Type "help", "copyright", "credits" or "license" for more information.
4
>>> import sqlite3
5
>>> sqlite3.connect(":memory:").execute("select sqlite_version()").fetchall()
6
[('3.27.2',)]

1
from js import fetch
2

3
res = await fetch("https://global-power-plants.datasettes.com/global-power-plants.db")
4
buffer = await res.arrayBuffer()
5

6
# Now write that to the in-memory simulated filesystem:
7
open("tmp/power.db", "wb").write(bytes(buffer.valueOf().to_py()))
8

9
# And run some queries against it:
10
import sqlite3
11
c = sqlite3.connect("tmp/power.db")
12
c.execute('select * from "global-power-plants" limit 10').fetchall()