I'm a clueless n00b. Halp. How do I update the demo files for my 2015 Samsung phone running Android 5.1.1, which apparently only likes PIE executables? I moved the demo files out of /sdcard/bas/ so xbasic 1.25 would regenerate them, including the sqlite3 shells, but no joy:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried blowing away the sql demo components sqldemo.bas and sqlite3*, reinstalling the xbasic 1.25-50 APK, and modifying a copy of sqldemo.bas to always run the @android_installer and run ls -l on the sqlite3 files. I tried having it install both sqlite3.armeabi and sqlite3.armeabi-v7a on separate runs, but no joy. Even trying the shell demo to get an interactive sh for poking around failed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm rolling my own ISAM engine in pure BASIC code using indexing based on prefix trees. I'm having more difficulties than anticipated optimizing certain queries to use sqlite3's indexes effectively, but using something like a quadtree or octtree ought to do the trick, and a trie with a fan-out of 16 and one trie node per nybble in the string key should do it. Here's the code for insertion and retrieval by full key as of a couple of weeks ago,
I'm a clueless n00b. Halp. How do I update the demo files for my 2015 Samsung phone running Android 5.1.1, which apparently only likes PIE executables? I moved the demo files out of /sdcard/bas/ so xbasic 1.25 would regenerate them, including the sqlite3 shells, but no joy:
Hm... It works on my Android 5.0 phone
It does work on an Android 4.4.4 tablet as well.
I tried blowing away the sql demo components sqldemo.bas and sqlite3*, reinstalling the xbasic 1.25-50 APK, and modifying a copy of sqldemo.bas to always run the @android_installer and run ls -l on the sqlite3 files. I tried having it install both sqlite3.armeabi and sqlite3.armeabi-v7a on separate runs, but no joy. Even trying the shell demo to get an interactive sh for poking around failed.
Well, so it is a new issue which only comes up with newer Android versions. Looks like they are not downwards compatible. How should one handle this?
I'm rolling my own ISAM engine in pure BASIC code using indexing based on prefix trees. I'm having more difficulties than anticipated optimizing certain queries to use sqlite3's indexes effectively, but using something like a quadtree or octtree ought to do the trick, and a trie with a fan-out of 16 and one trie node per nybble in the string key should do it. Here's the code for insertion and retrieval by full key as of a couple of weeks ago,
https://forums.craigslist.org/?ID=299254164
It will also be possible to walk the link or log files to retrieve keys and data in 'sequential' order.
Last edit: Yet Another Troll 2019-06-04
sqlite should work (again) with the new versions of X11-Basic 1.27-63. So this issue is fixed now.
It's working now on Android 4.4.4, 5.1.1, 8, 9, 10, and 11. I don't have any Android 6 or 7 devices to try it on.
Last edit: Yet Another Troll 2021-07-31