start with sqlite

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
tonton2
Posts: 297
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Has thanked: 8 times
Been thanked: 11 times
Contact:

Re: start with sqlite

Post by tonton2 » Thu Nov 14, 2019 12:52 pm

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
L'Algerie vous salut
Y.TABET

User avatar
tonton2
Posts: 297
Joined: Sat Jun 29, 2013 1:26 pm
Location: Algerie
Has thanked: 8 times
Been thanked: 11 times
Contact:

Post by tonton2 » Thu Nov 14, 2019 1:31 pm

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
L'Algerie vous salut
Y.TABET

Post Reply