python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - objection.js

How to setup mutli-tenancy using row level security on Postgres with knex

I am architecting a database where I expected to have 1,000s of tenants where some data will be shared between tenants. I am currently planning on using Postgres with row level security for tenant iso...
test-img

Sam Duvall

postgresql

multi-tenant

knex.js

objection.js

Votes: 0

Answers: 1

Latest Answer

Perhaps one solution might be to cache a limited number of connections, and destroy the oldest cached connection when the limit is reached. See this code as an example. That code should probably be ...
test-img

gbruins

Automatically update a column on insert - ObjectionJS

I want to automatically update the CreatedDateTime column whenever I want to insert or update column. But my problem is some tables have no CreatedDateTime column. My code looks like this: $beforeInse...
test-img

Ryan Garde

javascript

mysql

node.js

knex.js

objection.js

Votes: 0

Answers: 0

Why objection instance method did not work

I have setup the Objection model for Company, if I use static method to query database it is OK. (I already have Model.knex(knex) before to setup everything.) const companyInfo = await Company.query()...
test-img

Michael Hua

node.js

database

express

objection.js

Votes: 0

Answers: 0

Knex / ObjectionJs whereJsonSupersetOf with object containing an array

I use knex and objection.js with a postgresQL database. I updated knex from version 0.19.5 to 1.0.3 and part of one of my query stopped working. One of my table has a 'metadata' column, which is jsonb...
test-img

Marie Pelletier

postgresql

knex.js

objection.js

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs