prisma-engines-freebsd

1. Scripts for building the prisma engine on your own device
2. Precompiled prisma engine for freebsd 12-14
3. Prisma engine usage guide in freebsd

usage

• for freebsd < 14, download prisma-engines-FreeBSD_13.2-RELEASE_amd64.tar.gz, test on freebsd 13.2, freebsd 12.4

• for freebsd >= 14, download prisma-engines-FreeBSD_14.0-RELEASE_amd64.tar.gz, test on freebsd 14.0

use as environment variable

• https://www.prisma.io/docs/concepts/components/prisma-engines#using-custom-engine-libraries-or-binaries

# detect os
case "$(uname -r)" in
*"11."*)
  FreeBSD_Version=freebsd11
  Prisma_Build=https://github.com/gek64/prisma-engines-freebsd/releases/download/latest/prisma-engines-FreeBSD_13.2-RELEASE_amd64.tar.gz
  ;;
*"12."*)
  FreeBSD_Version=freebsd12
  Prisma_Build=https://github.com/gek64/prisma-engines-freebsd/releases/download/latest/prisma-engines-FreeBSD_13.2-RELEASE_amd64.tar.gz
  ;;
*"13."*)
  FreeBSD_Version=freebsd13
  Prisma_Build=https://github.com/gek64/prisma-engines-freebsd/releases/download/latest/prisma-engines-FreeBSD_13.2-RELEASE_amd64.tar.gz
  ;;
*"14."* | *)
  FreeBSD_Version=freebsd14
  Prisma_Build=https://github.com/gek64/prisma-engines-freebsd/releases/download/latest/prisma-engines-FreeBSD_14.0-RELEASE_amd64.tar.gz
  ;;
esac

# download prisma-engines
curl -Lo "/tmp/prisma-engines.tar.gz" $Prisma_Build

# unzip prisma-engines
mkdir -p /tmp/prisma-engines && tar -xvf "/tmp/prisma-engines.tar.gz" -C /tmp/prisma-engines

# rename libquery_engine.so
mv "/tmp/prisma-engines/libquery_engine.so" "/tmp/prisma-engines/libquery_engine.so.node"

# move to `/usr/share/prisma-engines`
mv /tmp/prisma-engines /usr/share/prisma-engines

# set env
export PRISMA_QUERY_ENGINE_BINARY="/usr/share/prisma-engines/query-engine"
export PRISMA_QUERY_ENGINE_LIBRARY="/usr/share/prisma-engines/libquery_engine.so.node"
export PRISMA_SCHEMA_ENGINE_BINARY="/usr/share/prisma-engines/schema-engine"
export PRISMA_CLI_QUERY_ENGINE_TYPE="library"
export PRISMA_CLIENT_ENGINE_TYPE="library"

# run test
npx prisma -v

use as library

# copy libquery_engine.so.node to the dist folder of the project compiled with ncc(https://github.com/vercel/ncc)
cp "/usr/share/prisma-engines/libquery_engine.so.node" "$HOME/moneybook/dist/libquery_engine-$FreeBSD_Version.so.node"

# copy libquery_engine.so.node to project node_modules folder
cp "/usr/share/prisma-engines/libquery_engine.so.node" "$HOME/moneybook/node_modules/.prisma/client/libquery_engine-$FreeBSD_Version.so.node"

compile yourself

• system memory >= 8GB

# compile using prebuilt openssl
curl -sSf https://raw.githubusercontent.com/gek64/prisma-engines-freebsd/main/build-prisma-engines.sh | sh
# compile using openssl compiled from source
curl -sSf https://raw.githubusercontent.com/gek64/prisma-engines-freebsd/main/build-prisma-engines.sh | sh -s -- -c

# check
ls "$HOME/prisma-engines-*.tar.gz"