Category "database"

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

Append characters to a string in multiple rows in Oracle SQL

I'm trying to update a single column in multiple rows by appending the string '999': UPDATE integration.ol_orders SET order_id = ((SELECT order_id

Is it necessary to avoid loops for updating models in laravel?

I'm trying to sort multiple records for a model based on a field and store their ranks in DB. Like below: $instances = Model::orderBy('field')->get(); $ran

Difference between SYSDATE(),NOW(),CURRENT_TIMESTAMP,CURRENT_TIMESTAMP() in MySQL? [closed]

As per my knowledge, SYSDATE(), NOW(), CURRENT_TIMESTAMP, and CURRENT_TIMESTAMP() in MySQL are synonyms for one another. They all returns

How to connect to a local database in SQL Server Management Studio?

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to conn

SQLite (Android) : UPDATE query with ORDER BY

Android, SQLite : I want to insert rows in between other rows in myTable using SQLite in android. For this, I am trying to increment ids of the all rows startin

Combining Python variables into SQL queries

I am pulling data from an online database using SQL/postgresql queries and converting it into a Python dataframe using Pandas. I want to be able to change the d

How does my list become ObservedList? Problem with replit db

I have a problem with making discord bot on repl.it, my list is 'ObservedList' and i dont know what to do with this, when I watch some tutorials its always just

MariaDB Import maximum key length

We are currently moving the DB to another Server but we got a problem. Our Database is quite big and when we want to Import it to our new MariaDB Server with Ph

SQL Server not listening on IP address even if TCP/IP is enabled

I am trying to set up MS SQL Server Express 2019 to listen on TCP/IP and connect to it through IP address instead of shared memory. I am currently connecting th

Why is the database of the webapp in the book "Head First Python 2nd Edition" not working as it should?

I'm currently studying Python by reading the book "Head First Python 2nd Edition" and it is really helpful and well-written, but I think it is a little anachron