-
thatfeelsgood
- Posts: 1
- Joined: Thu Jul 13, 2017 7:36 pm
Raspberry with sql
Someone, please help me I have a java web application of one page with SQL connectivity. I want to connect raspberry and web application and want to store raspberry sensors data in SQL database. How I can achieve this task in short amount of time.
-
W. H. Heydt
- Posts: 13955
- Joined: Fri Mar 09, 2012 7:36 pm
- Location: Vallejo, CA (US)
Re: Raspberry with sql
Install MySQL or MariaDB on your Pi.
-
robert_loblaw
- Posts: 8
- Joined: Mon Dec 19, 2016 4:59 pm
Re: Raspberry with sql
I found Sqlite3 works pretty well for small projects and it comes with Python.
-
Ronaldlees
- Posts: 294
- Joined: Sat Apr 16, 2016 4:28 pm
- Location: North Carolina, US
- Contact: Website
Re: Raspberry with sql
I'm using Sqlite3 on a Pi2 with PHP and Wordpress to serve blog pages. The same Pi also serves as the access point. I read that MySQL would consume more resources on the Pi, and might take something from the blog-server's performance. I don't know if that's true, or not, but SQLite3 does pretty nicely, excepting for larger graphics images in pages ...robert_loblaw wrote:I found Sqlite3 works pretty well for small projects and it comes with Python.
I've had trouble with some of the current WP plugins, that (apparently) really do need MySQL to operate correctly. I'm running a pretty sparse WP setup though, so the plugins are not a problem from my perspective, at least so far ...
As far as using Sqlite3 goes, and the associated security status, that's unknown to me, but it's a private access point anyway.
I am the Umbrella man