mORMot Open Source

TommyYommi

Member

Registered: 2013-01-18

Posts: 27

Connect Firebird

Hello,

Is there a way to use dbexpress or devart to connect into a database and still use your ORM?
If no, how can I acess a Firebird database other than ODBC?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Connect Firebird

I'm working on a native, direct and optimized connector on FireBird.
The file is not finished, but started.
See http://synopse.info/fossil/finfo?name=SynDBFirebird.pas

Any help is welcome.
Especially when testing phase will begin.
I will test it with the embedded library, but work on real database from already FireBird users like you may be very helpful.

Stay tuned!

TommyYommi

Member

Registered: 2013-01-18

Posts: 27

Re: Connect Firebird

Good!!!

I'm will wait for it.

wienani

Member

Registered: 2012-08-31

Posts: 29

Re: Connect Firebird

Woww.. finally Firebird native connection.

Thank you Arnaud

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Connect Firebird

This unit is not yet finished...

But you can have access via Zeos, UniDac or Odbc.
See http://blog.synopse.info/post/2013/02/1 … RMot-s-ORM
and http://synopse.info/forum/viewtopic.php?pid=6796#p6796
(latest version increased Zeos support, and enhanced its speed above UniDAC)

Fastest mean is Zeos - and it is free.
It is faster since we interfaced directly their ZDBC layer, so we by-pass all the DB.pas TDataSet marshalling.

talexone

Member

Registered: 2013-08-21

Posts: 21

Re: Connect Firebird

Hello,
Any news about native connection to Firebird server? Or it's sill in progress. I want implement it into existing project, but can't find any info about.
Started by creating a connection, then connect to server (seems to work), creating simple record's object and model, but then ... (there is no TSQLRestServerDB class in SynFirebird)
Any way to use it without virtual tables?

type
TUser = class (TSQLRecord)
  private
    fID: integer;
    fUsername: RawUTF8;
    fPassword: RawUTF8;
  public
    property ID: integer read fID write fID stored AS_UNIQUE;
    property Username: RawUTF8 index 20 read fUsername write fUsername;
    property Password: RawUTF8 index 20 read fPassword write fPassword;
  end;

var
  cn: TSQLDBFirebirdConnection;
  cp: TSQLDBFirebirdConnectionClientProperties;
  mu: TSQLModel;
  ur: TUser;

...
      mu := TSQLModel.Create([TUser]);

      cp := TSQLDBFirebirdConnectionClientProperties.Create(aServername+':'+aFilename,aFilename,aUsername,aPassword);
      cn := TSQLDBFirebirdConnection.Create(cp);
      cn.Connect;

      ur := TUser.Create;

...

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Connect Firebird

No this unit is not finished.
You should not use it.

We recommend you use the ZEOS/ZDBC connector, which works very well, and is a direct link to Firebird driver.
We are making all our tests for Firebird using ZEOS/ZDBC.

You can try firedac or unidac - but they are slower at reading, since they are not direct connection, but using a TDataSet.