Great and esteemed developer,
I want to express my admiration and respect for your work. I am truly grateful for your article titled "Embed an HTTP web server in Android" that you shared on https://yayocode.com/post/Rrg1SnHJ8yJ3bI4aoHOe?m=1. Your insights have been invaluable.
I have a similar idea in mind, but I am eager to seek your guidance. In your article, you used "private val userList = ArrayList()" as a storage solution. However, I am inclined to use SQLite for my project. I've attempted to utilize SQLDelight for managing SQLite, mainly because I plan to implement this solution in a cross-platform context in the future. Here's the link to the code I've been working on: https://github.com/cybernhl/Ktor_JWT/blob/5dac16ca81c82378ba20c7a51bf13e4312999502/server/server/src/main/kotlin/com/example/routing/Routes.kt#L204C13-L204C13 and the related Gradle file: https://github.com/cybernhl/Ktor_JWT/blob/5dac16ca81c82378ba20c7a51bf13e4312999502/share/db/build.gradle.kts#L156.
As someone primarily experienced in mobile development, I've attempted to reference various projects on GitHub, such as https://github.com/softartdev/NoteDelight, to gain insights into database operations. However, I still find the database-related aspects unsatisfactory and unfamiliar.
Additionally, I lack knowledge in handling server-side processes, specifically in querying through SQL and returning results to an API after receiving requests. I am in need of your expertise in these areas.
For example, in the early days of Android development, we used SQLiteOpenHelper/SQLiteDatabase, which would return -1 upon insertion failure. Also, when querying for a user by id or name, it would return null if there was no corresponding entry. How should these scenarios be properly handled?
Your guidance and insights would be greatly appreciated. Thank you for your time and assistance.
Great and esteemed developer,
I want to express my admiration and respect for your work. I am truly grateful for your article titled "Embed an HTTP web server in Android" that you shared on https://yayocode.com/post/Rrg1SnHJ8yJ3bI4aoHOe?m=1. Your insights have been invaluable.
I have a similar idea in mind, but I am eager to seek your guidance. In your article, you used "private val userList = ArrayList()" as a storage solution. However, I am inclined to use SQLite for my project. I've attempted to utilize SQLDelight for managing SQLite, mainly because I plan to implement this solution in a cross-platform context in the future. Here's the link to the code I've been working on: https://github.com/cybernhl/Ktor_JWT/blob/5dac16ca81c82378ba20c7a51bf13e4312999502/server/server/src/main/kotlin/com/example/routing/Routes.kt#L204C13-L204C13 and the related Gradle file: https://github.com/cybernhl/Ktor_JWT/blob/5dac16ca81c82378ba20c7a51bf13e4312999502/share/db/build.gradle.kts#L156.
As someone primarily experienced in mobile development, I've attempted to reference various projects on GitHub, such as https://github.com/softartdev/NoteDelight, to gain insights into database operations. However, I still find the database-related aspects unsatisfactory and unfamiliar.
Additionally, I lack knowledge in handling server-side processes, specifically in querying through SQL and returning results to an API after receiving requests. I am in need of your expertise in these areas.
For example, in the early days of Android development, we used SQLiteOpenHelper/SQLiteDatabase, which would return -1 upon insertion failure. Also, when querying for a user by id or name, it would return null if there was no corresponding entry. How should these scenarios be properly handled?
Your guidance and insights would be greatly appreciated. Thank you for your time and assistance.