mORMot Open Source

_db_

Member

From: Vancouver, BC, Canada

Registered: 2014-02-11

Posts: 4

Starting With mORMot - Complete Beginner

Hi experts,

I am working on a bar-code scanner app written in .NETCF3.5 on it's client side and Delphi 2010 on it's server side.
The server side is an Apache shared module written in Delphi, and it is talking to our database end to perform CRUD operations over a wireless network.  So, each operation on client, immediately and over the wireless network talks to the server (using SOAP) which then talks to our database (IBM DB2).

I would like to start implementing mORMot and replacing Apache server for this application, so my idea is to rewrite server to use mORMot and REST/JSON rather than Apache and SOAP. 

I have downloaded and I am in the process of reading the documentation, too.  But there is lots of it and I would rather work and read in parallel.

Who can provide me some starting points? 
Where and how to start?
How to install mORMot?
What are the keywords to search in documentation?
What are the objects I should use on server to talk to my DB2 database?

Much appreciated,
_db_

Last edited by _db_ (2014-03-04 18:45:45)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Starting With mORMot - Complete Beginner

Get the latest unstable 1.18 source code, and follow the instructions of the ReadMe.txt file.
See http://synopse.info/fossil/finfo?name=ReadMe.txt

Then download the 1.18 SAD pdf.
Read the FAQ at the beginning.

I've just added DB2 support to mORMot.
Integration into our ORM core was pretty easy, in fact.
We rely on ODBC for direct data access, and it works just fine.
Then it is difficult to find some SQL more standard than the one implemented by DB2!
See http://synopse.info/fossil/info/103fcd7e36

First time I used this database.
But sounds like a pretty solid solution.
The latest DB2 Express-C (for Community) just rocks.

Unlike the competitor express offerings, DB2 Express-C does not impose any limit on the size of database. The new DB2 Express-C 10.5 release also relaxes its memory restriction by 400%. It will now use up to 16GB of memory.
DB2 Express-C can handle database of any size, it can be used in production, and it can be redistributed with your applications.
http://www.db2teamblog.com

We are pretty close to MSSQL in terms of speed, without any restriction of data size, and much upper hardware limits:

Insertion speed
 		Direct	Batch	Trans	Batch Trans
ODBC DB2	4987	49112	14561	69604
MSSQL local	5429	53598	13612	61359
ODBC MSSQL	4920	19002	11775	20769

Read speed
	 	By one	All Virtual	All Direct
ODBC DB2	8428	86355		123924
MSSQL local	10399	209608		375065
ODBC MSSQL	13107	138888		252155

For your project:
- You can use your existing code and tuned SQL statements, then access the server via REST/JSON, using interface-based services;
- If you want to create new tables, you can use our code-first ORM, either on server side, either on client side, using our REST/JSON direct interface.

Performance above (i.e. insertion of more than 64,000 objects per second) is for the ORM part.
It includes JSON marshalling to/from Delphi objects, REST routing, security, and optimized DB access.
Just with some Add/Update/Delete/Retrieve methods, and the corresponding BatchAdd/BatchDelete/BatchUpdate methods.

_db_

Member

From: Vancouver, BC, Canada

Registered: 2014-02-11

Posts: 4

Re: Starting With mORMot - Complete Beginner

Much appreciated ab!