SQLite database and MIT app inventor 2

3,302 views
Skip to first unread message

Marijke Weijers

unread,
May 26, 2016, 4:01:56 PM5/26/16
to MIT App Inventor Forum
Is it possible to connect a local SQLite database with apps made by MIT AI2 ? Examples ?
If not, are there other ways to have a local database instead of tinyDB ? I need a database with 20.000 record, each of 3 fields < integer7, integer 13, char40 >.


Abraham Getzler

unread,
May 26, 2016, 7:07:09 PM5/26/16
to MIT App Inventor Forum
If you export the data as  a .csv file, and upload it into the Media drawer,
you can read it into a global text variable at Screen1.Initialize time,
and when it arrives via a File event, pass it thru a csv to table block, and save that in a global.
The table (list of lists) can be filtered using techniques in this sample app in the gallery ...

For 20,000 records, it might be small enough to not need indexes.

ABG

Abraham Getzler

unread,
May 27, 2016, 12:46:40 PM5/27/16
to MIT App Inventor Forum
Your reply came to my mail Inbox, instead  of this board, where it got caught in my nightly Inbox flush.

Try this link, for leads to SQLLite usage on AI2 ...

If they don't help, resume discussion on this board in this thread, to 
open it to more helpful eyes.

ABG

Taifun

unread,
May 27, 2016, 7:35:46 PM5/27/16
to MIT App Inventor Forum
you might be interested in my SQlite Extension to access the local SQlite database...
Taifun
Reply all
Reply to author
Forward
0 new messages