Page 6 of 6

Re: start with sqlite

Posted: Thu Nov 14, 2019 12:52 pm
by tonton2
mustafa wrote: Thu Nov 14, 2019 10:56 am Google Translation

Hello tonton2 friend
Thanks to the teachings of Friend Dragancesu I have been able to experience
a little bit SQLite

ConverterDBF <-> SQLite by Master Rathinagiri -> dbf2sqlite.zip
viewtopic.php?p=20587#p20587

viewtopic.php?f=5&t=5994&hilit=SQlite_Converter
SQlite_Tools.zip 

If I can serve you this little Sample that I publish
where you have the basic functions in a database
New, Modify, Low, Search and Printer

viewtopic.php?f=9&t=4795&hilit=mustafa+sqlite&start=10
Sqlite_Photo_Selection_New_Plus.zip

Regards /As Salamu Alaikum
Mustafa
Salam alik ya mustafa et merci beaucoup, je vais consulter tout ça

Re: start with sqlite

Posted: Thu Nov 14, 2019 1:31 pm
by tonton2
dragancesu wrote: Thu Nov 14, 2019 12:48 pm Hello Tonton
at one point I was curious about sqlite so I wrote a little bit about it,
after many tries and samples I gave up using it, it is skiled for simple applications, one exe and one database file, it works

But if an application needs to have a lot of data to account with then it needs something better, a good solution is MySQL (or MariaDB, for the program it's the same)

Harbour naturally uses DBF, MySQL and the like is a possibility and then you should first read the data that will be displayed

To start with it, need make some procedure/functions but it pays off, SQL is a simple and powerful language, the database stores a lot of data, quickly uses it select/insert/update/delete, data dictionary exsist, one make index and forget, it work

Data transfer to another computer is possible through tools, export and import
Merci beaucoup mon ami