HI, Iiam using Heroku and for some reason, when I use process.env.DATABASE_URL to connect I get a connection error. When I set all the credentials manually (URL, username, password, db, port) the connection works. also when i do git push heroku master
can't register.

const db = knex ({
client: 'pg',
password : 'test',
connection: {
host: process.env.DATABASE_URL,
ssl: true,
}
});
reply
app is running on port undefined

TypeError: db.select is not a function
    at Object.handleSignIn (C:\Users\Administrator\Desktop\node\controllers\signin.js:2:5)
    at C:\Users\Administrator\Desktop\node\server.js:30:38
    at Layer.handle [as handle_request] (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\layer.js:95:5)
    at next (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\route.js:137:13)
    at Route.dispatch (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\route.js:112:3)
    at Layer.handle [as handle_request] (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\layer.js:95:5)
    at C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\index.js:281:22
    at Function.process_params (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\index.js:335:12)
    at next (C:\Users\Administrator\Desktop\node\node_modules\express\lib\router\index.js:275:10)
    at C:\Users\Administrator\Desktop\node\node_modules\body-parser\lib\read.js:130:5

The app.models snippet no longer works even after digging through all of the outdated docs. I tried updating to the grpc methed but the documentation for that is also outdated as the PostModelOutputs is now postModelOutputs?. The region_info.bounding_box is now registering as unknown variable.