I'm looking to create a program in Compose Desktop...
# compose-desktop
b
I'm looking to create a program in Compose Desktop that can read data from excel sheets and compare that data to an SQLite Database(with millions of records) which then stores/outputs the results in various formats. Is there any tools/libraries you would recommend me using or looking into for this? Most of the results I see are built in android apps and I'm not sure if that is an ideal route in CD since the their is different options to choose from. I do plan on having this or at least the results shown on android/mobile in the future but not anytime soon.
j
Yeah, Compose for Desktop sounds like a great fit, especially if you want to go to Android some day. Most of the logic of your application is obviously not going to be specific to Compose for Desktop, and is just generic java logic. For example, to access an excel sheet, I'd probably suggest something Apache POI: https://howtodoinjava.com/java/library/readingwriting-excel-files-in-java-poi-tutorial/ When you render the records, keep in mind that you won't want to render all millions of records at once. You will want to use some sort of lazy list or pagination because your hardware graphics buffers aren't going to be large enough to render everything at once (regardless of rendering framework). But with some effort, you could make it look very seamless.
t
b
Thanks for the replies Jim & apache! That makes sense Jim, I've created a small script that reads txt documents and outputs the data into excel sheets. However, working with a database is new to me as well as a UI Framework. I'm fairly new to programming and it feels like I've hit a wall trying to decide with all of the choices out there for frameworks, etc. and was unsure what tools might be a better fit to learn to use with Kotlin & Compose for Desktop in order to make this program come to fruition; hence this post. I'll go over the logic again and try to keep any questions I may have in the right channels. This will be my first big project and looking forward to sharing my progress as I create the application in Compose for Desktop. Thanks again for the insight!
👍 1