Questions tagged [database]

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

0
votes
0answers
9 views

Java SQLite: Is it necessary to call rollback when auto commit is false and a transaction fails?

When working with a SQLite database in Java, suppose I set auto commit to false. Is it necessary when a SQLException occurs that I call rollback() method? Or can I simply ignore calling it and the ...
0
votes
0answers
7 views

Update document with aggregation pipeline with $lookup

I have a product collection which has fields -userId,referenceProductId, I want to add new field buyerUserId to all doc where its value will be equal to userId for documents where its _id is equal to ...
0
votes
1answer
16 views

when ever i've try to migrate my file this error op up

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'image' (SQL: create table products (id bigint unsigned not null auto_increment primary key, name varchar(255) not null, slug varchar(...
0
votes
0answers
7 views

Mongoose - Query times inconsistent

I want to measure my response time and improve it, but it is inconsistent. I'm using postman to monitor it. Most of the times, my first response time for a query (after not sending any requests for a ...
0
votes
0answers
22 views

Login Problems - PHP | Mysql database

I am new to the php and mysql environment and when I try to login to my site it tells me that I have entered the wrong credentials. I googled everywhere but found nothing to help me. Below is all the ...
-2
votes
1answer
38 views

How to get single record from multiple tables?

enter code hereI'm using SQL server and in that I wanted to take single record from multiple tables. Actually I'm doing project on Air reservation system and in that project I've the requirement that ...
0
votes
0answers
23 views

Microsoft SQL Server - Canceled ALTER TABLE ADD CONSTRAINT PRIMARY KEY CLUSTERED, used space grew. How to reclaim space?

I executed query ALTER TABLE ADD CONSTRAINT PRIMARY KEY CLUSTERED But decided to cancel it before it finished because it took too much time. Used space massively increased and not freed up. Table ...
0
votes
1answer
36 views

Most efficient way to store Perl hash data in a database

I have written Perl code that parses a text file and uses a hash to tally's up the number of times a US State abbreviation appears in each file/record. I end up with something like this. File: 521 OH =...
0
votes
0answers
8 views

Docker PostgreSQL 12.3 how to debug failed transaction\ incomplete message

Im using PostgreSQL 12.3 docker image, and i have an application that stopped working as some query transaction gets closed or incomplete in the middle of it and the application just doesn't work. My ...
0
votes
0answers
15 views

How to perform exclusive lock on a transaction so that other transaction can't access(read, write) same table (In Sequelize)?

I am having a nodejs program which uses sequelize to create tables and insert data based on it. Now, in future we are going to have multiple instances of the program and so we don't want multiple ...
0
votes
0answers
9 views

Unable to run pg_restore on windows

I have taken the backup using pg_dumpall of Postgres 11 and currently trying to restore it to Postgres 14.1. I am using "C:\Program Files\PostgreSQL\14\bin\pg_restore.exe" --file="...
0
votes
0answers
17 views

What's the best way to implement a big graph in C as a binary file? [closed]

I'm a beginner to coding in c, and I have a project : parse the dblp database and exactly to extract all the authors and their co-authors and to build a graph and finally to write some graph functions ...
0
votes
1answer
11 views

How to set permission to (.env) in windows 10 server xampp localhost

enter image description here im using xampp server on localhost and when try to install the database for laravel script get this error on file permission im trying to change the permission to full ...
-5
votes
0answers
18 views

Database filled with real books data [closed]

I am building a website that would allow users to manage and search for books. In order to do so, I need to fill my database with books’ data such as the title, author, cover, etc. Free and legally ...
-1
votes
0answers
11 views

Crud web application from mysql database

I would to create a CRUD web application based on Mysql database. This web application must be used from some users that create/read/update/delete the data in realtime like a google spreadsheet but ...

15 30 50 per page
1
2 3 4 5
12256