[fpc-pascal] Is there a way to create a Firebird embedded database programmatically?

[Tony Whyman]

I understand now what you are doing and would agree that for a simple
demo, you really do want to create the DB in code. I am thinking more
about distributing and supporting a fully supported application.

Interesting that I seemed to get so much push-back when I suggested isql
- I did so as a simple way to distribute a patch (and with an underlying
assumption that you would install a copy in your application directory
in order to avoid searching for it). In practice, I don't use isql to
patch a deployed database but have my own set of units to execute an SQL
Script using the TIBSQL component. I didn't suggest this because this is
more than just executing a script, but also includes version control
tables in the database itself and a configuration file distributed with
the scripts to tell the updating application which scripts have to be
applied to get to a specific patch level and so on. Or to put it another
way, I didn't want to get into a lengthy discussion on how to maintain a
database in the field. Perhaps I should have just avoided the topic :(

On 03/08/11 11:23, Reinier Olislagers wrote:
> I needed to create a db in code because I was writing a sample Lazarus
> application to show how to use SQLDB with embedded Firebird:
> http://lazarus.freepascal.org/index.php/topic,10811.msg74279.html#msg74279
>
> Having people download and run isql just to set up the database seemed
> inelegant, error prone and time consuming.
> Of course, I could have used IBX components, but then people would have
> to download & install those....
>
> Thanks for your insights,
>
> Reinier
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-pascal