search

jekalmin / extended_openai_conversation

Home Assistant custom component of conversation agent. It uses OpenAI to control your devices.
834 stars 108 forks source link

mariadb function and examples #145

Open jpleite opened 4 months ago

jpleite commented 4 months ago

Hi @jekalmin . First of all thank you for your great work. I was looking at the examples regarding DB queries but my HA instance data runs on MariaDB. Any chance I can run the the sqlite examples on MariaDB?

jekalmin commented 4 months ago

Thanks for reporting an issue.

If you plan to get history of states, use get_history function instead. Almost all examples from sqlite are possible with get_history function. (I recommend using get_history function even if you are using sqlite because it's more stable)

jpleite commented 4 months ago

thanks. I was already using it but wanted some custom queries using sql

jekalmin commented 4 months ago

Oh, it needs to be implemented in that case. Feel free to contribute to the code. I will work on it after previously requested features are done.