Open SQLite DB

[remysucre]

I was trying to load a SQLite .db file for the snippets, but couldn't get it to work. Is this supported? I know I can use a template with a SQL dump of the DB content, but directly using the .db file feels more natural (and maybe more performant). Markdown and HTML source attached for repro (I can't attach a .db file but an arbitrary one should work).

temp.md

temp.html

[nalgeon]

You're using the WASI engine (engine="wasi"), which doesn't support files at all. So unfortunately, the answer is no.

You can use files with a server-side SQLite sandbox as follows (assuming the Codapi server is listening on localhost:1313):

<codapi-settings url="http://localhost:1313/v1">
</codapi-settings>

```sql
.open src/data.db
.schema
```

<codapi-snippet sandbox="sqlite" editor="basic" files="data.db">
</codapi-snippet>