Awalkin13
Posts: 4
Joined: Tue Jan 24, 2017 11:31 pm

Raspberry Pi database question

Tue Jan 24, 2017 11:38 pm

I have a raspberry pi B+ and was wondering if what I'm thinking about doing is not only possible but the simplest way.

I am wanting to transfer data collected by the raspberry pi from a linear potentiometer and store it in a database on my PC, using python. I then want to access this database and display the results in a GUI that I created in Java.

peterlite
Posts: 720
Joined: Sun Apr 17, 2016 4:00 am

Re: Raspberry Pi database question

Wed Jan 25, 2017 2:51 am

Doable. There are many posts on databases. Search for magpi database to find articles on using databases in Pi based projects.

You will run into processing power limitations if you are storing hundreds of thousands of measurements per second. A 1000 per second into a database should work. At 10,000 per second, you need a Pi 3, an SSD, and good code.

Awalkin13
Posts: 4
Joined: Tue Jan 24, 2017 11:31 pm

Re: Raspberry Pi database question

Wed Jan 25, 2017 5:26 am

Thanks I'll take a look.

Return to “General discussion”