You are not logged in.
Pages: 1
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)
Offline
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.
Offline
Much appreciated ab!
Offline
Pages: 1