I’m an Apple Noobie and have been programming on a pc since the 80s. Mostly databases - Dbase, FoxPro, Access (VBA), Oracle PL/SQL.
I just purchased a MacBook Pro and want to create some apps for the iPhone (and potentially Android) market.
Since I’m used to databases, I’m starting with that and hoping to eventually learn SWIFT and perhaps Objective C
So much for that.
I’m thinking of writing my first app that saves quotes for different categories. At the user’s request, it copies it to a web area and updates the quotes on the iPhone with whatever someone else wanted to share.
I looked into Filemaker and XOJO.
Filemaker seems like a very rapid development with a somewhat limited ability to create one’s own procedures, etc. It also seems to limit users to using a Filemaker server and paying for access to such.
XOJO seems that it is more VBA like - define statements, VBA coding, connections, etc.
It also seems that I could run a web based server with a number of databases and not worry about number of user licenses (other than bandwidth).
Can XOJO connect to MS Access running on a web server (say godaddy) and utilize it inn real time? I’m familiar with MySQL a bit and if MS Access isn’t possible is that? Are the tools/drivers to do that built in? If not, are there a number of third part vendors?
I read that I could set up a local mySQL (or was it SQL lite) database and access it via XOJO code. Sounds simple enough. Is there a built in editor for code and something that would help visualize the table setups? Obviously doable with SQL statements, but I’m a little spoiled with MS Access GUI for database design/definition.
With XOJO - do I need any iOS drivers,SDK, etc or is that built in?
Is there a syntax checking editor that lets you place stops, watches, etc when you run the code, or are there third part tools that do that?
(Forgive me for this one) - Can anyone comment on the advantages/disadvantages of XOJO vs Filemaker?