What is the recommended way to create a graph from a table (or from an SQL query, in general)? Say, we have a table A with fields id and parent_id, where the latter refers back to the former of some…
I'm working on a system deals with dynamic properties. If I want to create a vertex, I can do it like this before that: select * from ag_catalog.cypher('people',$$ create (nyk:person{name:'nyk'}) return nyk $$) as (v ag_catalog.agtype); But now, I don't…
I have one question with Appliance IBM Guardium. I create Security Policy with Category (Audit, Access, Activity) and Rules include Log full details. Then I create Dashboard to show information about (Client Ip, DB Protocol, DB User name, Server IP,…
I read the documentation of Apache Age but I could not find how to install it on Windows 10. Any idea how to use Rgb tables with apache extension. Any articles or tutorials related to the installation will be quite…
I'm trying create multiple connections to my mongodb Cloud. The old code for single connection with mongoose.connect() is still fine, but when I changed to mongoose.createConnection() for multiple connections, I got this error: TypeError: conn1.model is not a function Edited:…
I have the following database relationship and query for PostgreSQL below: create table gender( gender_id int primary key, gender char(10)) create table student( student_id int primary key, first_name char(50) not null, last_name char(50) not null, gender_id int not null, constraint…
I am currently writing a pet project for an online store in React. I'm using a db.json file, which stores all the data I need (store products, categories, etc.) I ran into a problem when I need to query the…
I am allowing user to upload an avatar (profile image) in their profile. While uploading avatar is entirely optional, if user does not have avatar, a default image will be used. However, checking whether a user has an avatar uploaded…
I have the following movie database relationship diagram and used the queries below to create the tables and its keys as shown below: The following are the codes that I used to create these 4 tables and inserted the data:…
I am attempting to create database in postgres docker container using createdb command. It creates database, but I also get an error message: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory and I am…