Recent

Author Topic: WinCE (5.0) Application with MySQL / Firebird Access  (Read 6739 times)

DataCool

  • Newbie
  • Posts: 2
WinCE (5.0) Application with MySQL / Firebird Access
« 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
« Last Edit: November 04, 2012, 07:11:17 pm by DataCool »

ttomas

  • Full Member
  • ***
  • Posts: 245
Re: WinCE (5.0) Application with MySQL / Firebird Access
« Reply #1 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.

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: WinCE (5.0) Application with MySQL / Firebird Access
« Reply #2 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 ;)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

 

TinyPortal © 2005-2018