I am new to Swift and very rusty at coding. I have been trying to research the answer to this on the internet for nearly a week and found so many different answers and options. My brain has reached and passed overload.

I have an SQLite3 database on a remote server (Ubuntu 23), in a Samba shared directory. The server has a Fixed IP (known to me) and I have a domain name that points to it. I want to share the data across all my Apple devices. (I do not want this data available publically, it is just for me.)

How do I access it from Swift?

I have tried to use SwiftData and CloudKit, which meant I could do away with storing the data on a remote server. But this got so complicated and I could not get it to work. It went so far beyond my ability to understand, and every tutorial I looked at told me something different. (I do have my AppleID registered with a free Apple Developer account)

I gave up on this and I have also tried to use FileManager to remotely access a SQLite database on my Ubuntu Server, with Samba. But I found that FileManger had so very many options and configurations that I got just as confused.

Is there some kind and knowledgeable person that can tell me how to share my data across my devices?