How will the user can access only his data?

[ChrisWard]

@bianchix

No, but is it possible to access the data even if its offline?

Yes, the data is stored on the phone so it is offline and you can access it with your App.

FAQ Section: Sqlite

Tutorials Related tables. SimpleSqlite extension. Pharmacy example - @Juan_Antonio Web SQL Database in Browser. JavaScript. HTML5 - @Juan_Antonio Extensions PuraVidaApps SQLite extension - Taifun Some SQLite samples - Peter Thomson Thomas Bennedum SQLite extension Pedroza SQLite extension - Thunkable HOWTO: php SQLite3 as server database with AI2 - TimAI2 HOWTO: Use sqlite3 with @Juan_Antonio’s Terminal Extension - TimAI2

Depending on your search requirements, you could just as easily use a CSV file (comma separated text file), again stored on the phone. Also, depending on how many plants there are, you can use TinyDb.

[ChrisWard]

@SHUBHAMR69

I'm not taught about databases actually, except MS Excel and MS Access.

Excel is a spreadsheet, Access is a Database, both designed by MS for Windows but there are variants for other OS.

[SHUBHAMR69]

@ChrisWard

Excel is a spreadsheet

Wait can't we access things in Excel from outside.

Not sad to know that actually.

[ChrisWard]

@SHUBHAMR69

Wait can't we access things in Excel from outside.

In a convoluted way we can because Excel supports the CSV format. In such a process, we have to ensure that Excel is talking UTF-8 in many cases, as that's the default in App Inventor.