The aims of this exercise are to explore a small LAN looking at:
- the sort of information we can collect.
- some of the command line tools that are available.
- how we can communicate across the network
The amazing versatile Arduino microprocessor board that can be used in many projects.
RPi Twitter Led
This program follows on from the standard Python Twitter experiments.
The original inspiration for this whole experiment came from a @Rob Bishop (OCR) Raspberry Pi Recipe Card. The objective of the program is to light an LED every time a tweet containing a particular word is sent to a certain person.
Python is a highly readable language that is easy to use and learn hence it is gaining popularity as an education language. However, this should not lead anyone to consider it a child’s language for it is not. It is very powerful, flexible and platform independent. It supports many styles of programming from scripting and web design to GUI/Game development.
The Sense Hat from Raspberry Pi was developed as part of the Astro Pi Project. The Sense Hat comes with its own library and a variety of hardware including: a 8×8 RGB LED matrix for output; a five-button joystick for user control; and the following sensors:
- Gyroscope used to measure the positioning of an object
- Accelerometer used to measure the rate of the velocity of an object
- Magnetometer that provides an electronic compass
- Barometric pressure
The purpose of this page is a quick guide to using the different aspects of the Sense Hat but for full details you should check out the API.
MySql – Insert
Inserting rows into MySql can be done in a couple of ways. You can use the INSERT…VALUES and INSERT…SET commands.
MySql is the worlds second most popular database engine (July 2013) and its open source. It is based on SQL (Sequential Query Language). Unlike MS Access it does not run as a stand-alone application. It runs as a background service on a computer (typically called ‘a server’) and you connect to it using a username and password. Once you have connected to the MySql server you can query it using SQL or Structured Query Language. The server will respond with the results of your query.