Android Question SQL has several possiblilities: which one?

[Shelby]

I've been preparing for a database app development. I see and hear about SQL, MySQL and SQlite. For a couple of months I've been using tutorials of MySql to get an understanding of how to manipulate databases. Before I invest more time with MySql, I'm wondering if those of you who are familiar with database apps think I should continue with MySql learning. Maybe you have reasons why you think I should consider changing to another database manipulation language. My app will be comprised of 200 to 400 table line entries with probably not more that 4 to 6 columns for choices by users.
I guess I'm looking for the easiest for me to understand and easiest to build, B4A instance. If other than B4A is required, so be it. I'm always learning so I can be flexible with my direction.
Thanks,
Shelby

 

[aeric]

To make it easy, I would say if you just need a standalone or offline database just for your B4A app inside an Android device, then SQLite is good to go.

If you want to share the data or sync between more devices with another remote database server, then using MySQL as a database server is a better choice.
Since you have learned MySQL, it will be useful when you want to use SQLite later as the name suggest, SQLite is a lite version of database.

 

[Shelby]

Thanks Aeric, I think I'll start learning about SQLite as I see a tutorial by Klaus with 4 examples. https://www.b4x.com/android/forum/threads/35419/#content

 

[klaus]

You may also have a look at the B4X SQLite database booklet.
It contains the examples in the link of your post, and cross-platform.

 

[Shelby]

Right, Thanks Klaus