Can LiveCode be used to program Android apps with large databases?

[Andi124]

Hello,
I'm new here and discovered LiveCode by chance, looking for an easy way to create my own apps for my Android smartphone. I would like to program a vocabulary app according to my ideas, and the question of whether LiveCode can be used to create Android apps with large databases is very important to me. Is it possible to use SQLite databases in Android apps? Or what options does LiveCode offer in terms of databases?

[stam]

Hi Andi124, SQLite support is built-in in and works very well. LC also works well with MySQL, and other DBMS’s, as well as ODBC, although with the latter drivers may sometimes be an issue.

I know others have used this with NoSQL databases (anything accessible via REST interfaces should be fine). There is also an LC specific multiuser or single user DB called liveCloud (not affiliated with livecode).

Personally I’ve used SQLite and LiveCloud a lot and these work extremely well. I’ve used MySQL as a test and this seems to work well too, but haven’t deployed any apps with this.

hope this helps
Stam

[Andi124]

Hi Stam, thanks for the answer.
I was a bit confused because the "Resource Center" says that SQLite is a database for "Windows Desktop Applications". My question is whether this can also be used for creating Android apps in the same way.

Andreas

[stam]

I haven’t specifically written apps for Android by checking the dictionary (online API here: https://livecode.com/resources/api/)

According to entries like revExecuteSQL, these are auppoted on all platforms (mac, windows, linux, ios, android) so I would take that as given that Android is supported…

Stam

[Klaus]

Hi Andreas,

Hi Stam, thanks for the answer.
I was a bit confused because the "Resource Center" says that SQLite is a database for "Windows Desktop Applications". My question is whether this can also be used for creating Android apps in the same way.
Andreas

no idea where you have this screenshot from, but that one is many, many years old, the Livecode icon
has changes many time since then. What version of LC are you using currently?

And yes, today SQLite can be used on all platforms supported by LC.

Best

Klaus

[Andi124]

Hello Klaus,
the screenshot is from the Resource Center - SQLite - Launch Stack
I have a trial-version so far.

[Klaus]

Cannot find the "Resource Center" in my installation!?

Whatever, that info is outdated, SQLite runs on all platforms.

[Andi124]

I found it here.

[Klaus]

AHA, thanks!
After working with LC and its ancestors for over 30 years no, i never displayed the "Toolbar" at all.

[stam]

I found it here.

The better place to look is the Dictionary, which is basically LiveCode’s API documentation.

Look up “Database library” to see available functions and handlers. Each of these will state what platforms they’re valid for (pretty much all platforms I think).

The other good resource to look at is the User Guide (a PDF accessible under the “Help” menu). This is more verbose but covers fewer topics. It’s a bit older now but the content still holds.

Finally search the forums. There is an enourmouss wealth of info buried in these forums. The forum’s search function doesn’t work great however so I almost always just google a question prefixed with liveCode (eg “liveCode SQLite Android”) and more often than not this will link to something here…

Often it will also link to “lessons” provided by LiveCode, that’s especially a good starting point for new users.

For example, this may be what you’re looking for as it also shows deployment to Android and iOS:
https://lessons.livecode.com/m/4069/l/5 ... e-database

Stam

[Andi124]

Hello Stam,
thank you very much for this advice and information.
This is what I was looking for.
The content under the link looks very promising.

[Klaus]

Hi Andreas,

you will also need a basic knowledge of SQL or at least to know where to look for help/info!
I always visit these pages: https://www.w3schools.com/sql/default.asp

Best from germany

Klaus

[stam]

Hello Stam,
thank you very much for this advice and information.
This is what I was looking for.
The content under the link looks very promising.

You're welcome!

LiveCode is no different from any other programming language in this respect: Google is your friend
I google code all the time for a few different languages - and most coders do. I have my own little repository of code and tidbits on my laptop, but by and large Google is my friend too

To put it differently: it would be very rare indeed if you had a question that several others hadn't already had and discussed online before! (regardless of language, same goes for SQLite - it's really about knowing what it is you want to ask mind you, not always clear that one...)

But don't hesitate to ask on the forums if you get stuck, it's a friendly bunch here...!

S.