How do database files look like in Minetest
- debiankaios
- Member
- Posts: 910
- Joined: Thu Dec 03, 2020 12:48
- IRC: debiankaios
- In-game: debiankaios Nowe
- Location: germany
- Contact:
How do database files look like in Minetest
I was wondering what all the database files in Minetest look like(auth.sqlite, map.sqlite, players.sqlite, and so on for the other databases) because I want to read them out to match the files with which mods used them. Is there a document how the files look like?
Greetings,
debiankaios
Greetings,
debiankaios
📖 Deutsches Modding Book 👽 My Mod 🔌 TechAge Extension (WIP)
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
- Krock
- Developer
- Posts: 4650
- Joined: Thu Oct 03, 2013 07:48
- GitHub: SmallJoker
- Location: Switzerland
- Contact:
Re: How do database files look like in Minetest
Install "DB Browser for Sqlite" and you'll be able to easily investigate the format.
You can find more documentation here: https://github.com/minetest/minetest/bl ... at.txt#L61 or in the source code (TM).
You can find more documentation here: https://github.com/minetest/minetest/bl ... at.txt#L61 or in the source code (TM).
Look, I programmed a bug for you. >> Mod Search Engine << - Mods by Krock - DuckDuckGo mod search bang: !mtmod <keyword here>
- Blockhead
- Member
- Posts: 1697
- Joined: Wed Jul 17, 2019 10:14
- GitHub: Montandalar
- IRC: Blockhead256
- In-game: Blockhead Blockhead256
- Location: Land Down Under
- Contact:
Re: How do database files look like in Minetest
SQLite isn't the only database format, so it's not always .sqlite. There are several database backends that Minetest uses, and the engine abstracts the format out of the equation and just uses generic functions to write back to whatever database(s) is being used as per the configuration in minetest.conf. But I'll use those names for the sake of simplicity below since the most common setup is to use SQLite.
After looking around with SQLiteStudio, you can move onto the C++ code if you want to learn more; the database-related code is mostly in minetest/src/database/ in the source tree. Start with database.h which shows you what an implementation of that database for use inside Minetest will need, then look at any specific databases you are interested in. You will see what libraries are used to deal with each database supported by Minetest and how Minetest writes back to those databases.
- auth.sqlite: Holds player authentication information. Minetest uses SRP authentication, and this is where the users' SRP information is stored. Lua can access some functions related to it as documented here and here. Also holds the privileges.
- map.sqlite: Holds the world information, with one mapblock per row in the database. The format is documented here. The key format used in that database file is one of the things that needs to be changed if Minetest is to moved beyond 60 km world size.
- players.sqlite: Holds information about players: their position, health, breath, creation date, modification date; inventories, inventory items and metadata (which is how mods associate extra data with the player).
- mod_storage.sqlite: Holds key-value information that mods wants to store persistently. This is one of several useful techniques alongside the JSON and Lua table serializers that mods can use to store persistent data (see the Storage chapter of the modding book).
After looking around with SQLiteStudio, you can move onto the C++ code if you want to learn more; the database-related code is mostly in minetest/src/database/ in the source tree. Start with database.h which shows you what an implementation of that database for use inside Minetest will need, then look at any specific databases you are interested in. You will see what libraries are used to deal with each database supported by Minetest and how Minetest writes back to those databases.
/˳˳_˳˳]_[˳˳_˳˳]_[˳˳_˳˳\ Advtrains enthusiast | My map: Noah's Railyard | My Content on ContentDB ✝️♂
- Desour
- Member
- Posts: 1473
- Joined: Thu Jun 19, 2014 19:49
- GitHub: Desour
- IRC: Desour
- In-game: DS
- Location: I'm scared that if this is too exact, I will be unable to use my keyboard.
Re: How do database files look like in Minetest
You don't need to install any fancy gui stuff to look at the db tables. Just type `.schema` into the sqlite REPL (after starting with `$ sqlite3 <db file>`).
For how the world is stored, look into that file in doc/.
For how the world is stored, look into that file in doc/.
he/him; Codeberg; GitHub; ContentDB; public personal TODO list; "DS" is preferred (but often too short)
Re: How do database files look like in Minetest
Good advice.DS-minetest wrote: ↑Tue Jan 03, 2023 17:37For how the world is stored, look into that file in doc/.
However, a.m. "that file in doc/" being: Please be aware there might be undocumented changes to this format after the MT 5.5.0 release, I presume.
- Blockhead
- Member
- Posts: 1697
- Joined: Wed Jul 17, 2019 10:14
- GitHub: Montandalar
- IRC: Blockhead256
- In-game: Blockhead Blockhead256
- Location: Land Down Under
- Contact:
Re: How do database files look like in Minetest
Despite compiling Minetest from source regularly, I don't have the sqlite REPL installed, only the library files. So it's another program for me and presumably many others to install anyway. You don't need a markdown viewer to read lua_api.txt either, but some people like it that way.DS-minetest wrote: ↑Tue Jan 03, 2023 17:37You don't need to install any fancy gui stuff to look at the db tables. Just type `.schema` into the sqlite REPL (after starting with `$ sqlite3 <db file>`).
For how the world is stored, look into that file in doc/.
For what it's worth I tried the sqlite3 REPL and yeah.. it is a REPL with readline support.. okay. Good. But it's easier to read the schema off a GUI in my opinion, since it doesn't do any kind of pretty printing and just presents everything on one line:
Code: Select all
CREATE TABLE `player` (`name` VARCHAR(50) NOT NULL,`pitch` NUMERIC(11, 4) NOT NULL,`yaw` NUMERIC(11, 4) NOT NULL,`posX` NUMERIC(11, 4) NOT NULL,`posY` NUMERIC(11, 4) NOT NULL,`posZ` NUMERIC(11, 4) NOT NULL,`hp` INT NOT NULL,`breath` INT NOT NULL,`creation_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,`modification_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY (`name`));
I'm not saying don't use the SQLite CLI if you want to script something, or need to do some modifications on a game server with no GUI, I'm just recommending a really nice program, honestly. CLI purism, boo! Use of SQLiteStudio will not hinder your learning about SQLite and the SQL language, so avoiding it seems pointless to me.
I have no idea what you mean and the wiki link you gave does not help me understand. Why would the developers not update the documentation, what makes you think that?snoopy wrote: ↑Tue Jan 03, 2023 18:24Please be aware there might be undocumented changes to this format after the MT 5.5.0 release, I presume.
/˳˳_˳˳]_[˳˳_˳˳]_[˳˳_˳˳\ Advtrains enthusiast | My map: Noah's Railyard | My Content on ContentDB ✝️♂
Re: How do database files look like in Minetest
Hi,
@Blockhead - THX and apparently an interesting SQL viewer tool you are mentioning.
My five cents.
Have fun.
@Blockhead - THX and apparently an interesting SQL viewer tool you are mentioning.
Let me elaborate: IMO - without any blaming on anybody - one might be allowed to deduce the a.m. by usual dev's reluctance to do regular documentation updates and the following:Blockhead wrote: ↑Wed Jan 04, 2023 03:02. . .I have no idea what you mean and the wiki link you gave does not help me understand. Why would the developers not update the documentation, what makes you think that?snoopy wrote: ↑Tue Jan 03, 2023 18:24Please be aware there might be undocumented changes to this format after the MT 5.5.0 release, I presume.
- Increase max. objects per block defaults -- World / Server / Environment; MT 5.5.0 -> MT 5.6.0
- - 29 was added in 5.5.0-dev -- doc/ world_format.txt
My five cents.
Have fun.
- debiankaios
- Member
- Posts: 910
- Joined: Thu Dec 03, 2020 12:48
- IRC: debiankaios
- In-game: debiankaios Nowe
- Location: germany
- Contact:
Re: How do database files look like in Minetest
Under Linux:Blockhead wrote: ↑Tue Jan 03, 2023 16:28I suggest downloading the application SQLiteStudio, which is a great GUI program for exploring, editing and running SQL against SQLite database files.
Code: Select all
$ ./sqlitestudiocli
./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.34' not found (required by ./sqlitestudiocli)
./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.33' not found (required by /home/debiankaios/Programme/sqlitestudio/SQLiteStudio/lib/libreadline.so.8)
./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.33' not found (required by /home/debiankaios/Programme/sqlitestudio/SQLiteStudio/lib/libsqlite3.so)
./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.34' not found (required by /home/debiankaios/Programme/sqlitestudio/SQLiteStudio/lib/libsqlite3.so)
./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.33' not found (required by /home/debiankaios/Programme/sqlitestudio/SQLiteStudio/lib/libtinfo.so.6)
Code: Select all
$ sqlite3 players.sqlite # I easily excuted this command first
bash: sqlite3: Kommando nicht gefunden. # Translated: Command not found
sqlitebrowser worked fine.(sudo apt install sqlitebrowser)
📖 Deutsches Modding Book 👽 My Mod 🔌 TechAge Extension (WIP)
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
- Blockhead
- Member
- Posts: 1697
- Joined: Wed Jul 17, 2019 10:14
- GitHub: Montandalar
- IRC: Blockhead256
- In-game: Blockhead Blockhead256
- Location: Land Down Under
- Contact:
Re: How do database files look like in Minetest
snoopy wrote: ↑Wed Jan 04, 2023 09:04Let me elaborate: IMO - without any blaming on anybody - one might be allowed to deduce the a.m. by usual dev's reluctance to do regular documentation updates and the following:Today current stable is MT 5.6.1 or even unstable MT 5.7.0 available, I presume.
- Increase max. objects per block defaults -- World / Server / Environment; MT 5.5.0 -> MT 5.6.0
- - 29 was added in 5.5.0-dev -- doc/ world_format.txt
My five cents.
Have fun.
- Increase max. objects per block defaults -- World / Server / Environment; MT 5.5.0 -> MT 5.6.0
- - 29 was added in 5.5.0-dev -- doc/ world_format.txt
Code: Select all
$ cd minetest/doc/
$ git blame world_format.txt
e74668ef7f doc/mapformat.txt (Perttu Ahola 2012-06-08 14:57:02 +0300 1) =============================
d1624a5521 doc/world_format.txt (lhofhansl 2021-08-31 17:32:31 -0700 2) Minetest World Format 22...29
e74668ef7f doc/mapformat.txt (Perttu Ahola 2012-06-08 14:57:02 +0300 3) =============================
c353709f7e doc/mapformat.txt (Perttu Ahola 2012-03-22 13:36:56 +0200 4)
e74668ef7f doc/mapformat.txt (Perttu Ahola 2012-06-08 14:57:02 +0300 5) This applies to a world format carrying the block serialization version
021e667511 doc/world_format.txt (Dániel Juhász 2017-04-13 10:19:46 +0200 6) 22...27, used at least in
5c31445117 doc/mapformat.txt (Perttu Ahola 2012-07-24 14:56:32 +0300 7) - 0.4.dev-20120322 ... 0.4.dev-20120606 (22...23)
5c31445117 doc/mapformat.txt (Perttu Ahola 2012-07-24 14:56:32 +0300 8) - 0.4.0 (23)
5c31445117 doc/mapformat.txt (Perttu Ahola 2012-07-24 14:56:32 +0300 9) - 24 was never released as stable and existed for ~2 days
021e667511 doc/world_format.txt (Dániel Juhász 2017-04-13 10:19:46 +0200 10) - 27 was added in 0.4.15-dev
d1624a5521 doc/world_format.txt (lhofhansl 2021-08-31 17:32:31 -0700 11) - 29 was added in 5.5.0-dev
Code: Select all
$ git describe --tags d1624a5521
5.4.0-309-gd1624a552
$ git show --stat d1624a5521
commit d1624a552151bcb152b7abf63df6501b63458d78
Author: lhofhansl <lhofhansl@yahoo.com>
Date: 2021-08-31 17:32:31 -0700
Switch MapBlock compression to zstd (#10788)
* Add zstd support.
* Rearrange serialization order
* Compress entire mapblock
Co-authored-by: sfan5 <sfan5@live.de>
.github/workflows/build.yml | 2 +-
.github/workflows/macos.yml | 2 +-
.gitlab-ci.yml | 4 +--
Dockerfile | 2 +-
android/native/jni/Android.mk | 10 ++++--
builtin/settingtypes.txt | 16 ++++-----
cmake/Modules/FindZstd.cmake | 9 ++++++
doc/world_format.txt | 91 +++++++++++++++++++++++++++++----------------------
misc/debpkg-control | 2 +-
src/CMakeLists.txt | 11 +++++++
src/defaultsettings.cpp | 4 +--
src/main.cpp | 73 ++++++++++++++++++++++++++++++++++++++++-
src/mapblock.cpp | 166 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++------------------------------
src/mapblock.h | 2 +-
src/mapgen/mg_schematic.cpp | 9 ++++--
src/mapgen/mg_schematic.h | 1 +
src/mapnode.cpp | 30 ++++++-----------
src/mapnode.h | 5 +--
src/serialization.cpp | 135 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++----
src/serialization.h | 14 +++++---
src/unittest/test_compression.cpp | 42 ++++++++++++++++++++++--
util/buildbot/buildwin32.sh | 6 ++++
util/buildbot/buildwin64.sh | 6 ++++
util/ci/common.sh | 2 +-
24 files changed, 493 insertions(+), 151 deletions(-)
This was all working in reverse to trace things back to where they began in GitHub, but it reinforces my hypothesis that changes are not just added willy-nilly and undocumented to Minetest. The absence of evidence is not the evidence of absence. To apply this to my point: it's only casting unnecessary doubt to assume the developers of Minetest haven't updated their docs. Minetest isn't a solo project used by only a few people, subjected to little peer review and no complaints from breakage. Minetest's pull request reviews are thorough and pull requests won't get approved if the documentation isn't updated to match the new functionality. If anything, most people complain it takes too long to get anything merged into Minetest.'
You can found out about how the Minetest project is run relatively easily if you visit GitHub and just look through the pull request threads for some time. Any of the lengthier threads will show the kind of project Minetest is, because the communication is largely done out in the open, and the review process is obviously there. It's a free software project licensed under the LGPL, written by a large community of contributors and lead by a smaller group of core developers. There are also documents like the Contribution guidelines which GitHub will link to anyone who wants to open a new Minetest pull request.
Footnote
*Pulls and issues share the same number counter so differentiating pull and issue numbers is both impossible without context and not usually particularly useful anyway.
You must be running a relatively new or old Linux distribution, or not have a lot of software installed. You don't have the GLibc library version 6, or more likely your version is too odl or new. On Debian this is available through the package libc-bin or libc6 which works fine to run it for me on Debian Bookworm. I'm not sure about other distributions, sorry. Distributing software for Linux is never really that easy; if you got other programs working fine and you are happy with them, then I'm happy for you. It's just a software recommendation anyway.debiankaios wrote: ↑Wed Jan 04, 2023 17:34Under Linux:
Code: Select all
$ ./sqlitestudiocli ./sqlitestudiocli: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.34' not found (required by ./sqlitestudiocli)
Finding the package and installing it on Debian should look like this:
Code: Select all
$ apt-file search libc.so.6
libc6: /lib/x86_64-linux-gnu/libc.so.6
...
$ sudo apt install libc6
/˳˳_˳˳]_[˳˳_˳˳]_[˳˳_˳˳\ Advtrains enthusiast | My map: Noah's Railyard | My Content on ContentDB ✝️♂
- debiankaios
- Member
- Posts: 910
- Joined: Thu Dec 03, 2020 12:48
- IRC: debiankaios
- In-game: debiankaios Nowe
- Location: germany
- Contact:
Re: How do database files look like in Minetest
Code: Select all
$ apt-file search libc.so.6
libc6: /lib/x86_64-linux-gnu/libc.so.6
libc6-amd64-cross: /usr/x86_64-linux-gnu/lib/libc.so.6
libc6-amd64-i386-cross: /usr/i686-linux-gnu/lib64/libc.so.6
libc6-amd64-x32-cross: /usr/x86_64-linux-gnux32/lib64/libc.so.6
libc6-arm64-cross: /usr/aarch64-linux-gnu/lib/libc.so.6
libc6-armel-cross: /usr/arm-linux-gnueabi/lib/libc.so.6
libc6-armhf-cross: /usr/arm-linux-gnueabihf/lib/libc.so.6
libc6-hppa-cross: /usr/hppa-linux-gnu/lib/libc.so.6
libc6-i386: /lib32/libc.so.6
libc6-i386-amd64-cross: /usr/x86_64-linux-gnu/lib32/libc.so.6
libc6-i386-cross: /usr/i686-linux-gnu/lib/libc.so.6
libc6-i386-x32-cross: /usr/x86_64-linux-gnux32/lib32/libc.so.6
libc6-m68k-cross: /usr/m68k-linux-gnu/lib/libc.so.6
libc6-mips-cross: /usr/mips-linux-gnu/lib/libc.so.6
libc6-mips32-mips64-cross: /usr/mips64-linux-gnuabi64/libo32/libc.so.6
libc6-mips32-mips64el-cross: /usr/mips64el-linux-gnuabi64/libo32/libc.so.6
libc6-mips32-mips64r6-cross: /usr/mipsisa64r6-linux-gnuabi64/libo32/libc.so.6
libc6-mips32-mips64r6el-cross: /usr/mipsisa64r6el-linux-gnuabi64/libo32/libc.so.6
libc6-mips32-mipsn32-cross: /usr/mips64-linux-gnuabin32/libo32/libc.so.6
libc6-mips32-mipsn32el-cross: /usr/mips64el-linux-gnuabin32/libo32/libc.so.6
libc6-mips32-mipsn32r6-cross: /usr/mipsisa64r6-linux-gnuabin32/libo32/libc.so.6
libc6-mips32-mipsn32r6el-cross: /usr/mipsisa64r6el-linux-gnuabin32/libo32/libc.so.6
libc6-mips64-cross: /usr/mips64-linux-gnuabi64/lib/libc.so.6
libc6-mips64-mips-cross: /usr/mips-linux-gnu/lib64/libc.so.6
libc6-mips64-mipsel-cross: /usr/mipsel-linux-gnu/lib64/libc.so.6
libc6-mips64-mipsn32-cross: /usr/mips64-linux-gnuabin32/lib64/libc.so.6
libc6-mips64-mipsn32el-cross: /usr/mips64el-linux-gnuabin32/lib64/libc.so.6
libc6-mips64-mipsn32r6-cross: /usr/mipsisa64r6-linux-gnuabin32/lib64/libc.so.6
libc6-mips64-mipsn32r6el-cross: /usr/mipsisa64r6el-linux-gnuabin32/lib64/libc.so.6
libc6-mips64-mipsr6-cross: /usr/mipsisa32r6-linux-gnu/lib64/libc.so.6
libc6-mips64-mipsr6el-cross: /usr/mipsisa32r6el-linux-gnu/lib64/libc.so.6
libc6-mips64el-cross: /usr/mips64el-linux-gnuabi64/lib/libc.so.6
libc6-mips64r6-cross: /usr/mipsisa64r6-linux-gnuabi64/lib/libc.so.6
libc6-mips64r6el-cross: /usr/mipsisa64r6el-linux-gnuabi64/lib/libc.so.6
libc6-mipsel-cross: /usr/mipsel-linux-gnu/lib/libc.so.6
libc6-mipsn32-cross: /usr/mips64-linux-gnuabin32/lib/libc.so.6
libc6-mipsn32-mips-cross: /usr/mips-linux-gnu/lib32/libc.so.6
libc6-mipsn32-mips64-cross: /usr/mips64-linux-gnuabi64/lib32/libc.so.6
libc6-mipsn32-mips64el-cross: /usr/mips64el-linux-gnuabi64/lib32/libc.so.6
libc6-mipsn32-mips64r6-cross: /usr/mipsisa64r6-linux-gnuabi64/lib32/libc.so.6
libc6-mipsn32-mips64r6el-cross: /usr/mipsisa64r6el-linux-gnuabi64/lib32/libc.so.6
libc6-mipsn32-mipsel-cross: /usr/mipsel-linux-gnu/lib32/libc.so.6
libc6-mipsn32-mipsr6-cross: /usr/mipsisa32r6-linux-gnu/lib32/libc.so.6
libc6-mipsn32-mipsr6el-cross: /usr/mipsisa32r6el-linux-gnu/lib32/libc.so.6
libc6-mipsn32el-cross: /usr/mips64el-linux-gnuabin32/lib/libc.so.6
libc6-mipsn32r6-cross: /usr/mipsisa64r6-linux-gnuabin32/lib/libc.so.6
libc6-mipsn32r6el-cross: /usr/mipsisa64r6el-linux-gnuabin32/lib/libc.so.6
libc6-mipsr6-cross: /usr/mipsisa32r6-linux-gnu/lib/libc.so.6
libc6-mipsr6el-cross: /usr/mipsisa32r6el-linux-gnu/lib/libc.so.6
libc6-powerpc-cross: /usr/powerpc-linux-gnu/lib/libc.so.6
libc6-powerpc-ppc64-cross: /usr/powerpc64-linux-gnu/lib32/libc.so.6
libc6-ppc64-cross: /usr/powerpc64-linux-gnu/lib/libc.so.6
libc6-ppc64-powerpc-cross: /usr/powerpc-linux-gnu/lib64/libc.so.6
libc6-ppc64el-cross: /usr/powerpc64le-linux-gnu/lib/libc.so.6
libc6-riscv64-cross: /usr/riscv64-linux-gnu/lib/libc.so.6
libc6-s390-s390x-cross: /usr/s390x-linux-gnu/lib32/libc.so.6
libc6-s390x-cross: /usr/s390x-linux-gnu/lib/libc.so.6
libc6-sh4-cross: /usr/sh4-linux-gnu/lib/libc.so.6
libc6-sparc-sparc64-cross: /usr/sparc64-linux-gnu/lib32/libc.so.6
libc6-sparc64-cross: /usr/sparc64-linux-gnu/lib/libc.so.6
libc6-x32: /libx32/libc.so.6
libc6-x32-amd64-cross: /usr/x86_64-linux-gnu/libx32/libc.so.6
libc6-x32-cross: /usr/x86_64-linux-gnux32/lib/libc.so.6
libc6-x32-i386-cross: /usr/i686-linux-gnu/libx32/libc.so.6
libc6.1-alpha-cross: /usr/alpha-linux-gnu/lib/libc.so.6.1
debiankaios@debiankaios:~$ sudo apt install libc6
[sudo] Passwort für debiankaios:
Paketlisten werden gelesen… Fertig
Abhängigkeitsbaum wird aufgebaut… Fertig
Statusinformationen werden eingelesen… Fertig
libc6 ist schon die neueste Version (2.31-13+deb11u5).
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 0 nicht aktualisiert.
📖 Deutsches Modding Book 👽 My Mod 🔌 TechAge Extension (WIP)
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
- Blockhead
- Member
- Posts: 1697
- Joined: Wed Jul 17, 2019 10:14
- GitHub: Montandalar
- IRC: Blockhead256
- In-game: Blockhead Blockhead256
- Location: Land Down Under
- Contact:
Re: How do database files look like in Minetest
Ah, classic Debian. "Old software only". Bullseye is a version too out of date to run it.. Oh well. I guess there are older versions available, or you can compile from source, if you really want.debiankaios wrote: ↑Wed Jan 04, 2023 19:51libc6 ist schon die neueste Version (2.31-13+deb11u5).
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 0 nicht aktualisiert.
[/code]
/˳˳_˳˳]_[˳˳_˳˳]_[˳˳_˳˳\ Advtrains enthusiast | My map: Noah's Railyard | My Content on ContentDB ✝️♂
Debian rocks - Re: How do database files look like in Minetest
Hi,
@Blockhead - Sorry, but I agree to strongly disagree.
There are many Linux distributions, *BSD and some more Un*x options available for experts, developers and general users including but not limited to early adopters around for good reasons.
However, just bashing Debian again looks non-professional and IMO lacks some basic understanding.
My five cents.
@Blockhead - Sorry, but I agree to strongly disagree.
@Blockhead - si tacuisses, philosophus mansisses
There are many Linux distributions, *BSD and some more Un*x options available for experts, developers and general users including but not limited to early adopters around for good reasons.
However, just bashing Debian again looks non-professional and IMO lacks some basic understanding.
- The Open Source Definition -- derived from the Debian Free Software Guidelines (DFSG)
- Debian Free Software Guidelines (DFSG)
- Debian turn{ed} 29!
- Reasons to use Debian
- Updated Debian 11: 11.6 released December 17th, 2022
My five cents.
Last edited by snoopy on Fri Jan 06, 2023 12:54, edited 2 times in total.
- Blockhead
- Member
- Posts: 1697
- Joined: Wed Jul 17, 2019 10:14
- GitHub: Montandalar
- IRC: Blockhead256
- In-game: Blockhead Blockhead256
- Location: Land Down Under
- Contact:
Re: Debian rocks - Re: How do database files look like in Minetest
You seem to have missed my point above:
where I said I use Debian myself, just the testing distribution. I'm well aware of the philosophy and aims of Debian and that's why it's my preferred distribution. I'm just sharing the common frustration of using a stable distribution and not being able to use certain newer versions of software, which Debian stable users experience all too often. Those things we know most about we are most able to criticise. As is often the case with Debian stable, it looks like it's time for Debiankaios to compile from source again or use an older version. Now if the older version were available through apt, that would be easy, and that's the case for many, many programs on Debian, whose repositories are amongst if not the biggest of any Linux distribution. It's just a small omission of a relatively obscure program in this case.
Also why do you say "again"? I'm not in the habit of just "bashing" any operating system on here. I thought this was my first comment that had anything negative to say about Debian at all in this thread or really anywhere on the forums. In fact I try to participate in supporting users of Windows, macOS and Linux on here if you look through my post history. Consider my comment about "only old software" as a tongue-in-cheek caricature, much like calling Windows 10/11 Spyware, proclaiming "i use arch btw", or any other number of memes that proliferate about operating systems.
So this post isn't totally off-topic, here is an interesting little fact about Minetest: the unit tests for compression include tests for RLE, zlib and zstd compression to compare the performance when compressing pseudorandom data. The data in a mapblock is not likely to be quite as random, but it still proves zstd is a worthwhile codec for compressing mapblocks in the database.
You can see how long each test takes on your own system by running minetest --run-unittests. Despite compressing 10x more data, the zstd compression test runs in only 3-4 ms instead of the 1 ms of the zlib test. Impressive - though those figures may be subject to rounding problems of course.
/˳˳_˳˳]_[˳˳_˳˳]_[˳˳_˳˳\ Advtrains enthusiast | My map: Noah's Railyard | My Content on ContentDB ✝️♂
- debiankaios
- Member
- Posts: 910
- Joined: Thu Dec 03, 2020 12:48
- IRC: debiankaios
- In-game: debiankaios Nowe
- Location: germany
- Contact:
Re: How do database files look like in Minetest
Sorry, i am new on this topic(databases). But i like my OS(devuan chimaera) where shnap isn't working. But i like not flathub.
📖 Deutsches Modding Book 👽 My Mod 🔌 TechAge Extension (WIP)
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
Devuan & Debian - Re: How do database files look like in Minetest
Hi,
@debiankaios - Apparently you are a Devuan 'Friends and Software Freedom Lover' ?
Did you try to use a.m. sqlitestudiocli from the XZ-package or did you produce a self compile from sources?
FYI
Unfortunately, I am not familiar with Devuan but familiar with Debian.
AFAIK the release info from Devuan does not hold an obvious date & time stamp, unfortunately. However, the more obvious release info available as of today shows:
Furthermore:
Last not least IMO you should use the stable SQLiteStudio 3.4.1 sources and not the unstable dev sources.
AFAIK you could give compiling from sources a try. Presumably on Devuan and certainly with Debian (stable).
Good luck!
My five cents.
@debiankaios - Apparently you are a Devuan 'Friends and Software Freedom Lover' ?
Presumably you are using the sqlitestudio-3.4.1.tar.xz from the SQLiteStudio GitHub Release?debiankaios wrote: ↑Thu Jan 05, 2023 16:56But i like my OS(devuan chimaera) where shnap isn't working. But i like not flathub.
Did you try to use a.m. sqlitestudiocli from the XZ-package or did you produce a self compile from sources?
FYI
Unfortunately, I am not familiar with Devuan but familiar with Debian.
AFAIK the release info from Devuan does not hold an obvious date & time stamp, unfortunately. However, the more obvious release info available as of today shows:
- Devuan Chimaera 4.0 stable release - 2021-10-14
- Updated Debian 11: 11.6 Bullseye (stable) - released 2022-12-17
Furthermore:
- SQLiteStudio
- SQLiteStudio 3.4.1 released! - Posted on 02 December 2022
- SQLiteStudio Download & GitHub Releases
- SQLiteStudio Compiling from sources
- SQLiteStudio requires Qt 5.12+ apparently.
- Debian Bullseye available packages for qmake are
- qt5-qmake 5.15.2+dfsg-9: amd64 and
- qt5-qmake-bin 5.15.2+dfsg-9: amd64
- there are some other minor requirements easily met, I presume.
Last not least IMO you should use the stable SQLiteStudio 3.4.1 sources and not the unstable dev sources.
AFAIK you could give compiling from sources a try. Presumably on Devuan and certainly with Debian (stable).
Good luck!
My five cents.
- debiankaios
- Member
- Posts: 910
- Joined: Thu Dec 03, 2020 12:48
- IRC: debiankaios
- In-game: debiankaios Nowe
- Location: germany
- Contact:
Re: How do database files look like in Minetest
I tried option 3, but not important, i don't need all features(i think). I want only read the basic things of databases.
📖 Deutsches Modding Book 👽 My Mod 🔌 TechAge Extension (WIP)
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
2147483 is the new world border.
⛏ Proxima Survival(WIP) ⚔️ Minigames A.E.S(WIP)
🌐 My Website
Re: How do database files look like in Minetest
Hi,
My old friend @snoopy again catching some fish here?
Following the expert's advice from the Linux - Manual compilation - more detailed description under the SQLiteStudio GitHub wiki documentary.
For SQLiteStudio 3.4.1 compile from sources on Debian 11.6 Bullseye (stable) have a look at:
Q.E.D. and easy go with Debian (stable) after some little quirks healed by help found on the Debian package info and on the internet as always.
However, the SQLiteStudio3 program might be worth a try if you want to handle databases which are supported by this tool.
Have fun with MT and prosper.
My old friend @snoopy again catching some fish here?
Here's my catch on this little endeavour, if I may introduce this here for MT dev SQLite Database enthusiasts.debiankaios wrote: ↑Fri Jan 06, 2023 13:04I tried option 3, but not important, i don't need all features(i think). I want only read the basic things of databases.
Following the expert's advice from the Linux - Manual compilation - more detailed description under the SQLiteStudio GitHub wiki documentary.
For SQLiteStudio 3.4.1 compile from sources on Debian 11.6 Bullseye (stable) have a look at:
Q.E.D. and easy go with Debian (stable) after some little quirks healed by help found on the Debian package info and on the internet as always.
However, the SQLiteStudio3 program might be worth a try if you want to handle databases which are supported by this tool.
Have fun with MT and prosper.
Last edited by Zweihorn on Fri Jan 06, 2023 23:03, edited 1 time in total.
Re: How do database files look like in Minetest
IMO this would apply to Devuan Chimaera almost similarily.Zweihorn wrote: ↑Fri Jan 06, 2023 14:22
Some more concise script for SQLiteStudio 3.4.1 compile from sources on Debian 11.6 Bullseye (stable) would be:
...
Have fun with MT and MT sqlite database backend.
Furthermore, only from the above I just learned that Devuan is a project by the ©2000-2022 Dyne.org foundation located in Amsterdam, EU.
Their motto is:
"Free to share code.
Code to share freedom."
Re: How do database files look like in Minetest
I usually use DBeaver SQL Client to access Minetest Database files (because is the SQL client I use to access databases at work).
Who is online
Users browsing this forum: No registered users and 1 guest