database Questions

Get Length of agtype List/ Array – Postgresql

April 14, 2023
Muneeb Khan
3 Answers

I have created this vertex: test=# SELECT * FROM cypher('graph', $$ CREATE (s:student{name:"Muneeb", courses: ["OOP", "DS", "Programming", "Android"]}) RETURN s $$) as (student agtype); ---------------------------------------------------------------------------------------- student ---------------------------------------------------------------------------------------- {"id": 3377699720527873, "label": "student", "properties": {"name": "Muneeb", "courses": ["OOP", "DS", "Programming", "Android"]}}::vertex (1…

VIEW QUESTION

Firebase realtime database permission error even though rules playground simulation succeeds

April 13, 2023
Jacob
2 Answers

My database has a users child with fields email and name, with the key being the users uid. Here are the database rules: { "rules": { "users": { "$uid": { "email": { ".read": "auth.uid == $uid", ".write": "auth.uid == $uid"…

VIEW QUESTION

How do you update parent entities LastUpdate property when adding or changing a child at any level in the hierarchy below it in Entity Framework? – Asp.net

April 13, 2023
Pile
2 Answers

I have created a simple one-to-many hierarchy using the code first approach. All entities in the hierarchy have an Id, which is a Guid, and timestamps for CreatedOn and LastUpdate. These are contained in the BaseEntity class. Each entity may…

VIEW QUESTION

Listen for DB changes with SpringBoot – Postgresql

What's the easiest way to implement following solution: There is an old legacy app which uses Oracle DB, the idea is to create a new service in SpringBoot which would observe for changes on a few specific tables in this…

VIEW QUESTION

make: pg_config: Not a directory make: *** No rule to make target 'installcheck' – Ubuntu

I installed postgres version 13 from source code using wget https://ftp.postgresql.org/pub/source/v13.5/postgresql-13.5.tar.gz && tar -xvf postgresql-13.5.tar.gz && rm -f postgresql-13.5.tar.gz ./configure --enable-debug --enable-cassert --prefix=$(pwd) CFLAGS="-ggdb -Og -fno-omit-frame-pointer" make install It installed sucessfully and I tried installing AGE using git clone https://github.com/apache/age.git…

VIEW QUESTION

How to get a single item(id) from search table? Laravel

April 12, 2023
TheBetweener
2 Answers

I only need id data from a table for an insert data for another table. But I don't know how? So I created search data request $iduser = User::where('username','like','%' . request('username') . '%')->get(); I can't use $iduser->id or some similar…

VIEW QUESTION

MySQL 64kb size limit for MyISAM table-based metadata storage unclear – differences between MySQL and MariaDB

April 11, 2023
Deckard
2 Answers

The information found in the official MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html does not match the information shown in the manual at https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html for version 8. First link says that the 64kb limit was dropped, the 2nd link says it exists. It…

VIEW QUESTION

MySQL – Doing addition from "subquery field" in SELECT using alias

April 11, 2023
DenjanD
2 Answers

I would like to add some SUMs from subqueries in the SELECT into another new field. Here is the query that I am currently using: SELECT DAYNAME(date) AS day, DATE_FORMAT(date, "%d-%m-%Y") AS date, (SELECT SUM(qty) AS product1_shift1 FROM bill_details JOIN…

VIEW QUESTION

How to Access Index of Array in the properties of AGE Vertex When passed to PG_Catalog Function – Postgresql

April 9, 2023
Muneeb Khan
2 Answers

I have created a vertex student: test=# SELECT * FROM cypher('graph', $$ CREATE (s:student{name:"Muneeb", courses: ["OOP", "DS", "Programming", "Android"]}) RETURN s $$) as (student agtype); ---------------------------------------------------------------------------------------- student ---------------------------------------------------------------------------------------- {"id": 3377699720527873, "label": "student", "properties": {"name": "Muneeb", "courses": ["OOP", "DS", "Programming", "Android"]}}::vertex…

VIEW QUESTION

Insert and Fetch a List from Database(Sqflite) – Flutter

April 7, 2023
silentcry
3 Answers

I have a form(title, description, images, etc...), in this form I pick multiple images and store them in a list, I want to insert this list of images in the database and also fetchAndSet the data later on. since we…

VIEW QUESTION