Modules for DB Dialetica not Found

[coltossoff]

Describe the bug

I'm trying to add mikro-orm sqlite to my Angular SSR project. I have it to the point where it works with the mikro-orm-esm commands, but when I go to build/run the project it gives me the following errors. I think this has something to do with Sqlite configuration improperly passing something into core, but I'm not sure.

./node_modules/@mikro-orm/core/utils/Configuration.js:131:59-69 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/@mikro-orm/core/utils/Utils.js:146:41-51 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/@mikro-orm/core/utils/Utils.js:638:9-16 - Warning: Critical dependency: require function is used in a way in which dependencies cannot be statically extracted

./node_modules/@mikro-orm/core/utils/Utils.js:638:33-40 - Warning: Critical dependency: require function is used in a way in which dependencies cannot be statically extracted

./node_modules/@mikro-orm/core/utils/Utils.js:888:15-52 - Warning: Module not found: Error: Can't resolve '../../package.json' in 'C:\repos\AngularSignalsDemo\node_modules\@mikro-orm\core\utils'

./node_modules/@rushstack/node-core-library/lib/FileWriter.js:10:45-52 - Warning: Critical dependency: require function is used in a way in which dependencies cannot be statically extracted

./node_modules/@ts-morph/common/dist/typescript.js:2895:20-42 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/@ts-morph/common/dist/typescript.js:6069:26-45 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/jju/lib/utils.js:9:2-3 - Warning: Critical dependency: require function is used in a way in which dependencies cannot be statically extracted

./node_modules/knex/lib/migrations/util/import-file.js:11:44-90 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/knex/lib/migrations/util/import-file.js:11:93-110 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/umzug/lib/umzug.js:558:15-32 - Warning: Critical dependency: the request of a dependency is an expression

./node_modules/umzug/lib/umzug.js:567:15-31 - Warning: Critical dependency: the request of a dependency is an expression



./node_modules/@mikro-orm/knex/dialects/mysql/MariaDbKnexDialect.js:13:11-38 - Error: Module not found: Error: Can't resolve 'mariadb/callback' in 'C:\repos\AngularSignalsDemo\node_modules\@mikro-orm\knex\dialects\mysql'

./node_modules/@mikro-orm/knex/dialects/sqlite/BetterSqliteKnexDialect.js:11:11-36 - Error: Module not found: Error: Can't resolve 'better-sqlite3' in 'C:\repos\AngularSignalsDemo\node_modules\@mikro-orm\knex\dialects\sqlite'

./node_modules/@mikro-orm/knex/dialects/sqlite/LibSqlKnexDialect.js:14:11-28 - Error: Module not found: Error: Can't resolve 'libsql' in 'C:\repos\AngularSignalsDemo\node_modules\@mikro-orm\knex\dialects\sqlite'

./node_modules/knex/lib/dialects/better-sqlite3/index.js:7:11-36 - Error: Module not found: Error: Can't resolve 'better-sqlite3' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\better-sqlite3'

./node_modules/knex/lib/dialects/mssql/index.js:92:16-34 - Error: Module not found: Error: Can't resolve 'tedious' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\mssql'

./node_modules/knex/lib/dialects/mysql/index.js:27:11-27 - Error: Module not found: Error: Can't resolve 'mysql' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\mysql'

./node_modules/knex/lib/dialects/mysql2/index.js:14:11-28 - Error: Module not found: Error: Can't resolve 'mysql2' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\mysql2'

./node_modules/knex/lib/dialects/oracledb/index.js:46:21-40 - Error: Module not found: Error: Can't resolve 'oracledb' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\oracledb'

./node_modules/knex/lib/dialects/oracledb/utils.js:39:19-38 - Error: Module not found: Error: Can't resolve 'oracledb' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\oracledb'

./node_modules/knex/lib/dialects/pgnative/index.js:12:11-31 - Error: Module not found: Error: Can't resolve 'pg' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\pgnative'

./node_modules/knex/lib/dialects/postgres/index.js:59:11-24 - Error: Module not found: Error: Can't resolve 'pg' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\postgres'

./node_modules/knex/lib/dialects/postgres/index.js:166:56-82 - Error: Module not found: Error: Can't resolve 'pg-query-stream' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\postgres'

./node_modules/knex/lib/dialects/redshift/index.js:35:11-24 - Error: Module not found: Error: Can't resolve 'pg' in 'C:\repos\AngularSignalsDemo\node_modules\knex\lib\dialects\redshift'

tsconfig.json

/* To learn more about this file see: https://angular.io/config/tsconfig. */
{
  "compileOnSave": false,
  "compilerOptions": {
    "baseUrl": "./",
    "outDir": "./dist/out-tsc",
    "forceConsistentCasingInFileNames": true,
    "strict": true,
    "noImplicitOverride": true,
    "noPropertyAccessFromIndexSignature": true,
    "noImplicitReturns": true,
    "noFallthroughCasesInSwitch": true,
    "sourceMap": true,
    "declaration": false,
    "downlevelIteration": true,
    "experimentalDecorators": true,
    "emitDecoratorMetadata": true,
    "esModuleInterop": true,
    "moduleResolution": "node",
    "importHelpers": true,
    "target": "ES2022",
    "module": "ES2022",
    "useDefineForClassFields": false,
    "lib": ["ES2022", "dom"]
  },
  "angularCompilerOptions": {
    "enableI18nLegacyMessageIdFormat": false,
    "strictInjectionParameters": true,
    "strictInputAccessModifiers": true,
    "strictTemplates": true
  }
}

package.json

{
  "name": "test-prep",
  "version": "0.0.0",
  "scripts": {
    "ng": "ng",
    "start": "ng serve",
    "build": "ng build",
    "watch": "ng build --watch --configuration development",
    "test": "ng test",
    "dev:ssr": "ng run testPrep:serve-ssr",
    "serve:ssr": "node dist/testPrep/server/main.js",
    "build:ssr": "ng build && ng run testPrep:server",
    "prerender": "ng run testPrep:prerender"
  },
  "private": true,
  "dependencies": {
    "@angular/animations": "^17.3.6",
    "@angular/common": "^17.3.6",
    "@angular/compiler": "^17.3.6",
    "@angular/core": "^17.3.6",
    "@angular/forms": "^17.3.6",
    "@angular/platform-browser": "^17.3.6",
    "@angular/platform-browser-dynamic": "^17.3.6",
    "@angular/platform-server": "^17.3.6",
    "@angular/router": "^17.3.6",
    "@angular/ssr": "^17.3.6",
    "@mikro-orm/core": "^6.2.4",
    "@mikro-orm/entity-generator": "^6.2.4",
    "@mikro-orm/knex": "^6.2.4",
    "@mikro-orm/migrations": "^6.2.4",
    "@mikro-orm/reflection": "^6.2.4",
    "@mikro-orm/sqlite": "^6.2.4",
    "express": "^4.18.2",
    "knex": "^3.1.0",
    "rxjs": "~7.8.0",
    "tslib": "^2.3.0",
    "zone.js": "~0.14.4"
  },
  "devDependencies": {
    "@angular-devkit/build-angular": "^17.3.6",
    "@angular/cli": "^17.3.6",
    "@angular/compiler-cli": "^17.3.6",
    "@mikro-orm/cli": "^6.2.4",
    "@types/express": "^4.17.17",
    "@types/jasmine": "~4.3.0",
    "@types/node": "^20.12.8",
    "browser-sync": "^3.0.0",
    "jasmine-core": "~4.6.0",
    "karma": "~6.4.0",
    "karma-chrome-launcher": "~3.2.0",
    "karma-coverage": "~2.2.0",
    "karma-jasmine": "~5.1.0",
    "karma-jasmine-html-reporter": "~2.1.0",
    "ts-node": "^10.9.2",
    "typescript": "~5.4.5"
  },
  "mikro-orm": {
    "useTsNode": true
  }
}

mikro-orm.config.ts

import { Options, SqliteDriver, defineConfig } from '@mikro-orm/sqlite';
import { TsMorphMetadataProvider } from '@mikro-orm/reflection';
import { Migrator } from '@mikro-orm/migrations';

export default defineConfig ({
  driver: SqliteDriver,
  dbName: 'sqlite.db',
  entities: ['dist/**/*.entity.js'],
  entitiesTs: ['**/*.entity.ts'],
  metadataProvider: TsMorphMetadataProvider,
  debug: true,
  extensions: [Migrator]
});

Reproduction

https://github.com/coltossoff/AngularSignalsDemo/tree/retryssr

Use command:
npm run build:ssr

What driver are you using?

@mikro-orm/sqlite

MikroORM version

6.2.4

Node.js version

22.0.0

Operating system

Windows 11

Validations

• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion or join our Slack.
• The provided reproduction is a minimal reproducible example of the bug.

[B4nan]

I can't help much with this, those problems are about your bundler setup. Check this page for some hints:

https://mikro-orm.io/docs/deployment#deploy-a-bundle-of-entities-and-dependencies-with-webpack

Note that Warning: Critical dependency: the request of a dependency is an expression is just a warning and should be safe to ignore, and errors like Error: Module not found: Error: Can't resolve 'tedious' point to missing dependencies you need to declare as external in your webpack config.

Search on how to do this with knex, I guess you should find more information this way. The solution will be the same for the 3 problems reported from the ORM codebase.

---

Btw not sure how you came up with this, you should call MikroORM.init instead of using the constructor, this way there is no discovery happening.

[coltossoff]

Thanks for getting back to me.

• I included the warnings since they seemed like they could help with tracing the errors.
• In the link you posted, under the esbuild section (seems to be what Angular is using now) you have the knex.d.ts when I tried copying it in I got complaints about esbuild-support/knex, where does this come from, do I have to install a dependency? And, where would the externals be passed? Sorry, I'm new to playing with bundlers.
• Thanks for pointing this out, was going cross eyed when I put that in.

[B4nan]

you have

I did not write that section, as I said, this is not my domain, can't help much with bundlers and frontend/ssr stuff :] I'd look at esbuild issues connected to knex, those problems are usually about that (and only a very small part of them is about what the ORM is doing on top of it)