Difference between revisions of "Database backends"

From Luanti Wiki
Jump to navigation Jump to search
(Remove some misconceptions about sqlite3)
(Replaced content with "[https://dev.luanti.org/database-backends This page has moved to the Luanti Developer Wiki]")
Tag: Replaced
 
(48 intermediate revisions by 13 users not shown)
Line 1: Line 1:
Minetest supports several database backends. This page provides a comparison of all 3 (actually 4, but the ''dummy'' backend generally isn't useful) backends.
+
[https://dev.luanti.org/database-backends This page has moved to the Luanti Developer Wiki]
 
 
The database backend is set using the <code>backend</code> setting in ''world.mt''.
 
 
 
If you want to migrate a world to a new backend, use <code>minetestserver --migrate <name of new backend> --world <path to your world directory></code>.
 
 
 
== Comparison table ==
 
 
 
{| class="wikitable sortable" style="text-align: left; font-size: smaller"
 
|-
 
! Backend
 
! Speed
 
! Reliability
 
! Compatibility with builds
 
|-
 
| SQLite3
 
| style="background-color: #9F9;" |
 
'''Good'''
 
| style="background-color: #FFB;" |
 
'''Acceptable''' ''(problems can arise with concurrent accesses)''
 
| style="background-color: #9F9;" |
 
'''Very good''' ''(always supported)''
 
|-
 
| LevelDB
 
| style="background-color: #9F9;" |
 
'''Good'''
 
| style="background-color: #9F9;" |
 
'''Good'''
 
| style="background-color: #FFB;" |
 
'''Mostly supported'''
 
|-
 
| Redis
 
| style="background-color: #9EF;" |
 
'''Very good''' ''(data kept in RAM)''
 
| style="background-color: #9F9;" |
 
'''Good'''
 
| style="background-color: #FAA;" |
 
'''Inconvenient''' ''(redis server required)''
 
|-
 
| Dummy
 
| style="background-color: #9EF;" |
 
'''Blazing fast'''
 
|  |
 
'''N/A''' ''(nothing is saved to disk)''
 
|  |
 
'''N/A''' ''(nothing is saved to disk)''
 
 
 
|}
 
 
 
The ''Compatibility with builds'' column is only relevant if you want to distribute the worlds.
 
 
 
=== SQLite3 ===
 
 
 
SQLite3 is the default backend for all Minetest worlds, it is supported by every Minetest build and is therefore the standard database format that is used to distribute worlds.
 
 
 
=== LevelDB ===
 
 
 
LevelDB is mostly used on servers because of its improved reliability and possibly speed. You need to install it additionally.
 
 
 
=== Redis ===
 
 
 
Redis support was added to Minetest in April 2014, redis is mainly useful for servers as it allows multiple worlds to be stored in one redis instance. You need to install it additionally (''libhiredis'' library).
 
 
 
Information about setting up a redis server can be found here: http://redis.io/topics/quickstart
 
 
 
==== world.mt settings for Redis ====
 
 
 
<code>redis_address</code> '''--''' The IP or hostname of the redis server.
 
 
 
<code>redis_port</code> '''--''' The port of the redis server. ''Optional, default: 6379''
 
 
 
<code>redis_hash</code> '''--''' Hash where the MapBlocks are stored in, if you want multiple worlds in one redis instance this needs to be different for each world. If you don't need any hash, you can write <code>IGNORED</code>.
 
 
 
=== Dummy ===
 
 
 
A dummy database backend, which stores all MapBlocks in RAM without saving them and will most likely not be of any use for you.
 
 
 
 
 
[[Category:Server]]
 
[[Category:Map]]
 

Latest revision as of 12:36, 22 December 2024