#postgresql (28)
- Running and Orchestrating Containerized Services Locally
Orchestrate multi-service applications on your Apple Silicon Mac using Colima and Podman, running an API with a PostgreSQL database.
- Mastering Dolt: A Zero-to-Advanced Guide to Version-Controlled SQL
Embark on a comprehensive journey to master Dolt, the Git-for-data SQL database, from foundational concepts to advanced production practices, with practical steps and engaging challenges.
- Introduction to Dolt: Git for Your Data
Discover Dolt, the world's first Git-compatible SQL database. Learn to version control data like code, track changes, and collaborate efficiently.
- Time Travel Queries and Data Rollbacks
Master Dolt's time travel queries and data rollback features to navigate database history, audit changes, and safely undo mistakes.
- Branching and Merging Data: Collaborative Workflows
Explore Dolt's Git-for-Data branching and merging capabilities for collaborative database development, including conflict resolution and practical PostgreSQL-style data examples.
- Evolving Your Schema: Versioned Migrations
Learn how Dolt revolutionizes database schema evolution with Git-like versioning, branching, and merging for robust, collaborative, and auditable migrations.
- Project: Building a Versioned Inventory System with Doltgres
Learn to build a versioned inventory system using Doltgres, applying Git-for-Data concepts like commits, branching, and time travel to PostgreSQL-style business data for auditing and collaboration.
- Dolt Production Best Practices for CI/CD, Security, and Scalability
Learn to implement Dolt production best practices, including CI/CD for data, robust security, and scaling strategies for version-controlled databases.
- Project: Enterprise Financial Transactions Platform
Build a production-grade financial transactions platform using Dolt for version control, audit trails, and collaborative data management, integrating advanced Git-for-Data workflows and CI/CD.
- Implement Git-like Version Control in SQL with Dolt
Learn to apply Git-like version control, branching, and merging to SQL databases using Dolt, mastering schema evolution and production practices.
- Building a Production-Ready Docker Compose Stack
Learn to design and deploy a robust, multi-service application stack using Docker Compose, focusing on production best practices like security, data persistence, and image optimization.
- Establishing Secure Inter-Service Networking
Learn how to establish secure and isolated inter-service networking for your Docker Compose applications, ensuring services communicate safely and efficiently.
- Integrating a Database Service (PostgreSQL)
Learn how to integrate a PostgreSQL database service into your Docker Compose application stack, ensuring data persistence and secure communication.
- Implementing Health Checks for Service Robustness
Learn to implement robust health checks for Docker Compose services, ensuring application reliability and automatic recovery in production environments.
- Self-Hosting Trigger.dev: Taking Full Control (Advanced)
Explore the intricacies of self-hosting Trigger.dev, covering core architecture, local Docker Compose setup, and essential production deployment considerations for advanced users.
- Integrate Databases & Real-time Systems with Void Cloud Apps
Learn to integrate and configure databases and real-time systems for Void Cloud applications, enabling dynamic, data-driven apps with instant user updates.
- Database Query Optimization & Concurrency Control
Learn to diagnose slow database queries, apply indexes, understand transaction isolation, and mitigate concurrency issues for improved application performance.
- Build a Full-Stack Web App with Apple's Container Tools on macOS
Learn to containerize a full-stack web application on macOS, managing its database, backend, and frontend with Apple's native container tools.
- Launch Your First PostgreSQL Testcontainer for Integration Tests
Learn to programmatically launch your first PostgreSQL database container with Testcontainers for robust integration tests using Java, JS, and Python.
- 4. Core API: Generic Containers and Specific Modules
Dive into Testcontainers' Core API, exploring Generic Containers for any Docker image and specialized Modules for popular services like PostgreSQL and Kafka across Java, JavaScript, and Python.
- Testing PostgreSQL and Redis with Testcontainers
Use Testcontainers to test applications with real PostgreSQL and Redis databases, creating isolated environments in Java, Python, and JavaScript.
- Test Spring Boot Microservices with Testcontainers Integration
Learn to build and integration test Spring Boot microservices using Testcontainers to create realistic environments for databases and message brokers.
- 16. Project: Data Pipeline Testing with Python (Kafka & DB)
Build and test a simple data pipeline in Python using Testcontainers to spin up isolated Kafka and PostgreSQL instances. Learn end-to-end integration testing for complex data flows.
- 15. Project: API Gateway and Backend Testing with Node.js/TypeScript
Dive into a real-world project demonstrating advanced integration testing for an API Gateway and backend services using Testcontainers with Node.js/TypeScript, covering PostgreSQL and Redis.
- Data Persistence: PostgreSQL Integration & Migrations
Learn how to integrate PostgreSQL with a Node.js application using TypeORM and migrations for data persistence.
- Project: Database & Caching with Docker Compose
Learn how to integrate a database and caching service into your Dockerized application using PostgreSQL and Redis.
- Deploying to the Cloud (AWS/Azure)
Learn how to deploy a Spring Boot application to AWS and Azure, ensuring scalability and resilience.
- Deploy Next.js & Node.js Apps on VPS with PostgreSQL & Cloudflare
Learn to deploy a modern web application using Next.js, Node.js, and PostgreSQL on a VPS, integrating Cloudflare for performance and scalability.