Tutorials – Postgres
Aggregate Functions for Postgres
In this lesson we learn how to use the following Postgres aggregate functions: AVG function and SUM function, which are both aggregate functions in PostgreSQL. We also explore a statement required for filtering of aggregated data; “HAVING”.
Backup and Restore with Postgres and Python
Backup and Restore with PostgreSQL, Python, and HTML.
Backup Your Postgres
Backup Your PostgreSQL for a potential restore.
Copy tables in Postgres using Python
Duplicate tables from your PostgreSQL database using Python.
Creating and Deleting Postgres Tables
Write a Python app to create and Delete PostgreSQL tables.
Edit Columns with Postgres and Python
Edit Columns with PostgreSQL and Python
Foreign Keys in Postgres
Foreign Keys in PostgreSQL.
Forum Login with Python and Postgres
Forum Login with Python and PostgreSQL.
Forum Messages with Python and Postgres
Manage Forum Messages with Python and PostgreSQL.
Forum Post with Python and Postgres
Manage Forum Posting with Python and PostgreSQL.
Forum Registration with Python and Postgres
Forum Registration with Python and PostgreSQL.
Get Blob from Postgres with Python
For storing and retrieving images and other large data to and from a database. Get blob data type from Postgres using Python.
Get Records from Postgres using Python
Get Records from Postgres using Python.
Group By in Postgres
Using Group By in PostgreSQL.
Image upload with Python and Postgres
Upload images to Postgres using Python.
Injection Prevention for Postgres
Injection Prevention for PostgreSQL.
Limit Rows Returned in Postgres
Return a limited recordset to be returned in Postgres using Python.
List Tables from Postgres with Python
See a list of all tables in your PostgreSQL database using Python.
Loop Types for Postgres with Python
Explanation of various Loop Types for Postgres, using Python scripting.
Machine Learning using Python and Postgres
Machine Learning using Python and PostgreSQL.
Make a game in Python – Draw Sprites
Make a game in Python – Draw Sprites.
Make a game in Python – Draw the Screen
Make a game in Python – Draw the Screen.
Make a game in Python – Move Monsters
Make a game in Python – Move Monsters.
Make a game in Python – Move Player
Make a game in Python – Move Player.
Make a game in Python – Player Login
Make a game in Python – Player Login.
Make a game in Python – Player Registration
Make a game in Python – Player Registration.
Make a game in Python – Save Game
Make a game in Python – Save Game to Postgres database.
Make a game in Python – Sound
Make a game in Python – add sounds and music to your game!
Make a game in Python – Sprite Collisions
Make a game in Python – Sprite Collisions.
Make a game in Python – Sprite Intelligence
Make a game in Python – Sprite Intelligence. How to make the monsters “smart”.