Home Projects Portfolio Dashboard Export PDF Log in

Languages

English
189

Latest Updates

Documenting code, one commit at a time.

Supabase 10 posts
×

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.

Streamlining Article Proposals: Building a Submission API with NestJS and Supabase

The vive-tu-mente-preview project is enhancing its content pipeline by introducing a new feature: the ability for users to submit article proposals directly. This capability is crucial for fostering community engagement and gathering fresh content ideas efficiently. Implementing such a feature requires a robust backend API to handle submissions, validate data, and persist it reliably.

Fortifying Admin Access: Implementing a Protected Endpoint with NestJS and Supabase

In any application, the administrative backend is a critical asset, requiring robust security measures. Unprotected administrative endpoints are an open invitation to vulnerabilities, leading to unauthorized data manipulation or system compromise. For our vive-tu-mente-preview project, ensuring that only authenticated and authorized administrators can access sensitive operations was paramount.

Implementing Robust Administrative Authentication in NestJS with Supabase

The vive-tu-mente-preview project recently received an important security upgrade: the addition of administrative authentication. This enhancement ensures that critical administrative functionalities are protected, accessible only by authorized personnel, and lays a secure foundation for managing the application.

The Challenge of Admin Access

Unsecured administrative interfaces are a major

Building a Robust Articles API with NestJS and Supabase

The vive-tu-mente-preview project recently integrated a new articles API. This update was crucial for managing and delivering content dynamically, laying the groundwork for a scalable content platform. This post delves into the architectural choices and implementation approach that powered this new feature.

The Challenge

When building new API endpoints, especially for content delivery,