Re: [sqlite] sqlite on flash devices

2008-10-08 Thread Paul
We're using linux. Data loss is not critical. If anything is lost due to unexpected power downs, we can rebuild it and add it to the database at a later stage. Apart from using :memory: another idea is to use linux ramfs and periodically copy this to flash. The other thing I'm assuming is to com

Re: [sqlite] sqlite on flash devices

2008-10-03 Thread Paul
I was thinking of setting up similar experiments; nice idea hooking the MTD layer to count erase cycles.. I'm going to keep 1st implementation simple and just use sqlite direct to flash, no memory cache. Then I can measure the performance.. We should be using a flash controller that does wear le

Re: [sqlite] sqlite on flash devices

2008-10-03 Thread Paul
I thikn you mean supplying a sqlite3_vfs to the sqlite3_open_v2 call; will look into it. Anyone know where there are examples of this? - -Paul On Fri, 2008-10-03 at 01:03 +0400, Alexey Pechnikov wrote: > Hello! > > I'm using SQLIte on a few dozens winmobile devices a few years. It's work >

Re: [sqlite] sqlite on flash devices

2008-10-03 Thread Paul
-- -Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite on flash devices

2008-10-02 Thread Matthew L. Creech
On Thu, Oct 2, 2008 at 4:20 AM, Paul McMahon <[EMAIL PROTECTED]> wrote: > What's the consensus on using sqlite with flash based storage such as sd > cards on embedded devices? > > Has anyone done this successfully yet with a real product (that needs to > last a few years in the field)? > We've got

Re: [sqlite] sqlite on flash devices

2008-10-02 Thread Alexey Pechnikov
Hello! I'm using SQLIte on a few dozens winmobile devices a few years. It's work fine with standart FS. If you want to try raw access to flash you can find expiremental VFS code for flash and adopt this code for you. I don't remember where I did see this code. Best regards, Alexey. ___

Re: [sqlite] sqlite on flash devices

2008-10-02 Thread J Glassy
Paul, here are a few odd thoughts on this: --Flash memory devices in general are subject to 'finite' numbers of I/O events, mostly affecting writes; more recent flash memory devices ease this constraint a bit, if only by supporting more I/O events before they hit their useful life-limit. I think