SQLite - limit v aktívach app

MIT App Inventor Help
1

Hello.
Can anyone advise?
I have a csv file that has 2 columns and 66,000 rows. One line is about 50 characters plus the primary numeric key. Can I create a SQlite db in the assets app from this? Can AppInventor do it?
Ondrej

2

Why not try it, see how well it works?

I use a program called DB Browser for SQLite to view and create sqlite databases.

You do not necessarily need the second column with the numeric key, Sqlite will use the row number for this, if you prefer. (66,000 less pieces of data!)

SELECT rowid,* FROM 'Table1'

Once created you can upload to your assets.

Use Taifun's Sqlite extension.

1 Like