How to work with sqlite in java?

Question

Java

Good day. I recently began to study this topic and would like to ask how can I make it public in terms of entering data? In the sense that one user would enter data into the table, the second, third, and then it would be possible to take this data and output to all 3 users. And if it is possible, what should be done for this?

Answer 1

I'm new to this stuff myself and I'm curious. I would implement it like this. I would start a MySQL database (for CRUD). And then, in a separate thread, I would set up synchronization of the mysql => sqlite => mysql database
if this applies to android, then you can use mysql again, only for sqlite use not SqliteOpenHelper, but SQLiteAssetHelper .. probably ... It will be interesting to hear the opinion of experts