Good info. I'm not sure why it should choke on that. There are examples of sqlite for huge implementations, but I'd probably journal a log long before it got to that size.
I'm fine with only one writer, and besides the database only locks for a few ms when that happens. I prefer the small, light, and fast on a modestly powered device like the RPi, and it's an easy port to MySQL if I decide to go that route at some point. Colin P.S. Many would take offense to saying sqlite is not a 'real' database. It's just a different model. It all depends on what you need. > On Jan 2, 2014, at 16:27, Pedro Côrte-Real <[email protected]> wrote: > >> On Thu, Jan 2, 2014 at 11:57 PM, Colin Reese <[email protected]> wrote: >> Looks like I wrote essentially the same thing, except using python except >> ruby and sqlite instead in MySQL. > > I started with sqlite and had to change it for a real database when it > became too slow after I had a few million readings in the database. A > multi-client database also made it easy to have one program writing > values to it and multiple clients reading from it. > > I moved to mysql directly but it would probably have been better to > use something like ActiveRecord to support any database. It's a pretty > clean codebase today though and produces some nice graphs: > > http://www.corujas.net/weather > > Right now it only supports 1wire and dinrelay IP relays. > > Pedro > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Owfs-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/owfs-developers ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Owfs-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/owfs-developers
