Raspberry Pi Forums

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.

Install MySQL or MariaDB on your Pi.

I found Sqlite3 works pretty well for small projects and it comes with Python.

robert_loblaw wrote:I found Sqlite3 works pretty well for small projects and it comes with Python.

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 ...

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.