Total Newbie: SQLite on a remote server?

Databases
1

Hello all;

I am new to Xojo, but I used RealBasic 5.5 back-in-the-day. I want to get back into making programs, and now I want to dabble with databases.

I know without a license, all I can use is SQLite “flat file” type databases. Is it possible to store the .sqlite database file on a webserver or FTP server somewhere, and write a program that utilizes the database over the web?

Or, can you only locally access the database from the machine it’s on?

I am trying to scope out the limitations of SQLite.

Thank you.

2

I would recommend cubeSQL or Studio Stable Database.

3

Thanks. It looks like Studio Stable is discontinued. cubeSQL looks interesting, but requires some $$$ for unlimited concurrent connections.

I will investigate these options. If anyone else knows of servers for SQLite let me know here.

Thanks.

4

The problem with having the SQLite file on a remote server is file locking to prevent data corruption or even corruption of the database itself. To get around this, you have to have an application on said remote server open/update/modify/close the SQLite file. The two database’s @Phillip Zedalis mentioned are two good examples of this. Third option is for you to write one yourself.

Now if you dont want to go with CubeSQL or SSD or write you own, go with something like PostgreSQL which is free (for commercial and non commercial usage). But it isnt SQLite.

5

SQLite doesn’t have a database server as such – it’s built into your program. The data are held in a database file which, like any other file, you can put on a server system if you wish and if your server allows your program access to it. If you want to experiment with a “real” server, you can install MariaDb, MySQL or PostgreSQL on your server and write a program for access to the data therein. As Scott mentioned, SQLite is single-user – other uses have no access to the database file while somebody else is using it.

6

Great replies everyone!!

A couple of you mentioned PostgreSQL… I was under the impression any database program other than SQLite required a $299 add on to compile… is this true for PostgreSQL?

Also, good ideas from all the posts in this thread.

Honestly, I am such a newbie I probably can’t write my own SQLite server program like someone here mentioned.

7

I would have recommend both / either except that it looks like Brads decided to pull the plug on things & just abandon his user base. Thats too bad for them.

CubeSQL it is then.

Yes.
I always forget that not everyone buys everything all the time like I do/did.