mORMot Open Source

warleyalex

Member

From: Sete Lagoas-MG, Brasil

Registered: 2013-01-20

Posts: 250

FishFacts for mORMot

Recently I was playing with mORMot  and with BLOB fields. Remember that old demo "FishFacts" developed with Delphi that displays a list of fishes, as well fishes images and notes text BLOBS from a dataset Biolife. Old days...

Now, I’m using mORMot, with a background HTTP REST server, together with its SQLite3 database engine, I’ve implemented a thin client, Ajax-ready, open and lightweight javascript client using jQuery, that shows how to display style memo and graphic fields. This app has been compiled with Delphi 7, but you can recompile it with Delphi 2009/2010/XE.

Click here to watch my 3-minute video
http://youtu.be/eqzJQftv89s

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: FishFacts for mORMot

This is indeed a great video!
With very clear explanations about how mORMot RESTful scheme works.

May we ask you to share the code, if possible, so that we may add it to the source code repository as official sample?
It may help a lot other users!

Please note that you can force the automatic transmission of all BLOB fields from a Delphi client directly, by setting TSQLRestClientURI.ForceBlobTransfert property to TRUE (that is, by default "Lazy loading" is enabled, but can be disabled on purpose).

Or you can use a TByteDynArray kind of property to let the content be transmitted (after BIN64 encoding) together with the main AJAX GET request, and returned within the JSON object.
But your AJAX client need to decode the Bin64 content, of course.

Thanks a lot!

noobies

Member

Registered: 2011-09-13

Posts: 139

Re: FishFacts for mORMot

indeed it would be great to already have some videos, but unfortunately there is no source projects.
It would be possible to add them to the branch samples repository.

warleyalex

Member

From: Sete Lagoas-MG, Brasil

Registered: 2013-01-20

Posts: 250

Re: FishFacts for mORMot

May we ask you to share the code

OK. I'll send the project by email.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: FishFacts for mORMot

Thanks a lot.

I've just uploaded the corresponding source code to our repository.
See sample 19 - AJAX ExtJS FishFacts at http://synopse.info/fossil/dir?name=SQL … +FishFacts

You need to download the DB from http://synopse.info/files/samples/Project19Server.zip

Enjoy!

ebz

Member

Registered: 2011-07-20

Posts: 18

Re: FishFacts for mORMot

Great, more examples much better..
After tested, works nice without problem. I think jQuery isn't used in this examples, just pure javascript

Last edited by ebz (2013-04-27 08:09:02)

Roberiopraciano

Member

Registered: 2013-01-25

Posts: 8

Re: FishFacts for mORMot

Congratulations, Warley Alex and Ab Great Work