Skill UI

A comprehensive guide to implementing advanced user behavior tracking and real-time data synchronization with Algolia. This guide demonstrates how to use the Insights API to track clicks, conversions, and views, and how to build event-driven pipelines using database change listeners (e.g., Prisma middleware) to keep your Algolia index perfectly synced with your core application data. Essential for deep search analytics and relevance tuning.

A comprehensive, production-ready reference architecture for building robust, scalable transcription services using AssemblyAI. This guide demonstrates best practices for layered system design, covering API endpoints, service logic, client management, and infrastructure integration (webhooks, database). It is ideal for designing new high-throughput speech-to-text applications.

This comprehensive guide provides a production-ready reference architecture for implementing scalable search using Algolia. It details best practices for index design (including multi-index strategies), establishing robust data pipelines from source databases, structuring the service layer (search, indexing, settings), and integrating the frontend for optimal performance.

A comprehensive skill guide for Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This resource covers the entire database lifecycle, including schema management, multi-tenant architecture, advanced DDL migrations (e.g., column operations, constraint changes), and MySQL schema migration. It provides best practices for security (IAM auth), performance tuning (query plan explainability), and safe application development.

This skill provides comprehensive guidance for working with Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers direct query execution, robust schema management, multi-tenant isolation, IAM authentication, and detailed procedures for handling complex migrations (DDL/MySQL) and optimizing query performance using explain plans. Use it for building resilient, scalable applications.

Automate the execution of integration tests against a live ClickHouse database instance within a Continuous Integration (CI) pipeline using Docker containers. This setup eliminates the need for mocks, ensuring thorough schema validation and query reliability in environments mirroring production deployments. Ideal for robust CI/CD setup and schema enforcement.

This skill provides comprehensive tools and guides for interacting with Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. Users can manage schemas, execute complex queries, handle database migrations (including MySQL to DSQL), implement multi-tenant patterns, and diagnose query performance using detailed explain plans. Ideal for backend development and database evolution.

Comprehensive guide for working with Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers the full database lifecycle, including schema management, robust data migrations (e.g., MySQL to DSQL), multi-tenant pattern implementation, IAM authentication, and advanced query plan analysis (EXPLAIN ANALYZE). It is essential for developers building scalable, resilient distributed applications.

This skill guides users through setting up robust, production-grade infrastructure on Fly.io. It covers creating and connecting to Fly Postgres clusters for reliable data storage, provisioning persistent NVMe Volumes for durable file storage, and configuring private internal networking (6PN) for secure service-to-service communication. It is essential for modern microservices requiring stable databases and persistent state.

This guide provides comprehensive strategies to significantly boost the performance and reliability of applications deployed on Fly.io. Techniques covered include eliminating cold starts (auto-stop/start), right-sizing Virtual Machines based on workload demands, implementing multi-region deployment for low latency, and optimizing connection pooling for databases. Essential for scaling modern SaaS applications.

This comprehensive guide provides step-by-step instructions for migrating and upgrading services on the Fly.io platform. It details critical processes such as migrating applications from Apps v1 (Nomad) to v2 (Machines), upgrading the flyctl CLI, performing major Postgres database version upgrades, and executing region migrations. Essential for maintaining and modernizing cloud infrastructure.

This plugin allows developers to build Framer components by syncing data from external data sources (such as APIs or databases) into Framer's Managed Collections. It serves as the primary integration pattern, handling both schema creation and item population. Use this when your design requires displaying dynamic content driven by external systems.