Recent

Author Topic: Developing a database app for Android  (Read 5923 times)

bruce.button

  • New Member
  • *
  • Posts: 33
Developing a database app for Android
« on: September 20, 2016, 04:32:21 pm »
I would love to know whether it is practical at this stage to use Lazarus to develop a database app for Andoid (with sqlite).

If so, could someone point me to some tutorials/other info which will help me to get started.

Thanks in advance!
Bruce

Handoko

  • Hero Member
  • *****
  • Posts: 4155
  • My goal: build my own game engine using Lazarus
Re: Developing a database app for Android
« Reply #1 on: September 20, 2016, 05:15:45 pm »
I personally think Lazarus for Android development now is not ready for production use. If you're thinking to develop your commercial database app for Android, you may try other commercial tools first. But if it is for hobby or non-paid projects, you really should give Lazarus a try.

There are several options to build Android apps using Lazarus. Each of them has their own advantages/disadvantages. But all of them still has some bugs and not very suitable for serious projects. If you don't mind those minor issues, well I think you now can pick one or try all of them and start learning now. They're improving and when you already understand how to use it to build the app you want, it maybe ready too for production use.

In this post I listed all the options I know for building Android app using Lazarus:
http://forum.lazarus.freepascal.org/index.php/topic,33487.msg217112.html#msg217112

After several tests, I choose LAMW, which I think is suitable to me. I just checked the component listed in the component tabs, yes it has jSqliteDataAccess and jSqliteCursor.

bruce.button

  • New Member
  • *
  • Posts: 33
Re: Developing a database app for Android
« Reply #2 on: September 20, 2016, 07:33:34 pm »
Thank you, Handoko, for those helpful pointers. I will look into LAMW.

DonAlfredo

  • Hero Member
  • *****
  • Posts: 1438
Re: Developing a database app for Android
« Reply #3 on: September 21, 2016, 06:30:48 am »
LAMW +1 !
LAMW and mORMot +2 !!

The mORMot makes flexible database apps on Android very easy !
And, by changing one line of code, can be changed from local SQLite3 into remote REST.

And this remark is based on real experience (real Android apps), not by features (docs) !

hnb

  • Sr. Member
  • ****
  • Posts: 270
Re: Developing a database app for Android
« Reply #4 on: September 21, 2016, 08:31:17 am »
The mORMot makes flexible database apps on Android very easy !

I can confirm that. Lazarus/FPC + mORMot works amazing on Android platform for production.
Checkout NewPascal initiative and donate beer - ready to use tuned FPC compiler + Lazarus for mORMot project

best regards,
Maciej Izak

avra

  • Hero Member
  • *****
  • Posts: 2142
    • Additional info
Re: Developing a database app for Android
« Reply #5 on: September 21, 2016, 08:41:03 am »
You can also take a look into these JVM based db examples:
https://github.com/zeljkoc/pandroid/tree/master/example
ct2laz - Conversion between Lazarus and CodeTyphon
bithelpers - Bit manipulation for standard types
pasettimino - Siemens S7 PLC lib

Thaddy

  • Hero Member
  • *****
  • Posts: 10728
Re: Developing a database app for Android
« Reply #6 on: September 21, 2016, 09:03:35 am »
LAMW +1 !
LAMW and mORMot +2 !!

The mORMot makes flexible database apps on Android very easy !
And, by changing one line of code, can be changed from local SQLite3 into remote REST.

And this remark is based on real experience (real Android apps), not by features (docs) !
Excuse me for writing in Dutch, but
"Wij van WC eend adviseren WC eend."

Both are a bit right, but this is not an advertising platform.

bruce.button

  • New Member
  • *
  • Posts: 33
Re: Developing a database app for Android
« Reply #7 on: September 21, 2016, 12:12:08 pm »
Thanks again for the suggestions. mORMot looks good, but a bit of a learning curve (for me, at least). Are there any simple tutorials for developing Android apps using mORMot?

mangakissa

  • Hero Member
  • *****
  • Posts: 1113
Re: Developing a database app for Android
« Reply #8 on: September 22, 2016, 09:23:45 am »
Maybe a very good tutorial with good examples of mormot will help a lot of other people for using it. There is a great documentation., but not really tells from the beginning how it works.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

DonAlfredo

  • Hero Member
  • *****
  • Posts: 1438
Re: Developing a database app for Android
« Reply #9 on: September 22, 2016, 11:28:03 am »
There is a LAMW mORMOt sample to start with !

https://github.com/jmpessoa/lazandroidmodulewizard/tree/master/demos/Eclipse/AppmORMotDemo1

It mimics sample 1 of the mORMot demos.

But learning the mORMot is best to be done by just trying the provided samples on Windows or Linux.
The forum and author are also very helpfull and responsive.

bruce.button

  • New Member
  • *
  • Posts: 33
Re: Developing a database app for Android
« Reply #10 on: September 22, 2016, 12:45:24 pm »
Thank you. I'll have a look at that.

 

TinyPortal © 2005-2018