From DBF/CDX to SQLite
Posted: Thu Jun 24, 2010 1:09 pm
Hello,
I am trying to move from DBF/CDX to SQLite because of the many features and advantages I learned from here: http://www.sqlite.org/features.html
I was studing previous interesting posts with real examples about this subject and I am creating a simple program in CUI mode (Character User Interface) using Harbour + MingW32 + GTWVT + SQLite (all last versions available).
I could create a SQLite database, open it, do basic search with SELECT but I would like to do a equivalent to a BROWSE() from DBF/CDX.
Please keep in mind I never used SQLite before (nor any SQL like database) and my assumptions may be wrong (hopefully). Correct me, please.
The information I could collect is that I should use a SQL query to populate an ARRAY and them browse that array (maybe with ACHOICE?).
Other idea would be to use HBMEMIO to create a "DBF on memory", populate it and browse it.
Both ideas seem not really good to me because its kind of risky to depend on computers memory in special for big databases with zillions of records not to say other factors out of my control just to mention.
Any idea how to solve this? Any suggestions?
Please note that this is not a HMG specific question but since I found the most interesting information around HMG forums I gave a try to find more... Simple example code would be valuable too. (in special if it could be in simple text mode).
I am trying to make SQLite a reality for my application but I am not sure it will really replace DBF/CDX with advantage. Just wondering.
Thanks for any help.
Qatan
I am trying to move from DBF/CDX to SQLite because of the many features and advantages I learned from here: http://www.sqlite.org/features.html
I was studing previous interesting posts with real examples about this subject and I am creating a simple program in CUI mode (Character User Interface) using Harbour + MingW32 + GTWVT + SQLite (all last versions available).
I could create a SQLite database, open it, do basic search with SELECT but I would like to do a equivalent to a BROWSE() from DBF/CDX.
Please keep in mind I never used SQLite before (nor any SQL like database) and my assumptions may be wrong (hopefully). Correct me, please.
The information I could collect is that I should use a SQL query to populate an ARRAY and them browse that array (maybe with ACHOICE?).
Other idea would be to use HBMEMIO to create a "DBF on memory", populate it and browse it.
Both ideas seem not really good to me because its kind of risky to depend on computers memory in special for big databases with zillions of records not to say other factors out of my control just to mention.
Any idea how to solve this? Any suggestions?
Please note that this is not a HMG specific question but since I found the most interesting information around HMG forums I gave a try to find more... Simple example code would be valuable too. (in special if it could be in simple text mode).
I am trying to make SQLite a reality for my application but I am not sure it will really replace DBF/CDX with advantage. Just wondering.
Thanks for any help.
Qatan