MySQL over SQLITE

[Jamie Dunbar]

Hello everyone,

I wondered what the feeling was for using MySQL over SQLlite

I am currently using MySQL as I used to export from wview to MySQL as i was more familiar with it. To avoid fussing about I have stuck with it. I wonder sometimes if sqlite would just be easier, namely for backups as I can just copy the file away with no dumping and saving.

What are your thoughts?

Is there any easy way to migrate MySQL back to a nice tidy SDB file?

[Oz Greg]

Jamie,

Ultimately your choice of DB depends on your setup, I have a nice powerful NAS so mysql is my DB of choice leaving my PI box free of the IO's required to run a DB..  If you want to run your DB on your PI box then I would go with sqlite as it has minimal overheads..

[Oz Greg]

PS use the wee_config_database utility.. execute ./bin/wee_config_database ../weewx.conf --help from your weewx parent directory..

[Jamie Dunbar]

What does wee_config_database do? Feel free to point me to some documentation, I had a search but came up empty.

Many thanks.

[Jamie Dunbar]

Ignore me, I found it.

[Steve]

Sorry for bumping this, thought I'd do it rather than creating a new thread.

I run weewx on an RPi but also run energy monitoring software (MeasureIt) using a Current Cost EnviR and 10 sensors on it too, it's updated every 6 seconds and displayable in real time, so things are reasonably busy.

MeasureIt uses MySQL so I configured weewx to use MySQL seeing how it is already installed, used and the overhead is already there.

What I'm asking is, while I'm not using SQLlite for weewx, does it consume any resources or use any overheads? If it does, how can I prevent it / them?

Regards,

Steve. 

[Andrew Milner]

I can't for the life of me see why SQLite should use any significant resources if it's not being called upon to do anything - unless there is a regular housekeeping type of activity ... which, if it is not being used for anything, will be minimal overhead!

You can check running processes with ps -A command.  I just did that, and could see a couple of processes for Mysql - but nothing that looked like sqlite (which I also have got installed but, like you, am not now using as I switched to Mysql on my Pi because I am also using the mesowx extension to weewx that does not use SQlite.

Andrew

[Steve]

Thanks Andrew,

I did a ps -A and it didn't mean a lot to me (I only know enough to break stuff), but if it doesn't bother you, it won't bother me as you'd be on top of it if it was an issue, well before I stumbled across it :)

Regards,

Steve.

[Andrew Milner]

Lol ... don't take my word for anything - I rely on this excellent(??) guru of a teacher/informer/lecturer called Mr. Google!!!

Happy stumbling .... falls make one get more wakeful and alert!!

Andrew

[Thomas Keffer]

No. Sqlite is strictly an application-driven, file-based database. There is no server like there is with MySQL. It's just a library that manipulates a file. 

Weewx is designed that if you don't use sqlite, then it does not import its libraries. So, there is no overhead from it.

-tk

--
You received this message because you are subscribed to the Google Groups "Weewx user's group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Steve]

Thanks for confirming that Tom.

I was hoping it was the case after googling the pros and cons of each.

Regards,

Steve.