Minetest logo

IRC log for #minetest-dev, 2016-09-09

| Channels | #minetest-dev index | Today | | Google Search | Plaintext

All times shown according to UTC.

Time Nick Message
00:36 Void7 joined #minetest-dev
01:04 siva_machina joined #minetest-dev
02:29 AcidNinjaFWHR joined #minetest-dev
03:34 jomat joined #minetest-dev
03:40 alkotob joined #minetest-dev
03:55 Zeno` joined #minetest-dev
05:11 ensonic joined #minetest-dev
05:15 Hunterz joined #minetest-dev
05:46 Thomas-S joined #minetest-dev
05:50 paramat joined #minetest-dev
07:00 ensonic joined #minetest-dev
07:10 Darcidride_ joined #minetest-dev
08:20 nrzkt joined #minetest-dev
08:24 ensonic joined #minetest-dev
08:50 Fixer joined #minetest-dev
09:13 ensonic joined #minetest-dev
10:27 everamzah joined #minetest-dev
11:08 proller joined #minetest-dev
11:09 Megaf joined #minetest-dev
11:14 proller joined #minetest-dev
11:31 ensonic joined #minetest-dev
11:49 ensonic joined #minetest-dev
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
13:39 Hunterz joined #minetest-dev
13:49 troller joined #minetest-dev
13:54 alkotob_ joined #minetest-dev
14:15 STHGOM joined #minetest-dev
14:15 STHGOM joined #minetest-dev
14:24 AnotherBrick joined #minetest-dev
14:34 Darcidride__ joined #minetest-dev
14:36 Darcidride joined #minetest-dev
14:39 Darcidride_ joined #minetest-dev
14:44 everamzah joined #minetest-dev
14:50 twoelk joined #minetest-dev
14:56 Void7 joined #minetest-dev
14:59 KaadmY joined #minetest-dev
15:00 srifqi joined #minetest-dev
15:16 blaze joined #minetest-dev
15:26 troller joined #minetest-dev
15:28 alkotob_ joined #minetest-dev
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
16:06 alkotob_ joined #minetest-dev
16:21 hmmmm joined #minetest-dev
16:27 ensonic joined #minetest-dev
16:43 red-001 joined #minetest-dev
17:02 torgdor joined #minetest-dev
17:02 srifqi joined #minetest-dev
17:07 srifqi joined #minetest-dev
17:17 Void7 joined #minetest-dev
17:21 everamzah joined #minetest-dev
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
17:43 HonoredGlory joined #minetest-dev
17:47 srifqi joined #minetest-dev
17:48 Krock joined #minetest-dev
17:53 xunto joined #minetest-dev
18:03 DI3HARD139 joined #minetest-dev
18:06 ssieb joined #minetest-dev
18:10 torgdor joined #minetest-dev
18:26 Void7 joined #minetest-dev
18:32 proller joined #minetest-dev
18:40 damiel_ joined #minetest-dev
19:05 srifqi joined #minetest-dev
19:17 nore joined #minetest-dev
20:02 johnnyjoy joined #minetest-dev
20:11 Darcidride joined #minetest-dev
20:18 FelipeO_O_ joined #minetest-dev
20:21 nrzkt joined #minetest-dev
20:26 troller joined #minetest-dev
20:41 edgrey joined #minetest-dev
20:52 Megaf after reading this I believe MySQL could be very interesting DB for a MT Server https://www.digitalocean.com/community/tutori​als/sqlite-vs-mysql-vs-postgresql-a-compariso​n-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:55 srifqi joined #minetest-dev
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:00 srifqi joined #minetest-dev
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 troller joined #minetest-dev
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 Gael-de-Sailly joined #minetest-dev
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
22:43 siva_machina joined #minetest-dev
22:46 DI3HARD139 joined #minetest-dev
23:07 troller joined #minetest-dev
23:42 halt_ joined #minetest-dev
23:43 Sokomine joined #minetest-dev
23:45 paramat joined #minetest-dev
23:53 Grandolf joined #minetest-dev
23:58 STHGOM joined #minetest-dev
23:58 STHGOM joined #minetest-dev

| Channels | #minetest-dev index | Today | | Google Search | Plaintext