Saúl Sondón saulin18

Hello software developers,

Please check your code to ensure you're not making one of the following mistakes related to cryptography.

I. General Mistakes

Writing your own home-grown cryptography primitives (For example: Mifare Classic)
- Exception: For the sake of learning, but don't deploy it in production.
Using a fast hash function (e.g. MD5, SHA256) for storing passwords. Use bcrypt instead.
Not using a cryptographically secure random number generator

Python testing reference

This document is a reference for common testing patterns in a Django/Python project using Pytest.

Contents:

Set-up and tear-down

Complete Guide to Pytest: From Basics to Advanced

Pytest is a powerful Python testing framework that is widely used for unit testing, integration testing, and functional testing. This guide will take you step by step from basic to advanced features of Pytest, providing a comprehensive understanding of its capabilities.

INTRO

Concurrency is a domain I have wanted to explore for a long time because the locks and the race conditions have always intimidated me. I recall somebody suggesting concurrency patterns in golang because they said "you share the data and not the variables".

Amused by that, I searched for "concurrency in golang" and bumped into this awesome slide by Rob Pike: https://talks.golang.org/2012/waza.slide#1 which does a great job of explaining channels, concurrency patterns and a mini-architecture of load-balancer (also explains the above one-liner).

Let's dig in:

Goroutines

Drizzle ORM PostgreSQL Best Practices Guide (2025)

Latest Drizzle ORM features and optimal schema patterns

Major 2025 Update: PostgreSQL now recommends identity columns over serial types. Drizzle has fully embraced this change.

import { pgTable, integer, text, timestamp, varchar } from 'drizzle-orm/pg-core';

	-- 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%'

	from alembic import config
	from alembic import script
	from alembic.runtime import migration
	import sqlalchemy

	import exceptions


	engine = sqlalchemy.create_engine(DATABASE_URL)
	alembic_cfg = config.Config('alembic.ini')

	MIT License

	Copyright (c) 2022-present, cayter

	Permission is hereby granted, free of charge, to any person obtaining a copy
	of this software and associated documentation files (the "Software"), to deal
	in the Software without restriction, including without limitation the rights
	to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
	copies of the Software, and to permit persons to whom the Software is
	furnished to do so, subject to the following conditions:

	// This is an example table using the GenericTableComponent.tsx
	// mockData is generated randomly

	import { Image, Text, Checkbox, Badge, Box, Flex } from "@chakra-ui/react";
	import { ColumnDef } from "@tanstack/react-table";
	import React from "react";
	import GenericTable from "@/frontend/core/components/GenericTable";
	import TransitActionsButtonGroup from "./TransitTableActions";
	import { formatDate } from "@/frontend/core/utils/formatDate";
	import { ChevronDownIcon, ChevronRightIcon } from "@chakra-ui/icons";

	// This is an example table using the GenericTableComponent.tsx
	// mockData is generated randomly

	import { Image, Text, Checkbox, Badge, Box, Flex } from "@chakra-ui/react";
	import { ColumnDef } from "@tanstack/react-table";
	import React from "react";
	import GenericTable from "@/frontend/core/components/GenericTable";
	import TransitActionsButtonGroup from "./TransitTableActions";
	import { formatDate } from "@/frontend/core/utils/formatDate";
	import { ChevronDownIcon, ChevronRightIcon } from "@chakra-ui/icons";