Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2015-09

TDBF (dBase) vs TurboPower FlashFiler

5 messages · 4 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Graeme Geldenhuys

Hi,

I'm again revisiting the idea of porting FlashFiler to FPC, but trying to justify if it is worth it or not. The NexusDB owner offered me (at one stage) a possible license deal in porting NexusDB to FPC too.

My goal - have a database 100% compiled into the executable.

At this point I'm looking for local access only. So how does TDBF compare to FlashFiler?

* Both support local databases
* Both store a db table per file
* TDBF uses external files for indexes. Not sure what FlashFiler does.
* TDBF is local database only. FlashFiler is local and client/server.

On the other hand, NexusDB surpassed FlashFiler in features. eg: Views, Stored Procedures (which I never use), more up to date SQL syntax, and very very nice FTS (full-text search) support. I've never seen the NexusDB code, so I have no clue how "portable" it is though.

The pros for TDBF and FlashFiler is 100% free. Benefits will be easy deployment even for platforms like FreeBSD, OSX and probably even Android.

Please don't mention SQLite - I'm not interested in that. I'm also well versed on Firebird Embedded (I'm a big fan of Firebird) - and I fully know the deployment issues under OSX, and no official support for Android (but apparently it is coming).

So with the above said, what is the benefits of FlashFiler over TDBF? Any old Turbo Pascal or Delphi developers here that could comment?

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/ My public PGP key: http://tinyurl.com/graeme-pgp

Reply by email

Michael Van Canneyt
to Graeme Geldenhuys
Graeme Geldenhuys wrote 33 lines
Hi, I'm again revisiting the idea of porting FlashFiler to FPC, but trying to justify if it is worth it or not. The NexusDB owner offered me (at one stage) a possible license deal in porting NexusDB to FPC too. My goal - have a database 100% compiled into the executable. At this point I'm looking for local access only. So how does TDBF compare to FlashFiler? * Both support local databases * Both store a db table per file * TDBF uses external files for indexes. Not sure what FlashFiler does. * TDBF is local database only. FlashFiler is local and client/server. On the other hand, NexusDB surpassed FlashFiler in features. eg: Views, Stored Procedures (which I never use), more up to date SQL syntax, and very very nice FTS (full-text search) support. I've never seen the NexusDB code, so I have no clue how "portable" it is though. The pros for TDBF and FlashFiler is 100% free. Benefits will be easy deployment even for platforms like FreeBSD, OSX and probably even Android. Please don't mention SQLite - I'm not interested in that. I'm also well versed on Firebird Embedded (I'm a big fan of Firebird) - and I fully know the deployment issues under OSX, and no official support for Android (but apparently it is coming). So with the above said, what is the benefits of FlashFiler over TDBF? Any old Turbo Pascal or Delphi developers here that could comment?

I seem to remember that FlashFiler supported cross-table queries. TDBF does not.

Michael.

Reply by email

Serguei TARASSOV

Hello,

DBF and majority of others xBase are not real DBMS but record managers (there is no "database" notion, referential integrity etc). FlashFiler seems like more close to DBMS notion.
But we have Firebird, the real world production DBMS. Only one major distinction: it is deployed as DLL.

For info, UniDAC supports DBF in recent versions whereas TDbf was abandoned several years ago.

Regards,
Serguei

Show quoted text 45 lines
Message: 1 Date: Sat, 26 Sep 2015 12:12:10 +0100 From: Graeme Geldenhuys To: FPC-Pascal users discussions Subject: [fpc-pascal] TDBF (dBase) vs TurboPower FlashFiler Message-ID: Content-Type: text/plain; charset=utf-8 Hi, I'm again revisiting the idea of porting FlashFiler to FPC, but trying to justify if it is worth it or not. The NexusDB owner offered me (at one stage) a possible license deal in porting NexusDB to FPC too. My goal - have a database 100% compiled into the executable. At this point I'm looking for local access only. So how does TDBF compare to FlashFiler? * Both support local databases * Both store a db table per file * TDBF uses external files for indexes. Not sure what FlashFiler does. * TDBF is local database only. FlashFiler is local and client/server. On the other hand, NexusDB surpassed FlashFiler in features. eg: Views, Stored Procedures (which I never use), more up to date SQL syntax, and very very nice FTS (full-text search) support. I've never seen the NexusDB code, so I have no clue how "portable" it is though. The pros for TDBF and FlashFiler is 100% free. Benefits will be easy deployment even for platforms like FreeBSD, OSX and probably even Android. Please don't mention SQLite - I'm not interested in that. I'm also well versed on Firebird Embedded (I'm a big fan of Firebird) - and I fully know the deployment issues under OSX, and no official support for Android (but apparently it is coming). So with the above said, what is the benefits of FlashFiler over TDBF? Any old Turbo Pascal or Delphi developers here that could comment? Regards, - Graeme -

Reply by email

Marco van de Voort
to Serguei TARASSOV

In our previous episode, Serguei TARASSOV said:

Show quoted text 8 lines
DBF and majority of others xBase are not real DBMS but record managers (there is no "database" notion, referential integrity etc). FlashFiler seems like more close to DBMS notion. But we have Firebird, the real world production DBMS. Only one major distinction: it is deployed as DLL. For info, UniDAC supports DBF in recent versions whereas TDbf was abandoned several years ago.

Afaik tdbf got support for several new tabeltypes in 2014 by Reinier (aka bigchimp)

Reply by email

Graeme Geldenhuys
to Michael Van Canneyt: I seem to remember that FlashFiler supported cross-table queries. TDBF does not. Michael.

Hello Michael,

Michael Van Canneyt wrote
I seem to remember that FlashFiler supported cross-table queries. TDBF does not.

Thanks - that is quite an important point and concern for me.

Regards,
- Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal http://fpgui.sourceforge.net/

My public PGP key: http://tinyurl.com/graeme-pgp

Reply by email