Hi Dario,
On Dec 19, 2007 6:36 PM, Darío Mariani <[EMAIL PROTECTED]> wrote:
> 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.
Thanx. I was hoping the same from NFS :)
> But, if your NFS device is a complete box and not just a disk array
^^^
I hope you mean NAS device not NFS device here.
> with an ethernet card, you will be better creating a small
> client-server protocol over TCP.
I will check this in more detail and update. So, it would be OK to go
for sqlite over network
mounted filesystem if NAS is complete box and not an array of disks
with ethernet card I think.
---Trilok Soni
> 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]
> -----------------------------------------------------------------------------
>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
