Lazarus

Programming => Databases => Topic started by: bruce.button on September 20, 2016, 04:32:21 pm

Title: Developing a database app for Android
Post by: bruce.button 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
Title: Re: Developing a database app for Android
Post by: Handoko 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.
Title: Re: Developing a database app for Android
Post by: bruce.button on September 20, 2016, 07:33:34 pm
Thank you, Handoko, for those helpful pointers. I will look into LAMW.
Title: Re: Developing a database app for Android
Post by: DonAlfredo 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) !
Title: Re: Developing a database app for Android
Post by: hnb 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.
Title: Re: Developing a database app for Android
Post by: avra 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
Title: Re: Developing a database app for Android
Post by: Thaddy 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.
Title: Re: Developing a database app for Android
Post by: bruce.button 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?
Title: Re: Developing a database app for Android
Post by: mangakissa 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.
Title: Re: Developing a database app for Android
Post by: DonAlfredo 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.
Title: Re: Developing a database app for Android
Post by: bruce.button on September 22, 2016, 12:45:24 pm
Thank you. I'll have a look at that.
TinyPortal © 2005-2018