Since you need the session control to be centralized by one
administrative computer in the internet Cafe, I would suggest the AIR to
AMP(apache mysql php...cause it's free) server method; yet, that is my
opinion and we are all free to differ in opinion. If you want to use
your method, you are giving yourself more work, to get it working
properly, than it is worth; yet, again, this is only my opinion.
Sever less message switching using shared files has been around for
years. In fact I remember back in 2000 with flash 5 when I was still in
my teens trying out a method just like this and getting it to work with
XML; yet, realizing there were better ways I moved on.
Omar Fouad wrote:
Thanks Guys for the Replies...
OK I agree with all this, but do you believe I hadn't thought about using an
online server and save the headache? As I said before, it is an option that
will let the users of an AIR POS application (that also stores and read data
in a database shared on the network and it works for 6 months now like a
charm) communicate to each other. The real challenge here is the ability to
do this offline. I don't want an Internet connection to do this.
Plus I don't see the security a big issue in this case. I don't need
security. I clean the tables every 24 hours (and compact). There are no
plenty of users. I don't think there will be more than 5 computers running
it at the same time. I've been thinking about using a PC running Apache and
MYSQL locally and let all the computers connect to it (not sure if this is
gonna work) but come on, SQLite is amazing in my opinion. I've been testing
it since AIR was released and It IS reliable. Of course It is dangerous when
accessed by many clients but, as long as the client amount is resoanable,
and the code is well written, nothing is impossible.
Cheers.
On Sun, Jan 11, 2009 at 10:24 AM, Anthony Pace <[email protected]>wrote:
Exactly.
Nate Beck wrote:
Dave, I was thinking the same thing.
After reading through this thread again, I realized that this client to
client thing can be handled using a simple server. And there are already
many open-source solutions out there that will accomplish this behavior.
Red5, WebORB and BlazeDS all support concurrent connections and passing
data from client to client.
If you're already depending on the network for SQLite access, why not just
host some server solution on said network?
Cheers,
Nate
On Sat, Jan 10, 2009 at 9:44 PM, Dave Watts <[email protected]> wrote:
I apologize if I've missed something that anyone has posted in this
thread.
Insecurity? A SQLite database is ment to be written by clients... of
course
it is not like a server database, with users, privileges and so on. But
it
still does the job.
I don't think security is the main problem here, but rather the lack
of concurrency control. SQLite is meant to be a single-user database,
and has no multi-user concurrent capability.
Since AIR can talk to remote web services, why not just set up an
application server somewhere and let your AIR apps talk to that? Let
your app server (and/or its backend database) handle concurrency
control for you.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
