Dennizz

no profile record

Submissions

Show HN: Paul Graham GPT

chat.openai.com

1 pointsby Dennizz3 anni fa0 comments

DB Pilot: Query Postgres, files, S3 and more – all at once, from your laptop

5 pointsby Dennizz3 anni fa2 comments

Show HN: I built a database GUI with ChatGPT integration

89 pointsby Dennizz3 anni fa61 comments

comments

3 anni fadiscuss

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

3 anni fadiscuss

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!

3 anni fadiscuss

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

3 anni fadiscuss

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.

3 anni fadiscuss

Typescript and Rust, with SvelteKit and Tauri.

3 anni fadiscuss

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.

3 anni fadiscuss

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

3 anni fadiscuss

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.

3 anni fadiscuss

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

3 anni fadiscuss

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.

3 anni fadiscuss

Correct, you probably should know SQL.

In my experience though it is often a significant time saver if I only have to review the output of the AI vs. coming up with everything myself.

Re: ambiguities: You are right, the AI won't always be able to infer the correct fields to use. In such cases though it is often enough to help the AI out a little. E.g. by saying "information X is stored in field Y of table Z".

Even if you have to do that, you can still save time and more importantly mental effort by letting AI help you, compared to writing all the SQL yourself.

Re: iterative process: You can simply send a follow up message saying "You did X wrong". It is usually happy to correct itself.

3 anni fadiscuss

No, currently it doesn't.

This is a case where it could help to give the AI some example values of the actual data. The same applies for e.g. JSON fields.

I've been thinking about ways to make it possible for users to easily provide examples to the AI. Essentially that would mean selectively giving access for specific rows/columns to the AI.

3 anni fadiscuss

Interesting idea. Do you have some examples of how you would like to use that, or maybe even an app where you'd like to integrate it?

3 anni fadiscuss

Noted!

3 anni fadiscuss

So far it's Mac only. If I can get some traction on this, I plan to support Windows and Linux eventually.

3 anni fadiscuss

If I can get some traction on this, I plan to support Windows and Linux eventually.

3 anni fadiscuss

They are made with https://www.screen.studio/

3 anni fadiscuss

Correct. When you buy the lifetime license you get one year of the AI included, afterwards it is $49 per year for the AI then.

I should make that more clear on the website.

3 anni fadiscuss

Thanks for the feedback, I'll try to improve that.

3 anni fadiscuss

Thanks for reporting. I'll have a look what's missing.