Hey HN, creator of DB Pilot here.

I first announced DB Pilot on HN back in April: https://news.ycombinator.com/item?id=35761979.

Since then a lot has improved: More databases are supported, most of the product can now be used for free, and most importantly:

The app now comes with an analytics workspace powered by an embedded ClickHouse instance, running locally on your machine. This allows you to query local files, files on S3, PostgreSQL, SQLite & more - and all of those at once.

Embedding ClickHouse was possible thanks to chDB (https://github.com/chdb-io/chdb). A recent discussion on HN about it: https://news.ycombinator.com/item?id=37985005

Great work Dennis!

If you mean the common OpenAI API key, I'm not sure how that's different in regards to feeling secure compared to separate keys. Would you mind elaborating further, please?

To clarify, the common API key is known only by my server, not by the app!

Not yet but I have it in my list of TODOs!

I just pushed a new release. It should work now!

To install the new version, just restart the app. It should then prompt you to install the update.

Typescript and Rust, with SvelteKit and Tauri.

Do you mind telling where and why are you using rust?

That's fair. The "no-tricks pricing" wording was taken 1-to-1 from the UI template I used :)

I'll update the copy, and try to explain the pricing model more clearly.

Also a good idea to make it possible to use one's own API key. I'll consider that.

It's GPT-3.5 only so far but I might add additional models at some point.

Right now it's pretty simple: First I drop the table/column information if the token limit gets exceeded otherwise (this is shown as a warning in the UI). Then if the limit still gets exceeded, the I show an error to the user.

I plan to make this process more smart eventually.

I'd like to use it eventually but as of now API usage is too limited.

I've had mostly the same experience as calmoo.

And when it does go wrong, I've had good success telling it what it did do wrong. It will usually correct itself then.