Home Projects Portfolio Dashboard Export PDF Log in

Languages

English
144

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,

Securing Admin Access: Building Robust Authentication with Supabase and NestJS

Ensuring the integrity and security of administrative interfaces is paramount for any application. Without strong authentication mechanisms, sensitive data and critical configurations are vulnerable. This was a core focus for the vive-tu-mente-preview project, where we recently integrated a dedicated admin authentication flow.

The Challenge

Previously, administrative access might have