Usage of Home Assistant SQL Lite database instead of MariaDB

[DvdEnde]

First of all thank you for sharing this great project! I'm considering to install this solution and would like to understand whether also HA SQL Lite can be used instead of MariaDB as I would prefer to limit the number of different database platforms. Would that be a possibility?

[corneel27]

I am sorry, this is not possible in the short time.
I use on several places specific mysql/mariadb dialect in sql-queries.
On the long term I am going to switch to a general database-module (sqlalchemy) and then sqlite3 comes again in the picture.

[DvdEnde]

Hi Cees, Thank you for your explanation. Kind regards, Dave Van: Cees van Beek ***@***.***> Verzonden: maandag 19 februari 2024 21:29 Aan: corneel27/day-ahead ***@***.***> CC: DvdEnde ***@***.***>; Author ***@***.***> Onderwerp: Re: [corneel27/day-ahead] Usage of Home Assistant SQL Lite database instead of MariaDB (Discussion #76) I am sorry, this is not possible in the short time. I use on several places specific mysql/mariadb dialect in sql-queries. On the long term I am going to switch to a general database-module (sqlalchemy) and then sqlite3 comes again in the picture. — Reply to this email directly, view it on GitHub <#76 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/A3MKSEL3KNRHJWKXAVWFA2DYUOY2PAVCNFSM6AAAAABDPTVBB2VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DKMRRHA2TA> . You are receiving this because you authored the thread. <https://github.com/notifications/beacon/A3MKSEOKQLJO5K26ISNBT3TYUOY2PA5CNFSM6AAAAABDPTVBB2WGG33NNVSW45C7OR4XAZNRIRUXGY3VONZWS33OINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAQIEHU.gif> Message ID: ***@***.*** ***@***.***> >