I am not sure how much work would it involve since I rely on the good heart of @hgy29
to build gideros because I am not proficient enough to touch gideros source code, however I noticed that the sqlite3 plugin embedded in gideros is still using version 3.7.17 (released in 2013 - print(sqlite3.version()) ) while there were many updates in the current sqlite3 development. https://www.sqlite.org/changes.html
I can only hope that since there were no major releases (it is still 3.xx) nothing changed in dealing with it from the gideros side.. just asking if it's something easy to do
The "new" features I'd like to use so far are UPSERT and FULL OUTER JOIN, but I think I've found a way to work around and obtain the same result using lua. Maybe it's not as performant as it would be but it's ok for my purpose until now.
I don't know about the other features listed in the release history yet, I guess that some could come in handy sooner or later (along with the bugfixes and optimizations).
I was asking if it was "easy" also because I guess that nobody use sqlite except me, even in this forum there are only 3 or 4 posts about it, one of which is this one
I strongly suggest anyone to use it though, because it already is a really powerful tool to handle a lot of data: I don't understand why it's not so popular.
Likes: MoKaLux, pie
Thank you a lot @hgy29
Likes: MoKaLux, talis
Those would allow for example to join multiple queries in a single one:
"select 3 people who use glasses and 2 who doesn't"
"select 4 players who already won 1 to 5 times and 4 players at their first match".
However I already worked around that for the moment, so I am not asking you to update sqlite yet
One question I have though is if it might be possible to allow sqlite plugin to do its stuff directly from the |R| folder (android) instead of having to copy the db in |D| before any operation on the db begins.