Recent

Author Topic: multi database client... is there any in lazarus?  (Read 2685 times)

fabiopesaju

  • Jr. Member
  • **
  • Posts: 81
multi database client... is there any in lazarus?
« on: August 13, 2021, 04:55:51 pm »
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

  • Sr. Member
  • ****
  • Posts: 312
Best regards
paweld

ttomas

  • Full Member
  • ***
  • Posts: 233
Re: multi database client... is there any in lazarus?
« Reply #2 on: August 13, 2021, 08:49:14 pm »
Lazarus  ;D

MarkMLl

  • Hero Member
  • *****
  • Posts: 3501
Re: multi database client... is there any in lazarus?
« Reply #3 on: August 13, 2021, 09:11:31 pm »
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
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

dseligo

  • Sr. Member
  • ****
  • Posts: 375
Re: multi database client... is there any in lazarus?
« Reply #4 on: October 07, 2021, 12:21:07 am »
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?

HeidiSQL is open source (GPL license) and written in Pascal (Delphi).
Quote
Unfortunately, Lazarus or one of the other free compilers cannot currently compile HeidiSQL.

Gustavo 'Gus' Carreno

  • Hero Member
  • *****
  • Posts: 793
  • Professional amateur ;-P
Re: multi database client... is there any in lazarus?
« Reply #5 on: October 07, 2021, 12:25:29 am »
Hey Fabio,

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?

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
Lazarus 2.3.0(trunk) FPC 3.3.1(trunk) Ubuntu 21.10 64b Dark Theme
Lazarus 2.0.12(stable) FPC 3.2.2(stable) Ubuntu 21.10 64b Dark Theme
http://github.com/gcarreno

Thaddy

  • Hero Member
  • *****
  • Posts: 10991
Re: multi database client... is there any in lazarus?
« Reply #6 on: October 07, 2021, 08:46:36 am »
As already written: Lazarus...
Or just fpc, since sqldb provides support for most popular databases out of the box.
The average programmer productivity is 4-5 hours per day. Peak performance 72 hours for short bursts. MTBF is 1 second or less.

PascalDragon

  • Hero Member
  • *****
  • Posts: 3496
  • Compiler Developer
Re: multi database client... is there any in lazarus?
« Reply #7 on: October 07, 2021, 08:51:46 am »
Lazarus itself comes with the LazDataDesktop tool which uses SqlDB to connect to any of the supported databases.

 

TinyPortal © 2005-2018