* * *

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 15906 times)

Thaddy

  • Hero Member
  • *****
  • Posts: 6568
Re: Turbo Power Flashfiler Lazarus Port
« Reply #45 on: December 23, 2017, 12:47:10 pm »
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.
It is not under any license.  see: https://sqlite.org/copyright.html  It is copyright protected, though. It is public domain in the strictest sense of public domain. (Which differs from free software, that includes licensed software)
Because of the copyright protection the only limitation is that you  can not claim to have written it.
It is technically superior to firebird. That's a fact, not an opinion. Although I hate firebird, for the record.
And fpindexer contains a full text search engine, but it is an indexer.

But feel free to use FF. I did so for years. In my opinion it is a bad idea to recommend it, though, for the reasons I mentioned before.
- Not mainstream
- Not maintained
- Can you access your data in 20 years time?
« Last Edit: December 23, 2017, 12:59:05 pm by Thaddy »
Ada's daddy wrote this:"Fools are my theme, let satire be my song."

taazz

  • Hero Member
  • *****
  • Posts: 5257
Re: Turbo Power Flashfiler Lazarus Port
« Reply #46 on: December 23, 2017, 01:24:18 pm »
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.
It is not under any license.  see: https://sqlite.org/copyright.html  It is copyright protected, though. It is public domain in the strictest sense of public domain. (Which differs from free software, that includes licensed software)
Because of the copyright protection the only limitation is that you  can not claim to have written it.
Does not change the reasoning it only makes it even easier to use but you are right.

It is technically superior to firebird. That's a fact, not an opinion. Although I hate firebird, for the record.
Any proof to support your claim? Which feature are technically superior to firebird? As far as I know it has no concurrent access, limited SQL support (views become available the past year or two if I recall correctly), data types are non existent, they are considered requests not data types (try creating a field with data type thaddy and see for your self) numeric checks follow the string convention more than the numeric one and a number of other falsities which make it a bad choice for any mid to big data sized application.

And fpindexer contains a full text search engine, but it is an indexer.
A full text search engine is an indexer for text it does not make it a database the same way a index of a paradox table is not the database.
But feel free to use FF. I did so for years. In my opinion it is a bad idea to recommend it, though, for the reasons I mentioned before.
- Not mainstream
true then again very few database are mainstream and most of them you have no access to their code.
- Not maintained
Not yet. But its the only one that (if code properly) can go everywhere fpc goes with out the need a C/C++ compiler.
- Can you access your data in 20 years time?
well as long as I have the code the answer is yes. Can you say the same for Oracle? MSSQL? those are as mainstream as they come.
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

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus