Op vr, 22-04-2005 te 09:26 +0200, schreef [EMAIL PROTECTED]: > 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 ?
I don't know about the language issue, someone else must answer that. SQLite is for the rest a good choice, good connectivity, many wrappers in many programming languages, after some experimenting, easy to work with. It can run from CD, as long as you do not start transactions (nor implicit) Have fun with it. I must say, the SQL-features for SQLite are a little bit less then in Firebird. Mostly this is no problem at all. It is easy to switch from SQLite to Firebird and back. You can write a datapump in half an hour. I even once wrote an generic datapump from sqlite to firebird and back. http://www.rosa.nl/Bold2/ It does not work very well,it is again a bit old, summer last year, time flies in ICT, but you can look at the sourcecode how easy it is. So you can try both, and decide later which one is better for you, Firebird or SQLite Bert > > 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 > >> > >> > >> > >> > >> > >> > > > > > > > > >
