Dear Bert !
This group is not about firebird,
Ok, I know it.
But I want info from SQLite.
I wrote these fbembed question to see, I want to compare the possible solutions.
I don't know enough about the SQLite, so I'm not sure that is true, or not true, what I say about it.
If you think that SQLite have a simple way to create the apps, please write me.
The DataBase and app is must be placed in CD, and I not want write to DB. Only search datas, with eng/hun order, and with like "%n%" (eng/hun). SQLite is good for it ?
Thanx: ft
Bert Verhees írta:
Op vr, 22-04-2005 te 08:56 +0200, schreef [EMAIL PROTECTED]:
Hi !
In the years of 2000 I wrote 3 programs.
These apps are placed in CD, but in this time I don't have good solution for online databases.
Then I placed an Installer in CD, and this Setup prg. is install InterBase 6.0 in the computer with my software.
That is very wrong solution (I think it NOW), but in the year 2000 I need fast development...
The problems are many with this:
- The InterBase installer is english, and the program is multilang
- The IB server may be exists in the dest. computer, then it need sysdba password setting.
- If FB or other IB same systems are installed in computer, then the program have been crashed on checking.
So.
I need to re-develop these apps, and make new CD-s. But I have a problem, because I don't know, what a method I choose for it !
The older databases stored in IB6.0 format.
1. FB (FireBird) Embed 1.5.2:
That is very good if working, and not buggy.
But many questions I have about it.
A.) it is working if I place in CD ? (Online database needed !)
B.) it is working with older db format ?
C.) it have enough stability ?
D.) it is enough to place FBEmbed.dll as gds32.dll, or I need another files ?
E.) it is fully supports charset, and ordering ?
F.) I can protect my fdb file with another password technique ?
G.) it is enough speedy ?
H.) can I use it readonly mode ?
I.) it is supports an FB compliant interface to access db with IBX/IBO ?
This group is not about firebird, but as you say, it is feature-rich, you can use it embedded, and the only file you need is indeed gds32.dll It is said to be slower than SQLite, but in many situations you will not notice. It depends on what your app does, you only do reads, no inserts or updates I do not know about the language issue and firebird.
regards bert verhees
2. XML ?
XML is very flexible, and because it is text based, then everytime readable. MS XML Interface is good for it, but not support searches - so I need to filter every elements.
Another problem is charset. I need to use win1250 (hun), and english charset. How to this program works with another langs/settings ?
Sort problems.
3. SQLite
SQLite is developed for these types of applications. 1 user, local datasets, quick access, etc.
But many problems with it:
- it have only english "order by" lang support
- it is not suppports functions like upper/lower (with hun chars)
So I need to search every records, and I need to compare them with my function, and I need to repack the subqueries' result.
Many developing, and I don't know, how to works it in a system with another language...
Please help me. I want to choose SQLite if possible a 'simpler' solution than I write every filters by hand.
Thanx for it: ft
