All in one or two Systems (Tabels, forms, messanger in HomeAssistant)

Third party integrations
1

Hello

I’m working on a project to monitor a house and monitor greenhouses.
I could integrate ventilation, air conditioning, water parameters and all the things you need for a SmartHome very well in HomeAssistant.

However, I need tables, forms, etc. for various types of vegetables in order to be able to enter data here.
A kind of software for growing vegetables.

I am currently using my own software for this data. I have also integrated sensors for the greenhouses in this software.

Question:
Can you also create tables and forms in HomeAssistant?

Or does it make more sense to use two separate systems here?

I would also need all the databases for the greenhouse software in Home Assistant …

Thanks for your tips

Regards
Achim

2

You could create forms in HA for numeric data or pulldown fields for choices. Booleans for checkbox like choices. So yeah, in a way I think you could do pretty much everything. Tables though is difficult. You could use the grid layout options and some custom css to make it look like a spreadsheet or something alike. But it would be some work to make it so.

3

Is your software web based? You can put it in the ui via an iframe.

4

yes the software is webbased… yes a iframe is a simple way…

is ist possible to configure in Home Assistant also some mysql-querys ?
if yes, then i can also show and change some dates (like light on/off or some temp values)

then i use two systems… one of this is my webbased software

5

my thinking is now

if is possible to configure Home Assistant also with some mysql-querys … then i not need to connect and configure some sensors over Home Assistant.

The reason is my other webbased software— this software use a mysql-db to show on some changes like Temp-values or light on/off Times… and the arduinos write some sensor datas in this databse too…

now if is possible for home assistant to use some mysql-querys then is easy to integrate some dates from the greenhouse in the home-assistant frontend.
Then is maybe possible to show some dates from the greenhouses in homeasistant and also change some datas from there…

I don’t have then the full-control over both system by Home Assistant but maybe is this a way to integrated easy my running greenhouse system…with there databse

6

You can send MySQL query directly from HA. SQL - Home Assistant

7