infrai vs Supabase

SMS Delivery Status Polling for Waitlist Outage Alerts

The article advises that teams should only rely on an SMS API for critical outage alerts if their backend can poll delivery status and own retry, escalation, cancellation, and timing logic. Delivery reliability and timing constraints drive the design: define service-level objectives, record four reliability invariants (application-owned send IDs, bounded/idempotent retries, defined next actions per delivery state, and incident recovery that suppresses obsolete alerts), and treat providers as transport adapters. The author shortlists Twilio, Vonage, Sinch, and Infrai for evaluation, provides load-testing guidance, and includes a runnable Python example that polls SMS status, honors Retry-After, and applies backoff. The recommended architecture keeps durable incident state in the application and makes provider polling a replaceable adapter.

• Choose an SMS API for critical outage alerts only if the backend can poll delivery status and implement retry, escalation, cancellation, and timing logic.
• Four reliability invariants: application-owned identifier per send; bounded and idempotent retries; every delivery state must map to a defined next action; incident recovery must stop obsolete alerts.
• Article shortlists Twilio, Vonage, Sinch, and Infrai as candidate SMS providers to validate against the same decision record.

Backend-Owned SMS OTP: Cooldowns and Attempt Caps

This technical blog post explains best practices for implementing passwordless phone logins using SMS OTPs in an Express/Node.js backend. It argues that the backend must own resend cooldowns, verification attempt counters, and anti-abuse policies (not the client), model the authentication state machine (ready → code_sent → verified/expired/locked), persist minimal authoritative state, use atomic database transitions, emit single transition events for observability, and use idempotency keys and retry/backoff handling when calling providers. Provider choices (Twilio, Firebase, Auth0, Amazon SNS, Infrai) are discussed with trade-offs between managed verification and owning template/state-machine responsibilities.

• The article recommends the Express/Node.js backend should own SMS OTP resend cooldowns, maximum verification attempts, and anti-abuse counters rather than trusting the client.
• Designs should expose explicit states: send-code, verify-code, resend-code, and lockout; persist minimal authoritative state (challenge ID, phone identity, expiry, next-send time, counters, lockout).
• Use atomic database transitions and idempotency keys tied to admitted transitions to prevent race conditions and duplicate sends.

Bulk LLM Text Classification with Tenant Chargeback

The article recommends treating tenant accounting as the primary artifact when performing bulk CSV moderation with LLMs: create a tenant-owned job with stable row IDs, estimate costs before submission, submit asynchronous batch classification (preferably chat classification with a closed label set), and attach returned results and export references to the same tenant ledger for reconciliation. The author provides an example TypeScript batch submission pattern (idempotency derived from the validated request, bounded retries, handling 429), argues for allocating costs at the job boundary and reconciling at the row level, and discusses when to call providers directly (Infrai, OpenAI, Anthropic, Google Gemini) versus renting batch execution.

• Author recommends asynchronous chat classification with a closed label set and using a tenant ledger as the primary artifact for billing and reconciliation.
• Pattern: create a tenant-owned job with a stable ID per accepted CSV row, show an estimate before submission, persist the provider batch identifier, then reconcile results and costs back to the job and rows.
• TypeScript example demonstrates deriving an idempotency key from the validated batch-request.json, honoring Retry-After for HTTP 429, and using bounded exponential backoff.

Supabase is now available in Gemini Enterprise

Connect Supabase to Gemini Enterprise and query your Supabase projects with natural language, right inside the platform.

Build SaaS Apps with Claude Code, Clerk, and Supabase

This technical walkthrough guides product managers on how to build, secure, and monetize a full-stack B2B2C SaaS application using AI agents without writing code. Using a case study called AskOne—a live Q&A alternative to Slido—the tutorial details a universal, multi-step workflow. The process utilizes Anthropic's Claude Code to generate design layouts, establish design system tokens, and implement functional React components. The system integrates Clerk for user authentication and recurring subscription billing configuration, alongside Supabase as the backend database connected securely via Claude's Model Context Protocol (MCP) server framework.

• The author developed Grok Build for VS Code, achieving over 105,000 installations and 37,000 monthly active users (MAU).
• AI agents autonomously wrote 5,094 automated end-to-end integration and unit tests for the software in three months.
• The workflow utilizes a recommended B2B stack consisting of Next.js, Clerk, and Supabase.

Safely Drop All PostgreSQL Tables (2026)

A technical how-to describing safe methods to drop all tables in a PostgreSQL database. The article shows a one-command reset (DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ...), explains PostgreSQL 15 default changes that revoke CREATE from PUBLIC and set public's owner to pg_database_owner (which can cause permission errors), and details Supabase-specific risks (Dropping public can remove Supabase-managed schemas and extensions). It gives variants to preserve extensions (reinstall extensions or drop tables only via a DO-block loop), recommends wrapping resets in transactions for local dev, and provides a production safety checklist: take backups, confirm connection, block connections, and restore from pg_dump/pg_restore rather than dropping schema in prod.

• DROP SCHEMA public CASCADE removes the public schema and all dependent objects (tables, views, sequences, functions, triggers).
• PostgreSQL 15 defaults: PUBLIC no longer has CREATE by default, and the owner of public is pg_database_owner, which can cause 'permission denied for schema public' after recreating the schema.
• On Supabase, DROP SCHEMA public CASCADE can cascade into Supabase-managed schemas (auth, storage, realtime, graphql) and break the project; use 'supabase db reset' for dev and restore from backups for production.