Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
McGlockenshire
Dec 16, 2005

GOLLOCKS!

Poopernickel posted:

Is a SQLite database worth using for this kind of thing? If so, do I need to worry about having one program (the data collector) writing to it and deleting old records while the other program (the GUI) is trying to access it?

Activating the journal_mode=WAL pragma to use the 3.7.0+ writeahead log can provide a huge boost to sanity when you have concurrent readers and writers. Just be sure to understand the disadvantages listed. I'm still not sure if it'd still be fast enough here, but it could work.

McGlockenshire fucked around with this message at 18:35 on Dec 20, 2012

Adbot
ADBOT LOVES YOU

  • Locked thread