Start Free Trial

Sign In Start Free Trial

Posts tagged #postgres

Deep dives on postgres from the InvoicifyAI team.

October 10, 20252 min read

Why We Replaced Security-Barrier Views with analytics.* + SECURITY DEFINER RPCs

A practical blueprint for faster forecasts: materialized views in analytics.*, SECURITY DEFINER RPCs, and a priority-based refresh registry.

#analytics#postgres#supabase#data-engineering

Browse by tag

#accounts-receivable (19)#voice-ai (19)#automation (18)#collections (17)#small-business (17)#cash-flow (11)#AR-automation (10)#invoicing (7)#payment-collection (7)#ai-agents (6)#comparison (6)#crm (6)#service-business (6)#fintech (5)#saas (5)#smb (5)#freelancing (4)#sales (4)#ai-receptionist (3)#appointment-booking (3)#billing (3)#invoice-automation (3)#invoice-reminder (3)#invoice-reminders (3)#invoices (3)#supabase (3)#estimates (2)#invoice-generator (2)#payments (2)#after-hours (1)#ai (1)#ai-advisor (1)#ai-agent (1)#ai-ar-collections (1)#ai-collections (1)#ai-crm (1)#analytics (1)#answering-service (1)#call-script (1)#chatbot-vs-phone (1)#contractors (1)#customer-communication (1)#data-engineering (1)#deal-intelligence (1)#field service (1)#forecasting (1)#free-tools (1)#housecall-pro-alternative (1)#hvac (1)#invoice-agent (1)#invoice-follow-up (1)#jobber-alternative (1)#landscaping (1)#late-payments (1)#lead-qualification (1)#multi-tenancy (1)#physiotherapy (1)#pipeline (1)#plumbers (1)#plumbing (1)#postgres (1)#postgresql (1)#pricing (1)#product-launch (1)#productivity (1)#professional-services (1)#quote-to-cash (1)#real-estate (1)#revops (1)#roofing (1)#security (1)#software comparison (1)#templates (1)#thryv (1)#twilio (1)