те при фильтрации можно преобразовывать из одного типа в другой? но это же overhead

никакой индексации

Я делал бы средствами бека, не бд

хмм.. интересно

has anyone been  able to use  sqlite3 sequelize on nodejs ubuntu

Error -----------------------------------------------------------------

 Message:
 Please install sqlite3 package manually

 Stack:
 Error: Please install sqlite3 package manually
     at ConnectionManager._loadDialectModule (/root/smartecho/projectx/smartecho/src/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:81:15)
     at new ConnectionManager (/root/smartecho/projectx/smartecho/src/node_modules/sequelize/lib/dialects/sqlite/connection-manager.js:22:21)
     at new SqliteDialect (/root/smartecho/projectx/smartecho/src/node_modules/sequelize/lib/dialects/sqlite/index.js:14:30)
     at new Sequelize (/root/smartecho/projectx/smartecho/src/node_modules/sequelize/lib/sequelize.js:320:20)
     at Object.<anonymous> (/root/smartecho/projectx/smartecho/src/users/models.js:3:18)
     at Module._compile (internal/modules/cjs/loader.js:689:30)
     at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10)
     at Module.load (internal/modules/cjs/loader.js:599:32)
     at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
     at Function.Module._load (internal/modules/cjs/loader.js:530:3)
     at Module.require (internal/modules/cjs/loader.js:637:17)
     at require (internal/modules/cjs/helpers.js:22:18)
     at Object.<anonymous> (/root/smartecho/projectx/smartecho/src/app.js:29:14)
     at Module._compile (internal/modules/cjs/loader.js:689:30)
     at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10)
     at Module.load (internal/modules/cjs/loader.js:599:32)
     at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
     at Function.Module._load (internal/modules/cjs/loader.js:530:3)
     at Module.require (internal/modules/cjs/loader.js:637:17)
     at require (internal/modules/cjs/helpers.js:22:18)
     at Object.<anonymous> (/root/smartecho/projectx/smartecho/src/index.js:4:17)
     at Module._compile (internal/modules/cjs/loader.js:689:30)

  ----------------------------------------------------------------------

do you have this dependency installed locally?

yes

npm install sqlite3 works

but when i run the app i get the error

using express js

webapp

remove node_modules and reinstall

I think something with modules

what module did you install? official "sequelize"?

yes

npm install sequelize

try it

the app runs on my windows

but on ubuntu i get that error