Android Question Export SQLite

[Fizzy]

I have an application with a SQLite database. How can I make it export table to CSV, JSON, or any other format, and upload it to FTP or send it via email? In principle, these will be very small tables, with a maximum of 2 keys, 10 fields, and at most a few thousand records.

Later I am also interested in how I could perform an import from CSV, JSON .. TO SQLITE

 

[Erel]

DBUtils includes a method to convert query results to json: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/#content