Gladys Assistant 4.45: DuckDB, a revolution in Gladys! ⚡

People are harsh on Reddit :sweat:

It’s part of the game, and it’s precisely a win when you attract that kind of account :wink:

It creates engagement, and therefore views ^^ For me it’s a success!

4 Likes

I’m on Reddit every day, and it’s full of snobby people, no matter the subreddit ^^
But 30 comments in a few hours means this thread is doing well!!

3 Likes

I know why I don’t stay on Reddit or on social media for long!! Human nature is sometimes beyond imagination :face_in_clouds:

2 Likes

Thanks for these improvements — on my instance it’s not as relevant as it is for the rest of you given the original size, but it’s still interesting. The SQLite file goes from 2 GB to 3.3 MB.
The DuckDB file is 3.1 MB
:partying_face:

One quick question @pierre-gilles, do you plan in a few releases to remove the migration code or will you leave it for a while? During the last holidays I started installing Gladys at my parents’ place, it ran for a few weeks and I shut the instance down when I left. I just want to make sure that if I restart it in a few weeks, the automatic migration system will still be there.

Aha, same here, but honestly I think the subreddit overall has been pretty tame. This post is a success!

Don’t let the few grumps get you down :slight_smile:

Awesome! :partying_face:

Ah I think it will stay forever in Gladys. All the DB migrations have been in the code from the start, they’re there to serve anyone who is still on 4.0.0 and migrates later (there are some!)

We might hide the UI part somewhere more out of the way, but we’re not going to stop keeping the migration forever.

3 Likes

Hello,
The purge on my end isn’t working and on the system page the migration is stuck again.
I don’t know what to do given the following:

What’s in the « System » tab? Has part of the migration been done?

I have the same problem as @Jluc. The DuckDB migration appears to be done (visible in the task). But the SQLite purge doesn’t seem to be happening, or at least it’s very slow (3% in 2 days, as of yesterday), and on the /migration duck system the hourglass keeps spinning without me seeing any progress, and my Gladys server is extremely slow! (problem refreshing the info on my dashboards!)

I had the following yesterday and this morning, but nothing now

![Screenshot 2024-08-31 at 12.09.02|

1 Like

For me, the migration

Absolutely!

@Jluc can you restart your Gladys container (or reboot your machine)?
And then run the purge again…

Update performed on Pi3.
Problem following the step

1 Like

Hello everyone,

I’m not going to give you much information, but just to say that everything went very well: the update ran by itself without error, and I ran the purge of the SQLite states, which also completed successfully.

Good job!

4 Likes

Hello everyone,
For me, I also moved to DuckDB without a hitch, the database used to be 3.76GB and now it’s 287.77MB
As usual, great job @pierre-gilles, thanks again

3 Likes

Hello @GBoulvin,
This morning the purge shows 31% and I’m hopeful it will complete.
Gladys is running on a Pi 3b — is that the one that should be restarted? If so, I could do it, but I don’t know how to manage the containers.
Also, for two days the Zigbee2mqtt backup has been failing.

Dear @Jluc,
Don’t worry, it’s progressing!
So don’t do anything for now…
The backup is failing because your Raspberry Pi is overloaded. Unfortunately, there’s nothing to do but wait. It needs to process all the database entries and everything will be back to normal afterwards!
Good luck!

1 Like

At my home, I went from 732 Mbps to under 5 Mbps and it’s running like before. Thanks for the improvement.

4 Likes