I am looking for a lightweight, sql-compatible, java-compatible database to
port a dotnet app to the Macintosh platform, since many of my potential
users are Mac fanatics. The application is a full-text search program
against a corpus of early medieval texts (see www.aimsdata.com/tim for
details if you're interested in this sort of thing.)

FireBird has been recommended to me as a possiblity, and I'd like to get
more details on what is involved in installing FB onto a Macintosh.

By "lighweight", I mean:
(1) the database engine does not have to run as a background service on the
deployment PC
(2) the db will allow me to ship a pre-built data structure contained in a
few files that can live in the same folder; there will be no need to create
the database as part of the installation and no need to go looking in many
places for pieces of the installed package
(3) I won't have to write an installation program but can tell the user to
copy the files to a folder and away they go...

By SQL compatible I mean that the database understands the full range of
ANSI SQL -92 syntax.

Does FB meet my personal definition of lightweight and SQL compatibility?
Thanks for the info!
Tim