#1 mORMot 1 » Custom URL responses » 2015-01-16 13:29:45

gm
Replies: 1

Is there any way to respond custom URL requests like "domain.com/one/two/three/four/" ?

#3 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-15 17:02:22

gm

I found this: http://www.crossfpc.com/

they said:

Using an integrated toolchain, CrossFPC enables you to cross-compile your Windows® Delphi® applications to 32 bit and 64 bit native Linux applications for X86, Linux ARM and Android without ever leaving the IDE....

...This project was created for people who wish to develop cross-platform applications with Delphi while staying inside the familar Delphi IDE.

Does anybody knows about this project?

#5 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-13 17:37:06

gm
ab wrote:

@gm
Are you considering using http://docwiki.embarcadero.com/Librarie … ageService ?
Perhaps TAmazonTableService does make better sense, if you want to store objects.

No, I didn't know about this Library (thank you). Actually, I'm thinking about store only blobs (json,html,etc) on S3, what I intend to do is minimise the amount of structured data, and then ease the overload on the database layer (SQLite or MongoDB).


ab wrote:

I'm not convinced by the idea of paying Amazon, when you can host a mORMot RESTful server for almost nothing on a Linux box, and store the data using SQLite - or MongoDB if you want replication.


That bothers me too, but by my estimates, seems to be cheaper than maintaining the necessary infrastructure for a horizontal scalability. Do you think I'm wrong?

Which Linux host provider do you recommend?  In addition...  "What environment (tools/IDE) would you recommend to work with mORMot on linux?" I have no experience with linux development.

#6 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-13 13:10:47

gm

@ab,

I'm thinking of to persist many TSQLRecord as a local file and as object on amazon S3. How does it seems to you?   I'd appreciate it if you just put me in the right direction and point me the relevant info on documentation or website, especially on the objects serialization without the db layer.

#7 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-13 11:14:11

gm

Hi @edwinsn,

Thank you, It's really interesting this JSONB support on PostgreSQL but I am convinced that is the case where it's better a noSQL solution.

About "load-balance-controlled", I'm planning to use Amazon Elastic Load Balancing ( http://aws.amazon.com/elasticloadbalancing/?nc2=h_ls )

#8 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-08 10:39:11

gm
edwinsn wrote:

@gm, I don't have done any test, but mORMot just feels fast than enough to me in my experiences.


I know @edwinsn, I entirely agree with you. I'm just looking for the best approach for a scenario where maybe I can't have the HttpServer and the database in the same computer (VM) because of clones of VM httpServers are launched on demand automatically.

#9 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-07 17:28:44

gm
ab wrote:

...Do you need 100 GB of SQL data? I guess no. This would be about BLOB probably...

You're right, AB. Certainly I don't need of 100 GB of SQL data but let me explain:

My need is not about BLOB, my project is a server for a SaaS offer. Each service customer does not need 100 GB either, but I have to support hundreds of customer with 1 Gb needs and I intend a design that when a new VPS is launched by the load balance service, everything can be automated with no human intervention.

This is the real reason for my concerns about large data, however you helped me a lot.

Thank you so much!

#10 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-07 13:10:20

gm

How about something around 100Gb? Do you think SQLite is a viable option?


Is that a good idea split the data into multiple files (by accounts for example)? Parallel connections to different files could be a performance problem?

#11 Re: mORMot 1 » mORMot bigData future and actual state » 2015-01-07 12:34:59

gm

Thank you AB,

That helped me a lot. Just to clarify, I wasn't planning use EF. The only ORM I consider is mORMot due to performance.

About the horizontal scalability, that's exactly what I want but SQLite is not a good idea for the DB layer, right?

I'm looking for scalable and fast storage layer, even if I have to implement synchronization between the DB instances myself.


In your view, what is my best option?

#12 mORMot 1 » mORMot bigData future and actual state » 2015-01-06 22:19:08

gm
Replies: 22

Hello,

This is my first post and firstly i would congrat mORMot team for this great software.

Well, I read recently about the mORMot bigdata future ( http://blog.synopse.info/post/2014/12/3 … is-BigData ).

It’s perfect timing and very interesting because I've been thinking about how I should design a web app with mORMot that takes advantage of amazon auto scaling and, of course, in that scenario the data is the challenge.

My first thought was DynamoDB, but I want avoid to depend on a proprietary infrastructure. Then I thought of mongoDB and that's when I found the post mentioned above.

It made me a little unsure about the actual state of mORMot scalability. My another option would be "ASP.Net/Azure" but I am inclined to mORMot because of their performance. However, I have some concerns and really appreciate if someone could give me some advice.



1)  Does the mORMot has a significant better performance than asp.net when it work with no SQLite direct acess (mongoDB or external DB)?

2)  MongoDB/TMongoClient -- Is it a good option in terms of performance? Why WiredTiger for the future?

3)  How about the argue that the ORM layer by itself already degrades performance? This is true for the mORMot too? Should I consider programing SQL manually for best results?

4)  What do you guys think is the best design in terms of scalability and high performance for a server app on the cloud?

Board footer

Powered by FluxBB