Effortlessly Send Data via Motion Sensors with WIFI Technology

[Somali_Physicist]

Does anyone know how i can send information to the web through motion sensors?

 

[Borek]

Please elaborate, this is rather ambiguous so far.

In general you should connect the sensor to something capable of both reading the sensor state and forwarding the information. Arduino with WiFi shield, ESP2866 module, Raspberry Pi (Zero should be enough) - something like that.

 

[Somali_Physicist]

Please elaborate, this is rather ambiguous so far.

In general you should connect the sensor to something capable of both reading the sensor state and forwarding the information. Arduino with WiFi shield, ESP2866 module, Raspberry Pi (Zero should be enough) - something like that.

I want to basically check if someone walked into a room, so if X enters or leaves a room , uptick 1.If X leaves a room uptick -1. However i want the upticks to be sent to an online database.

 

[Borek]

OK.

My advice still holds.

 

[Somali_Physicist]

OK.

My advice still holds.

but i want to use a commercial wifi sensor.Building it my self would involve liabilities since i am selling a system.

 

[TechTree]

I believe there is a python database API that you could possibly make use of, if you choose to use a raspberry pi. Which should be quite familiar if you've worked with databases before. Here are some popular compatible database interfaces:
- GadFly
- mSQL
- MySQL
- PostgreSQL
- Microsoft SQL Server 2000
- Informix
- Interbase
- Oracle
- Sybase

Once you've got all that set up, it should just be a case of uploading the motion sensor's data to the database. You would also need to configure the sensor's sensitivity, possibly write a bit of code that will upload the data when a certain condition is met such as a time interval or you'll just over load the database with data. And then if you wanted to, make it log the data so you can see what's triggering it throughout the day. And then you should have a fairly good Internet motion sensor.

Additional information about the python database API can be found here:
https://www.python.org/dev/peps/pep-0249/

Hope this helps, I'm no expert but this would be my best approach!

 

[anorlunda]

but i want to use a commercial wifi sensor.Building it my self would involve liabilities since i am selling a system.

Do you mean something like this? https://www.amazon.com/dp/B07F7D557R/?tag=pfamazon01-20

If you don't already know how to design it, it may make sense to become a retail reseller of a product that other people already make.

 

[Somali_Physicist]

Do you mean something like this? https://www.amazon.com/dp/B07F7D557R/?tag=pfamazon01-20

If you don't already know how to design it, it may make sense to become a retail reseller of a product that other people already make.

Kind of , i want to be able to manipulate the data.Also i want to be for small rooms , thus if it shouldn't detect motion past a limited angle.(The latter could probably be fixed with just fancy cardboard.

 

[anorlunda]

Kind of , i want to be able to manipulate the data.

Manipulation would typically be done in the smart phone app that received the data.

 

[Borek]

So is the problem with manipulating the data, connecting existing WiFi sensor to the database on some computer, or about making a sensor that is able to send the information to the database?

Or is it all at the same time?

 

[Somali_Physicist]

Manipulation would typically be done in the smart phone app that received the data.

So is the problem with manipulating the data, connecting existing WiFi sensor to the database on some computer, or about making a sensor that is able to send the information to the database?

Or is it all at the same time?

The software part, how could i send raw data into my computer so i can manipulate with a database software.

 

[anorlunda]

The software part, how could i send raw data into my computer so i can manipulate with a database software.

You have a lot of learning to do. The question is, "How can my program get data from the Internet?" That's too big a question for a forum. Instead, you need some programming courses.