PS: loved this thread :D On Sat, Jan 10, 2009 at 2:36 AM, Omar Fouad <omarfouad....@gmail.com> wrote:
> 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. > -- 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