Stack Overflow
Stack Overflow

Questions tagged [sails-postgresql]

A Waterline adapter for PostgreSQL. May be used in a Sails app or anything using Waterline for the ORM.

106 questions
0
votes
0 answers

Does Sails.js/waterline parameterized query really protect against sql injection (official document)?

I'm using waterline v0.11 (yes,very old) and postgresql 11, i heard that the parameterized query protect against sql injection in sails but i can not find any official document about this. I've searched for a while and there is not much information…
kanfam
  • 1
0
votes
0 answers

Connect Azure Postgresql database in sailsjs

I'm trying to connect my azure postgresql database to my sails app, using sails-postgresql adapter my connection url is this url:'postgresql://@:@.postgres.database.azure.com:5432/', postgresql…
Dileepa Mabulage
  • 1
  • 2
0
votes
1 answer

Hello Folks: I am having problem in starting sails app in nodejs. can anyone put forth their insights on that?

I tried running the latest version of node and postgresql, but was having problem i deprecated node to 13.12.0 and sails-postgresql to 1.0.2 as mentioned in one of the blog. still the error is coming. Stack trace is as below: sails lift info:…
user14798877
0
votes
1 answer

SailsJS: Requests choking at database query via models

We have SailsJS app with postgresql adapter. Requests made to server chokes at database query via models. i.e Users.find(). Database server is up and running, connection string is correct and in place in datastore.js under default head My guess is…
ducktyped
  • 4,354
  • 4
  • 26
  • 38
0
votes
1 answer

PostgreSQL setup in Sails

I am new to sails and its connection to database. I plan to use Heroku to host my app so I would like to use Postgresql. I have changed config.datastore file with the following code: default: { adapter: 'sails-postgresql', url:…
Paulo Brás
  • 57
  • 8
0
votes
0 answers

getting time out error while connecting postgres in sails application in development mode?

I am trying to develop a simple HTTP API using sails framework. I have created models, controllers, helpers and routes in order to complete the workflow of the API but when I am lifting sails app in development mode , I am getting a timeout error…
Niraj Rajput
  • 1
  • 1
0
votes
1 answer

SailsJs/Postgresql - How to create a one way association or one-to-many relation via an unique field

I have two models: PdfAnnotation.js: module.exports = { tableName: "pdf_annotations", primaryKey: "pk_id", attributes: { pk_id: { type: "number", autoIncrement: true }, annotation_id: { type: "string", …
K. Tai
  • 136
  • 1
  • 8
0
votes
1 answer

skipRecordVerification doesn't suppress ORM warning

sails 1.2.4, waterline 0.13.6, sails-postgresql 1.0.2, npm 6.14.4, macOS 10.15.4 My final objective is to suppress the warning provided by waterline because I have a field configured in sails' model as 'number', and it is configured as 'bigint' in…
marxxx
  • 1
  • 1
0
votes
2 answers

How to prevent insert of data that is passed using query string in sails.js for post request?

I have created new table in mysql also created model and controller in sails.js. Now I am trying to insert data using sails. As we know when we create new modal in sails it will create new post, get and other api for us by default. Now I am trying…
baj9032
  • 2,414
  • 3
  • 22
  • 40
0
votes
0 answers

Sails JS not able to get Path params as object and not able to modify it

I have created the middleware, where i am able to modify request.body and request.query as I am getting it as object but I am not able to get path params as object because in sails request.params gives array type with values in URL format instead of…
Soorya Prakash
  • 921
  • 3
  • 9
  • 29
0
votes
1 answer

connecting to dynamic postgresql database hosts using sails app version 0.12 based on the ui input to back end api's

My requirement is to connect to dynamic databases of postgresql after the sails is lifted in sails api v 0.12. From angular ui, i have a drop down of different DB values i am sending one param (dbhostname)to dummycontroller.js and want to connect to…
bhaskar reddy
  • 35
  • 1
  • 6
0
votes
1 answer

Create user with avatar

I want to add an avatar in the user registration, but I don't know how, Please can someone share with me a full example (form, JS front, and JS backend). I'm using SailsJS 1.0 (the stable version) with VueJs. Thanks in advance .
Abdelmajid ELHAMDAOUI
  • 325
  • 1
  • 9
0
votes
1 answer

Sailsjs fetch data from two different mysql databases

I'm building a rest api using sails js v 1.x I need to connect two mysql database so I have defined them in config/datastores.js file life this: module.exports.datastores = { default: { adapter: require('sails-mysql'), url:…
node_man
  • 1,359
  • 4
  • 23
  • 50
0
votes
1 answer

Sails - Postgres - Unable to lift

Issue : Unable to lift sails project (Initially written for mysql, Change adapter and settings to postgres) Error : info: ·• Auto-migrating... (drop) error: A hook (`orm`) failed to load! error: error: error: syntax error at or near "ON" at…
Sandeep PC
  • 797
  • 8
  • 12
0
votes
1 answer

sails-postgresql "poolSize" too high error when connecting to database running in Docker container

I'm building a new Sails.js application that connects to a PostgreSQL database. The application used to run just fine until I created a new model using sails generate model products. I now run into the following error when the application tries to…
JackH
  • 4,613
  • 4
  • 36
  • 61
1 2 3 4
5
6 7 8