Imagine this, you are building a startup and have a small engineering team focused on the product. As you build and grow, you probably run into some of the following challenges and requirements.
⚙️ Operational Portal — Interface to allow for easy access to database for non-technical/operational users — who has used the most recent feature, who is your most valuable customer, custom KPIs tracking etc
🙅🏻♀️ Access Control — Setup and maintain access control to the data to different internal/external user groups — CRUD tasks, data perms and protection rules, user groups management
👾 Automation Tasks — Build automation tasks and cloud functions on the data to trigger events such as slack messages on new customer signup, send emails alert for bugs… and maybe woof ;)
📈 Data Validation — Validate data manual data entered for errors, alerts because they cause production errors
Do you invest your precious engineering resource to build internal tools and automation tasks or invest in growth of your product? The answer is obvious: everything takes a backseat compared to your revenue driver.
We researched and did not find a compelling solution focused on Google Firestore as the core infrastructure, so we decided to build it as a side project and make it available to the world 🤗
Firetable, an open source self hosted platform that allows you to leverage the scalable infrastructure of Google Firestore with the ease and simplicity of a spreadsheet.
I know there will be a lot of questions, so let me try answering them preemptively here 🙏
How to get started?
You can get started here.
Hit the ground running on your existing datasets, using our simple step-by-step guided setup wizard screens.
How are we different?
👉 From other spreadsheet like UI products (Google Docs, Airtable, and similar)
In terms of UI, Firetable is highly accessible and intuitive similar to other platforms. However,
📲 Where it shines is in its LIVE nature. Firetable is connected to your data source on Firebase and any changes to the data on the UI is reflected on your data store directly. Say goodbye to emailing “FINAL” Excel sheets. This gives immense power in terms of a true operational dashboard to your non-technical teams. But as they say with great power comes great responsibility, you do not want to mess up your production data!
👉 From other products in internal tools space
We are super focused on Google Firebase and optimised for it. Unlike other internal products out there that offer a wide array of data connections and thereby diluted in feature richness of the product. Highlighting some below:
Wide range of unique data columns ranging from as JSON, Images, Single/Multi selects to connected tables, subtables, trigger scripts, derivative functions, users ids (created by, updated by), action buttons and more! With over 25 different field types and intuitive UIs, you can monitor and update just about any data type you can imagine.
Fully functioning cloud functions and scripting support with code action column — run and undo support.
We are also open-source 🤗 That means you can manage and self host it yourself and no worry about data privacy concerns, you fully own and control your data!
Who are our users?
Developer: Build and ship products fast. Firetable enables developers to setup data infrastructure quickly.
Ops: Take actions on day to day operational tasks with spreadsheet like interface.
Editor: Monitor and update data to allow for high control on your product
Admin: Super users who can create data tables and control access
So if this is you and would like to try out or have any questions, please connect via my twitter DMs are always open 🙌