- main.js runs database connecting test to:
- MongoDB 3.x
- MongoDB 6.x
- FerretDB PostgreSQL
- FerretDB SQLite
- At package.json is many packages, that are also used at https://github.com/wekan/wekan
- main.js and npm packages are compiled to single executeables with Bun and Deno.
- Not possible yet with Node.js, because Node.js can not yet include npm packages to executeable.
- This test is to see, what works at each CPU/OS. This is only database connect test, not yet any other features.
- Only difference is, how to do imports. Other Javascript code is exactly same in Node.js 20, Bun and Deno.
- Node.js and Bun use this syntax for imports at
main.jshttps://github.com/wekan/wekan-node20/blob/main/main.js#L7-L9
// Node.js and Bun imports using package.json
const { MongoClient } = require("mongodb");
const { MongoClient: MongoClientLegacy } = require("mongodb-legacy");
- Deno uses different syntax for imports at
main-deno.jshttps://github.com/wekan/wekan-node20/blob/main/main-deno.js#L2-L4
// Deno imports using deno.json
import { MongoClient } from "mongodb";
import { MongoClient as MongoClientLegacy } from "mongodb-legacy";
- SE = Single Executeable at https://github.com/wekan/wekan-node20/releases
- Runs = Does run, but no Single Executeable
| Features | Node.js 20 | Bun | Deno | Details |
|---|---|---|---|---|
| Single Executeable | No. Can not include npm modules yet. | Yes | Yes. Deno can crosscompile some binaries. | |
| Production use | Yes, has traceability and many CPU/OS | No | No | |
| Linux amd64 | Runs | SE 92.1 MB | SE 365 MB. "Node.js compatibility layer" includes Node.js, so binaries are bigger. | |
| Linux arm64 | Runs | SE 84.4 MB | SE 1.35 GB Too big size is bug | https://github.com/wekan/wekan/wiki/Raspberry-Pi |
| Linux s390x | 20 Runs. 14 has Segmentation fault | No | No | https://github.com/wekan/wekan/wiki/s390x |
| Windows amd64 | Runs | No | SE 324 MB | https://github.com/wekan/wekan/wiki/Offline |
| Mac amd64 | Runs | No. "Your shell is running in Rosetta 2. Downloading bun for darwin-aarch64 instead" | SE 348 MB | https://github.com/wekan/wekan/wiki/Mac |
| Mac arm64 | Runs | SE 49.9 MB | SE 345 MB | https://github.com/wekan/wekan/wiki/Mac |
- There is no precompiled binaries of Zig and Bun oven-sh/bun#2632
- Trying: Compile LLVM, to compile Zig, to compile Bun.
- Trying to compile LLVM (for Zig and Bun) ends with this error at s390x VM that has 8 GB RAM:
inlined from ‘std::__cxx11::basic_string<_CharT, _Traits, _Allocator>& std::__cxx11::basic_string<_CharT, _Traits, _Alloc>::_M_replace(size_type, size_type, const _CharT*, size_type) [with _CharT = char; _Traits = std::char_traits<char>; _Alloc = std::allocator<char>]’ at /usr/include/c++/12/bits/basic_string.tcc:532:22,
inlined from ‘std::__cxx11::basic_string<_CharT, _Traits, _Alloc>& std::__cxx11::basic_string<_CharT, _Traits, _Alloc>::replace(size_type, size_type, const _CharT*, size_type) [with _CharT = char; _Traits = std::char_traits<char>; _Alloc = std::allocator<char>]’ at /usr/include/c++/12/bits/basic_string.h:2179:19,
inlined from ‘std::__cxx11::basic_string<_CharT, _Traits, _Alloc>& std::__cxx11::basic_string<_CharT, _Traits, _Alloc>::insert(size_type, const _CharT*) [with _CharT = char; _Traits = std::char_traits<char>; _Alloc = std::allocator<char>]’ at /usr/include/c++/12/bits/basic_string.h:1936:22,
inlined from ‘std::__cxx11::basic_string<_CharT, _Traits, _Allocator> std::operator+(const _CharT*, __cxx11::basic_string<_CharT, _Traits, _Allocator>&&) [with _CharT = char; _Traits = char_traits<char>; _Alloc = allocator<char>]’ at /usr/include/c++/12/bits/basic_string.h:3549:36,
inlined from ‘virtual void {anonymous}::UnsafeBufferUsageReporter::handleUnsafeVariableGroup(const clang::VarDecl*, const clang::DefMapTy&, clang::UnsafeBufferUsageHandler::FixItList&&)’ at /home/linux1/repos/llvm-project-17/clang/lib/Sema/AnalysisBasedWarnings.cpp:2255:36:
/usr/include/c++/12/bits/char_traits.h:435:56: warning: ‘void* __builtin_memcpy(void*, const void*, long unsigned int)’ accessing 9223372036854775810 or more bytes at offsets [2, 9223372036854775807] and 1 may overlap up to 9223372036854775813 bytes at offset -3 [-Wrestrict]
435 | return static_cast<char_type*>(__builtin_memcpy(__s1, __s2, __n));
| ~~~~~~~~~~~~~~~~^~~~~~~~~~~~~~~~~
[3640/4949] Building CXX object tools/clang/lib/ASTMatchers/Dynamic/CMakeFiles/obj.clangDynamicASTMatchers.dir/Registry.cpp.o
FAILED: tools/clang/lib/ASTMatchers/Dynamic/CMakeFiles/obj.clangDynamicASTMatchers.dir/Registry.cpp.o
/usr/bin/c++ -DGTEST_HAS_RTTI=0 -D_DEBUG -D_GLIBCXX_ASSERTIONS -D_GNU_SOURCE -D_LIBCPP_ENABLE_HARDENED_MODE -D__STDC_CONSTANT_MACROS -D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS -I/home/linux1/repos/llvm-project-17/build-release/tools/clang/lib/ASTMatchers/Dynamic -I/home/linux1/repos/llvm-project-17/clang/lib/ASTMatchers/Dynamic -I/home/linux1/repos/llvm-project-17/clang/include -I/home/linux1/repos/llvm-project-17/build-release/tools/clang/include -I/home/linux1/repos/llvm-project-17/build-release/include -I/home/linux1/repos/llvm-project-17/llvm/include -fPIC -fno-semantic-interposition -fvisibility-inlines-hidden -Werror=date-time -fno-lifetime-dse -Wall -Wextra -Wno-unused-parameter -Wwrite-strings -Wcast-qual -Wno-missing-field-initializers -pedantic -Wno-long-long -Wimplicit-fallthrough -Wno-maybe-uninitialized -Wno-nonnull -Wno-class-memaccess -Wno-redundant-move -Wno-pessimizing-move -Wno-noexcept-type -Wdelete-non-virtual-dtor -Wsuggest-override -Wno-comment -Wno-misleading-indentation -Wctad-maybe-unsupported -fdiagnostics-color -ffunction-sections -fdata-sections -fno-common -Woverloaded-virtual -fno-strict-aliasing -O3 -DNDEBUG -fno-exceptions -funwind-tables -fno-rtti -UNDEBUG -std=c++17 -MD -MT tools/clang/lib/ASTMatchers/Dynamic/CMakeFiles/obj.clangDynamicASTMatchers.dir/Registry.cpp.o -MF tools/clang/lib/ASTMatchers/Dynamic/CMakeFiles/obj.clangDynamicASTMatchers.dir/Registry.cpp.o.d -o tools/clang/lib/ASTMatchers/Dynamic/CMakeFiles/obj.clangDynamicASTMatchers.dir/Registry.cpp.o -c /home/linux1/repos/llvm-project-17/clang/lib/ASTMatchers/Dynamic/Registry.cpp
c++: fatal error: Killed signal terminated program cc1plus
compilation terminated.
[3645/4949] Building CXX object tools/clang/lib/Sema/CMakeFiles/obj.clangSema.dir/SemaCodeComplete.cpp.o
ninja: build stopped: subcommand failed.
- There is no ninja_gn binaries for s390x https://github.com/denoland/ninja_gn_binaries
- Rust ring (a crypto dependency) does not support s390x.
- denoland/deno#20212 (comment)
- FerretDB Linux amd64/armv7/arm64 https://github.com/ferretdb/FerretDB/pkgs/container/ferretdb
- Some not checked yet, does it exist?
| Features | MongoDB 3.x | MongoDB 6.x | FerretDB |
|---|---|---|---|
| Linux amd64 | Yes | Yes | Yes |
| Linux armv7 | ? | No | Yes |
| Linux arm64 | ? | Yes | Yes |
| Linux s390x | ? | ? | ? |
| Windows amd64 | ? | Yes | ? |
| Mac amd64 | ? | Yes | ? |
| Mac arm64 | ? | Yes | ? |
- MongoDB 3.x, to be compatible with WeKan Snap Stable migrations, and https://sandstorm.io MongoDB 3.0
- MongoDB 6.x, to be compatible with newest Meteor
- FerretDB
- Website https://www.ferretdb.io
- FerretDB is MongoDB 6.x wire protocol compatible proxy to PostgreSQL or SQLite. Replaces MongoDB.
- https://blog.ferretdb.io/ferretdb-v1-10-production-ready-sqlite/
- Improve compatibility with real specific apps and libraries FerretDB/FerretDB#5
- FerretDB WeKan issue FerretDB/FerretDB#1752
- At this repo docker-compose.yml:
- FerretDB PostgreSQL
- FerretDB SQLite
- PostgreSQL
- SQLite
- MySQL
- MSSQL
- Oracle
- DAL (Database Access Layer) and ORM (Object Relational Mapper)
- Generating database queries from same syntax to many different database syntax
- If using DAL/ORM is improvement, not too much size or slowness added
- Those that also support CloudFlare D1 SQLite database
- Kysely, at bottom of page https://github.com/wekan/wekan/wiki/WeKan-Multiverse-Roadmap
- Feathers-kysely
- Drizzle ORM
- Or others at https://developers.cloudflare.com/d1/platform/community-projects/
- Or maybe:
- TypeORM https://www.npmjs.com/package/typeorm
- Sequelize https://www.npmjs.com/package/sequelize