Difference between revisions of "Python Easy DataBase Project"

From OpenCircuits
Jump to navigation Jump to search
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 ]'''
  
=== 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]]
+
[[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.

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

The Internet

General

Matthias Random Stuff and Related

Matthias's youtube videos originally informed me about the SmartPlugs.

Amazon

Of course there are other sources.