Difference between revisions of "Python Easy DataBase Project"
Russ hensel (talk | contribs) |
Russ hensel (talk | contribs) |
||
Line 63: | Line 63: | ||
*'''[https://www.amazon.com/dp/B07KYVS85J/ref=dp_cerb_1 TP-Link Mini WiFi Smart Plug, Wi-Fi, Compatible with Alexa, Only Occupies one Socket (HS105), Wall-Light, Electronic-Component-switches, 1-Pack (Renewed) - - Amazon.com ]''' | *'''[https://www.amazon.com/dp/B07KYVS85J/ref=dp_cerb_1 TP-Link Mini WiFi Smart Plug, Wi-Fi, Compatible with Alexa, Only Occupies one Socket (HS105), Wall-Light, Electronic-Component-switches, 1-Pack (Renewed) - - Amazon.com ]''' | ||
− | + | ||
− | |||
− | |||
− | [[Category:Python Projects]] [[Category:Python | + | [[Category:Python Projects]] [[Category:Python Easy DB]] [[category:Python]] |
Revision as of 12:27, 1 December 2019
This is an article started by Russ Hensel, see "http://www.opencircuits.com/index.php?title=Russ_hensel#About My Articles" About My Articles for a bit of info. Still polishing up this page.
Contents
Introduction/Status
Purpose: This is a Graphical User Interface Application to easily create databases using simple text files to control input, output, and record maintance. The application uses an sqllite database. It should work on Windows, Mac, Linux, and the Raspberry Pi. It does require at least Python 3.6 as it uses f-strings ( print( f"evaluate this{1+1}" )
Program Status: ( Program now Ver9 ) Very Alpha, many parts work. Not ready to post the code. Intended for those with some Python experience who can add the files to their Python development environment ( no install features for this code ). Some dependencies will need to be installed, probably prompted by error messages. Editing of the parameter file should be easier for those with Python experience. Users should find some useful documentation in the code, this is still a work in progress. Much code has been lifted from other projects of mine, some artifacts remain.
This Page Status: This page is the "master" page for the project, all other pages link back here, either directly or indirectly. Pages are drafts, but worth reading if you are trying to use the program.
Help File: Including install and configuration. Easy DB Help File. Screen shots and more at: Easy DB GUI Images.
More Documentation: Not ready yet, this is false as of now See links below, and code ( russ-hensel/Smart Plug Repository )
Graphical User Interface
Like to see what the interface, the gui, looks like see: *Easy DB GUI Images
Help "file" for the Program
Not a file but a page on this Wiki, this includes information on Download and Install, see: SmartPlug Help File Note that the wiki pages as pdf files may be found in .\wiki_etc, but these sometimes lag the online versions.
Python Code
Available at: Not yet, this links to a different project
- Directory Structure
- .\ all executable python code
- .\wiki_etc supplementary documentation, in particular this wiki's pages as pdf's.
Program Design
See: Easy DB Technical
Links
In this Wiki
- Easy DB Help File
- Easy DBTechnical
- Easy DBGUI Images
- Click on Python Easy DB Category below
The Internet
General
- pyHS100 · PyPI
- GadgetReactor/pyHS100: Python Library to control TPLink Switch (HS100 / HS110)
- pyhs100 – PCEasies
- There's now a pyhs100 library/utility that works pretty nicely out of the box. ... | Hacker News
Matthias Random Stuff and Related
Matthias's youtube videos originally informed me about the SmartPlugs.
- Refrigerator heat pump efficiency test - YouTube
- (54) Refrigerator heat pump efficiency test - YouTube
- Refrigerator heat pump efficiency
- Of dehumidifiers, moisture and vapour barriers - experiments
Amazon
Of course there are other sources.