[ steps ] stop artifactory stop mysql Upgrade Ubuntu 14.04 to 16.07 Upgrade mysql-server to 5.7 Downloaded 7.75.5.tar.gz file put it into /opt/jfrog/artifactory untared 7.77.5.tar.gz removed /opt/jfrog/artifactory/app cp -r /opt/jfrog/artifactory/7.77.5/app/* /opt/jfrog/artifactory/app started up mysql-server started artifactory. Looking at console.log got…
I have a web application TODO list. Users can add, modify, and delete tasks. Issue is that every user who log in to my web application can see all tasks that are created by other users. My idea is to…
I have a hierarchical lineage for object dependency in json format. The json itself has a very simple structure but it has variable depth. I have attached an image to show the tree structure. The depth of the json could…
I created person table, then inserted 2 rows into it as shown below: CREATE TABLE person ( id INT, name VARCHAR(20), age INT ); INSERT INTO person (id, name, age) VALUES (1, 'John', 27), (2, 'David', 32); Then with an…
I'm trying to return TEXT[] type from my_func() with a RETURN QUERY EXECUTE and VALUES statement. But calling my_func() which has " in '' got the error as shown below: CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $$ BEGIN --…
I am developing a game like app with an leaderboard and want the leaderboard to have this features: Show Top 100 Show Top 100 Monthly, Weekly, Daily Show Trends next to every User (if the user moved up on the…
Is it not possible to store data to JSON file ? I mean I want to store the questions from the UI. I haven't started my database concepts yet. I know it is far far efficient to use Database. Can…
Refer this! I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i am worried that what…
I am implementing a leaderboard for my game and since it needs to be fast and run-time I am planning to use Redis. I haven't use Redis before so I am confused about one thing. As far as I know…
I tried to declare the local variable value with RECORD[] type in a DO statement as shown below: DO $$ DECLARE value RECORD[]; BEGIN END $$; But, I got the error below: ERROR: variable "value" has pseudo-type record[] I referred…