Android Question SQL has several possiblilities: which one?

Shelby

Well-Known Member
Licensed User
Longtime User
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
 
Last edited:

aeric

Expert
Licensed User
Longtime User
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.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…