Daniel Ripoll JustDevZero

Trust me I was a devops before It was cool. Full-time ironic. Developer and only a bit human.

pkpinto / SQLSource.py

Last active July 28, 2021 11:13

	# coding: utf-8

	from contextlib import contextmanager
	import logging

	import pandas as pd
	from sqlalchemy import create_engine
	from sqlalchemy.orm import scoped_session, sessionmaker

Jaza / Private-pypi-howto

Last active July 2, 2023 16:24

Guide for how to create a (minimal) private PyPI repo, just using Apache with directory autoindex, and pip with an extra index URL.

letmaik / models_committed.py

Created May 22, 2014 14:54

delete, insert, update events after a commit for SQLAlchemy

	from sqlalchemy import create_engine, event, orm
	from sqlalchemy.orm import sessionmaker
	from sqlalchemy.orm.session import Session as SessionBase, object_session
	from sqlalchemy.event.api import listen

	# The following adds delete, insert, and update events after successful commits.
	# SQLAlchemy provides only events after flushes, but not after commits.
	# The classes are adapted from Flask-SQLAlchemy.
	# see also https://stackoverflow.com/a/12026787/60982

rgreenjr / postgres_queries_and_commands.sql

Last active November 17, 2024 13:10

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'