0

Is there any service in which I can inject my Firebase database and build complex queries and visualise them? Real time injection and querying will be an added benefit.

  • I couldn't find any tool that work with Firebase. Could you sync the DB to any of the following DBs? MySQL, Postgres, SQL Server, AWS Redshift, Google BigQuery, Druid, H2, SQLite, Oracle, Crate, Google Analytics, Vertica. – Sonamor Oct 31 '17 at 15:59
  • @Sonamor Sync is an option. I was thinking to directly connecting to Firebase. But, if it's not possible, then I guess I can stream data to MySQL. I'm kind of inclined to Google BigQuery also, with it's Data Studio. Entire solution will be at one place. With MySQL, I have to again rely on a 3rd party dashboard. What do you suggest? – Sachin Bansal Nov 1 '17 at 7:53
  • I am using metabase, metabase.com it it's open source and on premises, you can set it up on 5 minutes if not less. It has permissions and the ability to either write SQL or use its own language. Also it gets updates regularly and its actively maintained. – Sonamor Nov 1 '17 at 7:59
1

As you said on your comment that sync is an option. I would suggest Metabase, you can set it up in 5 or less minutes. You can write your queries either in SQL, or its own Metabase Language.

You can set up permissions, it's open source, actively developed and maintained. I've used it on a MySQL Database to create dashboards. It support other DBs as well, actually all the DBs I mentioned on my comment and other drivers are being build in the community.

Also it has an option to set up variables so a user can select which data the want to retrieve.

eg. You give access to a user, to a dashboard & questions which has variables, and the user can select which data-range he wants the data from.

Personally, I am amazed how an open source project can be that good and easy to set up. That's how Open Source projects should be.

Last but not least, I would suggest to switch from it's own H2 database (it holds the dashboard data there) to MySQL for extra data protection as H2 is prone to corruptions with a sudden power cut as I found.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.