This repository is a comprehensive French-language training course for PostgreSQL 18, structured as 22 progressive chapters and 7 reference annexes. It serves as educational material covering PostgreSQL fundamentals, SQL querying, advanced features, administration, performance tuning, extensions, and modern architectures. The content combines theoretical explanations with practical examples, best practices, and version-specific features (like asynchronous I/O, UUIDv7, and native OAuth). While not containing executable code or data pipelines, it provides reusable reference materials such as SQL query templates, shell scripts for backup/monitoring, configuration guides, and checklists that can be adapted across projects. The repository is actively maintained with recent updates and demonstrates low technical drift due to its focus on enduring database principles alongside version-specific annotations.
PM2 is a production process manager for Node.js applications with built-in load balancing, monitoring, and deployment capabilities. It keeps applications alive forever, enables zero-downtime reloads, and provides comprehensive system administration features. The architecture features a daemon-based design with CLI and programmatic APIs communicating via IPC (pm2-axon). Key capabilities include process clustering, log management, metrics collection, Docker integration, startup script generation, and a plugin system for extensibility. The codebase demonstrates strong engineering practices with internalized dependencies to reduce supply chain risk, comprehensive test coverage, and active maintenance with regular updates supporting Node.js >=18 and Bun.
GoTrue is a self-contained user registration and authentication API written in Go. It provides endpoints for signup, login (via email/password or OAuth2 providers like GitHub, GitLab, Google, Bitbucket, Facebook), token refresh, password recovery, email verification, and user management (CRUD for admin users). The architecture is a monolithic HTTP API using the chi router, backed by a MySQL database (via pop/v5 ORM) and a configurable mailer (SMTP or noop). It supports both single-tenant and multi-tenant deployments, with JWT-based authentication (HS256) and optional SAML SSO. The codebase is well-organized into packages: api for HTTP handlers, models for database entities, conf for configuration, mailer for email sending, and crypto for security utilities. It includes extensive unit tests and integration tests using a MySQL test database.
This repository is a collection of case studies and presentations on how various companies operate Apache Kafka in production. It provides insights into the challenges and solutions encountered by big companies when running Kafka in production.