stevieb has asked for the wisdom of the Perl Monks concerning the following question:
Perlmonks is usually slow on weekends, so I thought I'd fire off another question.
I have an SQLite database that will be used to store data every 3-10 seconds. This will be happening on a Raspberry Pi, so the 'disk' is an SD card. What I'm hoping to do is load that file into memory, and use it there, then create an event to write it to disk every X minutes, making it permanent (if data is somehow lost in the meantime, it isn't critical).
Everything writing to the DB will be in Perl, and all processes will be within a single process umbrella.
Is this a Linux question, or can this somehow be done (copy the db file to memory) within Perl, at the onset of my application load? If so, can I please get some recommendations on a practical way of doing this, or perhaps pointers to modules that may already do this?
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Putting an SQLite DB file into memory
by clueless newbie (Curate) on Sep 25, 2016 at 23:12 UTC | |
by stevieb (Canon) on Oct 04, 2016 at 13:35 UTC | |
Re: Putting an SQLite DB file into memory
by tybalt89 (Monsignor) on Sep 25, 2016 at 23:14 UTC | |
by Linicks (Scribe) on Sep 26, 2016 at 16:11 UTC | |
Re: Putting an SQLite DB file into memory
by Laurent_R (Canon) on Sep 26, 2016 at 06:16 UTC | |
by BrowserUk (Patriarch) on Sep 26, 2016 at 06:46 UTC | |
by Laurent_R (Canon) on Sep 26, 2016 at 23:01 UTC | |
by BrowserUk (Patriarch) on Sep 26, 2016 at 23:53 UTC |