Difference between revisions of "Python Easy DataBase Project"

From OpenCircuits
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
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. '''[[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 ( '''[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]''' )
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?