rfkortekaas questions

rfkortekaas answers

• SQLAlchemy: Query a JSON column (PostgreSQL) containing array and counting matches
• use Pydantic to create CSV line
• bulk insert sqlalchemy core with on conflict update
• group by and count in sqlalchemy
• Flask SqlAlchemy: Returning None for JSON type inserts 'null' string, not real NULL
• Skyfield visible area underneath EarthSatellite
• SQLAlchemy query with where with comparison on tuple of multiple columns
• Python sqlite - quotes usage in execute() method
• When to use `session_maker` and when to use `Session` in sqlalchemy
• Send logs to Slack from Python