# Gladys Assistant 4.45: DuckDB, a revolution in Gladys! ⚡ **URL:** \ **Category:** Actualités\ **Created:** [August 26, 2024, 6:30pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058 "2024-08-26T18:30:41Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\ **Post date:** [August 26, 2024, 6:30pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/1 "2024-08-26T18:30:41Z")
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 😂 I talk about it in a blog post: > **[DuckDB : Des performances extrêmes et une base de données 97% plus légère ! |...](https://gladysassistant.com/fr/blog/gladys-and-duckdb/)** > > Une mise à jour majeure de Gladys qui va révolutionner votre utilisation. I can’t wait to get your feedback once the update and migration are done: how big is your DB (before/after)? 😃 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](https://x.com/gladysassistant/status/1828135258660995118) to help spread the word about Gladys! ---
**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\ **Post date:** [August 26, 2024, 6:52pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/2 "2024-08-26T18:52:25Z")
---
**Author:** ![StephaneB](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/stephaneb/32/15443_2.png) [@StephaneB](https://community.gladysassistant.com/u/StephaneB)\ **Post date:** [August 26, 2024, 7:14pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/3 "2024-08-26T19:14:43Z")
@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](https://gladys-assistant-community.b-cdn.net/uploads/default/original/3X/2/9/294376e6a578b175f4dc37b5558d3dcc0fe3bb04.png) ---
**Author:** ![guim31](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/guim31/32/4840_2.png) [@guim31](https://community.gladysassistant.com/u/guim31)\ **Post date:** [August 26, 2024, 7:23pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/4 "2024-08-26T19:23:19Z")
Here I go!! ![1000006573](https://gladys-assistant-community.b-cdn.net/uploads/default/original/3X/1/f/1ffc24de8905994584d05825011de56c0a5c31a2.jpeg) ---
**Author:** ![GBoulvin](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/gboulvin/32/10006_2.png) [@GBoulvin](https://community.gladysassistant.com/u/GBoulvin)\ **Post date:** [August 26, 2024, 7:31pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/5 "2024-08-26T19:31:12Z")
It’s because this time, the online version (G+) is up to date, but your instance isn’t yet… Patience! 😉 ---
**Author:** ![guim31](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/guim31/32/4840_2.png) [@guim31](https://community.gladysassistant.com/u/guim31)\ **Post date:** [August 26, 2024, 7:58pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/6 "2024-08-26T19:58:29Z")
![image](https://gladys-assistant-community.b-cdn.net/uploads/default/original/3X/b/b/bbf813d2d4f707d75cef0a27668edac972019a52.png) From 23GB to 62MB … we’re goooood 😃 Now I’m starting the cleanup ---
**Author:** ![StephaneB](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/stephaneb/32/15443_2.png) [@StephaneB](https://community.gladysassistant.com/u/StephaneB)\ **Post date:** [August 26, 2024, 8:00pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/7 "2024-08-26T20:00:33Z")
Ohhh, well yes, but no, I’m too impatient ---
**Author:** ![GBoulvin](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/gboulvin/32/10006_2.png) [@GBoulvin](https://community.gladysassistant.com/u/GBoulvin)\ **Post date:** [August 26, 2024, 8:11pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/8 "2024-08-26T20:11:52Z")
You can force the update… I’m looking for the command that @pierre-gilles gave very recently (December 2023! Time flies!) > [@pierre-gilles](#): > > In the meantime, if you want to run the update yourself, you can do this from the CLI: > > ```auto > docker run --rm \ > -v /var/run/docker.sock:/var/run/docker.sock \ > containrrr/watchtower \ > --run-once > > ``` ---
**Author:** ![jparbel](https://gladys-assistant-community.b-cdn.net/letter_avatar_proxy/v4/letter/j/d6d6ee/32.png) [@jparbel](https://community.gladysassistant.com/u/jparbel)\ **Post date:** [August 26, 2024, 8:38pm UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/9 "2024-08-26T20:38:09Z")
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 ---
**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\ **Post date:** [August 27, 2024, 6:18am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/10 "2024-08-27T06:18:30Z")
Amazing feedback 😍 Can’t wait to see the final result after purge / clean / reboot! ---
**Author:** ![guim31](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/guim31/32/4840_2.png) [@guim31](https://community.gladysassistant.com/u/guim31)\ **Post date:** [August 27, 2024, 6:24am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/11 "2024-08-27T06:24:20Z")
Do you need to reboot manually at the end? Or is it automatic? ---
**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\ **Post date:** [August 27, 2024, 6:50am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/12 "2024-08-27T06:50:13Z")
If you don’t reboot after the cleanup, the SQLite file keeps its original size, you have to do it yourself 🙂 It’s stated in the blog post in the migration section: > **[DuckDB : Des performances extrêmes et une base de données 97% plus légère ! |...](https://gladysassistant.com/fr/blog/gladys-and-duckdb/#la-migration)** > > Une mise à jour majeure de Gladys qui va révolutionner votre utilisation. ---
**Author:** ![jparbel](https://gladys-assistant-community.b-cdn.net/letter_avatar_proxy/v4/letter/j/d6d6ee/32.png) [@jparbel](https://community.gladysassistant.com/u/jparbel)\ **Post date:** [August 27, 2024, 6:50am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/13 "2024-08-27T06:50:53Z")
Everything is clean on my end. Nice work @pierre-gilles . ---
**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\ **Post date:** [August 27, 2024, 6:51am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/14 "2024-08-27T06:51:31Z")
@jparbel what’s the final size of your database then? Did you do the purge and cleanup? ---
**Author:** ![jparbel](https://gladys-assistant-community.b-cdn.net/letter_avatar_proxy/v4/letter/j/d6d6ee/32.png) [@jparbel](https://community.gladysassistant.com/u/jparbel)\ **Post date:** [August 27, 2024, 6:57am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/15 "2024-08-27T06:57:32Z")
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 ---
**Author:** ![Janssens](https://gladys-assistant-community.b-cdn.net/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@Janssens](https://community.gladysassistant.com/u/Janssens)\ **Post date:** [August 27, 2024, 7:31am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/16 "2024-08-27T07:31:46Z")
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 ---
**Author:** ![pascal\_sapin](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pascal_sapin/32/8958_2.png) [@pascal\_sapin](https://community.gladysassistant.com/u/pascal_sapin)\ **Post date:** [August 27, 2024, 9:08am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/17 "2024-08-27T09:08:26Z")
Hello, still no update for me, is that normal? ---
**Author:** ![jean\_bruder](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/jean_bruder/32/13_2.png) [@jean\_bruder](https://community.gladysassistant.com/u/jean_bruder)\ **Post date:** [August 27, 2024, 10:16am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/18 "2024-08-27T10:16:13Z")
Hello 🙂 Forced migration last night, everything went well 👍 ![image](https://gladys-assistant-community.b-cdn.net/uploads/default/original/3X/a/2/a28329fa53cc02a884f11119d15bdacf4a6f61d1.png) ![image](https://gladys-assistant-community.b-cdn.net/uploads/default/original/3X/1/2/12b8e41405e449cf573a937a5c11bc4710dd6b82.png) Have a nice day, Jean ---
**Author:** ![Einstein8854](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/einstein8854/32/9474_2.png) [@Einstein8854](https://community.gladysassistant.com/u/Einstein8854)\ **Post date:** [August 27, 2024, 10:33am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/19 "2024-08-27T10:33:25Z")
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! ---
**Author:** ![guim31](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/guim31/32/4840_2.png) [@guim31](https://community.gladysassistant.com/u/guim31)\ **Post date:** [August 27, 2024, 10:57am UTC](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058/20 "2024-08-27T10:57:43Z")
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 😃 [Next page](https://community.gladysassistant.com/t/gladys-assistant-4-45-duckdb-une-revolution-dans-gladys/9058.md?page=2)