Category "database"

ModelService does not remove the model in groovy script

I'm trying to remove a model from database using ModelService in my groovy script but it doesn't remove. import de.hybris.platform.core.model.order.OrderModel i

Missing comma before start of a new alter operation. (near "CHARACTER SET")

Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SE

Leaderboard ranking with Firebase

I have project that I need to display a leaderboard of the top 20, and if the user not in the leaderboard they will appear in the 21st place with their current

How to query data from different types of databases in a microservice based architecture?

We are a using a micro-service based pattern for our project where we have Users and their Orders. Users personal information (name, email, mobile) is stored in

How can Select date(dd/mm/yyyy) in ascending order in sql

I want To Select stockDate in ASC Order My Table Structure is.:-

Postgres Join tables and create new field if join exists

I'm new to Postgres and I have a confusing one. Basically, I want to find if my post is bookmarked by the user or not in a new field bookmarked = true / false H

WHERE IN array binding in DB::raw laravel 5.4

I'm trying to bind an array in a raw WHERE IN query in the Laravel DB example: $arr = [1,2,3]; DB::select(DB::raw("select * from test1 WHERE id IN ? "), [$arr

C# Winform LiveCharts does not know how to plot

I'm trying to draw a graph with some arrays. I got 4 arrays (Time,Temprature,Speed,Water). I want to add Time array on AxisX. The others are going to be on Axis

Variable retrieved from json data doesn't seem right

I retrieve data from mysql server and one of the fields is an int value (1 or 0 ) and it's printed right (1 or zero ) but when I try to apply an if condition on

UninitializedPropertyAccessException in Android Studio using Kotlin

I am a beginner making use of a Roomdatabase. Mostly using it to load in and pass items between tables using simple relationships. package com.example.allin

How to minimize transaction log sqlserver database .?

I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2

How to select all fields from one table that contain a substring from any row in another column

I'm trying to export a dictionary of words in sqlite made up only of words that start with, contain, or end with specific filters. If one filter was 'ment' and

Quarkus docker container failed to run / connect to the DB

In my project, using Quarkus, Angular and PostgreSQL DB, when I run the backend & and the frontend in dev Mode, I can connect to the DB (which is postgreSQL

how to save and update menu in php laravel

I want to create an admin panel where I can change almost everything of the pages. Should we save every menu-item and its children in a different table in the d

django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')

My model: class Course(models.Model): language = models.ForeignKey(Language) name = models.CharField(max_length=50, unique=True, default='course')

Why and when Liquibase?

I have searched for this answer on stack overflow, but I couldn't find any questions on this. I am new to Liquibase and want to learn Why Liquibase? When exactl

Add Items to a ListView from a database

I am a Vb nooby and I have trouble to add specific Items to my Listview from a database. I would like to compare the value of a combobox with a column value of

Can we have multiple databases in ElastiCache (for Redis)?

Difficult to find this information for ElastiCache (for Redis) - if we can use databases with it such as 0, 1, 2 ... like it's possible in Redis.

How to store H2 database file into project directory

When I used H2 database the database files are stored at C:\Users\MyName\TestDataBase.db directory. The H2 path is jdbc:h2:~/TestDataBase. This is default H2 da

Calling grpc server from multi-threaded client

I have a client side code, which is multi-threaded, calling updateInfo rpc method to the grpc server to update the information(Eventually will updata data in SQ