Does anyone know if there is a way to control a MySQL database through voice command of Alexa. Like let's say I say "Alexa Up" and it will put a 1 in a specific spot on a database?

Ok so after looking into Node-Red it seems to be exactly what I am looking for. However, I am just wondering if anyone knows how to do a simple SELECT statement with this. I have already installed the mysql node. I have attached an image of what I think it should be. Also I this is what I believe sh...

amazing! This is exactly what I am looking for I will post my updates in a bit.

Interesting I never thought of that approach. I am not too familiar with Node.js do you know of any tutorials showing this method?

I eventually want to have more than one RPI running at a time from one screen. So lets say I have 3 lights bulbs all controlled by differe RPIs in my house. I want to be able to see them all on the same webpage and click on a button to send say a 1 to my database where the RPI will read it and turn ...

Hi there, I am new to Raspberry PI and I am looking for a way in which I can turn on and off a light using MySQL and a web interface which will be hosted on a separate machine since I eventually want to use more than one RPI. I have searched online and can only find servers being run on the same RPI...

Ok that makes sense. My final question and I'm sorry I've been asking a lot. In terms of reading the GPIO. I'm assuming I would need to read GPIO 3. I would first need to make GPIO 3 and input using the command GPIO.setup(3, input)

But than to read it what would it be?

Thank you for getting back to me and explaining it to me so well. Now if I only needed to know if power was in or not would I still need the voltage divider. What I mean to say is I dont specifically need to know how much power is going in rather if there is or not. So like a boolean.

So I bought myself one of these https://www.creatroninc.com/product/pcf8591-8-bit-i2c-adc-dac/?search_query=PRODA-008591&results=1 I have been doing some research and turns that for what I need I can connect the voltage of the USB port into the VCC and than I would connect my raspberry PI to AOut? i...

Excellent. I am currently looking into that now. My last question I have is what command can I use to show the value of the GPIO input?

Thank you for your replys. ADC seems the way to go from what I can read online. Any suggestions on ones. And cheaper would be better. Also I am assuming there is a command like read voltage to actually read the value from the GPIO?

I am new to Raspberry Pi and just got my self a new one. I have installed raspian OS on it. My plan is to plug a power source into one of the GPIO pins and read the voltage. Is this possible?

Ex. Get the voltage of USB of a TV and read it to the Raspberry Pi.