Time  Nick      Message
11:03 Megaf     Dear devs, how is it going? I have this question about sqlite compression. There's this too
11:04 Megaf     Tool, called sqlitebrowser, it has an option to compress the db
11:05 Megaf     I wonder if I could use it to compress my map.sqlite. Have you ever tried that?
11:06 Krock     mapblocks are already gzipped
11:06 Krock     and double compression usually lacks of effectivity
11:07 Megaf     If it is so then the engine is pretty inefficient in storing information on the db
11:10 Krock     yesterday appeared a potential metadata issue, where empty inventories were saved in a mapblock.
11:10 Krock     maybe cleaning that up would free some space
11:12 Megaf     Krock: I read that, I was wondering how possible would it be to clean/fix that
11:12 Krock     me too
12:57 Fixer     Megaf: try unexplore script
13:00 Megaf     Fixer: I read about it Fixer, I'm almost sure it will mess up my world pretty badly, specially because we have lots of things built with trees, stone and dirt
13:00 Megaf     I also have nether, and things build with nether stuff
13:02 Megaf     Fixer: What I'm doing right now is a /clearobjects, then I will vacuum it and rebuild the index
13:03 Megaf     and in a backup copy I will try to compact the db with sqlitebrowser
13:06 Megaf     Never mind then
13:16 Megaf     up #1620
13:16 ShadowBot https://github.com/minetest/minetest/issues/1620 -- Progress bar/status/info for /clearobjects.
15:13 Megaf     The DB got 129.624 MB after VACUUM. It's not a huge reduction is it?
15:14 Megaf     original size was 4453.74 MB
15:15 Megaf     Krock: ^
15:15 Megaf     reindex don't change the size at all
15:16 Krock     indeed, that's not much
15:16 Megaf     and that was after a /clearobjects
15:17 Megaf     I'm backing up the db now and will run a compression on it to see if there's any significant change
15:18 Megaf     it will be fun handling a 4.4 GB db on this AMD E1 at 1.3 GHz CPU with 4 GB of RAM
15:25 Megaf     well, no size difference at all after compression
15:25 Megaf     [12:06:14] <Krock> mapblocks are already gzipped
15:25 Megaf     [12:06:33] <Krock> and double compression usually lacks of effectivity
15:25 Megaf     You are right
15:49 nrzkt     vacuum is the only way to reduce size in pg
15:50 nrzkt     you sould enable auto vacuum & use recent pgsql
15:52 Megaf     and how would that help? What's the benefit?
16:09 nrzkt     perf + automatic vacuum cleanup
16:09 Megaf     I can setup automatic vacuum on sqlite too, and we don't know that pgsql is faster with minetest
16:12 nrzkt     then just ask skype why they use pgsql instance of sqlite :p
20:09 est31     https://lists.x.org/archives/xorg-devel/2016-September/050975.html
20:09 est31     nice nice nice
20:09 est31     may fix bug #1763
20:09 ShadowBot https://github.com/minetest/minetest/issues/1763 -- Spinning frustum on Xwayland
20:10 kruug     Is there an "on_point" function similar to "on_drop" or "on_place"?
20:21 Hijiri    no
20:22 kruug     Hmmm...
20:23 kruug     is there a channel designated for modding?  I don't want to muddy up the main dev chat with the rest of my questions.
20:23 est31     kruug, #minetest or #minetest-project
20:23 Hijiri    #minetest is where mod discussion usually goes
20:23 kruug     still on freenode?
20:23 Hijiri    both yes
20:23 est31     yes
20:23 kruug     thanks.
23:39 nolsen    Looks like collect_static isn't working properly anymore.