The mORMot on Android

AOG · 2020-04-27 18:58:40

For anybody interested in running the mORMot on your Android phone.

https://github.com/LongDirtyAnimAlf/fpc … -debug.apk

This is TestSQL3 designed to run on Android through OpenGLES.
Its for armv7, so should run on any phone.
Enjoy. Feedback welcome as ever.

ab · 2020-04-27 19:56:14

It worked great on my cheap (50€) phone!

Only issue is that some tests failed...
Did all tests pass on yours?

AOG · 2020-04-27 20:16:27

On my phone, I have 76 failures. Of which 74 similar from one test.

Last edited by AOG (2020-04-27 20:16:48)

AOG · 2020-04-28 06:50:42

Solved the remaining issues.
New uploaded (see link) apk now gives all greens on my phone.

Edit:
This apk was created with FPC (and Lazarus). Not a single line of java was needed. Its a pure native Android app, written in Pascal.

Last edited by AOG (2020-04-28 06:53:02)

AOG · 2020-04-28 09:25:10

Uploaded universal apk. It has armv7 and arm64. This is needed for the app-store.

https://github.com/LongDirtyAnimAlf/fpc … -debug.apk

EMartin · 2020-04-28 11:14:54

all tests passed !!! Congratulations AOG !!!

Can you suggest me tutorials for Android development with Lazarus/FPC ? I know that there is someones in the net, but I don't know the more reliable.

Thanks.

camu72 · 2020-04-28 13:09:25

Very Cool!!! All test passed ... and like Esteban, I would also appreciate a reference to a tutorial ... Congratulations AOG!

urhen · 2020-04-28 14:38:37

iOS also fully functional?

AOG · 2020-04-28 18:26:51

I am a bit busy the next couple of days. But I will publish all.
In general, the LAMW framework can be used to make Android apps based on Java.
The Castle Game Engine can be used for iOS apps.
For this test however, I have used the Asphyre PXL framework.
Will update on its use.

Last edited by AOG (2020-04-28 18:28:25)

AOG · 2020-05-03 07:33:43

Sources are uploaded. They contain a special version of the mORMot.

https://github.com/LongDirtyAnimAlf/AsphyrePXL

Tha latest (pre-) release of fpcupdeluxe can install these sources AND perform some magic to set all path correct.

https://github.com/LongDirtyAnimAlf/fpc … tag/1.6.8o

Edit:
The module name to install/use is "mORMotPXL".

Last edited by AOG (2020-05-03 07:51:49)

EMartin · 2020-05-03 15:21:53

Thank you @AOG !!! I'll investigate. One question: is needed asphyre for non graphical apps ?

AOG · 2020-05-03 16:33:19

This is a pure Pascal native Android app. No Java, so no easy views. That is why I used Asphyre and GLES.
With normal Java, you can create views and more easily.
But for testing, this was the most easy way to do.
For all the rest, I would advice LAMW.

EMartin · 2020-05-03 16:50:30

Ok, thank you very much.

emk · 2020-05-03 19:00:42

AOG wrote:

This is a pure Pascal native Android app.

Can I use sqlite-db-acces from mORMot as Android-library(.so, .a) or iOS .dylib linked to FMX project?
For example a subset of main database will be downloaded from server to local device to speed up things, so the most used tabled are in place and acts as a cache.
I can use the same code(partially) on the main server and also on the local device - FMX (views) and shared library (data access and logic).

ab · 2020-05-04 06:38:35

FMX is supported only for the client side (SynCrossPlatform* units), not the server/data side (SynCommons/mORMot/SynSQLite3).
So a FMX project won't be able to use the mORMot SQlite3 features.

Whereas with FPC, it will work, as the Alfred sample shows.

emk · 2020-05-04 12:26:53

ab wrote:

FMX is supported only for the client side (SynCrossPlatform* units), not the server/data side (SynCommons/mORMot/SynSQLite3).
So a FMX project won't be able to use the mORMot SQlite3 features.
Whereas with FPC, it will work, as the Alfred sample shows.

That's what I wanted to say: mORMot+FPC packed in shared library. This library can be used by a FMX project.

Last edited by emk (2020-05-04 12:27:46)

ab · 2020-05-04 13:10:24

@emk
Ah! Make sense now!

I guess we may more easily add Delphi new targets in mORMot2.
In plain mORMot, it could be difficult to add Delphi iOS, Android or Linux support.
But in mORMot2, all Operating System calls are defined in a single unit named https://github.com/synopse/mORMot2/blob … ore.os.pas
So we may be able to add Delphi multi-target support easier.

AOG · 2020-05-04 13:43:20

Hi Ab,
I was looking at the mORMot2 code you posted above.
Regarding mORMot and testing on different platform, I would like to ask you a favor.

To get TestSQL3 running on Android, I needed to catch the output to console (STD).
Normally, Android has no (visible) console.
In mORMot1, TestSQL3, you use a text to write towards console.
I would like to ask you to make this a variable (global or setable) text to be able to catch it. Can be a file, can be a stringlist-redirect like I have used for the Android sample. That way, mORMot2 can put its TestSQL3 output (or other console output) in any text, being std by default.
Thanks, Alfred.

ab · 2020-05-04 15:34:54

@Alfred

I have added such a callback to mORMot2.

AOG · 2020-05-04 16:12:20

That is good ! Thank you !!

emk · 2020-05-04 17:03:01

ab wrote:

Ah! Make sense now!

mORMot+FPC can act as fast "local server" ("so" library or "dylib") on mobile device. The first use case I wait to test sqlite-access+custom-AES-encryption.
Exchange of data between FMX-project and "local server" can be made as JSON. Practically you can have on your mobile a replica(subset or integrally) of the main database from cloud-server but sharing the same code (AES, pascal stored procedures, etc)

ab wrote:

I guess we may more easily add Delphi new targets in mORMot2.

Perfect! Because I see a real push from ARM servers.

Last edited by emk (2020-05-04 17:05:17)

AOG · 2020-05-04 17:26:40

@emk.
This issue has been discussed more often on this list: the need for offline (but encrypted) functionality on mobile.
I would be very interested in an automagical (user transparent) scheme to have offline changes uploaded to online and an auto-switch-over from off- to on- to off- with updates and encrypted local storage.

itSDS · 2020-05-13 10:52:50

Interesting work.

i would like to test it on RS 10.4 do you think it will work ?

Last edited by itSDS (2020-05-13 10:54:44)

AOG · 2020-05-13 11:29:32

https://www.google.com/search?q=RS+10.4

What is RS 10.4 ... |-) ... ?

ab · 2020-05-13 12:14:07

RS 10.4 = Rad Studio 10.4 = upcoming Delphi 10.4.

And to answer the question.
It won't work with Delphi Android. Only FPC Android is supported for server side.
But you can generate client code for Delphi Android, even in older revisions.

mORMot Open Source

#1 2020-04-27 18:58:40

The mORMot on Android

#2 2020-04-27 19:56:14

Re: The mORMot on Android

#3 2020-04-27 20:16:27

Re: The mORMot on Android

#4 2020-04-28 06:50:42

Re: The mORMot on Android

#5 2020-04-28 09:25:10

Re: The mORMot on Android

#6 2020-04-28 11:14:54

Re: The mORMot on Android

#7 2020-04-28 13:09:25

Re: The mORMot on Android

#8 2020-04-28 14:38:37

Re: The mORMot on Android

#9 2020-04-28 18:26:51

Re: The mORMot on Android

#10 2020-05-03 07:33:43

Re: The mORMot on Android

#11 2020-05-03 15:21:53

Re: The mORMot on Android

#12 2020-05-03 16:33:19

Re: The mORMot on Android

#13 2020-05-03 16:50:30

Re: The mORMot on Android

#14 2020-05-03 19:00:42

Re: The mORMot on Android

#15 2020-05-04 06:38:35

Re: The mORMot on Android

#16 2020-05-04 12:26:53

Re: The mORMot on Android

#17 2020-05-04 13:10:24

Re: The mORMot on Android

#18 2020-05-04 13:43:20

Re: The mORMot on Android

#19 2020-05-04 15:34:54

Re: The mORMot on Android

#20 2020-05-04 16:12:20

Re: The mORMot on Android

#21 2020-05-04 17:03:01

Re: The mORMot on Android

#22 2020-05-04 17:26:40

Re: The mORMot on Android

#23 2020-05-13 10:52:50

Re: The mORMot on Android

#24 2020-05-13 11:29:32

Re: The mORMot on Android

#25 2020-05-13 12:14:07

Re: The mORMot on Android

Board footer