import asyncio
import jupylite_duckdb as duckdb
async def duckdb_demo():
##############################
# Ignore the async stuff above and below. Just write your code here.
query = """
create table iris as select * from read_csv_auto('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/iris.csv');
select * from iris;
"""
print("Loading duckdb wasm and connecting to the database")
await duckdb.connect()
print("Executing query to get DuckDB Version")
df = await duckdb.query("pragma version")
print(df)
df2 = await duckdb.query(query)
print(df2.describe())
display(df2.head(3))
##############################################################################################################################
# Run
print("Pyodide is loaded, Modules installed")
asyncio.ensure_future(duckdb_demo())
Shift-Enter to Execute. First execution has a slight delay / hang