pierregillesl

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.

Ok! And what kind of hardware do your users run on? Do you get great quality of detection like Google Home/Alexa speakers?

Nice! What languages do you support? (for STT & TTS)

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.

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? :)

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

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 )

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.

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

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...

Why? If you use Gladys locally (on your local network), or has the knowledge to self host everything, then it’s 100% free (because it’s open-source), and your privacy is respected

You pay for things which cost me money !

Hi Hacker News

I’m Pierre-Gilles Leymarie, and I created 7 years ago Gladys Assistant, an open-source home automation software.

At the time, it was just a pet project: something to help me automate my student room.

Today, we have been downloaded more than 40k times and we are launching a new website based on Docusauraus v2.

I would love to have your feedback on this new website!

I've been building an open-source assistant for the home for 6 years, it's called "Gladys Assistant".

I have a paid plan with additional features which allows me to sustain my cost, and pay myself :)

Being open-source doesn't mean that you can't monetize your work. People are happy to pay when you develop something great :)

Our website: https://gladysassistant.com Our GitHub: https://github.com/GladysAssistant/Gladys/

Run my home automation system with Gladys Assistant! :)

https://gladysassistant.com/

Exactly that's the goal

It's a community project, not a contract :) So I try to be as close as possible from my community

Totally agree!

Wow, I'm impressed by your Patreon! Congrats :)

Awesome work, love the concept :)