Lazarus

Installation => General => Topic started by: DataCool on November 04, 2012, 06:37:24 pm

Title: WinCE (5.0) Application with MySQL / Firebird Access
Post by: DataCool on November 04, 2012, 06:37:24 pm
Hello everybody,

at the moment i'm going to develop an application für this device:
ULTRAX s. http://www.axess-wego.de/index.php?o...246&Itemid=711
This device has an ARM CPU !!!

My application shoud record diffent industry data, but also display further informations to some tasks.

So main goal is local data recording(local cache for security)and data transfer/sync to a server.
Also that must be a solution to display LIVE informations from a server DB.
MySQL 5.5 is actually planned, if i couldn't convince the other involved people for Firebird 2.5

My first thought was/is Lazarus.
I wanted to use the components from the register "sqlDB" in two ways :
1. Store the data in a local sqlite DB
2. Transfer/Receive data to/from the server DB

Unfortunately, I find out, correct me if i'm wrong, that's impossible to connect to a MySQL server from a WinCE/Arm device,
because there is no compiled version of the "libmysql.dll" for WinCE/ARM.
Or did i missed something ?

For Firebird should be a compiled version the client DLL, but i didn't found it yet.
http://www.lazarus.freepascal.org/in...,11364.15.html


Or should i switch to a solution without database access, storing recorded data in Textfiles
and realize data exchange/request via REST to an own written server ?

Any other solutions are also welcome, many thanks in advance,

Greetz Data
Title: Re: WinCE (5.0) Application with MySQL / Firebird Access
Post by: ttomas on November 04, 2012, 08:13:24 pm
For my Inventory Application I use WinCE barcode terminal with Lazarus and SQLite and for sinchronization I copy SQLite database to windows do all processing in win and finaly copy db to WinCE.
Title: Re: WinCE (5.0) Application with MySQL / Firebird Access
Post by: BigChimp on November 04, 2012, 09:30:46 pm
I wouldn't use direct database access from a (mobile) device over the internet. Too insecure for one.

As Phil said in another thread: it's best if you decouple elements so you can switch elements without impacting the rest.
Having your mobile application tied to a specific database doesn't sound like a good idea.

So doing something with REST sounds good; note that you can still use local databases (or text files, DBF files, whatever) to store things in the mobile application....

PS: Am I dreaming or has your post translated itself from German into English ;)
TinyPortal © 2005-2018