Time  Nick      Message
13:11 everamzah Action was needed on #4508 (doc update) -- that was fulfilled, so the label may be removed.  TIA
13:11 ShadowBot https://github.com/minetest/minetest/issues/4508 -- Return nil on empty get_area() by everamzah
15:36 Zeno`     I'll merge #4508 unless there is an objection
15:36 ShadowBot https://github.com/minetest/minetest/issues/4508 -- Return nil on empty get_area() by everamzah
15:36 Zeno`     will do so in 10 minutes
15:40 Zeno`     thanks, btw, everamzah
15:44 everamzah thank /you/ !
15:48 Zeno`     done
17:23 red-001   could someone review  #4468?
17:23 ShadowBot https://github.com/minetest/minetest/issues/4468 -- Load textures from the subfolders in texturepacks. by red-001
20:52 Megaf     after reading this I believe MySQL could be very interesting DB for a MT Server https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems
20:52 Megaf     !title
20:52 ShadowBot SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems | DigitalOcean
20:59 Calinou   Megaf: MySQL is good only because it's popular ._.
20:59 Calinou   PostgreSQL is way better on lots of aspects
20:59 nolsen    But MySQL is faster.
21:00 Calinou   nolsen: as long as it's faster than SQLite, we're good
21:00 Calinou   (I don't think SQLite is a big bottleneck on a machine with a SSD, for Minetest)
21:05 nrzkt     nolsen, it's absolutely false.
21:05 nrzkt     MySQL and PostgreSQL has differences and postgresql is far more performant on big tables than mysql
21:05 nrzkt     postgresql knows more data types, is ACID compliant and SQL norm compliant, mysql is not
21:06 nrzkt     but yes MySQL is performant, and PostgreSQL too, the main difference: how you run queries, but it doesn't depend on the engine, and how you tune the engine after tuning queries
21:07 nrzkt     yandex, skype uses postgresql for example (skype provide many interesting tools for high availability, like pgbouncer
21:09 Megaf     nrzkt: so, for a minetest server, what db would be the best? Since dbs can get huge like on my server it's approaching 5GB
21:10 nrzkt     depend on your scalability
21:10 nrzkt     postgresql is good for big databases
21:10 nrzkt     i have a 14GB postgresql db on my server it works fine
21:11 Megaf     wow, 14 GB? How old is the server?
21:12 nrzkt     2 years
21:14 sofar     minetest is fairly single-process for most of the engine
21:15 sofar     so locking isn't much of an issue, which is why sqlite is fine for a lot of servers
21:16 Megaf     and sqlite has the lowest latency
21:16 Megaf     maybe leveldb is better
21:18 sofar     I've worked with mariadb and postgresql (and mysql) for years
21:19 sofar     for most setups I'd use mariadb, just because it's usually easier to setup related projects since most projects have good docs for setting up stuff with mariadb/mysql
21:19 sofar     but postgresql does better in large tables, for sure
21:19 Megaf     sqlite says sqlite4 is faster than leveldb
21:19 Megaf     https://sqlite.org/src4/doc/trunk/www/design.wiki
21:19 Megaf     !title
21:19 ShadowBot SQLite4: The Design Of SQLite4
21:19 sofar     I haven't gotten to any scale where it matters yet
21:20 sofar     the biggest mysql table I have is 450mb
21:20 sofar     well, that's a database, not a table
21:20 sofar     150m table, 180m index
21:21 sofar     5 years of mythtv recordings :D
21:21 nrzkt     sofar i have 50GB tables at work on MySQL, some queries are a pain, whereas there is proper index
21:22 sofar     yeah, at that size it's going to start hurting
21:22 nrzkt     on postgresql agregations runs just fin, on MySQL/MariaDB 10.1 it's a little bit slow (250 millions records)
21:22 sofar     it takes mythweb ~10 seconds to display my entire list of recordings
21:22 sofar     and mythfrontend does it in <1
21:22 sofar     so I'm not worried
21:22 nrzkt     postgresql json storage is good for devs who wants to store nosql datas in some fields :)
21:23 nrzkt     also postgresql replication is stronger than MySQL replication
21:24 nrzkt     MySQL replication data recovery is a little bit complicated in case of master server failure :s
21:25 sofar     yeah, I don't use replication