Mobile database for Linux based device

  • Thread starter Thread starter Lonifasiko
  • Start date Start date
L

Lonifasiko

Although I know this group is related to Compact Framework from
Microsoft.NET, I wanted to ask an open-source related question:

I want to embedd in a Linux based micro-device (Gumstix) a little
database to store changes made locally in the micro. Then, my purpose
is to synchronize this local database with a remote database located
in a computer over the net.

Until today, I've only worked with Windows Mobile powered devices, and
consequently, I've built applications using Compact Framework and SQL
Mobile as mobile database. Then, I've tried both RDA and Merge
Replication.

Therefore, appart from SQL Mobile, what are the most suitable
databases for mobile devices running Linux-based OS? I've heard
something about SQLite database.
Moreover, which is the most suitable way to accomplish data
synchronization between these open-source mobile databases and rmeote
databases. Only web services is the choice?

I would really appreciate any help on this cause don't know any other
mobile database technology.

Thanks very much in advance.
 
Hi Chris,

Thanks very much for your reply.

You mean I would be able to run Windows CE 5.0 or 6.0 in Gumstix
hardware using DrumStix project's "glue software". Would be awesome!
And this would let me install Compact Framework 2.0, SQL Mobile and
all needed libraries and SW........ummmmmmm! Having these, could setup
replication really fast.
Do you know any success case in running Windows CE in GumStix
hardware? Moreover, any application performing replication over
Gumstix? I forgot to mention that my application also needs to
communicate with 2-3 sensors from a microcontroller. I understand
Windows CE would also fit this need....

What about Windows CE license? I would need one OS license per
microdevice and we plan to install the future application in many
devices? Maybe very expensive?

What about other databases you mention: Does MySQL has a mobile
version? Did not know about......
SQLite seems also a good choice but in both cases, it's a pity you
have to code from scratch all synchronization logic. That would take
me at least a month!

I'll do a little research and bring back results to the thread as soon
as possible.

Thanks very much again for pointing me in the right direction.
 
Yes, there are projects that use the Gumstix. I don't know what the chances
are that you'll find one that specifically uses replication, but it's CE and
you have the right database in it. There's nothing special about Gumstix
that would somehow prevent replication! You'd have to write some sort of a
"driver" for your extra I/O.

The license cost can be quoted by any of the Microsoft distributors listed
at www.microsoft.com/embedded. What you pay per-device depends on what
components you put into the device. You might guess something on the order
of $15, given that you're putting databases in there. Obviously, if you buy
10,000 licenses, you should be able to get some volume discount.

MySQL was the subject of a recent thread either here or in the
microsoft.public.windowsce.* group tree. A quick GoogleGroups search should
find the answer to that question there.

Paul T.
 
You mean I would be able to run Windows CE 5.0 or 6.0 in Gumstix
hardware using DrumStix project's "glue software". Would be awesome!
Click to expand...

It's not "glue software", it's a full up BSP for the hardware, likely based
on the PXA255 CE 5.0 BSP from Microsoft.
And this would let me install Compact Framework 2.0, SQL Mobile and
all needed libraries and SW........ummmmmmm! Having these, could setup
replication really fast.
Click to expand...

Yes, it would save you a *lot* of time and effort.
Do you know any success case in running Windows CE in GumStix
hardware?
Click to expand...

Not offhand, but Paul Yao at WE_DIG could probably point you in the right
direction. To be clear, I've not used this BSP, just aware of its
existence.
Moreover, any application performing replication over
Gumstix?
Click to expand...

That's irrelevent. Once it's running CE, Replication is Replication.
I forgot to mention that my application also needs to
communicate with 2-3 sensors from a microcontroller. I understand
Windows CE would also fit this need....
Click to expand...

If the hardware supports it, yes it's simple.
What about Windows CE license? I would need one OS license per
microdevice and we plan to install the future application in many
devices? Maybe very expensive?
Click to expand...

Depends on your volume and what components the image has in it. Probably in
the $3-12 per device range though.
What about other databases you mention: Does MySQL has a mobile
version? Did not know about......
Click to expand...

They list it as supported on their site. Not used it, just aware that it's
available.
SQLite seems also a good choice but in both cases, it's a pity you
have to code from scratch all synchronization logic. That would take
me at least a month!
Click to expand...

At least.


--
Chris Tacke - Embedded MVP
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--
 
Back
Top