Current implementations of NFS on Linux have a decent lock mechanism
(as far as I know). You'll have to check your NAS device how does it
handle NFS locking.
But, if your NFS device is a complete box and not just a disk array
with an ethernet card, you will be better creating a small
client-server protocol over TCP.
Darío
On Dec 19, 2007 6:04 AM, Trilok Soni <[EMAIL PROTECTED]> wrote:
> Hi John,
>
> On Dec 18, 2007 11:53 PM, John Stanton <[EMAIL PROTECTED]> wrote:
> > Sqlite depends upon POSIX file locks. It is no better or no worse than
> > the POSIX lock implementation on your platform.
>
> Thanx for the reply. My platform is based on Linux running on ARM9, with
> having 128MB of the flash on it. The captured video from analog/IP camera
> will be stored on the NAS storage device connected to it through network,
> which
> gets mounted to the filesystem using NFS. So, the database file containing
> these
> videos meta information will be stored on NAS device, not on the flash
> partition,
> as flash is used to keep programs binaries and the size constraint.
>
> >
> > We use Sqlite in a multi-user environment without dependency oin the
> > POSIX locks by embedding it in a server using HTTP when it is on a
> > remote machine. We get the small footprint and simoplicity of Sqlite
> > and get no multi-user glitches regardless of platform.
>
> I am not able to understand, what you mean here by "embedding sqlite in a
> server using HTTP when it is on a remote machine". In our project scenario,
> we do have remote interface of this platform using embedded webserver running
> on the device (e.g. boa/lighthttpd/webapp) and we want to show various
> information
> about these videos on the webpage by searching this file database
> residing on the NAS.
>
> Only confusion for selecting SQLite came here is, because we are not storing
> this database on the local flash on the device, but on the NFS mounted
> NAS device,
> which gets accessed/configured through web-interface provided by the
> device through
> some embedded webserver as explained in the earlier paragraph. And
> SQLite FAQs I have
> pointed mentions that there could be problem in accessing the database
> over the NFS,
> this is where I got confused and unable to decide to go for SQLite or not.
>
> --
> --Trilok Soni
>
>
>
> >
> >
> > Trilok Soni wrote:
> > > Hi,
> > >
> > > I am evaluating SQLite for the design of the surveillance camera/DVR
> > > product based on Linux, which stores its captured
> > > analog/IP camera streams to the NAS storage device(s). To facilitate
> > > faster search/scanning of those media files
> > > containing many days of videos spread over multiple files, we plan to
> > > keep the metadata of those videos
> > > in some file format/database stored on NAS itself, so that
> > > search/analysis mechanism just go through this
> > > database to locate exact file with some search criteria like
> > > time/data/camera/alarms/events etc.
> > >
> > > While reading the SQLite documentation I came to following FAQ, where
> > > it lists that SQLite as application file format,
> > > may not scale well to the NFS/Neworked attached drives due to the
> > > locking problems.
> > >
> > > http://www.sqlite.org/faq.html
> > > Refer 5th question.
> > > (5) Can multiple applications or multiple instances of the same
> > > application access a single database file at the same time?
> > >
> > > Is there any other way to work around this problem and use SQLite as
> > > application file format in the above scenario. See that Linux
> > > will run on the ARM9 having video processing done on specialized DSP.
> > >
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> >
> >
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-