As a huge fan of SQLite I do this kind of thing in SQLite “memory” databases all the time.
Running sqlite3 will give you a shell onto an in-memory database.
sqlite3
My Datasette software can provide a web UI onto an in-memory database too, e.g. at https://latest.datasette.io/_memory?sql=select+sqlite_version%28%29
In Python itself you can run the following:
import sqlite3 db = sqlite3.connect(":memory:") print(db.execute("select 1 + 3").fetchall())
Always love learning others’ weird tricks for how to debug. For normal JavaScript/C++ programming we love our print statements but it’s interesting to see how that translates to different environments like SQL.
As a huge fan of SQLite I do this kind of thing in SQLite “memory” databases all the time.
Running
sqlite3will give you a shell onto an in-memory database.My Datasette software can provide a web UI onto an in-memory database too, e.g. at https://latest.datasette.io/_memory?sql=select+sqlite_version%28%29
In Python itself you can run the following:
Always love learning others’ weird tricks for how to debug. For normal JavaScript/C++ programming we love our print statements but it’s interesting to see how that translates to different environments like SQL.