CODEWITHSUNDEEP
sqlfirebird
Mason Wheeler
Mason Wheeler

Reputation: 84640

Is it possible at all to bulk-load data from an application into Firebird?

I've been looking over various questions on loading data into Firebird, and apparently it's possible to run multiple INSERT statements in a batch... if you're running a script in ISQL and all the values are written inline.

If you're trying to do this from code, of course, you have two problems here: 1) ISQL syntax doesn't work, and 2) any developer with 20 minutes of SQL experience knows that writing data values inline into your query is an unholy abomination that will summon nasal demons, cause your hair to fall out, and oh by the way leave your system open to SQL Injection vulnerabilities.

But I haven't found any solution whatsoever about running bulk inserts from application code. I haven't even found anyone discussing it. Apparently there's a mechanism for quick-loading data from "external tables" if you write it out to a file in the right format, but there's precious little information available on how that works, and what is available claims that it has problems with concepts as simple as blobs and even nulls!

So I'm just about at my wits' end here. Does any mechanism at all exist to allow 3rd-party application code to bulk-load any and all data supported by Firebird into a FB database?

Upvotes: 0

Views: 518

Answers (1)

user13964273
user13964273

Reputation: 1221

  1. Prepared parameterized statement in loop.
  2. IBatch class in Firebird 4 OO API.
  3. IReplicator class in Firebird 4 OO API which is tricky but the fastest possible option.

In any case parsing of source data format and transforming values into types supported by Firebird is up to the application programmer. There is no silver bullet that "load anything".

Upvotes: 1

Related Questions