* * *

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

Hansvb

  • Sr. Member
  • ****
  • Posts: 331
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

  • Sr. Member
  • ****
  • Posts: 400
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

teos

  • Full Member
  • ***
  • Posts: 145
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

  • New member
  • *
  • Posts: 12
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.

XUbuntu 16.04. Lazarus 1.8.0 rUnversioned directory FPC 3.0.4 x86_64-linux-gtk2

PatBayford

  • Jr. Member
  • **
  • Posts: 96
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: 1419
    • 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/

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus