pymssql VS mvvmFX

Install pymssql, connect to the database, read data from files and do a lot of inserts.

Support of vendors. For example, the MS SQL driver for Python is developed from community a nd for some time it was in a maintenance state because developer stopped the project (see this). Instead, the JDBC driver is developed directly from Microsoft

pymssql-utils is a small library that wraps pymssql with the aim to make your life easier, and your database admins slightly happier.

Hi, at some point in the past I used mvvmFX and it was pretty nice to work with, but sadly it looks abandoned. So does drombler-fx which I remember looking into around that time. There was also tornado-fx (don't mind doing GUI code in Kotlin) but that's unmaintained now too. All that I could find today is Griffon, although that's clearly slowing down as well.

I still like it 🤷‍♀️ The property system is excellent and if you use a framework on top of it (I prefer mvvmFX), it's a breeze to build some quite complex stuff.

I'd recommend using some kind of framework, personally I like mvvmFX

I think the MVVM pattern is the one you are looking for. Take a look at this framework that implements it in javafx https://github.com/sialcasa/mvvmFX

I would recommend using a Framework such as mvvmFX. Using such a framework coupled with a DI framework like Guice (for which mvvmFX has native support) lends itself very well to a complex UI build out of multiple views, stiched together either by using fx:include or views loaded programatically with it's FluentViewLoader, with data shared via Scopes and Repository classes injected into the ViewModels. I would highly recommend not using stock JavaFX for anything complicated.

You can take a look at this: https://github.com/sialcasa/mvvmFX/tree/develop/examples