Category "database"

How to create the file format in Snowflake?

I have below sample csv data with column delimiter as "|" and row delimiter is "|\n". I am receiving below error. How can I create the File Format? Key|DimType|

Milvus standalone is not real standalone version

Milvus2.0 has a stand-alone version called milvus-standalone. But this version, in addition to milvus itself, also includes two third-party components, minIO an

Flutter objectbox initialization

How can i initialize properly the instance of my DatabaseProvider? I'm struggling with it. I found solutions but everyone of them initialize objectbox in the wi

Why doesn't the AWS studio doesn't show up the "one to many" modal relationship?

There are 3 modals in the aws-amplify studio. They are as follows: It was quite straight-forward to add the relationship for the Video modal. But for the User

why does it keep giving me errors?

SQL table: CREATE TABLE Application ( App_ID number(5), Child_Name varchar2(15) CONSTRAINT pk_Application_App_ID PRIMARY KEY, Child_Weigh

TimescaleDB high disk space usage despite compression activated

I have a TimescaleDB database running on Docker (which is running on Ubuntu). As you can guess, I store a lot of time-series data in it and to save disk space I

Unable to scan a Azure SQL Database in Azure Purview

I am unable to connect a my Azure SQL Database to Purview. I have already followed the steps described in all the documentation. I keep getting the following er

Best way to update Database with List where items have been deleted

I'm working on a recipe Webapp with Asp.NET 6.0 and Razor pages. There are three database tables : recipe, ingredient and food. Each Recipe has a Name, Preperat

Aerospike filter expression on boolean fields not working

I've written the following Aerospike filter in Java. Both Field1 and Field2 are booleans. For some reason, the "filterByField.ValidBoth" condition does not yiel

Generate sales report using MySql and Php

I m looking for advices in report generating per client, per product, per salesman, in a given period, using mysql and php. I m currently working on an applicat

How to use a database connection string in App.config?

I use EF 6, and if I use a hardcode database connection in the OnConfiguring: protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

(NoSQL)Which database type would be suitable for these needs?

You are creating a web-based interface to allow for the ad-hoc querying and reporting on a large (and growing) collection of various types of customer invoice,

Invalid KeyConditionExpression: An expression attribute value used in expression is not defined

aws dynamodb query --table-name shoutout-testing --key-condition-expression "Model = :a" I tried this query but it's saying that :a is not defined

Simple fact-dim relationship lead to wrong averages

I'd like to answer a simple question: What is the avarage age of persons that own cars of specific colors ? ( Using Penatho BI, Yellowfin BI, MariaDB) To do tha

Can i use firebase + spring boot at same time in Ionic app

I'm building a mobile app in ionic and i want to know if i can use firebase and spring boot at the same time in the same app so i can benefit firebase real-time

How can I create monthly repeating tasks in Flutter/Firebase?

I am currently working on a finance app, where the user can create many transactions. To make the user's job a little easier, I want to add transactions that re

What is included in the ‘standalone’ vs ‘cluster’ Milvus deployments?

What is included in the ‘standalone’ vs ‘cluster’ Milvus deployments? Standalone makes it sound like it is a single instance, but as far

Neo4j Browser Connection

From neo4j browser, when I connect to the database I get the below error. This is purely a cloud based instance. ServiceUnavailable: Could not perform discovery

Does milvus auto-flush inserted data to object storage? or do we have to manually call flush?

I used the milvus1.x version in the past. After I insert data, I need to call the flush interface to ensure that the data is placed on the disk, so as to ensure

Someone could help me with this exercise for beginners in neo4j,why it returns me anything?

The schematic is: The question is:Who are the friends of the friends of Claudia My code: MATCH (a:Student)-[:friend]->()-[:friend]->(b:Student) MATCH (a