Which database

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Oliver901
Posts: 9
Joined: Tue May 14, 2024 7:49 pm

Which database

Post by Oliver901 » Sat May 18, 2024 6:19 pm

Which database works best with LiveCode?

Klaus
Posts: 13893
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Which database

Post by Klaus » Sat May 18, 2024 6:58 pm

LC comes with a build-in SQLite engine, so this might be the best option for a single user DB.
However LC supports MySQL, postgreSQL and many other database engines.

Oliver901
Posts: 9
Joined: Tue May 14, 2024 7:49 pm

Re: Which database

Post by Oliver901 » Sat May 18, 2024 7:41 pm

Klaus wrote:
Sat May 18, 2024 6:58 pm
LC comes with a build-in SQLite engine, so this might be the best option for a single user DB.
However LC supports MySQL, postgreSQL and many other database engines.
Non-SQL database are suitable?

Klaus
Posts: 13893
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Which database

Post by Klaus » Sat May 18, 2024 8:04 pm

Sorry, no idea...

stam
Posts: 2845
Joined: Sun Jun 04, 2006 9:39 pm
Location: London, UK

Re: Which database

Post by stam » Sun May 19, 2024 2:14 pm

Oliver901 wrote:
Sat May 18, 2024 7:41 pm
Non-SQL database are suitable?
Hi Oliver,
LiveCode has drivers for SQLite, MySQL, PostgreSQL and ODBC. I think it's possible to use MariaDB as well and Valentina provides drivers if you want to see Valentina server instead...

noSQL databases are by-and-large online entities and you would usually communicate with them via REST APIs, which is eminently feasible in LC...

a liveCode specific noSQL database you can use right away is LiveCloud (https://livecloud.io - there is a free tier you can use) - but any database that provides a REST API is fully usable.

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 9917
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Which database

Post by FourthWorld » Sun May 19, 2024 5:14 pm

Oliver901 wrote:
Sat May 18, 2024 7:41 pm
Klaus wrote:
Sat May 18, 2024 6:58 pm
LC comes with a build-in SQLite engine, so this might be the best option for a single user DB.
However LC supports MySQL, postgreSQL and many other database engines.
Non-SQL database are suitable?
There is a CouchDB library available in these forums.
viewtopic.php?f=12&t=24925

And just about anything with a REST API can be used.

The question is better approached by determining the type of database that best fits your application needs, and then determining how to use it from LC.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

Oliver901
Posts: 9
Joined: Tue May 14, 2024 7:49 pm

Re: Which database

Post by Oliver901 » Sun May 19, 2024 9:38 pm

Thank you all for the help :)

Post Reply

Return to “Databases”