How to write a mobile application for android?

Question

Android

Hello, I have a few questions at once. Please tell me:
1. Tell me in what language to write a mobile application? I read on the Internet that in java, but the top mobile game platforms, such as Unity, work with C # for some reason ... So I have a dilemma.
2. And what is the best platform to use? android studio? Or the same Unity? Or maybe some more?
3. I want to write an application and use the site's database, in which MySQL. It turns out that in order to link the mobile phone with the site database, I have no other choice, and I have to use MySQL for the mobile phone? I just read on the internet that for mobile phones sql lite is the most normal.

Oh yes, and another question. I read somewhere that java cannot be written for IOS. That is, if in the future I want to expand and write an application for ios, will I have to learn other languages ​​there?))

Answer 1

1. There are a bunch of applications to choose from: Kotlin, Flutter, Java, Xamarin, React native
And there is KMM on Kotolin
For games, there is Unity, Godot, UE
2. Choose what you know better
3. Interact with the site through the REST API.
4. If you choose non-cross-platform technology, then yes

Answer 2

1. The key to writing an application on Android is the Android SDK itself, you can write in many languages. The most common for applications is Java, which is actively growing and being promoted by Kotlin. There are a bunch of cross-platform solutions like Xamarin and React. C# and, accordingly, Unity are no longer used for applications, but for games, although, of course, no one forbids writing applications as well.
2. For applications - Android Studio, for games - Unity.
3. SQLite is used as an internal application database, but you are developing a client-server application, that is, you need to write the application itself separately, separately its server part, which will already communicate with the site's MySQL. How exactly to connect the client and the server - there are a bunch of different ways. Direct queries to MySQL, of course, should not be used.
4. As I wrote above, there are cross-platform solutions, but in general, you need to write your own application for each platform, there are their own features everywhere. So get ready to rewrite and support the two applications accordingly. By the way, the basic syntax of Swift (it is written for iOS) is not much different from the same Java or C #, the need for MacOS to actually build the application and publish it in the store can become a bigger problem.

Answer 3

1. I advise kotlin, if the program is for robots, and if games, then Unity
2. Depends on the choice above, if kotlin is android studio, and if unity, then unity
3
. you have to rewrite in swift or something like that, look on the Internet, the modet will have an answer there
I hope it helped a little...

Answer 4

If Android is Java & Kotlin
It's better to start with Java, but Kotlin is more promising. Write in Android Studio, most people write there.