Recent

Author Topic: Database Query tool / Query workbench / ...  (Read 3140 times)

Hansvb

  • Hero Member
  • *****
  • Posts: 618
Database Query tool / Query workbench / ...
« on: September 28, 2017, 03:32:58 pm »


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

  • Hero Member
  • *****
  • Posts: 532
Re: Database Query tool / Query workbench / ...
« Reply #1 on: September 28, 2017, 05:12:15 pm »
hi,
i sent you a pm about this.

thank you
Lazarus 2.0.2 64b on Debian LXDE 10

teos

  • Full Member
  • ***
  • Posts: 157
Re: Database Query tool / Query workbench / ...
« Reply #2 on: September 28, 2017, 07:47:30 pm »
depending on your database.. but is DBeaver useable for you?

sash

  • Sr. Member
  • ****
  • Posts: 366
Re: Database Query tool / Query workbench / ...
« Reply #3 on: September 28, 2017, 11:35:59 pm »
I 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.

Lazarus 2.0.10 FPC 3.2.0 x86_64-linux-gtk2 @ Ubuntu 20.04 XFCE

PatBayford

  • Full Member
  • ***
  • Posts: 125
Re: Database Query tool / Query workbench / ...
« Reply #4 on: September 29, 2017, 02:13:14 am »
It very much depends on your database - SQLite, for example, has a very good studio/workbench suite, freely available for download. (SQLIteStudio)
Lazarus 1.8.0 FPC 3.0.2 SVN 56594 Windows 10 64bit (i386-win32-win32/win64)

Graeme

  • Hero Member
  • *****
  • Posts: 1428
    • Graeme on the web
Re: Database Query tool / Query workbench / ...
« Reply #5 on: October 12, 2017, 05:26:47 pm »
Does 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.
--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

 

TinyPortal © 2005-2018