Hacker News new | ask | show | jobs
Show HN: GUI client for Cloud Firestore with JavaScript query editor, table view (firefoo.app)
11 points by xathis 1860 days ago
5 comments
xathis 1860 days ago
Hi HN! About a year ago we started using Cloud Firestore at work. And while I love it for its amazing realtime and effortless scaling capabilities, I grew more and more frustrated with the limitation in tooling around it. No way to query from shell, export collections, rename docs, edit nested field names, …

One day I had enough and pitched an idea to a friend: to create the experience I wanted to see. Luckily he was all in and we continued to spend our Corona lockdown hacking together an Electron app in TypeScript that makes my work delightful again! A few months later and we're glad to announce that Firefoo is now live for everyone to use!

Some features include

- Table View

- Export to JSON and CSV

- JavaScript Query Shell

- Batch Edit Documents

- Geo Point Map

We'd love to hear your thoughts and will be around in the comments all day!

- Mathis & Moritz

link
mritchie712 1859 days ago
Looks great! How did you make the decision to go Electron vs. a web app?
link
xathis 1859 days ago
Thanks! It's for security reasons. We want to keep all the data locally on the user's computer, so your data will never touch our or a third party's server (other than Google). If we piped the requests through a backend, nobody could verify that we're not reading the content of your data or secrets.
link
sichtlinkair 1860 days ago
Wow really nice! I also have some contact with Firebase at my job and the web client is really poor and frustrating to use.

I wonder why Google hasn't done this yet? Would offer an even stronger case for Firebase

link
gbourne 1860 days ago
Congrats - this is definitely needed since the Firestore default GUI is so limited. I suggest an FAQ and include the Firestore query quota costs. If someone gets 1 million docs back it will go against their monthly quota.
link
xathis 1860 days ago
Thanks! That's a good idea, we'll put info about the numbers of read/write/delete operations that Firefoo uses up somewhere. For long-running tasks (export, delete/rename colls) we show those numbers in the Tasks popup already but it'd be nice to show them up front!
link
asaddhamani 1860 days ago
I've looked for something like this in the past, and this looks really cool, but I don't see why this has to be a subscription
link
dougpy 1859 days ago
Matches what i've been looking for! Will Google accept this?
link
xathis 1859 days ago
Why shouldn't they? We haven't been in contact with anyone from Google yet but I expect they are happy about tooling around their products!
link