195,242
questions
0
votes
0
answers
13
views
FlaskSQLAlchemy - Why are my tables not being created upon initialization?
So I'm creating a real time chat application and I want to add authentication for my users. The problem is when I attempt to add a new user to my database I receive the following error "...
- 1
0
votes
0
answers
12
views
Prevent DataIntegrityViolationException from containing sensitive details?
org.springframework.dao.DataIntegrityViolationException contains sensitive data, e.g.:
could not execute statement [ERROR: null value in column
"" of relation "" violates not-null
...
- 1,485
0
votes
0
answers
13
views
Problems with docker and airflow (specifically dockeroperator)
I turn to you to help me to solve a many-days problem. I'm having problems with a specific configuration of ariflow in docker. The context is that i am configurating several containers in order to run ...
0
votes
0
answers
22
views
Error: querySrv EREFUSED _mongodb._tcp.cluster0.vzygb.mongodb.net while connecting to mongodb
I've tried everything using chatgpt and configuring it again. Creating a new project and then creating a cluster and then doing all the process again.
But this error seems to be stuck there. what is ...
0
votes
0
answers
19
views
Does the .NET object persistence API limit the fields it fetches to only those in the object?
If I use DynamoDBContext.LoadAsync to get an object and the underlying table has more attributes than what are present in the object, will it automatically limit the attributes to only those needed?
- 2,699
0
votes
1
answer
46
views
PostgreSQL container unexpectedly dropping database
Problem Summary
I'm running a flask app on a basic DO droplet
The database is being dropped for some weird reason (or probably sthg I haven't been able to track yet)
# docker-compose.yaml
version: '3....
- 13
0
votes
0
answers
11
views
Is it possible to configure the ESP32 to write data log files onto the USB on the TP-Link Archer X55? [closed]
We're high school student researchers looking at the possible topic of using the ESP32 as a Water Quality Checker for school.
(ln theory) the plan is to hook up couple sensors to the ESP32 to measure ...
- 1
0
votes
2
answers
23
views
not able to connect flutter app with node server
iam trying to connect my flutter app to a node server the flutter application has a registration screen that accepts username,password and email from users and it should be reflected to mongodb using ...
0
votes
1
answer
17
views
pymongo.errors.ConfigurationError: The resolution lifetime expired after 21.215 seconds
When I'm trying to connect to pymongo getting below error
pymongo.errors.ConfigurationError: The resolution lifetime expired after 21.215 seconds: Server 192.168.1.1 UDP port 53 answered The DNS ...
- 33
0
votes
1
answer
18
views
Firestore error "User document does not exist"
I'm working on a project similar to Linktree and have implemented Firebase for authentication and Firestore for the database. The authentication system is functioning correctly, and user data is being ...
0
votes
0
answers
25
views
Forward Filling a column in Kusto
I have the following query:
let table = MyMaterialisedView
| extend Value= iff(isnan(Value), double(null), Value) //replacing NANs with Nulls to avoid issues when calculating the Average
| order by ...
- 2,197
0
votes
2
answers
64
views
Sqlite slower response with String criteria
I have a table with three columns. Two are BIGINT data type columns and one is varchar(512) data type.
Using java language.
CREATE TABLE IF NOT EXISTS `UNIQUE_ENTITIES` (DETAILS_ID BIGINT, ACCOUNT_ID ...
- 364
-2
votes
0
answers
32
views
How to save users selected options from MySQL data table into a different table that stores the options selected along with the user id? [closed]
I'm trying to build a version of premier fantasy fooball game for my own local team using php, mysql, javascript, etc...
Currently I'm having trouble in how to save the users picks. This is how the ...
- 1
0
votes
1
answer
19
views
Adding vectorized data to an AI chatbot in Python
I'm trying to add vectorized data (file format .npz) to my Azure OpenAI chatbot in order to make it generate answers based on this data.
The thing is I tried watching various videos but none helped me ...
-2
votes
0
answers
22
views
Displaying Partitioned Data over Power BI [closed]
I have a folder of hive partitioned parquet files which due to some reasons, I need to display over power BI but it doesn't support that. Converting it to a single parquet would consume time. Is there ...
- 1
-4
votes
0
answers
26
views
How Cassandra out performs MySQL [closed]
I have a Cassandra cluster with single DC, 3 node, in contrast 1 master and 2 follower MySql architecture. I would have like, 10M reads in 3hrs and 3M write and updates in 3hrs, with replica factor of ...
1
vote
1
answer
10
views
In version 2.4.0, there are occasional inconsistencies in query results
After building the vector library in version 2.4.0, we sliced the data and then performed queries later on. We found that querying the same issue sometimes yields different results, and occasionally, ...
- 123
0
votes
0
answers
15
views
Website on local machine doesn't run and redirects to phpmyadmin page
I took a full backup(including a partial backup of the 2 databases) of a site using Cpanel and downloaded it to my local machine and tried to run it using xampp
I have connected the databases and ...
0
votes
1
answer
10
views
Why are Plans serialized explicitly in RetrieveRequest and SearchRequest (internal proto)
The proto definitions for RetrieveRequest and SearchRequest store the search/query plan in the following form:
// milvus/internal/proto/internal.proto
message RetrieveRequest {
...
bytes ...
- 123
-2
votes
0
answers
22
views
assign multiple persons to a specific segment in table with unknown number in a specific column row [duplicate]
A trip is identified by a number, not unique; the pairing date and number are.
Example:
Trip 7294 on 9/4/2024
Trip 7294 on 9/20/2024
The trip has multiple segments; each segment is identified by a ...
0
votes
1
answer
18
views
"SQLite3::SQLException: index already exists", but I can't find the index anywhere (Rails)
Trying to use a migration to create a joint table in Rails, but it's raising a exception about duplicate index.
How can I solve this supposedly duplicated index?
I tried to find this index by using ...
- 1
0
votes
0
answers
23
views
WP Multisite: The plugin 0 has been deactivated due to an error: Plugin file does not exist
Something happened with our Multisite installation that broke everything. So in an attempt to find the problem we deleted all the plugins and themes it showed the warning "The plugin 0 has been ...
0
votes
0
answers
29
views
Is it possible to use Langchain for both Agent and Memory?
We would like to combine the Agent functionality to search for information on the Internet using Langchain with the Memory functionality to remember past conversations.
We use AWS for our ...
- 1
0
votes
0
answers
17
views
Why Does My Node.js App Time Out When Connecting to SQL Server with Windows Authentication?
I am trying to connect to a SQL Server instance from a Node.js application using Windows Authentication, but I'm encountering a connection timeout error.
SQL Server Version: SQL Server 2019
Port: 1433
...
0
votes
1
answer
44
views
How to set hash tags correctly for a uuid key stored as byte array in Redis
As per Redis documentation hashtags could be used to force assign keys to the same hash slot. I have a use case where we are storing {UUID}Integer as a byte array in Redis where I expect only the UUID ...
- 653
0
votes
0
answers
21
views
Locked dead tuples PostGres [duplicate]
I'm dealing with a situation of dead tuples on an extremely busy environment. Post maintenance, everything performs optimally but within a couple days query execution times increase to about 90%. I ...
0
votes
1
answer
42
views
How to create singleton database object and utilise in different files?
I want to create the database for my app and I'm using floor database. I have created entity, dao and database class like below.
@entity
class User{
@primaryKey
final int id;
final String name;
...
0
votes
0
answers
40
views
How we can use Like queries for searching on encrypted data? I used default Active Record Encryption [duplicate]
My Propose model is below for in which i use Active Record Encryption to encrypt some fields and I'm fetching the data using LIKE query as added below instead if rails query, but when i call that ...
1
vote
1
answer
9
views
Representation of int8 and int16 scalar fields in schemapb
Looking at the Proto definitions in schema.proto, I see the following types are allowed for scalar fields:
message ScalarField {
oneof data {
BoolArray bool_data = 1;
IntArray int_data = 2;
...
- 123
0
votes
0
answers
15
views
"show table" cannot display the table
I created a table, but "show table" does not display it.
public ❯ \d
Query took 0.007 seconds.
public ❯ create table "tb/001"(f1 bigint, tags(t1));
Query took 0.005 seconds.
public ...
- 542
-4
votes
1
answer
40
views
Selecting indexed column returns different order from table design [duplicate]
Using select top 1 * from on the table works
But select top 1 id doesn't. When selecting only the indexed column, returns in the wrong order. Even though, the column id has a user defined clustered ...
0
votes
0
answers
47
views
Is there something like @Embeddable for Hibernate in Diesel for Rust
I have the following structs
#[derive(Debug, Clone, Queryable, Selectable)]
#[diesel(table_name = crate::schema::parents)]
#[diesel(check_for_backend(diesel::pg::Pg))]
pub struct Parent {
id: i32,
...
- 1,774
-1
votes
0
answers
12
views
Laravel Tree List
I will create a Tree list. My scenario is as follows
There are pictures and parts of pictures. A fragment can be added under the image or a fragment from a different image can be added under the image....
0
votes
1
answer
13
views
Basic auth for web console but not for metrics endpoint
I enabled basic auth for QuestDB web console and API using these config variables
export QDB_HTTP_USER=******
export QDB_HTTP_PASSWORD=*******
It is all good, but my metrics endpoint at port 9003 now ...
- 4,081
0
votes
0
answers
20
views
Python cx_oracle/oracledb log bad records
After executing,
cursor.executemany("insert into table(col1, col2, col3) values (:1, :2, :3"), data, batcherrors = True)
connection.commit()
for errorobj in cursor.getbatcherrors():
I want ...
- 325
0
votes
1
answer
63
views
Architecture question concerning data processing and optimize on a mariadb database and myisam tables [closed]
I receive thousands of recordings in my IS every day and I have to keep track of these recordings, line by line, over several years.
This daily data is then processed to derive KPIs and also to ...
1
vote
1
answer
54
views
Laravel with custom relation
I have a question regarding Eloquent relations in a Laravel 10 project. Let's say there are three tables:
orders- table with order data
id - order ID
shop_id - ID of the shop to which the order ...
- 11
0
votes
0
answers
22
views
How to identify if my Oracle DB is on premise or running on DBaaS host? [duplicate]
I have already gone through this link
[https://stackoverflow.com/questions/75680600/how-to-know-if-my-oracle-db-is-on-premise-or-cloud]
but couldn't get any help from the query suggessted as column ...
- 175
1
vote
1
answer
21
views
Question regarding batch Insert & Read Consistency
Context
My question is about batch inserts into the database and their consistency for readers.
In the "Strong" or "Eventual Staleness" consistency levels, if we insert data as a ...
- 123
0
votes
1
answer
43
views
Blazor server displaying data through a async Task<string> task not displaying string
I am making a Roster with all different types of employees. I am using a table to display this data where i used to have it so it was displaing the first name of the employees which were the own ...
- 3
0
votes
2
answers
46
views
Why does dividing one string into 2 lines of strings work with `format()`?
On psql, I could call format() with 'Hello World' as shown below:
postgres=# SELECT format('Hello World');
format
-------------
Hello World
(1 row)
Now, dividing 'Hello World' into 'Hello ' and '...
-1
votes
3
answers
83
views
SQL unique values for one column
I have data composed of three columns. I would like to get distinct values for 2 columns only (ID, value).
Here is my data:
enter image description here
I would like to have this desired result:
enter ...
- 15
-1
votes
0
answers
32
views
What is the most effective way to save timer progress? [closed]
I developed a web service that allows users to manage timer and notepad with one tool.
Like the Pomodoro timer, the timer allows the user to set the time themselves.
Even if the user leaves the ...
- 89
-3
votes
0
answers
29
views
Easy method to store a minimal amount of data in JavaScript [closed]
What would be the best method to store data for it so I can edit and read them from my js program without spending too much time on other languages or programs than js? I don't need much more than ...
- 1
0
votes
1
answer
41
views
Making breaking changes in relational Database between app versions
Assume that I am doing some refactoring in app's code thst uses some relational database. It was decided that some columns and tables are not required from domain perspective , require renaming or ...
- 1
0
votes
0
answers
63
views
mysql : my database seems to keep getting disconnected and idk what to do [closed]
I'm currently developping a web application in local on PhpStorm, and I'm having several connexion problems with MySQL, which are probably linked altogether and I'm a bit lost.
First issue
Initially, ...
-2
votes
0
answers
20
views
Implementing a Group Feature Similar to Facebook Groups [closed]
I'm working on a project where I want to implement a group feature similar to Facebook Groups. Users should be able to:
Create groups
Join existing groups either by invitation or through a public ...
0
votes
1
answer
24
views
flutter use build_runner output Configuring *** in target *** but this is not a known Builder
When I try to generate a database management file using annotations and build_runner in Flutter, the output is look like:
➜ tao_bao flutter pub run build_runner build ...
0
votes
0
answers
17
views
Which side of a relationship can have entities that may not be associated with any entity on the other side: the "one" side or the "many" side?
Which side of relationship(In all possible mapping cardinality) can have entities that are not associated with any entity on the other side: the "one" side or the "many" side or &...
-1
votes
0
answers
30
views
How do I get a specific value from a table and do some multiplication [closed]
When I do want to extract a value of a table and multiply it with a number, I get the message: unsupported value:("comlun2+multiplier"). The multiplier gets exchanged by the value it is ...
- 17