Editing Python Easy DataBase Project

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 2: Line 2:
 
= Introduction/Status=
 
= 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}" )
+
'''Purpose:''' This is a Graphical User Interface Application (actually two applications ) is to control TP-LINK HS110 Smart Plug w/Energy Monitoring (*'''[https://www.amazon.com/gp/product/B0178IC5ZY/ref=ppx_yo_dt_b_asin_title_o06_s00?ie=UTF8&psc=1 TP-LINK HS110 Smart Plug w/Energy Monitoring - - Amazon.com ]''' ) graph and otherwise process the data.  The application uses the pyHS100 library code.  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
+
'''Program Status:''' ( Program now Ver7 ) More or less beta, seems to work fairly well if not stressed.  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.
 
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  
 
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  
Line 11: Line 11:
 
'''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.
 
'''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]]'''.
+
'''Help File:'''  Including install and configuration. [[SmartPlug Help File]].  Screen shots and more at: '''[[SmartPlug GUI Images]]'''.
  
'''More Documentation:'''  Not ready yet, this is false as of now See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )
+
'''More Documentation:'''  See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )
  
 
= Graphical User Interface =
 
= Graphical User Interface =
Line 24: Line 24:
  
 
= Python Code =
 
= Python Code =
Available at: Not yet, this links to a different project
+
Available at:
  
 
*'''[https://github.com/russ-hensel/smart_plug/tree/master russ-hensel/smart_plug: Program Source ]'''
 
*'''[https://github.com/russ-hensel/smart_plug/tree/master russ-hensel/smart_plug: Program Source ]'''
Line 33: Line 33:
  
 
= Program Design =
 
= Program Design =
See: [[Easy DB Technical]]
+
See: [[SmartPlug Technical]]
  
 
= Links =
 
= Links =
  
 
== In this Wiki ==
 
== In this Wiki ==
*[[Easy DB Help File]]
+
*[[SmartPlug Help File]]
*[[Easy DBTechnical]]
+
*[[SmartPlug Technical]]
*[[Easy DBGUI Images]]
+
*[[SmartPlug GUI Images]]
*Click on Python Easy DB Category below
+
*Click on Python SmartPlug Category below
  
 
== The Internet ==  
 
== The Internet ==  
None yet, ever?
+
=== General ===
  
[[Category:Python Projects]] [[Category:Python Easy DB]] [[category:Python]]
+
*'''[https://pypi.org/project/pyHS100/ pyHS100 · PyPI ]''' 
 +
*'''[https://github.com/GadgetReactor/pyHS100 GadgetReactor/pyHS100: Python Library to control TPLink Switch (HS100 / HS110) ]'''
 +
*'''[https://pceasies.com/blog/tag/pyhs100/ pyhs100 – PCEasies ]'''
 +
*'''[https://news.ycombinator.com/item?id=18576009 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.
 +
*'''[https://www.youtube.com/watch?v=0LVKUxtK4Wg Refrigerator heat pump efficiency test - YouTube ]'''
 +
*'''[https://www.youtube.com/watch?v=0LVKUxtK4Wg (54) Refrigerator heat pump efficiency test - YouTube ]'''
 +
*'''[https://woodgears.ca/heating/fridge.html Refrigerator heat pump efficiency ]'''
 +
*'''[https://woodgears.ca/physics/humidity.html Of dehumidifiers, moisture and vapour barriers - experiments ]'''
 +
 
 +
=== Amazon ===
 +
Of course there are other sources.
 +
*'''[https://www.amazon.com/gp/product/B0178IC5ZY/ref=ppx_yo_dt_b_asin_title_o06_s00?ie=UTF8&psc=1 TP-LINK HS110 Smart Plug w/Energy Monitoring - - 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 ]'''
 +
 
 +
=== Youtube Not Involving Python ===
 +
Or maybe some Python ??
 +
*'''[https://www.youtube.com/watch?v=9gTDlD1whdw (54) ESP8266 Smart Power Plug: Control and Monitor device from Internet - YouTube ]'''
 +
 
 +
 
 +
[[Category:Python Projects]] [[Category:Python SmartPlug]] [[category:Python]]

Please note that all contributions to OpenCircuits may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see OpenCircuits:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)