| 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/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: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 |
