Android Question Little Database

[hasexxl1988]

Hello,
I would like to build a small product app, but you should add / delete categories. And in the categories accordingly afterwards products with different values (product name, price, addition, etc.).

I've looked at SQL and Sets already, but has problems with it.

The database should then be stored locally.

Example (That's how I imagined it):

Categorie = Categorie1
Productnames: Name1, Name2, Name3
Prices = 1,2,3
Addition = TestAdd1, none, TestAdd3

Categorie = Categorie2
Productnames: Name1, Name2, Name3
Prices = 1,2,3
Addition = TestAdd1, none, TestAdd3

And all values in a Database / File.

If possible with an Encryption (Username / Password)

Are there any possibilities to do so? Has any ideas?

 

[Daniel-White]

If I understand you well, you can use SQLite with Encryption. Take a look here. . https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/ I am using it a lot, and work great.

 

[hasexxl1988]

If I understand you well, you can use SQLite with Encryption. Take a look here. . https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/ I am using it a lot, and work great.

Ah okay thank you: D

I have just found "SQLite Light four simple SQLite projects" by klaus, now explains itself a lot

 

[klaus]

There is also a complete chapter 5 SQLite Database in the B4A User's Guide.