duckdb - UI tool and integration?

[wildthink]

1. This may be an aside, but duckdb offers a nice builtin UI (web server) and reads and writes SQLite. - https://duckdb.org/2025/03/12/duckdb-ui.html
2. Has a native Swift API - https://duckdb.org/2023/04/21/swift.html
3. A boatload of extensions - https://duckdb.org/docs/stable/extensions/overview
4. A thriving community

Anyone interested in collaborating in beefing up the Swift features?

[mbrandonw]

Hi @wildthink, it does seem like it would not take too much work to create a driver for DuckDB that can execute queries built by this library. You could probably start with the sample SQLite implementation that we have in this repo and make the necessary changes to speak DuckDB's API.

Would you like to see how far you can get with that and let us know if you have any questions? We'd be more than happy to help!

[wildthink]

A very rough start - https://github.com/wildthink/duckdb-swift.git
Stuff is all over the floor :-) (contained w/in SwiftDuckDB) but I have some semblance of a QueryDecoder working. DuckDB typing is much stricter so I know there is work around that.
Any pointers on processing the insert statement would be most appreciated.

[thinkpractice]

Any update on this?

[dan5082]

Any progress?

[wildthink]

Hey, I've been head-down on other stuff but I haven't forgotten. Note that this is just starting but at least it has a place to check,
https://github.com/wildthink/duck-data