Hacker News: pierregillesl

New comment by pierregillesl in "DuckDB Internals Part 1"

pierregillesl — Fri, 19 Jun 2026 12:20:32 +0000

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.

New comment by pierregillesl in "Home Assistant 2023.11"

pierregillesl — Fri, 03 Nov 2023 08:33:27 +0000

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

New comment by pierregillesl in "Home Assistant 2023.11"

pierregillesl — Thu, 02 Nov 2023 15:44:34 +0000

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

New comment by pierregillesl in "Home Assistant 2023.11"

pierregillesl — Thu, 02 Nov 2023 09:59:56 +0000

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.

Show HN: Connecting GPT-3 to my smart home

pierregillesl — Thu, 26 Jan 2023 11:25:44 +0000

Article URL: https://gladysassistant.com/blog/open-ai-gpt-3-in-gladys-assistant/

Comments URL: https://news.ycombinator.com/item?id=34530380

Points: 1

# Comments: 0

New comment by pierregillesl in "Show HN: Comparing Open Source Projects"

pierregillesl — Tue, 22 Nov 2022 09:47:00 +0000

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

New comment by pierregillesl in "Cron-based backup for SQLite"

pierregillesl — Sun, 15 May 2022 13:43:43 +0000

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

New comment by pierregillesl in "Cron-based backup for SQLite"

pierregillesl — Sun, 15 May 2022 12:21:10 +0000

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 )

New comment by pierregillesl in "Gladys Assistant – A privacy-first, open-source home assistant"

pierregillesl — Sat, 09 Apr 2022 17:13:05 +0000

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.

New comment by pierregillesl in "Gladys Assistant – A privacy-first, open-source home assistant"

pierregillesl — Sat, 09 Apr 2022 17:10:07 +0000

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

New comment by pierregillesl in "Node-RED: Low-code programming for event-driven applications"

pierregillesl — Mon, 25 Oct 2021 09:14:12 +0000

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

We reduced our back end load from 400k to 40k requests per day

pierregillesl — Fri, 23 Apr 2021 09:45:00 +0000

Article URL: https://twitter.com/pierregillesl/status/1385519936819191811

Comments URL: https://news.ycombinator.com/item?id=26912857

Points: 4

# Comments: 0

Show HN: An affordable CDN for delivering large binaries

pierregillesl — Fri, 21 Aug 2020 13:03:36 +0000

Article URL: https://elephantcdn.com/

Comments URL: https://news.ycombinator.com/item?id=24234529

Points: 1

# Comments: 2

New comment by pierregillesl in "Show HN: Gladys Assistant – A privacy-first, open-source home assistant"

pierregillesl — Tue, 21 Jul 2020 18:31:57 +0000

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 !

New comment by pierregillesl in "Show HN: Gladys Assistant – A privacy-first, open-source home assistant"

pierregillesl — Tue, 21 Jul 2020 12:51:17 +0000

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!

Show HN: Gladys Assistant – A privacy-first, open-source home assistant

pierregillesl — Tue, 21 Jul 2020 12:50:14 +0000

Article URL: https://gladysassistant.com/

Comments URL: https://news.ycombinator.com/item?id=23906416

Points: 13

# Comments: 4

New comment by pierregillesl in "Ask HN: Dear open source devs how do you sustain yourself"

pierregillesl — Mon, 18 May 2020 09:05:58 +0000

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/

New comment by pierregillesl in "Ask HN: What do you do with your Raspberry Pi?"

pierregillesl — Tue, 25 Jun 2019 03:35:54 +0000

Run my home automation system with Gladys Assistant! :)

https://gladysassistant.com/

Show HN: Location Diary – Decentralized and open-source location tracker

pierregillesl — Sun, 26 May 2019 11:11:21 +0000

Article URL: https://locationdiary.com/

Comments URL: https://news.ycombinator.com/item?id=20014309

Points: 5

# Comments: 0

How I saved 875$ per year on email marketing

pierregillesl — Sun, 14 Oct 2018 09:16:21 +0000

Article URL: https://pierregillesleymarie.com/blog/2018/10/14/how-i-saved-875-dollar-per-year-on-email-marketing.html

Comments URL: https://news.ycombinator.com/item?id=18212069

Points: 2

# Comments: 0