Skip to content

BigData-Appspot/firetable

 
 

Repository files navigation

Firetable

Firetable is an open-source platform to unlock the full potential of Google Firestore

With Firetable, non-technical team members can access Firestore data with a permission controlled intuitive UI while developers can build fast on the GCP stack (manage their data models, create and deploy cloud functions, connect to third party apps via webhooks and APIs...and more!) 🚀

Firetable demo GIF


Stay Up-to-Date

Watch the releases of this repository to be notified for future updates

drawing

Features

  • Intuitive spreadsheet like interface for Firestore. With Firetable UI you can view and directly edit the data in Firestore but not just that, you can completely manage your existing data model or create from scratch.

    • CRUD operations on your data - Add, edit, and delete rows
    • Create table collections, add column fields
    • Sort and filter data
    • Resize and rename columns
  • Rich set of data fields. 29+ field types supported and growing

    • Basic types: Short Text, Long Text, Email, Phone, URL…
    • Custom UI pickers: Date, Checkbox, Single Select, Multi Select…
    • Uploaders: Image, File
    • Rich Editors: JSON, Code, Rich Text (HTML)
  • Default values and Required fields. You can assign default values to any Firestore fields on row creation (null, static or undefined). You can also define which fields are required for a row creation.

  • Permission controlled views. You can customize who sees what data and what action they can take with powerful set of access controls based on custom user roles. Read more

  • Bulk data actions. You can import and export your Firestore data from/to CSV files.

  • Supercharge your database with your own scripts.

    • Action field: trigger any Cloud Function
    • Derivative field: populate cell with value derived from the rest of the row’s values
    • Aggregate field: populate cell with value aggregated from the row’s sub-table
  • Integrations with external services.

    • Connect Table uses Algolia to get a snapshot of another table’s row values
    • Connect Service uses any HTTP endpoint to get a cell value

Firetable makes it easy to use key Firebase products

Cloud Firestore Firebase Authentication Firebase Functions Firebase Hosting Firebase Storage

Getting started

To set up Firetable, you must be comfortable with working with the command line and have basic how to use npm.

Documentation

We’re still working on improving our documentation and writing more beginner-friendly guides.

Documentation on GitHub Wiki →

Issues

Open issues

Create issues and bug reports here.
Make sure to provide console log outputs and screenshots!

Roadmap and feature requests


Contributing 🙌

We welcome any contributions from the open source community.

  • Good First Issues project is a good place to start for contributing to Firetable.
  • For new feature or enhancement, please create an issue first or send us a message on Discord so that we can discuss and guide you as needed ahead of you starting the work.

About

Unlock the full potential of Google Firestore with Excel/Google Sheets like UI.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • TypeScript 98.9%
  • Other 1.1%