DBFCDX or SQLite
Moderator: Rathinagiri
DBFCDX or SQLite
Hi All,
Which better HMG+DBFCDX or HMG+SQLite ?
Regards,
Tristan
Which better HMG+DBFCDX or HMG+SQLite ?
Regards,
Tristan
Re: DBFCDX or SQLite
With DBF you have no problem with record locking in multiuser environment.
You have date and logic fileds.
SQLite - fine, if you want use SQL and have all data in one file.
I didn't test for speed.
Marek
You have date and logic fileds.
SQLite - fine, if you want use SQL and have all data in one file.
I didn't test for speed.
Marek
Re: DBFCDX or SQLite
Hi Tristan,
Thanks a lot
You have started the hottest topic of my choice
In my first message I am writing points for DBFCDX (and in next message I shall write for SQLite)
PROS:
1. Easy to create.
2. Native database for HMG (more specifically Harbour/xHarbour), like Access for VB and MS Sql for VB.Net. (Please correct me if I am wrong)
3. No extra load.
4. Runs very fast.
5. Store good amount of data.
6. We can use standard good old xbase commands.
CONS:
1. Database is easily corrupted.
2. No security feature.
3. Each table is a file. I get confused with so many files. This is my very humble personal opinion. Some of my expert friends like this feature.
4. We can't use SQL commands. There is an exception - VFP, where we can use SQL commands with DBF/CDX. Again some of my expert friends may differ. But, in my very humble personal opinion - sometimes SQL is more efficient both in execution time and code size (especially for queries, reports etc.)
There are so many points, which don't come to my mind right now
Again, I regard myself as a learner of HMG. So, those points may be wrong.
You may find following link helpful viewtopic.php?f=15&t=853&start=9
With best regards.
Sudip
Thanks a lot
You have started the hottest topic of my choice
In my first message I am writing points for DBFCDX (and in next message I shall write for SQLite)
PROS:
1. Easy to create.
2. Native database for HMG (more specifically Harbour/xHarbour), like Access for VB and MS Sql for VB.Net. (Please correct me if I am wrong)
3. No extra load.
4. Runs very fast.
5. Store good amount of data.
6. We can use standard good old xbase commands.
CONS:
1. Database is easily corrupted.
2. No security feature.
3. Each table is a file. I get confused with so many files. This is my very humble personal opinion. Some of my expert friends like this feature.
4. We can't use SQL commands. There is an exception - VFP, where we can use SQL commands with DBF/CDX. Again some of my expert friends may differ. But, in my very humble personal opinion - sometimes SQL is more efficient both in execution time and code size (especially for queries, reports etc.)
There are so many points, which don't come to my mind right now
Again, I regard myself as a learner of HMG. So, those points may be wrong.
You may find following link helpful viewtopic.php?f=15&t=853&start=9
With best regards.
Sudip
With best regards,
Sudip
Sudip
Re: DBFCDX or SQLite
Using DBFCDX, you can easily browse huge tables -size doesn't matter.
Using SQLite - you must create array in memory - I've reached exhaustion in my test while converting DBF (something about 40MB) to SQLITE, so you can present only range of database.
maybe I'm wrong, but I think - DBF's are very easy and work fine. In my apps, corruption od DBF doesn't happened fro years. Sometimes, it's necessary to rebuild indexes.
Using SQLite - you must create array in memory - I've reached exhaustion in my test while converting DBF (something about 40MB) to SQLITE, so you can present only range of database.
maybe I'm wrong, but I think - DBF's are very easy and work fine. In my apps, corruption od DBF doesn't happened fro years. Sometimes, it's necessary to rebuild indexes.
Re: DBFCDX or SQLite
Yes Marek, you are absolutely correct I may differ in one point. I faced several cases data corruption for my clients with Clipper apps and VFP apps. But, since one year when I converted my Clipper apps to x/Harbour. I didn't face this problem too much
I must say that using DBFCDX with HMG is easier than any Sql database. But this may be changed if we have good SQLRDD (I haven't tested HMG 3.0.0 IV SQLRDD yet).
There is one point which I got from Roberto Lopez. If we can port our app to Sqlite, we can port it into many big, client server RDBMS, like MYSQL, PostGreSQL (till now I can't use PostgreSQL with HMG) etc. This scalability issue is a very good point.
We can't use transaction facility with DBFCDX (till now).
Again, IMHO, DBFCDX is record based where SQL is set based. So, for query SQL database should be more efficient
Please, write your valuable views. It will be extremely helpful for me
Rathi, I need your views also
With best regards.
Sudip
I must say that using DBFCDX with HMG is easier than any Sql database. But this may be changed if we have good SQLRDD (I haven't tested HMG 3.0.0 IV SQLRDD yet).
There is one point which I got from Roberto Lopez. If we can port our app to Sqlite, we can port it into many big, client server RDBMS, like MYSQL, PostGreSQL (till now I can't use PostgreSQL with HMG) etc. This scalability issue is a very good point.
We can't use transaction facility with DBFCDX (till now).
Again, IMHO, DBFCDX is record based where SQL is set based. So, for query SQL database should be more efficient
Please, write your valuable views. It will be extremely helpful for me
Rathi, I need your views also
With best regards.
Sudip
With best regards,
Sudip
Sudip
Re: DBFCDX or SQLite
I agree with you.
Changing from DBF to SQL requires change of thinking of data.
Besides, world trend is for SQL
Changing from DBF to SQL requires change of thinking of data.
Besides, world trend is for SQL
Re: DBFCDX or SQLite
Hello Sudip!
Hello Mol!
Unfortunately I do not have knowledge in SQL and theoretical background as you both.
I have read, that DBFCDX creates more traffic because a lot of (index) information is ordered from the server. This could be a problem in lange LANs.
I work in a small company with less then 10 clients. Typical problems are converting article data and condensing data.
When I tested the time for indexing 50k of articles ist lastet about 0.3 seconds.
So for my special situation I think DBFCDX ist the best solution.
Best regards! Hans
Hello Mol!
Unfortunately I do not have knowledge in SQL and theoretical background as you both.
I have read, that DBFCDX creates more traffic because a lot of (index) information is ordered from the server. This could be a problem in lange LANs.
I work in a small company with less then 10 clients. Typical problems are converting article data and condensing data.
When I tested the time for indexing 50k of articles ist lastet about 0.3 seconds.
So for my special situation I think DBFCDX ist the best solution.
Best regards! Hans
Re: DBFCDX or SQLite
I would say that SQLite is more elegant and I believe it can replace DBF with some advantage in most cases.
Just my personal opinion.
Just my personal opinion.
Harbour | GTWVT | MingW | Visual Studio Code
- fouednoomen
- Posts: 188
- Joined: Sun Oct 14, 2012 8:33 am
- DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, Oracle, ODBC
- Location: Tunisia
Re: DBFCDX or SQLite
Dear All ,
I just finish to Migrate from clipper to Hmg ,
I have a big Application with more than 50 simultaneous users and more than 30 dbf files
with more than 1 Gb as size , with DBFCDX it's run Very well with a good server but i have
a security problem , so for this reason i think to migrate to a database system .
i don't knows what i should take as database system ( sql lite or my sql or ...) and the volume of job to migrate ,
i need your help for the best /fast solution and the easy way to migrate without many changes
Regards
Foued
I just finish to Migrate from clipper to Hmg ,
I have a big Application with more than 50 simultaneous users and more than 30 dbf files
with more than 1 Gb as size , with DBFCDX it's run Very well with a good server but i have
a security problem , so for this reason i think to migrate to a database system .
i don't knows what i should take as database system ( sql lite or my sql or ...) and the volume of job to migrate ,
i need your help for the best /fast solution and the easy way to migrate without many changes
Regards
Foued
- Rathinagiri
- Posts: 5477
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: DBFCDX or SQLite
For 50+ simultaneous users SQLite is out.
Your options are mysql or postgreSQL or firebird.
Now a days I use MariaDB which is a drop in replacement for MySQL with full open source license.
Your options are mysql or postgreSQL or firebird.
Now a days I use MariaDB which is a drop in replacement for MySQL with full open source license.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.