Overview:
Rowy is an open-source platform that provides a spreadsheet-like interface for managing databases, primarily targeting Firebase Firestore and Google Cloud Platform. It allows users to perform CRUD operations, import or export data, and sort or filter records directly from a browser-based UI. The platform also includes low-code capabilities for building cloud functions triggered by data changes, using pre-built integrations or custom code. It is designed for developers and teams working with Firebase who want a more visual and accessible way to interact with their database.
Core Features:
Spreadsheet Interface: Provides a CMS-like interface for Firestore with CRUD operations, bulk import/export (CSV, JSON, TSV), sorting, filtering, and column management (lock, freeze, resize, hide, rename).
Field-Level Cloud Functions: Enables building cloud function workflows triggered by field-level data changes, with support for NPM modules and external APIs.
Pre-Built Extensions: Includes ready-made code blocks for integrating with tools like SendGrid, Algolia, Twilio, and Bigquery, with the option to create custom blocks.
Rich Data Fields: Supports over 30 field types, including basic text, email, URL, date, checkbox, select, image, file, JSON, code, rich text (HTML), and Markdown.
Action and Aggregate Fields: Offers an Action field for clickable cloud function triggers and an Aggregate field to populate cells with values from a row’s sub-table.
Role-Based Access Control: Provides granular table-level and field-level permission management with built-in user management and customizable views for different roles.
Use Cases:
Developing Apps with Firebase: Developers can manage Firestore data visually without relying solely on the Firebase console or custom admin panels.
Automating Data Workflows: Teams can set up cloud functions that execute on data changes, integrating with external services like SendGrid for email notifications or Algolia for search indexing.
Collaborating on Database Management: Teams can control access to specific tables or fields, allowing different user roles to view or edit data as needed.
Why It Matters:
Rowy offers a practical alternative to managing Firebase Firestore through a spreadsheet-like interface, reducing the need for custom admin UIs. Its low-code approach to cloud functions, with pre-built integrations and field-level triggers, allows teams to automate workflows without leaving the browser. Because it runs on the user’s own Google Cloud Project, data and cloud functions remain within their own infrastructure, which is a key consideration for teams that need to keep data on their own GCP environment.
