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

News
1

Hi everyone!

I’m very happy to launch Gladys Assistant 4.45 today, which includes the move to DuckDB, a revolutionary new database system that will change everything in Gladys, and honestly this really isn’t clickbait :joy:

I talk about it in a blog post:

I can’t wait to get your feedback once the update and migration are done: how big is your DB (before/after)? :smiley:

Thanks again to the testers who helped with the development of this update!

Note: Please feel free to favorite/retweet the launch post on Twitter to help spread the word about Gladys!

8 Likes
3

@pierre-gilles : Bravo, very eager to benefit from this revolution!

I’m just flagging a small oddity on my end, because Gladys is still on 4.44 and so logically I don’t have a migration started when I connect locally, but I see this when I connect via Gladys Plus :

IMG_3767
IMG_37671170×2532 219 KB

4

Here I go!!

1000006573
10000065731200×2670 148 KB

1 Like
5

It’s because this time, the online version (G+) is up to date, but your instance isn’t yet… Patience! :wink:

6

image
image561×144 11 KB

From 23GB to 62MB … we’re goooood :smiley:

Now I’m starting the cleanup

4 Likes
7

Ohhh, well yes, but no, I’m too impatient

3 Likes
8

You can force the update…
I’m looking for the command that @pierre-gilles gave very recently (December 2023! Time flies!)

1 Like
9

Thanks @pierre-gilles
Migration completed successfully in 38 minutes.
SQLite database: 17 GB
DuckDB database: 218 MB
Database cleanup in progress.
You made our tasks extremely easy, that’s great.
Well done again on this masterful work.
Jean Paul

4 Likes
10

Amazing feedback :heart_eyes:

Can’t wait to see the final result after purge / clean / reboot!

11

Do you need to reboot manually at the end? Or is it automatic?

12

If you don’t reboot after the cleanup, the SQLite file keeps its original size, you have to do it yourself :slight_smile:

It’s stated in the blog post in the migration section:

13

Everything is clean on my end.
Nice work @pierre-gilles .

2 Likes
14

@jparbel what’s the final size of your database then? Did you do the purge and cleanup?

15

Yes, I’ve done everything, final sizes:
SQLite database: 23.8 MB
SQLite.wal: 27.1 MB
DuckDB database: 224.7 MB
DuckDB.wal: 16.3 MB

2 Likes
16

Hello everyone,
This short post to let you know that Gladys installed itself on its own (automatically) last night. I just purged the SQLite database.
Everything works perfectly. A big thank you, Pierre-Gilles
Daniel

2 Likes
17

Hello, still no update for me, is that normal?

18

Hello :slight_smile:

Forced migration last night, everything went well :+1:

image
image337×111 5.56 KB

image
image444×160 3.34 KB

Have a nice day,
Jean

1 Like
19

Don’t worry, I’m in the same situation as you. I’m confident and patient; I’m waiting for the automatic update — no forcing!

1 Like
20

After the migration I do notice changes in my graphs. They aren’t necessarily faster to display (they were already very fast, so not a noticeable difference), but they’re much more « beautiful ».

I have no idea why, but they’re smoother, and I notice that for my temperature sensors, when viewing the last hour, I often had a tiny curve (basically a small line in the middle of the chart) as if data were missing to display a complete curve.

That’s no longer the case and my curves look great now :smiley:

4 Likes