You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 2014-09-01 07:25:57
- ozgunlu
- Member
- Registered: 2014-09-01
- Posts: 4
mySQL - mORMot - Mobile App
Hi,
I want to make a mobile application which is communicate with remote DB (mySQL) using Delphi XE6.
The structure of my project:
Remote DB(mySQL) -> mORMot(Rest Server) -> Mobile App (firemonkey)
Can i use mORMot for this project? If its possible, are there any samples with connection mySQL db?
Excuse my bad English
Offline
#2 2014-09-01 07:45:54
Re: mySQL - mORMot - Mobile App
Yes, of course, this is possible, and a very good solution:
- Search for MySQL keyword in the SAD 1.18 pdf - we recommend using the latest unstable 7.2 ZDBC connector (via SynDBZeos), or ODBC (via SynDBODBC);
- See sample "SQLite3\Samples\28 - Simple RESTful ORM Server" and switch the PostgreSQL initialization line into MySQL;
- See sample "SQLite3\Samples\27 - CrossPlatform Clients" and http://blog.synopse.info/post/2014/08/1 … FreePascal for FireMonkey clients;
- Consider putting your logic as interface-based services on the server, not using the framework as a SQL proxy - your FireMonkey app should benefit of being only a "view" of your logic, and you would be able to switch to AJAX or HTML5/PhoneGap mobile app later on, if needed.
The SAD 1.18 pdf is worth taking a look, even if your English is not fluent.
I'm no native English either. 
You do not have to read all 1600 pages - just start from the first chapter, to understand the design concepts behind mORMot.
See also this set of slides: http://blog.synopse.info/post/2014/04/1 … principles
Offline
#3 2014-09-01 07:56:01
- ozgunlu
- Member
- Registered: 2014-09-01
- Posts: 4
Re: mySQL - mORMot - Mobile App
Thanks for quick reply and helping 
Offline
#4 2014-09-02 07:36:17
- ozgunlu
- Member
- Registered: 2014-09-01
- Posts: 4
Re: mySQL - mORMot - Mobile App
ab, i searched but i couldnt find. May i ask a simple question? How can i select table from db, can you write a simple example? 
Offline
#6 2014-09-03 11:28:41
- ozgunlu
- Member
- Registered: 2014-09-01
- Posts: 4
Re: mySQL - mORMot - Mobile App
thanks, i can use RESTful ORM Server with mySQL. And now i'm trying to understand crossplatform samples, but i got an error: undeclared identifier 'TSQLRestClientHTTP'. I just want to monitoring remote db's datas from mobile app clients.
Offline
Pages: 1