Database Query tool / Query workbench / ...
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2017-09-28 13:32

This is perhaps not the right location to ask this question but i
guess that someone can help me.
I am looking for a tool (free or paid) which can do one or all of the
next things:
-   Excecute predefined queries (select and create queries)
-   edit and safe predefined queries (select and create queries)
-   the available queries must been shown in a list or serie of
buttons from which the user can execute them
-   the user must able to add new queries and these new queries must
be available in de the list of all queries (or something) to execute
them
-   Filter the result
-   export the result

I find a lot of "query build" tools but that is not what i really
need. That is just a part of what i need.
I know it is possible to make it myself in Pascal, but that is not
what we want right now.

Does someone have any tips?

----------------------------------------------------------------------
tudi_x · 2017-09-28 15:12

hi,
i sent you a pm about this.

thank you

----------------------------------------------------------------------
teos · 2017-09-28 17:47

depending on your database.. but is DBeaver useable for you?

----------------------------------------------------------------------
sash · 2017-09-28 21:35

Quote from: Hansvb on September 28, 2017, 03:32:58 pmI am looking for
a tool (free or paid) which can do one or all of the next things...
...

If you want some single item of your wish-list, almost every tool
allows it.
If you want it all, then it looks like you need your own custom
project.

----------------------------------------------------------------------
PatBayford · 2017-09-29 00:13

It very much depends on your database - SQLite, for example, has a
very good studio/workbench suite, freely available for download.
(SQLIteStudio)

----------------------------------------------------------------------
Graeme · 2017-10-12 15:26

Quote from: Hansvb on September 28, 2017, 03:32:58 pmDoes someone have
any tips?
The tiOPF's tiopf-apps code repository includes a tool called
tiSQLEditor. It has some very nice features, talks to any database
tiOPF supports (which is everything), supports code completion, syntax
highlighting and most importantly, can easily be extended to support
new features. eg: I used tiSQLEditor as the base for a new tool which
I gave to one of my clients to run incremental update scripts from a
directory tree.