@Scott D Anyone know where I can go to learn how to develop for Xojo specifically to integrate into a db? And some guidance on what db I should be using?
My suggestion would be to start playing with Xojo and get used to the language to see if you like it. I love the language... I use MySQL but others like Postgres and other flavors of SQL.
Then think about how you want to deploy your Xojo app. As of today, you could create a Desktop app and a separate iOS app. Or you could create a Web app that would work almost everywhere. That's all possible today.
That said, I'm waiting for Xojo Web 2.0 to become available. Based on the sessions at XDC 2018 and XDC 2019 I hope it'll be a fantastic replacement for FileMaker. The Xojo Road Map, https://docs.xojo.com/Roadmap , states that Xojo Web 2.0 is high on the list but ''Easy Database Connectivity" is very low on the list which would help folks coming from FileMaker. Writing all the SQL code is a big change for most FM devs, but it's manageable.
You should know you can run Xojo Web apps on Mac, Windows, and Linux. I prefer Linux in order to run on Amazon Lightsail servers which a very low cost and rock-solid and they've added MySQL to the Lightsai admin page recently.
Thing is we don't know when Xojo Web 2.0 or Easy Database Connectivity will be available. While I wait, I'm working in PHP to have a backup plan.