multi database client... is there any in lazarus?
lazarus / 16-Databases

----------------------------------------------------------------------
fabiopesaju · 2021-08-13 14:55

please, is there any application that is preferably (but not
necessarily) multi-client, to connect to popular databases on the
market? something like dbeaver or heidesql? but made in pascal and
open source... does it exist?

thankful.

----------------------------------------------------------------------
paweld · 2021-08-13 16:34

LazSqlX: https://github.com/flakron-shkodra/LazSqlX

----------------------------------------------------------------------
ttomas · 2021-08-13 18:49

Lazarus

----------------------------------------------------------------------
MarkMLl · 2021-08-13 19:11

What /exactly/ are you asking? To start with, the ability to have
multiple simultaneous clients is primarily dictated by the server to
which you're connecting, if you're trying to handle that in the
clients you're doing it wrong.

Second, do you want to connect to different types of database
simultaneously, or one at a time?

Third, do you want to connect to multiple database instances
simultaneously (irrespective of server type)?

Fourth, what do you want to do about e.g. PostgreSQL schemata which
are an intermediate isolation layer between tables and databases?

Fifth, what about things like asynchronous signals/events?

Sixth, what provisions do you require in order to handle e.g. very
large tables (much larger than available memory, so you need to use
cursors)?

Seventh, what about pooling and failover?

Eighth, what do you actually want to do once you've got the data
available?

Ninth, and so on?

MarkMLl

----------------------------------------------------------------------
dseligo · 2021-10-06 22:21

Quote from: fabiopesaju on August 13, 2021, 04:55:51 pmplease, is
there any application that is preferably (but not necessarily) multi-
client, to connect to popular databases on the market? something like
dbeaver or heidesql? but made in pascal and open source... does it
exist?
HeidiSQL is open source (GPL license) and written in Pascal (Delphi).
QuoteUnfortunately, Lazarus or one of the other free compilers cannot
currently compile HeidiSQL.

----------------------------------------------------------------------
Gustavo 'Gus' Carreno · 2021-10-06 22:25

Hey Fabio,

Quote from: fabiopesaju on August 13, 2021, 04:55:51 pmplease, is
there any application that is preferably (but not necessarily) multi-
client, to connect to popular databases on the market? something like
dbeaver or heidesql? but made in pascal and open source... does it
exist?

I've starred this one on GitHub a long time ago when I asked myself
(And Google) the same question: https://github.com/lalexs75/FBManager

Not the most maintained code, but it's still active.

Hope this helps.

Cheers,
Gus

----------------------------------------------------------------------
Thaddy · 2021-10-07 06:46

As already written: Lazarus...
Or just fpc, since sqldb provides support for most popular databases
out of the box.

----------------------------------------------------------------------
PascalDragon · 2021-10-07 06:51

Lazarus itself comes with the LazDataDesktop tool which uses SqlDB to
connect to any of the supported databases.