php - Flex + Air App to Database? -


i'm trying create air app using flex 4.5. app interacts livecyle collaboration service support screen-sharing , webcam chatting in desktop.

i'm looking database (not local sqlite) store , load facebook wall-sized data. is, many users can store , load database in short amount of time (synchronization issue). also, i'll set database in mac mini snow leopard server.

i came these 3 solutions:

1) mysql using amfphp - access mysql via server-side language.

2) mysql via assql library - direct access mysql, bad security.

3) blazeds/livecyclees , coldfusion - java ee backend, coldfusion commercial, , suited large project?

which 1 best solution small , mid-sized project? or recommend other solution? thanks.

coldfusion suited large projects. shouldn't matter it's commercial unless have budget doesn't fit into. but, if livecyclees more expensive if cost issue you'll have use blazeds.

as "wall-like" feature facebook has several things have consider. wall implies have soft of social graph stored. graph networks not easy on large scale relational db. i'd suggest looking @ nosql storage mongodb, cassandra. options scale less effort sharding database requires lot of software engineering store efficiently.

http://www.rackspace.com/cloud/blog/2010/05/12/cassandra-by-example/

you're going have issues solve phpamf , blazeds if want share screens between 2 clients. asynchronous messaging isn't support either of options it's no-starter. livecycle es has support type of thing blaze/ds hasn't in past. might want double check features of blaze/ds see if that's changed lately. 1 option @ red5 has support rtmp/e.

http://www.red5.org/


Comments

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -