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 is 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.
database
195,215
questions
-1
votes
1
answer
23
views
How to merge cells in this table [duplicate]
this is my codes, very basics, sorry I'm not expert just interested.
$query = "SELECT \*, GROUP_CONCAT(`Kode Unit`) AS Kodeunit, COUNT(`Kode Unit`) AS Jumlah FROM `STOCKS` GROUP BY `Nama Produk`, ...
0
votes
0
answers
8
views
Why is read repair not sufficient in making dynamo-style database linearizable?
I am reading DDIA. It says "possible to make Dynamo-style quorums linearizable at the cost of reduced performance: a reader must perform read repair (see “Read repair and antientropy” on page 178)...
0
votes
0
answers
10
views
Error in Filament\Support\Services\RelationshipJoiner
I am currently learning to use Filament, but I encountered an error that says, Filament\Support\Services\RelationshipJoiner::prepareQueryForNoConstraints(): Argument #1 ($relationship) must be of type ...
-1
votes
0
answers
14
views
What database should i use when I am always reading the N most recent documents? [closed]
What database should i use when I am always just adding documents and accessing the N most recent documents? Basically I think a LIFO stack data structure would be a good fit.
Is a NoSQL Document ...
-3
votes
0
answers
14
views
Dica de criação de banco de dados para iniciante [closed]
Estou realizando um trabalho na faculdade e como sou iniciante, estou um pouco perdida ainda, queria algumas dicas... Tenho um projeto web que é feito o cálculo de estruturas metálicas para uma loja, ...
0
votes
1
answer
25
views
Storing text data from python web scrape
So I have scraped the information that I want but I don't know how to store it. So, I can manipulate it and clean it. It's one long string either I would like to store it in a csv file or a database ...
0
votes
0
answers
23
views
Optimization for Datetime and Value storage in database [closed]
I receive data (Timestamp and Value) from external service (let's assume that Timestamp is Datetime and Value is string). I want to store it in database. So for example following data sequence can be ...
1
vote
1
answer
12
views
Queries and best practices: How to query multiple tables and return object using Convex.dev?
I have a few queries, that seems very large in terms of lines of code, and I was wondering if there is a better way to do this. This example is a get query from multiple tables to then end up ...
1
vote
1
answer
43
views
INSERT and UPDATE the Values into the table based on condition
I have 2 tables:
Table 1: EnrollmentTransaction (PK is both the column)
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
7 ...
-1
votes
0
answers
11
views
Receiving CSVS from Database and rewriting .csv file based on the content. How to optimize this process (maybe caching/redis)?
So I am receiving csvs from an azure database based on the url on the clientside. Then I rewrite the ExampleData.csv file to have this new csv received from the database. I am having a problem when ...
0
votes
1
answer
13
views
Table primary key uniqueness across different / multi-region Amazon RDS postgres
I have an application that uses postgres database on one region (US West) containing several tables, one of which contains several hundred thousand records (let's call it "events" table with ...
0
votes
0
answers
22
views
PostgreSQL Login Error: "password authentication failed for user 'postgres'"
I've been struggling with an error while trying to log into PostgreSQL:
psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed ...
0
votes
0
answers
7
views
next_connect__WEBPACK_IMPORTED_MODULE_3__.default) is not a function
import dbConnect from '../../lib/mongodb';
import Job from '../../models/Job';
import multer from 'multer';
import nextConnect from 'next-connect';
import fs from 'fs';
import path from 'path';
const ...
1
vote
2
answers
21
views
updating related relations in database
i have created groups , which has members , each member has a group array displaying which they are part of . if i delete a group i want that user's group array also updates. i am using express and ...
-1
votes
0
answers
33
views
Group function not allowed here [closed]
I am trying to get the count of distinct c.deal_no and use this value in my further calculations, but I get an error.
This is my query:
Select
a.Oa_Permid,
a.NAME,
select
count(...