Skip to main content

DuckDB: Extreme Performance and a 97% Lighter Database!

ยท 6 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone,

Today is a big day: Iโ€™m releasing a major version of Gladys that will drastically improve the Gladys experience and keep us at the cutting edge of data storage technology.

Imagine...

โžก๏ธ Your Gladys database shrinking from 47 GB to 1.5 GB...
โžก๏ธ Your charts displaying instantly, even over long periods of data...
โžก๏ธ Your Gladys Plus backups becoming lighter and faster...

Well, we did it!

The Technology: DuckDBโ€‹

DuckDB is an OLAP database system that, like SQLite, stores data in a single file.

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Test Gladys Assistant with an existing Zigbee2mqtt instance!

ยท 3 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

Today I'm releasing Gladys Assistant 4.40, an update to Gladys that brings a much-requested feature: the ability to use Gladys with an existing Zigbee2mqtt instance.

Using Gladys with an existing Zigbee2mqtt instanceโ€‹

From now on, when you configure Zigbee2mqtt in Gladys, Gladys will offer you 2 choices:

Gladys Zigbee2mqtt mode choice

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Launch of the ULTIMATE guide to getting started in home automation ๐Ÿš€

ยท 3 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

I've been wanting to tell you about this project for so long, so here it is at last ๐Ÿ˜

For those who missed the launch, the replay is available on YouTube (in French):


Order your training now (French only for now): formation.gladysassistant.com

I'm buying an apartmentโ€‹

The first news of this launch is that I'm buying an apartment in the south of France: my first main residence!

Obviously, I'm going to connect this apartment entirely with Gladys and make it a real showcase for what's possible in home automation in 2024 ๐Ÿ˜Ž

I'm going to push the cursors to the max on all subjects: lighting, presence detection, security, music, etc....

The aim of this apartment is also to turn it into a real laboratory for home automation experiments.

This will allow me to be at the forefront in terms of Gladys use, and to be able to test all the new features at home.

I'll show you my personal setupโ€‹

For the moment, the apartment is empty.

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Gladys Assistant's 2023 Year In Review

ยท 6 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Happy New Year to all ๐Ÿ™Œ

I hope 2024 will be a year full of good things for you: health, family, projects!

Like every year, I take stock of the previous year and present my plans for the new year.

If you prefer this review on video, I've made a YouTube live which is available for replay here (in french only).

What happened in 2023?โ€‹

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Sonos integration now available!

ยท 4 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

2 weeks ago, I was live on Youtube for a live coding session that lasted over 7 hours!!!

In this live, I developed from start to finish a Sonos integration for Gladys.

The live coding was in French, if you are interested, the live replay is available here on YouTube.

Today, I'm happy to release Gladys Assistant 4.32, which includes this Sonos integration ๐Ÿ˜

Sonos integration in Gladysโ€‹

Now you can connect your Sonos speakers to Gladys.

Sonos integration

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Tag filtering & MQTT in scenes in Gladys Assistant 4.31

ยท 4 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hello everyone,

At the end of October I presented Gladys Assistant 4.30, a version that brought a complete alarm to Gladys!

Today I'm releasing Gladys Assistant 4.31, a version that brings a lot of new features and fixes following your feedback on the alarm mode ๐ŸŽ‰๐ŸŽ‰

Tag filtering in scenesโ€‹

Many of you have been asking for a mechanism to filter the increasing number of scenes in your instances, and @Lokkye has done just that!

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Gladys gets a full alarm!

ยท 3 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

Gladys Assistant 4.30 has just been released, and it's a hell of a version!!! ๐Ÿฅณ

The main feature is the complete management of an Alarm mode that allows you to set up a complete home security system.

Gladys iPad Alarm Mockup

You've got to admit, it does make you want to ๐Ÿ˜Ž

An alarm in Gladysโ€‹

Gladys can now replace a complete alarm system by managing the various states of any good alarm system:

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

MELCloud integration, full-screen tablet mode, Tuya shutters

ยท 3 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

Another Gladys update with lots of new features ๐Ÿฅณ

Integrations with Mitsubishi air conditionersโ€‹

It's now possible to connect your Mitsubishi air conditioners (connected via MELCloud) to Gladys!

Mitsubishi air conditioner

Thanks to @Lokkye for the development ๐Ÿ™Œ

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

IKEA TRร…DFRI Zigbee compatibility & dashboard device renaming

ยท 4 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hello everyone!

Hope you spent good holidays โ˜€๏ธ

On the Gladys Assistant front, I returned last week with an update to v4.26.1, which introduced a set of fixes in response to your feedback over the summer.

Today I'm following up with a more important update in terms of features: Gladys Assistant 4.27.

Rename your devices on the dashboardโ€‹

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚

Gladys Assistant is now compatible with Tuya devices!

ยท 2 min read
Pierre-Gilles Leymarie
Founder of Gladys Assistant

Hi everyone!

Today I'm pleased to announce Gladys Assistant 4.26, a release that brings compatibility with Tuya-compatible devices.

It was already possible to use certain Tuya Zigbee devices with Gladys via our Zigbee2mqtt integration, but now Wi-Fi connected sockets and light bulbs are also compatible via an official Tuya integration ๐ŸŽ‰๐ŸŽ‰

Subscribe to the Gladys Assistant newsletter

A few emails per month about new releases and project news. Sent by Pierre-Gilles Leymarie, founder of the project. Unsubscribe anytime ๐Ÿ™‚