Anthony, File locking would be an issue i know but there are two ways to connect to a SQLite file, one is with open() and the other is with openAsync() - Basically a SQLite file is locked only within the execution of a SQL statement and not while connected. The openAsync connection allows putting several SQL statement on queue (fair enough) from many clients. So if the file is locked, an incoming sql execution will be reserved untill the file unlocks. Pretty neat ha?
On Sat, Jan 10, 2009 at 2:18 AM, Anthony Pace <anthony.p...@utoronto.ca>wrote: > That is definitely a nifty way to avoid writing a server. If it works > that's cool; yet, what happens when they request or write to the file at the > same time? > I don't see this working with multiple connections trying to write to the > same file at once; considering there is no server handling the threading of > requests to the db. > > > Omar Fouad wrote: > >> Weyert, the SQLite file is stored somewhere in a full access shared >> folder. >> Each AIR application connects to it, and performs sql statements without >> any >> problem, as long as the computer is connected to the same network. >> >> Yours >> >> On Sat, Jan 10, 2009 at 2:07 AM, Omar Fouad <omarfouad....@gmail.com> >> wrote: >> >> >> >>> Antony I have already 3 computers connected to the Same SQLite shared >>> file >>> on the network and it works like a charm. :) >>> >>> >>> On Sat, Jan 10, 2009 at 1:54 AM, Anthony Pace <anthony.p...@utoronto.ca >>> >wrote: >>> >>> >>> >>>> SQLite won't connect to another computer on the lan though... >>>> >>>> Since you know c#, just replace where it says java with c# that is >>>> somewhat similar; however, I do completely understand this is sometimes >>>> easier said than done. >>>> >>>> >>>> >>>> http://www.google.ca/search?hl=en&q=simple+socket+server+in+c%23&btnG=Search&meta= >>>> >>>> >>>> >>>> Nate Beck wrote: >>>> >>>> >>>> >>>>> Good to hear Omar! I hate nagging bosses. >>>>> On Fri, Jan 9, 2009 at 3:22 PM, Omar Fouad <omarfouad....@gmail.com> >>>>> wrote: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>> Guys when there are deadlines and a Boss bugging you 24/7 there is no >>>>>> time >>>>>> to pick a book and learn a language definitely different from the >>>>>> language >>>>>> you are being writing for years. >>>>>> >>>>>> I've found another way to share information between two applications >>>>>> by >>>>>> the >>>>>> way. It is not a new way, it is the traditional use of a local SQLite >>>>>> databse file. That will help and I'll implement some Ideas I already >>>>>> have >>>>>> to >>>>>> do what is needed. But please don't tell my boss :D >>>>>> >>>>>> Cheers. >>>>>> >>>>>> On Sat, Jan 10, 2009 at 12:32 AM, Weyert de Boer <w...@innerfuse.biz> >>>>>> wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> If you want to open server sockets with AIR. You need an extra >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> application >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> alongside your AIR application. This application then opens the >>>>>>> listening >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> or >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> server socket and then acts as some sort of middleman or proxy for >>>>>>> your >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> AIR >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> application by redirecting the traffic back and forth of the >>>>>>> listening >>>>>>> socket to the open connection of the AIR application to this middle >>>>>>> man. >>>>>>> Like: >>>>>>> >>>>>>> 1. Start helper application >>>>>>> 2. Helper application opens AIR application after opening connection >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> (or >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>> use SocektMonitor to monitor it instead) >>>>>>> 3. AIR application open client connection to Helper application >>>>>>> 4. Any incoming data into the listening socket should be forward to >>>>>>> the >>>>>>> socket connected from the AIR application >>>>>>> >>>>>>> Yours, >>>>>>> Weyert >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Flashcoders mailing list >>>>>>> Flashcoders@chattyfig.figleaf.com >>>>>>> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> -- >>>>>> Omar M. Fouad - www.omar-fouad.net >>>>>> Cellular: (+20) 1011.88.534 >>>>>> Mail: m...@omar-fouad.net >>>>>> >>>>>> This e-mail and any attachment is for authorised use by the intended >>>>>> recipient(s) only. It may contain proprietary material, confidential >>>>>> information and/or be subject to legal privilege. It should not be >>>>>> copied, >>>>>> disclosed to, retained or used by, any other party. If you are not an >>>>>> intended recipient then please promptly delete this e-mail and any >>>>>> attachment and all copies and inform the sender. Thank you. >>>>>> _______________________________________________ >>>>>> Flashcoders mailing list >>>>>> Flashcoders@chattyfig.figleaf.com >>>>>> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> _______________________________________________ >>>> Flashcoders mailing list >>>> Flashcoders@chattyfig.figleaf.com >>>> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders >>>> >>>> >>>> >>> >>> -- >>> Omar M. Fouad - www.omar-fouad.net >>> Cellular: (+20) 1011.88.534 >>> Mail: m...@omar-fouad.net >>> >>> This e-mail and any attachment is for authorised use by the intended >>> recipient(s) only. It may contain proprietary material, confidential >>> information and/or be subject to legal privilege. It should not be >>> copied, >>> disclosed to, retained or used by, any other party. If you are not an >>> intended recipient then please promptly delete this e-mail and any >>> attachment and all copies and inform the sender. Thank you. >>> >>> >>> >> >> >> >> >> > > _______________________________________________ > Flashcoders mailing list > Flashcoders@chattyfig.figleaf.com > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > -- Omar M. Fouad - www.omar-fouad.net Cellular: (+20) 1011.88.534 Mail: m...@omar-fouad.net This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________ Flashcoders mailing list Flashcoders@chattyfig.figleaf.com http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
