Ever get notified about issues, bugs and problems by people – but also have the data in elasticsearch. There is a tool called elastalert that can alert on data in your elasticsearch cluster. Warning Elastalert 2 only supports recent things… Elasticsearch 6 is not supported, only: Elasticsearch 7.x or 8.x, or OpenSearch 1.x or 2.x […]
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 […]
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 […]
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 […]
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 […]