Live stream to http://twitch.tv/adafruit looking at how to use the SQLite database to store simple sensor readings and configure program state. Explores how to use SQLite tools and execute queries from Python.
Links mentioned in the video:
- Code for this project: https://github.com/adafruit/Raspberry_Pi_SQLite_Sensors
- SQLite homepage: https://www.sqlite.org/
- Manga Guide to Databases book: http://www.amazon.com/Manga-Guide-Databases-Mana-Takahashi/dp/1593271905
- Learn SQL The Hard Way book (alpha version): http://sql.learncodethehardway.org/
- SQLite data types: https://www.sqlite.org/datatype3.html
- SQLite date functions: https://www.sqlite.org/lang_datefunc.html
- Python 3 sqlite module: https://docs.python.org/3.4/library/sqlite3.html
- SQLiteStudio tool: http://sqlitestudio.pl/
Acknowledgements:
- Music: bartlebeats
- Intro shuttle footage: NASA
- Intro fonts: Typodermic
- Intro inspiration: Mr. Wizards's World
- Matrix background: cool-retro-term & cmatrix
-----------------------------------------
Visit the Adafruit shop online - http://www.adafruit.com
Subscribe to Adafruit on YouTube: http://adafru.it/subscribe
Join our weekly Show & Tell on G+ Hangouts On Air: http://adafru.it/showtell
Watch our latest project videos: http://adafru.it/latest
New tutorials on the Adafruit Learning System: http://learn.adafruit.com/
Music by bartlebeats: http://soundcloud.com/bartlebeats
-----------------------------------------