Recent

Poll

Is it worth to port these components, would you like to use it?

Yes sure, I've been waiting for that, I will use them.
2 (28.6%)
Yes it is good to have them in Lazarus, but I will not use it.
4 (57.1%)
No alternatives enough. (Firebird, Sqlite, TDbf, ..)
1 (14.3%)
They do not  interest me.
0 (0%)

Total Members Voted: 7

Voting closed: April 11, 2017, 06:58:11 pm

Author Topic: Turbo Power Flashfiler Lazarus Port  (Read 22901 times)

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #30 on: December 19, 2017, 09:49:23 pm »
Well, basically, Flash Filer is history, gone to meet its maker, pushing up daisies, it is an ex-filer..... (Free Monty Python)
Unless you have a very good reason, leave it alone.
(Although there is a working version somewhere in another thread)
« Last Edit: December 19, 2017, 09:51:26 pm by Thaddy »
Most people that want to use threading should learn to patch their jeans first: use a needle.

ozznixon

  • Jr. Member
  • **
  • Posts: 85
    • http://www.modernpascal.com/
Re: Turbo Power Flashfiler Lazarus Port
« Reply #31 on: December 20, 2017, 02:37:04 pm »
I have to recompile it. I followed all of the other threads before downloading the pristine the "OneDrive" link is empty.

Since 99/2000 I have been running servers built in D5 and now D7, now I am trying to compile it using FPC 3 - and get rid of all the assembly in ffllbase to pure pascal. My goal is to port it to pure pascal so I can run it in my Linux servers and Mac servers. I am aware of other solutions, but, this is a needed task.

Thanks,
Ozz
---
Want to kick the tires to a Free Pascal like script engine? http://www.ModernPascal.com/

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #32 on: December 20, 2017, 04:06:07 pm »
It is already ported including server. Read this thread: http://forum.lazarus.freepascal.org/index.php/topic,34834.msg229248
Most people that want to use threading should learn to patch their jeans first: use a needle.

ozznixon

  • Jr. Member
  • **
  • Posts: 85
    • http://www.modernpascal.com/
Re: Turbo Power Flashfiler Lazarus Port
« Reply #33 on: December 22, 2017, 06:25:19 pm »
Thanks - as stated:

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.

Every link that supposedly has source in this thread - all link to OneDrive, and report the above. I would love to save the time I am spending to migrate it to Linux if someone else has already done so.
---
Want to kick the tires to a Free Pascal like script engine? http://www.ModernPascal.com/

taazz

  • Hero Member
  • *****
  • Posts: 5363
Re: Turbo Power Flashfiler Lazarus Port
« Reply #34 on: December 22, 2017, 06:47:52 pm »
Thanks - as stated:

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.

Every link that supposedly has source in this thread - all link to OneDrive, and report the above. I would love to save the time I am spending to migrate it to Linux if someone else has already done so.
https://onedrive.live.com/?authkey=%21AFDr0v7myFuatlg&cid=1CF6E5B11FE74543&id=1CF6E5B11FE74543%21108&parId=root&action=locate
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #35 on: December 22, 2017, 08:16:42 pm »
Tnx Taaz.
If he wants to use it he can use it.
But he should convert ASAP to mainstream.
Most people that want to use threading should learn to patch their jeans first: use a needle.

ozznixon

  • Jr. Member
  • **
  • Posts: 85
    • http://www.modernpascal.com/
Re: Turbo Power Flashfiler Lazarus Port
« Reply #36 on: December 22, 2017, 09:05:40 pm »
Thanks Taazz!

Downloaded - running diffs and recompiling :-)
---
Want to kick the tires to a Free Pascal like script engine? http://www.ModernPascal.com/

ozznixon

  • Jr. Member
  • **
  • Posts: 85
    • http://www.modernpascal.com/
Re: Turbo Power Flashfiler Lazarus Port
« Reply #37 on: December 22, 2017, 09:25:32 pm »
If he wants to use it he can use it.
But he should convert ASAP to mainstream.

Why do you feel that FF 2 was not mainstream enough? I know it's been stale for a decade, however, it worked then and works now. Nexxus supposedly used the code and made a business out of the engine. The project I am working on, is coming from fixed record length flat files - I was going to port to Foxpro DBF/CDX when I stumbled across someone mentioning why not FlashFiler in my blogs. (I have another commercial suite that is running against FF 2.1 flawlessly since 1998/99 to now. With over 50 concurrent users 5 to 6 days a week -- it's a CRM I designed to mimic ACT! - and to this date FF has never given me a problem - it supports most of SQL-92, and for this new project, that is more than I need.

Thanks!
Ozz
---
Want to kick the tires to a Free Pascal like script engine? http://www.ModernPascal.com/

ozznixon

  • Jr. Member
  • **
  • Posts: 85
    • http://www.modernpascal.com/
Re: Turbo Power Flashfiler Lazarus Port
« Reply #38 on: December 22, 2017, 10:36:21 pm »
Downloaded (thanks) - it is still only WINDOWS compliant code... so I will compare for any differences to my Linux build and resume.

Thanks!
O.
---
Want to kick the tires to a Free Pascal like script engine? http://www.ModernPascal.com/

taazz

  • Hero Member
  • *****
  • Posts: 5363
Re: Turbo Power Flashfiler Lazarus Port
« Reply #39 on: December 23, 2017, 02:30:20 am »
If he wants to use it he can use it.
But he should convert ASAP to mainstream.

Why do you feel that FF 2 was not mainstream enough? I know it's been stale for a decade, however, it worked then and works now. Nexxus supposedly used the code and made a business out of the engine.
Nexus used the team not the code.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #40 on: December 23, 2017, 08:17:24 am »
If he wants to use it he can use it.
But he should convert ASAP to mainstream.

Why do you feel that FF 2 was not mainstream enough? I know it's been stale for a decade, however, it worked then and works now. Nexxus supposedly used the code and made a business out of the engine.
Nexus used the team not the code.

Indeed, Nexus has a completely different engine.
Aside: Paradox and dBase also still work, but are just as stale.
My current advise is to port everything to Sqlite for single user code (although with e.g. even mOrMot to multi-user) or use a modern maintained SQL database format that scales and is mainstream: MySQL, MariaDb, Progress, even Oracle.
Note that there is even a full pascal translation of Sqlite (commercial): https://www.yunqa.de/delphi/products/sqlite3/index This is not a binding, but full sourcecode in Object Pascal. In case you want everyting in Object Pascal.
Most people that want to use threading should learn to patch their jeans first: use a needle.

taazz

  • Hero Member
  • *****
  • Posts: 5363
Re: Turbo Power Flashfiler Lazarus Port
« Reply #41 on: December 23, 2017, 08:38:46 am »
Indeed, Nexus has a completely different engine.
Aside: Paradox and dBase also still work, but are just as stale.
paradox and dbase have no acceptable supported solution. BDE was the only compatitor to access back in the day
My current advise is to port everything to Sqlite for single user code (although with e.g. even mOrMot to multi-user) or use a modern maintained SQL database format that scales and is mainstream: MySQL, MariaDb, Progress, even Oracle.
Personally I dislike sqlite. I prefer ff2 it is far more interesting with smaller file sizes it includes everything I need.
Note that there is even a full pascal translation of Sqlite (commercial): https://www.yunqa.de/delphi/products/sqlite3/index This is not a binding, but full sourcecode in Object Pascal. In case you want everyting in Object Pascal.
I thought that it had the sqlite c code linked in as obj not rewritten in object pascal.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #42 on: December 23, 2017, 09:17:33 am »
Indeed, Nexus has a completely different engine.
Aside: Paradox and dBase also still work, but are just as stale.
paradox and dbase have no acceptable supported solution. BDE was the only compatitor to access back in the day
My current advise is to port everything to Sqlite for single user code (although with e.g. even mOrMot to multi-user) or use a modern maintained SQL database format that scales and is mainstream: MySQL, MariaDb, Progress, even Oracle.
Personally I dislike sqlite. I prefer ff2 it is far more interesting with smaller file sizes it includes everything I need.
Note that there is even a full pascal translation of Sqlite (commercial): https://www.yunqa.de/delphi/products/sqlite3/index This is not a binding, but full sourcecode in Object Pascal. In case you want everyting in Object Pascal.
I thought that it had the sqlite c code linked in as obj not rewritten in object pascal.
diSqlite is a full pascal translation of everything as far as I know.  Linking in the obj files - now file - is something I already did in 2000 so then the product would not interest me. It is interesting what he did, but he charges too much.
dBase - almost all versions, including foxpro - has very good and maintained support out of the box in FPC. Paradox is available too to some extend, unmaintained.
Sqlite format is lighter than FF afaik: it stores minimum content+ length information. FF stores fixed length. There is also a reason that *everybody* uses it as the preferred embedded data store: Apple, Microsoft, Google, you name them.

Anyway: FF is available for FreePascal. Client and recently also server. But it is also un-maintained and abandoned straight after finishing it by its author.
« Last Edit: December 23, 2017, 09:23:55 am by Thaddy »
Most people that want to use threading should learn to patch their jeans first: use a needle.

Thaddy

  • Hero Member
  • *****
  • Posts: 8673
Re: Turbo Power Flashfiler Lazarus Port
« Reply #43 on: December 23, 2017, 09:43:16 am »
Note Pascal has also file of record and FPC has a good lightweight engine as standard: fpindexer. If you want really lightweight  :D :D :)
« Last Edit: December 23, 2017, 09:58:07 am by Thaddy »
Most people that want to use threading should learn to patch their jeans first: use a needle.

taazz

  • Hero Member
  • *****
  • Posts: 5363
Re: Turbo Power Flashfiler Lazarus Port
« Reply #44 on: December 23, 2017, 10:04:16 am »
Note Pascal has also file of record
file of record is not an acceptable solution either, to many missing parts, TurboPower B-Tree Filer is a far better solution if you want to go down the record route. If I could only find the port posted on the mail list a couple of years back. It did not survived my last disk crash.
FPC has a good lightweight engine as standard: fpindexer. If you want really lightweight  :D :D :)
You do know that fpindexer is a full text search engine and not a database, right?
DBase, paradox and the rest of the solutions are not acceptable either the existing components target the file format only, no sql, no network/locks and the index support is sketchy at best. FF2 has the complete package from compressed tables up to encrypted ones with sql support views, stored procedures etc. It is the best pascal database so far and if supported properly it will be far better than sqlite.
As for the popularity of SQLite the main reasons are 1) it is a c based embedded database 2) it is under the BSD license and 3) it has a small footprint. Those reasons makes it a good solution for storage limited devices (mobiles phones, tablets etc). it is not its technical superiority over (firebird for example) other databases that it was chosen.

« Last Edit: December 23, 2017, 10:14:44 am by taazz »
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64