Instapy: I built myself a Dashboard using https://metabase.com/

[GaWr26]

Now I want much more data in the database!

[ArdyBeheshti]

Hey this is pretty cool! How did you set this up?

[mrallanodreman]

Wow nice!

[GaWr26]

First of all I got inspired by https://github.com/converge/instapy-dashboard so thanks a buch for that!
The problem I was facing there was the multiple databases as i run multiple accounts.
If you install metabase which is a written in java and run it you can connect to many databases.
I just connected it to each sqllite database of instapy.
Then you need to start building your dashboard which is pretty straight forward and really easy.
No coding required.

I have it running on a RaspberryPi 3B and love it. It also starts a webserver and is responsive so now I can always see whats going on. Even on the go.

[ArdyBeheshti]

First of all I got inspired by https://github.com/converge/instapy-dashboard so thanks a buch for that!
The problem I was facing there was the multiple databases as i run multiple accounts.
If you install metabase which is a written in java and run it you can connect to many databases.
I just connected it to each sqllite database of instapy.
Then you need to start building your dashboard which is pretty straight forward and really easy.
No coding required.

I have it running on a RaspberryPi 3B and love it. It also starts a webserver and is responsive so now I can always see whats going on. Even on the go.

Sweet! When you mean multi dbs/account issues, does displaying them not work so seamlessly as showing just one account's information?

[GaWr26]

Sweet! When you mean multi dbs/account issues, does displaying them not work so seamlessly as showing just one account's information?

I use split_db as I had quite some crashes with writing to only one db. The instapy-dashboard can only connect to one db and running multiple instances of it made no sense to me.

Metabase works great with multiple databases.

[lerra]

Do you have a docker image + instructions to share? :-)

[GaWr26]

Do you have a docker image + instructions to share? :-)

Sorry, no docker image or documentation. I just played with it and am quite happy with the result.
It's super straight forward as metabase is a really well built tool with a great UI. All you need to do is install it and select the appropriate database(s) and then go ahead and create a dashboard to your liking.

[ExoCode17]

Trying it out. How did you get the two in the top right? The increase from the previous day?

[GaWr26]

Trying it out. How did you get the two in the top right? The increase from the previous day?

that's a smart Number. This should help:

[ExoCode17]

Gotcha! Now I have them too. And how did you get the reverse ordering by date in the bottom two? Can't get my head around it

[ExoCode17]

[GaWr26]

Reverse ordering can be done on the far right with the three dots menu. There you can sort by created date and then select desc.

Also you could group by created if you want to get only one row per day.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

If this problem still occurs, please open a new issue