hey this is SQLITE for AGK

Started by Pfaber11, March 01, 2025, 14:45:51

Previous topic - Next topic

Pfaber11

After searching a bit I found this on TGC forum.
Sorry this is for Dark Basic

I checked this for viruses and it is free of them.(when checked)
Windows 11 home edition
PureBasic 6.20 and AppGameKit studio
ASUS Vivo book i5 15 16gb ram 512gb ssd
ASUS Vivo book i3 15 16gb ram 256gb ssd
HP Desktop; AMD 6700 A10 16GB ram 2 GB graphics card windows 10

Pfaber11

I get it now I figured SQL was a plugin to give me database access but now I see it is a language in itself. Although I did not get what I originally wanted I have learnt a few things so it was an ok day.

Windows 11 home edition
PureBasic 6.20 and AppGameKit studio
ASUS Vivo book i5 15 16gb ram 512gb ssd
ASUS Vivo book i3 15 16gb ram 256gb ssd
HP Desktop; AMD 6700 A10 16GB ram 2 GB graphics card windows 10

Derron

What did you think the L in SQL stands for?

You wanted database support - and the databases of the last 20 years are almost all offering a flexible ability to query for data ... and flexibility often comes with some simple "language".
It is up to the "module/lib/..." to offer you a procedural interface to many things ("results.getFirst()" so to say). It is not on the database to offer you these things.


bye
Ron

Pfaber11

Although I have not tried but I think quite possible would be for me to write my own database as and when required.  
Windows 11 home edition
PureBasic 6.20 and AppGameKit studio
ASUS Vivo book i5 15 16gb ram 512gb ssd
ASUS Vivo book i3 15 16gb ram 256gb ssd
HP Desktop; AMD 6700 A10 16GB ram 2 GB graphics card windows 10

Derron

#4
As you seem not to have to do so much (except language hopping) : why not do that as an excercise? Remember to take care of character encoding - would be bad if you put in UTf16 but ignore that on reading in - your foreign customers would not be happy (or customers which have foreign customers ... or simply foreign employee names).
Also pay attention to floating point issues ... nobody likes it if you store your numbers in an inaccurate way (1.4 is not 1.399999 or 1.4000007 !).
Also people might have databases way bigger than your RAM .. so you need to support a bit of paging and streaming.
Also people might be interested in "entry 540.000" and next then "entry 2" - be prepared for "fast lookups" (know "where" in the file to look instead of simply scanning the file until you reach "id 540.000").

OK ... time to stop making you afraid ... write a simple (!) database - storing stuff, loading in stuff, allow grouping (dunno how many levels...) and at the end you get at least some kind of ".ini"-file writer and loader. On Windows you surely are supposed to use the Windows Registry instead of ini files but yeah ... maybe someone still uses it, and it is a good excercise.
Then with it, learn where to pay extra attention to: serializing primitives (texts in various encodings), numbers (floating point, BIG numbers, ...)

This is then your knowledge base when it comes to writing your "own database". And is super useful when you need to tackle other things (talking to external (eg. web) APIs requiring input in certain shapes).



bye
Ron

Pfaber11

I would think GUI stuff on the whole is no great feet for a programmer as well using AGK S/C . 
I noted that when testing virtual buttons on AGK S for Android the virtual buttons can be used for GUI stuff not just for Android and you can make them look anyway you like. 
Windows 11 home edition
PureBasic 6.20 and AppGameKit studio
ASUS Vivo book i5 15 16gb ram 512gb ssd
ASUS Vivo book i3 15 16gb ram 256gb ssd
HP Desktop; AMD 6700 A10 16GB ram 2 GB graphics card windows 10

Pfaber11

Just to add the particle editor is not required to make smoke I use the particle emitter. 
Windows 11 home edition
PureBasic 6.20 and AppGameKit studio
ASUS Vivo book i5 15 16gb ram 512gb ssd
ASUS Vivo book i3 15 16gb ram 256gb ssd
HP Desktop; AMD 6700 A10 16GB ram 2 GB graphics card windows 10