Difference between revisions of "Python Easy DataBase Project"

From OpenCircuits
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
= Introduction/Status=
 
= Introduction/Status=
  
'''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}" )
+
'''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 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
+
'''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.
 
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. [[SmartPlug Help File]].  Screen shots and more at: '''[[SmartPlug GUI Images]]'''.
+
'''Help File:'''  Including install and configuration. '''[[Easy DB Help File]]'''.  Screen shots and more at: '''[[Easy DB GUI Images]]'''.
  
'''More Documentation:'''  See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )
+
'''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]''' )
  
 
= Graphical User Interface =
 
= Graphical User Interface =
Line 24: Line 24:
  
 
= Python Code =
 
= Python Code =
Available at:
+
Available at: Not yet, this links to a different project
  
 
*'''[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 38: Line 38:
  
 
== In this Wiki ==
 
== In this Wiki ==
*[[SmartPlug Help File]]
+
*[[Easy DB Help File]]
*[[SmartPlug Technical]]
+
*[[Easy DBTechnical]]
*[[SmartPlug GUI Images]]
+
*[[Easy DBGUI Images]]
*Click on Python SmartPlug Category below
+
*Click on Python Easy DB Category below
  
 
== The Internet ==  
 
== The Internet ==  
=== General ===
+
None yet, ever?
  
*'''[https://pypi.org/project/pyHS100/ pyHS100 · PyPI ]''' 
+
[[Category:Python Projects]] [[Category:Python Easy DB]] [[category:Python]]
*'''[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]]
 

Latest revision as of 12:29, 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.

Introduction/Status[edit]

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[edit]

Like to see what the interface, the gui, looks like see: *Easy DB GUI Images

Help "file" for the Program[edit]

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[edit]

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[edit]

See: Easy DB Technical

Links[edit]

In this Wiki[edit]

The Internet[edit]

None yet, ever?