Embeded DB for Firemonkey apps

Question

Creating a client application, want the whole DB to be embed in the software or in a single standalone dll (ie sqlite), not something like mysql.

Whats built into XE2 which would work 'out of the box' and not need thirdparty tools?

Other than TClientDataSet / xml files :)

score 3 · Answer 1 · answered Sep 24 '11 at 17:07

3

Firebird is available with XE2... For a single user usage, you don't need to run a service to access it (but you'll need the firebird client and the vendor dll to access it).

answered Sep 24 '11 at 17:07

Whiler

7,998
4
32
56

How do you embed that though? – David Heffernan Sep 30 '11 at 21:12
resource.. extracted at runtime... :/ The way I understood the question was more that he doesn't want a server solution... but I maybe misunderstood? – Whiler Oct 01 '11 at 02:11
Read the feature matrix carefully. The dbExpress Firebird driver is not supported with the Professional or Starter version. To get the dbExpress Firebird driver you need the Enterprise, Ultimate or Architect version. – Michael Riley - AKA Gunny May 16 '12 at 17:56
@CapeCodGunny: Yes, that's correct. (maybe Wizzard can precise which version he has...) – Whiler May 16 '12 at 19:00

score 3 · Accepted Answer · answered Sep 30 '11 at 11:21

You can use my SQLite wrapper (also some more info in my blog) which supports multiple platforms. In Windows you'll need to deploy sqlite3.dll with your application, there is no need for this on OSX. You can get sources from the svn. Example usage:

uses
  SQLiteTable3,
  {$IFDEF DELPHI16_UP}
  System.SysUtils;
  {$ELSE}
  SysUtils;
  {$ENDIF}

procedure Demo;
var
  slDBpath: string;
  db: TSQLiteDatabase;
  pstm TSQLitePreparedStatement;
begin
  slDBpath := IncludeTrailingPathDelimiter(GetHomePath) + 'test.db';
  db := TSQLiteDatabase.Create(slDBpath);
  try
    if db.TableExists('testtable') then
    begin
      pstm := TSQLitePreparedStatement.Create(db,
        'insert into testtable (name,number) values (?,?)',  //sql statement
        ['NewRec', 99.99]); //parameter values
      try
        pstm.ExecSQL;
      finally
        pstm.Free;
      end;
    end;

  finally
    db.Free;
  end;
end;

score 1 · Answer 3 · answered Sep 30 '11 at 21:09

1

Also you may look at NexusDB Embedded, which is native Delphi solution, and doesn't require any Dlls.

answered Sep 30 '11 at 21:09

Mohammed Nasman

10,992
7
43
68

Embeded DB for Firemonkey apps

3 Answers3

Linked