Sweep firebird database from application
lazarus / 16-Databases

----------------------------------------------------------------------
fjabouley · 2019-12-30 06:55

Hello all
I would like to perform a database sweep from my app (firebird).
I know I could launch a command with "gfix -sweep...", but, is there a
component like fbadmin for backups and restore that I could use?
Best regards

----------------------------------------------------------------------
tonyw · 2019-12-30 16:02

You need to use the Firebird Services API if you want to perform a
database sweep from your own application.

IBX supports use of the services API. The TIBXValidationService
component provides the database sweep service - see the IBX User Guide
for more information.

----------------------------------------------------------------------
fjabouley · 2019-12-30 17:09

Actually I use zeos to connect to my database, is there any other
means to perform sweep without using IBX ?
Thanks very much for your answer !

----------------------------------------------------------------------
valdir.marcos · 2020-01-07 20:01

Quote from: fjabouley on December 30, 2019, 07:55:58 amHello all
I would like to perform a database sweep from my app (firebird).
I know I could launch a command with "gfix -sweep...", but, is there a
component like fbadmin for backups and restore that I could use?
Best regards
Quote from: tonyw on December 30, 2019, 05:02:51 pmYou need to use the
Firebird Services API if you want to perform a database sweep from
your own application.
IBX supports use of the services API. The TIBXValidationService
component provides the database sweep service - see the IBX User Guide
for more information.
Quote from: fjabouley on December 30, 2019, 06:09:20 pmActually I use
zeos to connect to my database, is there any other means to perform
sweep without using IBX ?
Thanks very much for your answer !Tony's solution is the best one, but
you can also use TProcess:
https://firebirdsql.org/manual/gfix-housekeeping.html
https://www.freepascal.org/docs-html/current/fcl/process/tprocess.html
Code: [Select]linux> gfix -sweep my_db