updating requirements and readme

1 files changed, 36 insertions, 0 deletions

diff --git a/README.md b/README.md
index 9913fa6..c54b359 100644
--- a/README.md
+++ b/README.md
@@ -4,6 +4,42 @@ This is a small collection of scripts I use to collect information about my
 energyconsumption.
 
 
+## Set up venv
+
+```
+python3 -m venv venv
+source venv/bin/activate
+pip3 install -r requirements.txt
+```
+
+
+## Handling pip
+
+```
+# Create requirements.txt
+pip3 freeze > requirements.txt
+
+# Show outdated packages
+pip3 list --outdated
+
+# Upgrade package
+pip3 install -U name
+
+# Upgrade everything
+pip3 install -U -r requirements.txt
+
+# Update requirements.txt
+pip3 freeze > requirements.txt
+```
+
+
+## Schema
+
+Install schema
+``` 
+psql el < schema.sql
+```
+
 
 schema.sql created with:
 ```