Check this out:

6.0 How To Corrupt Your Database Files

http://www.sqlite.org/lockingv3.html

(And to add to Anthony's point, I must admit it clearly says: "Your best
defense is to not use SQLite for files on a network filesystem.").

Cheers
Juan Pablo Califano


2009/1/10, Omar Fouad <omarfouad....@gmail.com>:
>
> And why problematic on Macs?
>
> On Sun, Jan 11, 2009 at 12:56 AM, Juan Pablo Califano <
> califa010.flashcod...@gmail.com> wrote:
>
> > As far as I know, SQLite uses the OS file locking facilities (which do
> seem
> > to be problematic in Macs). Anyway, I'm not saying this is the most
> robust
> > possible solution. I'm just saying that given the circumstances, it could
> > be
> > good enough.
> >
> > Cheers
> > Juan Pablo Califano
> >
> > 2009/1/10, Anthony Pace <anthony.p...@utoronto.ca>:
> > >
> > > Well the db is a raw file; thus,  I was referring to the db.
> > >
> > > If you look at my last few lines, I was trying to tell him how his
> > system,
> > > in which the file can be written to by all clients, can only work even
> > > marginally well with a timed write delay; yet, nowhere did I say it was
> > more
> > > secure.  In fact, if you look at my first line, I note that it is a bad
> > way
> > > to do things, and is very insecure.
> > >
> > >
> > _______________________________________________
> > Flashcoders mailing list
> > Flashcoders@chattyfig.figleaf.com
> > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
> >
>
>
>
> --
> Omar M. Fouad - ActionScript Developer
> 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

Reply via email to