pierregillesl
Joined 11 years ago
Karma
71
Submissions
39
Member since
Aug 17
Recent submissions
Comment · 4 months ago
I wouldn’t see it as a replacement.
SQLite and DuckDB solve different problems and actually complement each other quite well. SQLite is excellent for transactional workloads (OLTP), while DuckDB shines for analytical workloads (OLAP), especially time-series data and aggregations.
We’ve been using both side-by-side in an open-source project for about two years: SQLite for configuration and transactional data, DuckDB for historical sensor data and analytics. So far, it’s been a very good combination.
Comment · 3 years ago
Ok! And what kind of hardware do your users run on? Do you get great quality of detection like Google Home/Alexa speakers?
Comment · 3 years ago
Nice! What languages do you support? (for STT & TTS)
Comment · 3 years ago
We are making Gladys Assistant ( https://gladysassistant.com/ ), an open-source smart home software.
It's less "techy" than HA (no YAML files, no CLI), and UI first.
We have way less integrations for now, but are working hard on it.
Don't hesitate to try it and make us some feedback.
Comment · 4 years ago
Nice project! Just one question, how do you find open-source projects?
I'm the core maintainer of an open-source smart home software (https://github.com/GladysAssistant/Gladys, 2.2k stars, has been existing since 2014), and is not listed, any reason why? :)
Comment · 4 years ago
It's not what I've experienced!
In my experience, as soon as there is some new data coming in the DB, the .backup command will continue, and if the writes are not stopping, the backup will never stop as well :D
In Gladys case, we put in the application logic a blocking transaction to lock writes during the backup. I haven't found any other way to avoid infinite backups in case of write-heavy databases
Comment · 4 years ago
Don't forget to stop writing to the database while doing the backup, otherwise you can run into an infinite loop if you write faster than sqlite3 .backup is doing the backup :D
Learned that the hard way when implementing sqlite3 backups on Gladys Assistant ( open-source home automation platform https://github.com/GladysAssistant/Gladys )
Comment · 4 years ago
We do have a Google Home integration. IMO Gladys is more about going further with scenes, a beautiful customizable dashboard, and using regular Google Home / Alexa for voice commands.
Comment · 4 years ago
HA is very good, it has way more compatibilities than Gladys right now, but IMO HA is more targeted to developers/tech-savy people, or at least people who likes “hackable” software
Gladys was designed from the beginning to be a consumer software, meaning: no SSH needed, no files to edit, no “you-need-to-configure-grafana”.
Everything happens in a very simple UI that the whole family can use, that’s our end goal :)
So I would say it’s 2 differents philosophy
Comment · 5 years ago
Also, you can use Node-RED with Gladys Assistant (open-source home automation software) to have a clean dashboard on top of Node-RED:
https://gladysassistant.com/blog/integrate-node-red-with-gla...
More on https://gladysassistant.com/ Twitter: @pierregillesl