Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: What databases I can use with Firemonkey on mobile applications ?



Permlink Replies: 18 - Last Post: Mar 8, 2018 6:37 AM Last Post By: Jan Kučera
John Birch

Posts: 135
Registered: 8/23/02
What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 10, 2018 8:17 PM
This message is no longer available.
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 10, 2018 9:39 PM   in response to: John Birch in response to: John Birch
On 2/10/2018 11:17 PM, John Birch wrote:
What databases I can use with Firemonkey on mobile applications ?

I know about SQLlit and interbase togo but what else ?

I think you mean FireDAC not FireMonkey. FireMonkey is not a data access library.

Here is the wiki page that shows each driver and what platforms that driver
supports. Bot iOS and Android require that a native statically linkable driver
be available from the DB vendor for FireDAC to support it so if you don't' see
it supported it is probably because the vendor does not have a client for that
platform.

http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Databases_(FireDAC)

Also not that you can get around the limits of the native drivers if you want to
put a Datasnap server in between the app and the DB.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John Birch

Posts: 135
Registered: 8/23/02
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 10, 2018 9:44 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thanks Jeff I wanted to see the databases I can use on mobile apps that has native client.
Eitan Arbel

Posts: 508
Registered: 2/24/13
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 1:18 AM   in response to: John Birch in response to: John Birch
for local info storage, embarcadero says that IBLite and SQLite should work well.
but from what i tried, SQLite didn't work, and i didn't want to use IBLite, so for me none of them was an option.
i ended up using an ini file instead...

Edited by: Eitan Arbel on Feb 11, 2018 11:18 AM
Dave Nottage

Posts: 1,850
Registered: 1/7/00
Re: What databases I can use with Firemonkey on mobile applications ? [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 2:58 AM   in response to: Eitan Arbel in response to: Eitan Arbel
Eitan Arbel wrote:

but from what i tried, SQLite didn't work

What do you mean by "didn't work"?

--
Dave Nottage [MVP, TeamB]
Find hints, tips and tricks at Delphi Worlds blog: http://www.delphiworlds.com
Eitan Arbel

Posts: 508
Registered: 2/24/13
Re: What databases I can use with Firemonkey on mobile applications ? [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 12, 2018 1:26 PM   in response to: Dave Nottage in response to: Dave Nottage
Hi Dave

What do you mean by "didn't work"?

by "didn't work" i mean that what ever i tried - it "refused" to connect.

i'm a heavy Delphi and database user (from Paradox, to MSAcc, MySQL, MSSQL, IB and FB) and with many years of experience with Delphi and DB, so i don't think i'm a noob that doesn't know how to connect.
it just "didn't work"
so since i just need a single-record "DB" of local data, i gave up on SQLite and did everything i need with an encrypted ini file (and encryption is yet another thing SQLite can't give us)

btw, i love your blog (delphiworlds.com) :)
Dave Nottage

Posts: 1,850
Registered: 1/7/00
Re: What databases I can use with Firemonkey on mobile applications ? [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 13, 2018 12:08 AM   in response to: Eitan Arbel in response to: Eitan Arbel
Eitan Arbel wrote:

by "didn't work" i mean that what ever i tried - it "refused" to connect.

That's odd, because it works every time for me.

btw, i love your blog (delphiworlds.com) :)

Thanks! :-)

--
Dave Nottage [MVP, TeamB]
Find hints, tips and tricks at Delphi Worlds blog: http://www.delphiworlds.com
Ken Randall

Posts: 130
Registered: 11/12/99
Re: What databases I can use with Firemonkey on mobile applications ? [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 13, 2018 5:35 AM   in response to: Dave Nottage in response to: Dave Nottage
Dave Nottage wrote:

That's odd, because it works every time for me.

And for me too. I have several published apps on all platforms using it
with no problem at all, ever!
Ken Randall

Posts: 130
Registered: 11/12/99
Re: What databases I can use with Firemonkey on mobile applications ? [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 7:43 AM   in response to: Eitan Arbel in response to: Eitan Arbel
Eitan Arbel wrote:

for local info storage, embarcadero says that IBLite and SQLite
should work well. but from what i tried, SQLite didn't work, and i
didn't want to use IBLite, so for me none of them was an option. i
ended up using an ini file instead...

SQLite works fine!
John Birch

Posts: 135
Registered: 8/23/02
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 9:31 AM   in response to: John Birch in response to: John Birch
Where I can download IBLite ? is it free ? I tried to google it but could not find it
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 8:07 PM   in response to: John Birch in response to: John Birch
On 2/11/2018 12:31 PM, John Birch wrote:
Where I can download IBLite ? is it free ? I tried to google it but could not find it

IBLite is free. It has limitations, but they should be fine for a mobile app (2
active transactions max for instance, 1 cpu etc).

A good comparison chart is at
http://docwiki.embarcadero.com/InterBase/XE7/en/Comparing_IBLite,_ToGo,_and_InterBase_Server_Edition

Info on how to get the IBLite license

http://docwiki.embarcadero.com/RADStudio/Tokyo/en/IBLite_and_IBToGo_Test_Deployment_Licensing

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

John Birch

Posts: 135
Registered: 8/23/02
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 8:12 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
@Jeff Overcash

Thanks alot my friend I think it is better than SQLite.
Mike Margerum

Posts: 590
Registered: 12/1/99
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 11, 2018 9:05 PM   in response to: John Birch in response to: John Birch
On 2/11/18 11:12 PM, John Birch wrote:
@Jeff Overcash

Thanks alot my friend I think it is better than SQLite.
cant beat free and besides sqlite is awesome. I recommend you take a
look at it as it's very capable.
John Birch

Posts: 135
Registered: 8/23/02
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 12, 2018 10:49 AM   in response to: Mike Margerum in response to: Mike Margerum
ok thanks Mike
Mike Margerum

Posts: 590
Registered: 12/1/99
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 15, 2018 5:42 AM   in response to: John Birch in response to: John Birch
On 2/12/18 1:49 PM, John Birch wrote:
ok thanks Mike
One feature i love is the virtual tables and full text search. Using it
in an ios app with a 75 MB sqlite db and its blazingly fast.
Richard Stevens

Posts: 52
Registered: 5/1/00
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 16, 2018 8:21 AM   in response to: Mike Margerum in response to: Mike Margerum
One feature i love is the virtual tables and full text search. Using it
in an ios app with a 75 MB sqlite db and its blazingly fast.

Would love to hear a bit more about your app Mike. Do you get data from a remote database and store it locally in SQLite? Or is it a completely self-contained app?

If the former, what process do you use to transfer the data back and forth?

Thanks
Richard
Mike Margerum

Posts: 590
Registered: 12/1/99
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 19, 2018 1:14 PM   in response to: Richard Stevens in response to: Richard Stevens
On 2/16/18 11:21 AM, Richard Stevens wrote:
One feature i love is the virtual tables and full text search. Using it
in an ios app with a 75 MB sqlite db and its blazingly fast.

Would love to hear a bit more about your app Mike. Do you get data from a remote database and store it locally in SQLite? Or is it a completely self-contained app?

If the former, what process do you use to transfer the data back and forth?

Thanks
Richard
The SQLITE dbs get produced by a back end process and are downloaded via
HTTPS + gzip. we do have incremental update support with SQL
statements, but we really haven't had to use it. The mobile speeds are
so fast now. We update these databases weekly. They are read only for
us. We store the writable stuff in core data although, in retrospect, i
may have used SQLITE for that as well.

New records are sent up via XML / HTTPS posts.

This is not a traditional CRUD app though.
Michael Leahy

Posts: 239
Registered: 5/9/07
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 2, 2018 8:38 AM   in response to: Mike Margerum in response to: Mike Margerum
Add me to the list of folks who are quite happy with FireDAC and SQLite on mobile. Each table has about 10,000 chess positions with text.
Jan Kučera

Posts: 13
Registered: 10/27/14
Re: What databases I can use with Firemonkey on mobile applications ?
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 8, 2018 6:37 AM   in response to: John Birch in response to: John Birch
i used SQLITE for local data
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02