Best practices for developing a cross platform app that talks to SQL Server

Databases
1

New to Xojo and need some basic guidance.

I am developing a Raspberry Pi application for an industrial environment involving the reading of sensors, and downloaded the Xojo free version for now and it works like a champ! The GUI part of what I developed with Xojo makes this tool seem perfect.

Now I want to push the recorded data to SQL Server and it seems like from what I have read here, the included Plugins for Xojo OOB are SQL Server, MySQL, ODBC (great!), Oracle and PostgreSQL.

However, ALL of these would be for the Windows Desktop and/or Mac?

For the Raspberry Pi, would I/should I use the MonkeyBread software library? It looks like it has everything I need, a Linux version (which I am guessing is Pi compatible). I don’t know a thing about that layer and I looked into Microsoft .Net Core 5/6, which seems like it would do it, but that is just another layer/library that feels like it might not be necessary.

My question to the collective is: What are the best practices for developing an application that would run on the Raspberry Pi/Linux using Xojo in the Windows environment, and probably testing within the Windows environment?

After the Raspberry Pi project, I will be buying the Xojo “non free” version for other things, and potentially some iOS iPad type applications. Hoping for Android, but it seems like that is a lot further out.

Thanks in advance,

Brandon

2

They work for raspberry pi also depending on your license i guess.
You can ask about the license scheme’s by mailing to hello@xojo.com

Not everything requires a plugin, it could help but it’s not required 9/10 times.

There is a “Remote Debugger” you can install on your raspeberry pi and have it running, then you can add your raspeberry pi in the preferences of the xojo ide and use the menu Project–>Run On–>select your rasperrby pi.
https://documentation.xojo.com/getting_started/debugging/remote_debugging.html

3

Wow @DerkJ thanks for the fast response!

The Raspberry PI license is free, but I am going to buy the standard license for desktop and potential mobile future state, aka Android.

I am not wholly against the iOS platform, I just wanted to use more inexpensive tablets that run Android. Anything Apple is significantly more money.

Thanks again for your response and I will definitely put the remote debugger on the pi and give that a whirl!

I had created a samba share and was simply copying it over each time, etc, but that seems much quicker and more efficient.

Brandon

1 Like
4

Well, you need to pay apple to the privilege of developping something… Expensive devices that dont really have advantages for the industrial environment. I have used the Samsung Galaxy Tab for a log time.

1 Like