Grafana Dashboard

[lenaxia]

Hi all, the core dashboard wasn't quite cutting it for my needs, so I created a grafana dashboard that is better suited to operational use.

Here's a screen shot:

I have this set up on an Amazon Fire Tablet 8 HD using Fully Kiosk with motion sensing so it lights up whenever my wife sits down to feed. This requires to be using the postgres backend for babybuddy.

It comes in handy because for instance, the time since last feed actually tells you that, AND time since you started feeding if you're mid feed, so you can track time.

Of note:

• in the timeline, the different colors have meaning:
  • Feeding: orange is bottle feeding, pale yellow is breast feeding
  • diaper: red is solid, pink is wet, purple is both
  • sleeping: light blue is naps, dark blue is sleeping
• All counters count since last started (so feeding is since you last started feeding not since you last stopped feeding), except sleeping which tells you time since last sleep ended.
• the average by hour of day charts is what we used to help better understand our feeding patterns throughout the day.

You can get the dashboard here: https://github.com/lenaxia/home-ops-prod/blob/main/cluster/apps/home/babybuddy/dashboard/babybuddy.json

[cdubz]

Very cool! Thanks for sharing. I'll add the dashboard config link to BBotW.

[feranwq]

how to count the number of diapers used every week and every month? then thank you for your work @lenaxia

[smarinel]

Very interested in something like this, I am using Baby Scout to input data, but it doesn't update my iPad display automatically. It would be ideal to have a more real-time display. Not sure about how to use Grafana though?

[Mewks]

My instance of BabyBuddy is currently using the SQLLite database, is there any way to easily convert/migrate this to Postgres so I can connect Grafana to it?

[adampetrovic]

I managed to convert mine to postgres. It's a bit of a pain though. You'll need to drop certain database constraints (temporarily, then manually recreated them) that get created when the new database structure is bootstrapped in order for Django to populate the tables.

If you're up for that I can run you through it.

[th0mcat]

@adampetrovic if I ever get time to do a migration from SQLite to Postgres, I would love your assistance if you are still offering

[namelivia]

I'm setting up this one too, thank you for your work @lenaxia!

[lenaxia]

Here's an updated copy of the dashboard for 2.0

https://github.com/lenaxia/home-ops-prod/blob/main/cluster/apps/home/babybuddy/dashboard/babybuddy.json

[andremsousa]

Awesome job!
Do you have any guide on how to config BabyBuddy with Postgres in order use this dashboard?
Thanks!

[lenaxia]

@cdubz has great documentation already available here: https://docs.baby-buddy.net/configuration/database/. Use this as your DB_BACKEND value django.db.backends.postgresql

Beyond that, just configure grafana to point to your postgresdb, enter the username and password that you defined, and you should be able to import the dashboard I linked and update it to point to your configured postgres source. If you run into any issues feel free to ask specific questions.