Home Projects Portfolio Dashboard Export PDF Log in

Languages

English
144

Latest Updates

Documenting code, one commit at a time.

SQL 10 posts
×

Building an API for Educational Cards with NestJS and Supabase

Managing dynamic, engaging content is crucial for any platform aiming to educate or inform. Without a robust and well-structured system, content delivery can quickly become a bottleneck, hindering user engagement and administrative efficiency.

In the vive-tu-mente-preview project, we've recently enhanced our capabilities by implementing a new feature for managing "educational cards.

Streamlining Information: Adding FAQ Management with NestJS and Supabase

The vive-tu-mente-preview project, a platform dedicated to fostering mental well-being, recently received a crucial update: the integration of a comprehensive Frequently Asked Questions (FAQ) management system. This new feature allows administrators to easily add, update, and remove FAQs, providing users with quick access to common information without needing direct support.

Streamlining Dynamic Content: Building a Testimonials API with NestJS and Supabase

The vive-tu-mente-preview project recently gained a powerful new feature: dynamic testimonial management. This enhancement moves away from static content, allowing for flexible updates and better engagement.

The Situation

Initially, the vive-tu-mente-preview application relied on static content for displaying customer testimonials. While simple, this approach presented limitations: any

Adding a Simple Visit Counter API with NestJS and Supabase

Understanding user engagement is crucial for any project, even a preview site like vive-tu-mente-preview. While full-fledged analytics platforms can be overkill for simple needs, a lightweight visit counter provides valuable insights into content popularity. This post details the implementation of a basic visit counter API to track page views, leveraging NestJS for the API logic and Supabase

Database Evolution: Adding Article Content with SQL Migrations in Supabase

Project Context

In the vive-tu-mente-preview project, focused on delivering engaging content, a recent development involved laying the groundwork for a new feature: content articles. To support this, a crucial first step was to establish the necessary database structure. This involved creating a dedicated table to store article data, a common requirement for any content-driven application.

Standardizing Supabase Migrations: The Power of Root-Level Organization

For any project involving a database, managing schema changes is crucial. In our vive-tu-mente-preview project, a recent chore commit brought a significant improvement to our development workflow: centralizing Supabase migrations to the project's root directory. This seemingly small organizational change has profound implications for consistency, team collaboration, and deployment reliability.

0 SQL Supabase

Empowering Dynamic Content: A Supabase Migration for Editable Data

Introduction

In the vive-tu-mente project, a platform designed for mental wellness and personal growth, content is king. To keep our platform engaging and up-to-date, the need for dynamic, editable content became paramount. This led to a crucial database migration aimed at establishing the infrastructure for managing content that can evolve without requiring application code changes.

Ensuring Data Integrity: Making Supabase Triggers Idempotent

Building robust applications requires careful attention to data integrity, especially when working with event-driven systems. In our vive-tu-mente-preview project, we encountered a common pitfall with database triggers: non-idempotency.

The Challenge with Triggers

Database triggers are powerful tools for automating tasks, like updating related tables or logging changes.