losfair/mvsqlite

Instructions on how to build sqlite3.exe for windows

fire opened this issue · 2 comments

fire commented

Windows support with sqlite3.exe

cmd
scoop install llvm openssl-mingw llvm-mingw
cargo build --release -p mvsqlite` Works on Windows 11.
cd mvsqlite/mvsqlite
# Tinkering with shims see zip.
gcc -O2 -o sqlite3 sqlite3.c shell.c shim.c preload.c -L../target/release -LC:/Users/elee/scoop/apps/openssl-mingw/current/lib64 -lmvsqlite -lssl -lcrypto -lWs2_32 -lbcrypt -lUserenv -lntdll
set RUST_LOG=info
set MVSQLITE_DATA_PLANE=http://localhost:7000
sqlite3.exe test
.vfslist
  2022-10-19T05:05:35.621924Z  INFO mvsqlite: mvsqlite initialized, default_sector_size: 8192
    at mvsqlite\src\lib.rs:174

SQLite version 3.39.3 2022-09-05 11:02:23
Enter ".help" for usage hints.
sqlite> .vfslist
vfs.zName      = "mvsqlite"  <--- CURRENT
[...]

mvsqlite.zip

We are assuming that the fdb and mvstore is in an ubuntu os. That they've been started and the admin interface has been used to create a test database.

Other notes

The dependencies openssl-devel are required for ssl and crypto. Might be able to use mbedtls.

fire commented

I made a partial godot engine sqlite module. It's partial because it doesn't store the rust code. It fetches the static library from the Windows 11 filesystem.

https://github.com/V-Sekai/godot-sqlite/tree/mvsqlite

image

I told godot to do a listing of the database tables.

fire commented

Closing because I am using this and it appears to work for me.