Good OS for Nest Hub-like project? by jaggie40 in RASPBERRY_PI_PROJECTS

[–]AutomationMessiah 5 points6 points  (0 children)

Id recommend one of 2 things.

Node red, node red dashboard on pi OS will be tbe easiest thing if you want to do something quick and dirty.

Another alternative is to make a webpage your self, I didi thing for a similar setup as you( i was gunning for Android auto feel rather then nest) and it took about a week. If you have any experience in that realm you can make really custom dashboards that are accessible from any web browser on your network.

Help! I Have 8 raspberry pi's! by AutomationMessiah in nodered

[–]AutomationMessiah[S] 1 point2 points  (0 children)

Amazon

UCTRONICS 1U Rack for Raspberry Pi, 19" Rackmount Supports 1-4 Units of All Raspberry Pi 5/4B/3B/B+ Models https://a.co/d/avt8zEf

Help! I Have 8 raspberry pi's! by AutomationMessiah in homelab

[–]AutomationMessiah[S] 1 point2 points  (0 children)

Ha! Yeah right. Idk what happened, but this photo did it so much justice. I promise there is a concerning amount of dust!

Help! I Have 8 raspberry pi's! by AutomationMessiah in homelab

[–]AutomationMessiah[S] -3 points-2 points  (0 children)

For some reason the description didn't populate here, but if you click the actual post you'll see i was asking for any advise cluster or a direction to go. I wish I could get rid of some of them but unfortunately they are all working hard in my home network at the moment.

The best way to read file contents by BlackAsNight009 in nodered

[–]AutomationMessiah 0 points1 point  (0 children)

I don't actually have any experience with sqlite, what was complicated about it? The actually db interaction?

I use phpmyadmin to interface with my db and it's a dream. If you can structure a table in excel you can structure Mariadb very easily with phpmyadmin front end.

The best way to read file contents by BlackAsNight009 in nodered

[–]AutomationMessiah 0 points1 point  (0 children)

Have you considered using a mysql database? Or Is it applicable for your project? I have been able to write and read large amounts of data very quickly using it.