search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.8k stars 123 forks source link

Add option store queries (maybe per database?) #386

Closed D-nov closed 2 weeks ago

D-nov commented 2 years ago

Is your feature request related to a problem? Please describe. Yes, now I have to retype my queries :D

Describe the solution you'd like Add a sidebar with saved queries so I can find and just run a previously saved query instead of retyping it. This would be good to have the option to save it per database so there would be less variables to rename before exequting it.

KazimirPodolski commented 1 year ago

I think queries tabs should persist by default. E.g. if I do some stuff in a Query #1, close antares, and open it again, then there should be a way to re-open Query #1 with all what's left when I closed it.

Unless any work I didn't put into DB is lost every time, which is really annoying.

DataGrip does it exactly right I think.

Fabio286 commented 1 year ago

I think queries tabs should persist by default. E.g. if I do some stuff in a Query #1, close antares, and open it again, then there should be a way to re-open Query #1 with all what's left when I closed it.

Unless any work I didn't put into DB is lost every time, which is really annoying.

DataGrip does it exactly right I think.

By now query tabs are persistent (if not disabled in settings) with last query executed on it.

What do you mean by lost work? Can you give me an example?

D-nov commented 1 year ago

I was thinking the same... Isn't this already implemented ?

KazimirPodolski commented 1 year ago

By now query tabs are persistent (if not disabled in settings) with last query executed on it.

What do you mean by lost work? Can you give me an example?

Oh, so this is what restore session setting does. But it's still not fully persistent query tabs.

The idea is you make a query tab e.g. "Query 10" and type something there e.g.

SELECT * FROM users;

Let's say you closed the tab and/or the app. You still should have a way to reopen the "Query 10" with the latest state.

Unless the only reliable place to put work between workdays is the DB.

curruwilla commented 11 months ago

I just installed Antares and it's perfect, the only thing missing is this save query feature.

For example, I manage many databases, and each database has a different query, there is no way I can leave it in open tabs because there would be many, if I could save the tabs and resume them, that would be great.