I developed a Yii2 application that works in my computer with Debian. Then I installed Bitnami WAPP in a computer with Windows 8 and I tried to execute it but it doesn't work. It shows the content like a folder…
I am currently working on a Django based service that will gather users' data from their Shopify shops and provide some insights. I use PostgreSQL as my DB server. The problem I am facing is whether it is more efficient…
I have created a table that contains a list of keywords and a code that identifies synonyms. I.e. All keywords with the same code are to be considered the same keyword. varchar varchar tsvector C1000 AI 'ai':1 C1000 Artificial intelligence…
This is my query in Postgresql: SELECT C.id, S.domen, B.name, C.source_id, ST.name FROM "calls" C INNER JOIN "site" S ON S.id=C.site_id INNER JOIN "sources" ON sources.id=C.source_id INNER JOIN "brand" B ON B.id = S.id_brand INNER JOIN "source_types" ST ON ST.id…
We have just installed the PostgreSQL component into plesk but we cannot authenticate using the PHP function @pg_connect() $connection = @pg_connect("host=localhost port=5432 dbname=my_db_name user=my_user password=my_pwd"); output("Connection: ".$connection); The error is showed in the connection object that is printed: Connection: Array…
I have a table item name which is like this : Microsoft Word Adobe Premiere Paint Mozila Firefox Adobe Photoshop CS7 Windows Movie Maker I want to select the data (table product, column name) become like this : Microsoft Word…
I'm working out how to run openproject with docker. I'm working through openproject/docker. I've got the docker image running with an external postgres directory. I'm now working out how to connect to an existing running instance of postgresql. The command…
I am creating an API and my app isn't saving user information to the POSTGRES database. Can someone look over my code and tell me what is wrong? SECRET_KEY = os.environ['SECRET_KEY'] ALLOWED_HOSTS = ['salty-sands-40947.herokuapp.com','.herokuapp.com'] DEBUG = True # Application definition…
We've got a table where we're exposing a ShortID to our consumers that generates a Youtube like identifier (heavily inspired by this SO post). We use the primary KEY of the row to generate it (in the view). For example…
I realize this is a bit of noob question but im not exactly sure what is the best solution. I have a REACT/Node.js application that is using a Authentication API (Stormpath in this case). The app is working. I have…