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: 14016
Joined: Sat Apr 08, 2006 8:41 am
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: 14016
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Which database

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

Sorry, no idea...

stam
Posts: 3003
Joined: Sun Jun 04, 2006 9:39 pm

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: 9964
Joined: Sat Apr 08, 2006 7:05 am
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 :)

markwilliams21
Posts: 1
Joined: Fri Jul 19, 2024 9:56 am

Post by markwilliams21 » Fri Jul 19, 2024 10:06 am

Hi there,

Choosing the right database for your LiveCode project depends on several factors, including your specific requirements, the scale of your application, and your familiarity with different database systems. Here are some options you might consider:

SQLite:

Pros: Lightweight, easy to set up, and ideal for single-user applications or small projects.
Cons: Not designed for high-concurrency or large-scale applications.
Integration: LiveCode has built-in support for SQLite, making it easy to use.
MySQL/MariaDB:

Pros: Robust, widely used, and suitable for larger applications with multiple users.
Cons: Requires more setup and maintenance compared to SQLite.
Integration: You can use LiveCode’s revDB library to connect to MySQL/MariaDB databases.
PostgreSQL:

Pros: Highly extensible, supports complex queries, and has strong community support.
Cons: Can be more complex to set up and manage.
Integration: LiveCode also supports PostgreSQL through the revDB library.
Salesforce:

Pros: Powerful CRM features, cloud-based, and excellent for applications that require advanced customer relationship management.
Cons: Typically used for specific use cases and can be more expensive.
Integration: You can interact with salesforce database using LiveCode’s HTTP commands and the Salesforce REST API.
Others:

If you need NoSQL databases like MongoDB or need to interact with other types of data stores, LiveCode can connect to these using APIs and custom scripts.
Recommendation:

For simple, local storage needs, SQLite is often sufficient and very easy to use with LiveCode.
For more complex, multi-user applications, MySQL or PostgreSQL are better choices.
If your project heavily relies on CRM functionalities, consider integrating with Salesforce.
Ultimately, the best database for your project will depend on your specific needs and constraints. Feel free to provide more details about your project requirements if you need a more tailored recommendation.

I hope this helps! Let me know if you have any other questions or need further assistance.

Klaus
Posts: 14016
Joined: Sat Apr 08, 2006 8:41 am
Contact:

Re: Which database

Post by Klaus » Fri Jul 19, 2024 3:33 pm

Dear AI,

thank you very much for this elaborate explanation! :D


Best

Klaus

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7335
Joined: Sat Apr 08, 2006 8:31 pm
Contact:

Re: Which database

Post by jacque » Sat Jul 20, 2024 5:37 pm

I'm waiting for one AI post to answer another. Kind of like that time someone engaged Siri to talk to Google Assistant.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com

SparkOut
Posts: 2903
Joined: Sun Sep 23, 2007 4:58 pm

Re: Which database

Post by SparkOut » Sat Jul 20, 2024 8:13 pm

I may be imagining but I think that's already happened here sometime, but then I don't have a reliable memory.

Post Reply

Return to “Databases”