Categories
python python performance

Python Simple Asyncio [Part 1]

Is asyncio simple? Some ideas: https://charlesleifer.com/blog/asyncio/ https://techspot.zzzeek.org/2015/02/15/asynchronous-python-and-databases/ https://lucumr.pocoo.org/2016/10/30/i-dont-understand-asyncio/ Came across a well written and simple post about Async programming in Python. A good place to learn about python is always the documentation – here is the documentation for asyncio There is also this Python and Async simplified post. Many of the examples of asyncio can […]

Categories
sqlachemy

SQLAlchemy: Filtering a many-to-many on a field but keeping all results of that field

Going Back to Basics In models.py: “”” Basic Product Category models using reference from: https://docs.sqlalchemy.org/en/14/orm/relationship_api.html#sqlalchemy.orm.relationship “”” from sqlalchemy import Column, ForeignKey, Table, Integer, Boolean, String from sqlalchemy.orm import declarative_base, relationship Base = declarative_base() category_products = Table( “category_products”, Base.metadata, Column(“product_id”, ForeignKey(“products.id”), primary_key=True), Column(“category_id”, ForeignKey(“category.id”), primary_key=True), ) class Products(Base): __tablename__ = “products” id = Column(Integer, primary_key=True) label […]

Categories
python

Python Implicit Namespace Packages

A very confusing topic is python imports and paths. One area that makes it more confusing was the introductions of implicit namespace packages. https://peps.python.org/pep-0420/#differences-between-namespace-packages-and-regular-packages These are packages that are found even without an __init__.py. A folder can be created on the python path and that folder automatically becomes a python package. Not sure why or […]

Categories
postgres

Postgres: Querying Arrays

Quering tables that contain arrays can be tricky in postgres. The Postgres docs: Array functions provide a good explanation but it is good to practically run the queries and see the results. There is documention about arrays in general from postgres. Caveats: Array Types An important thing to note is that arrays being compared need […]

Categories
Uncategorized

How to Raise an Objection to Increased Property Rates Joburg

The city of Joburg is again rerating the market value of properties in the City. The previous time this was done was in 2018 – where rate increases became effective July 2018. Use the objections.joburg.org.za website to object. The deadline for objecting is end of March 2023. The userguide on how to object is on […]