195,059 questions
0
votes
0
answers
4
views
How to install extenions from source in postgres or supabase using docker and docker-compose?
I am extending the supabase image to install apache age but when I run my migration to add the extension I get: extension "age" is not available
dbmate-1 | Applying: ...
- 277
-1
votes
0
answers
10
views
Database / Search-Index recommendation: Match time ranges from different categories
300k+ videos
10+ millions of markers, pointing to timeranges in videos
{
"markerCategory": "something",
"markerDesc": "something-more-specific",
"...
- 15k
-3
votes
0
answers
17
views
can we intergrate whole apache superset system with react.js and node.js? [closed]
I am working on a project where I need to integrate Apache Superset (for data visualization) with a React.js frontend and a Node.js backend. Here’s what I’m trying to achieve:
Frontend: React.js for ...
0
votes
0
answers
11
views
How to trigger data population when connecting new Incremental type materialised views to a massive table with existing data in Clickhouse?
We recently built a data processing pipeline that uses Clickhouse as our big data database.
In the pipeline, data is continually ingested into a huge table (let's call it table A) with ~60 columns. It ...
- 111
-1
votes
0
answers
15
views
Using Azure, how do I copy data from one database to another on different servers without changing the schema?
I have two databases on two different servers using Azure. One is a test server the other is a dev server. I want to copy the data from the test database on the test server onto the dev database on ...
- 299
-2
votes
0
answers
30
views
Is it faster to keep a checksum column for big text comparisons in a sql database [closed]
A technique I've used in a couple projects is that when there is a potentially large text column where I may need to do an exact match (a good example of this is storing arbitrary user file paths (...
- 137
0
votes
0
answers
31
views
Is there a function/feature in OpenObserve platform to group the Netflow data by ID's in which port every IP's are accessing
I am using the local UI of OpenObserve, and I want to track which IP addresses are accessing specific ports. Ideally, I would like to add something like IDs or tags to every port to make it easier to ...
0
votes
0
answers
8
views
Database based upon schema.org or MS Common Data Model
I want to start picking up modern development so I’m looking at writing a simple web app for CRM / contact management.
I’ve seen the likes of https://schema.org and also Microsoft’s Common Data Model, ...
- 359
0
votes
0
answers
24
views
Firebase Initialization Issues: 'firebase.database()' Not Defined and Errors with SDK Loading [closed]
I'm trying to implement Firebase in my project, but I'm encountering issues with the Firebase libraries not being loaded properly. Specifically, I’m getting errors related to Firebase initialization ...
- 1
0
votes
2
answers
51
views
Integer PK but a GUID as FK
In our current PostgreSQL DB, primary keys are Ints. However, in almost all of the communications between services another candidate key is used, a GUID. While I am not the original author of the ...
- 35
0
votes
1
answer
16
views
Identify primary and replica on QuestDB
I have a QuestDB Enterprise cluster, and I would like to be able to know if I am working with a primary or a replica from the web console.
I can execute a query like select value from (show parameters)...
- 4,032
0
votes
1
answer
48
views
SQL update column based on another table details
Source table:
customer
category
sales
date
order status
allen
in
200
04-03-2025
Completed
currie
out
300
04-03-2025
WIP
frank
out
400
04-03-2025
WIP
alice
in
500
04-03-2025
WIP
allen
out
400
04-...
- 626
-4
votes
1
answer
27
views
H5PY for simulation output and parameter storage, should I describe everything?
I'm using H5PY to store a high number of simulations' outputs. Now of course these simulations are parametrized, hence I need to also store what parameters were used for which simulation output.
At ...
- 27
0
votes
0
answers
21
views
SyntaxError: Unexpected strict mode reserved word in nestjs
package.json
{
"name": "nestjs-pinecone-api",
"version": "0.0.1",
"description": "NestJS API with Pinecone integration",
"...
- 34
-1
votes
1
answer
25
views
Fintech OS query Payload
Create a payload for this
SELECT acc.id, pol.id, add.id, fp.no
FROM account acc
LEFT JOIN address add ON acc.ad_id = add.ad_id
LEFT JOIN mpol pol ON pol.ac_id = acc.id
LEFT JOIN mxpol ON pol.mid = mxp....
0
votes
0
answers
18
views
Recover data that is not push type API Power BI
Is there a way to retrieve data that is not of the Push API type. My model is of the Semantic type. I don’t see any clear documentation for this topic and it’s really a challenge for me.
I was able to ...
-1
votes
0
answers
21
views
Are there any issues with using the primary key as a ltree label?
I am storing a graph structure in Postgres using 2 tables, a Node table and an Edge table. The node table has the schema:
Column Name
Column Type
node_id
UUIDv4
nodeType
String
nodeValue
String
...
- 3,169
0
votes
1
answer
104
views
Choosing a PostgreSQL connection in Delphi
how to write code like this in delphi:
#include <stdio.h>
EXEC SQL BEGIN DECLARE SECTION;
char dbname[1024];
EXEC SQL END DECLARE SECTION;
int main()
{
EXEC SQL CONNECT TO testdb1 AS ...
- 33
-1
votes
1
answer
38
views
Database model for blood tests project [closed]
I’m developing a medical app (learning purpose) where users can store and manage blood test results, medications, doctor appointments, and medical documents. I’ve designed a PostgreSQL database schema,...
0
votes
1
answer
19
views
Trouble Binding InputSelect (drop down list) in Blazor from Database
I'm new to Blazor and the next issue I'm having is trying to bind dynamic data from a lookup table onto an InputSelect deal
Here's the Create Code:
@page "/movies/create"
@rendermode ...
- 21
0
votes
0
answers
14
views
What is the cost of receiving a RecordBatch and converting it to a Pandas DataFrame in PyArrow?
The database I use, ClickHouse, allows my Python code to receive and process PyArrow's RecordBatches in a stream with query_arrow_stream, which is both fast and convenient.
Following Arrow's zero-copy ...
- 1,775
0
votes
1
answer
13
views
SAMPLE BY query missing time ranges
I am migrating from InfluxDB to QuestDB and I am in the process of re-writing my queries and embracing SQL time series extensions. But I am not sure what I am doing wrong, as I am getting some ...
- 4,032
0
votes
1
answer
11
views
Find the first occurrence of each unique value in a QuestDB table
I have a QuestDB table storing market data, and I need to find the first recorded trade for each stock symbol in the past month.
This is my schema
CREATE TABLE 'trades' (
symbol SYMBOL CAPACITY ...
- 4,032
0
votes
0
answers
43
views
+50
What is best way to Sync SQLite Database over Local WIFI connection in React Native App installed in multiple Android devices? [closed]
I have a React Native app installed in multiple Android devices.
Those devices are connected to same WIFI (no internet connection).
The app uses SQLite database to store the data.
I want to sync ...
- 45
0
votes
1
answer
15
views
Repetitive varchar columns taking a lot of storage on my questdb table
I have a table where I am storing queries executed by users with some metadata. The table expires after 1 day.
CREATE TABLE '_query_trace' (
ts TIMESTAMP,
query_text VARCHAR,
...
- 4,032
0
votes
1
answer
10
views
Histogram for query times using _query_trace
I want to check how fast my queries are and would like to display a cumulative histogram to understand how many are in the fastest 10%, slowest 10% and so on.
I enabled
query.tracing.enabled=true
So ...
- 4,032
-2
votes
0
answers
33
views
Recommendation for implementing a simple PHP project [closed]
I would like to build a small, wiki-like page and would appreciate some tips, whether someone has done or knows of a similar project.
It’s about the following:
People arrive at a landing page by ...
- 1
0
votes
1
answer
15
views
QuestDB and PingFederate "Log in with other account"
I am configuring QuestDB Enterprise for SSO with PingFederate. I have gone through the config at the docs and everything is looking good on PingFederate. I have also added to my server.conf file this:
...
- 4,032
-1
votes
3
answers
56
views
join with a fall back option and outer join isn't working
ProjectFundingTable:
Project
Team
TeamFundingAllocation
ProjectA
Team1
10
ProjectA
Team2
15
ProjectB
Team1
5
ProjectB
Team3
20
WorkDoneTable:
Project
Team
WordDoneAmount
ProjectA
Team1
5
...
-4
votes
0
answers
40
views
How do I connect my tkinter GUI with a database? [closed]
I have a gui and I want to link it to a database. There are many windows, and when button 'next' is pressed, one closes and opens another. Now my problem is that I have other buttons that I wanna ...
- 1
0
votes
0
answers
50
views
The wizard was interrupted before oracle database 21c express edition could be completely install
I am trying to install Oracle Database 21c Express Edition (XE) on my Windows 10(64-bit) system, but the installation gets interrupted with the following error message:
"Oracle Database ...
0
votes
0
answers
21
views
How can I create parent IDs for rows in a Pandas DataFrame based on multiple conditions? [closed]
I have a DataFrame where each row represents an event, and I need to generate a parent ID column that groups related rows based on specific conditions. For example, rows with similar timestamps or ...
0
votes
0
answers
54
views
Limitations of database context pooling in .NET
I have a base class called BaseDbContext. I derived two classes from this: WriteDbContext and ReadDbContext. Both contexts have compiled queries as private members in WriteDbContext and ReadDbContext:
...
- 21
0
votes
0
answers
18
views
django: Updating a database based on changes on a object or file?
So I am making a website to dynamicaly calculate cost and profit of some crafts(bps) in a game (Eve btw). As I like to do calculations on my own and store my own data, I need to get most of the needed ...
0
votes
0
answers
31
views
How to resolve circular dependency error in django models
I have 2 apps in my django project
customer app
trades app
Customer app has following tables in models.py
customer_table
trade_plan_table
service_plan_table
customer_payments
trades app has ...
0
votes
0
answers
30
views
MS Access Filter options in combo box on subform in many-to-many relationship
I have an Microsoft Access database where I track invoices and payments. A payment can pay multiple invoices, and the payor can take multiple payments to pay one invoice in full. I am trying to make a ...
- 183
-2
votes
0
answers
40
views
Using ImageSecure And I Cant Delete An Image Upload [closed]
I am using a image upload script called ImageSecure that I downloaded and setup. Everything works great except for when I go to delete an image. Nothing happends, no error messages, nothing. If I ...
-3
votes
0
answers
43
views
Modeling different types of Post entities [closed]
I'm designing a databa
Proposals
id (primary key)
user_id (references Users)
title
description
location
date
max_participants
confirmed_participants
created_at
Experiences
id (primary key)
user_id (...
- 1
0
votes
0
answers
22
views
Liquibase with Databricks: "Unsupported data type DATETIME" error during liquibase update
I’m trying to use Liquibase with Databricks SQL Warehouse to manage schema migrations. However, when I run the liquibase update command, I encounter the following error:
System and Version info:
...
0
votes
1
answer
8
views
Extract multiple parts of varchar in QuestDB
We have a table with a column 'streamId' that itself is composed of several parts.
I'm trying to explode the parts into separate columns in a query on the fly but not getting very far.
This is an ...
- 4,032
-1
votes
1
answer
20
views
How to configure spring.datasource.hikari.maximumPoolSize when using a DataSource Bean in Spring Boot
SB 3.4.2, Java 21
We can't use the autowired datasource as we are getting database credentials etc. from AWS Secrets manager.
In our application.properties, these are being ignored:
spring.datasource....
- 12.4k
0
votes
0
answers
67
views
Efficient algorithm for real-time account balance calculation from transactions without storing balance [closed]
I'm working on a wallet management system where I need to calculate an account's balance in real-time by summing all its transactions, without storing the balance directly in the database. The system ...
- 324
0
votes
1
answer
11
views
Converting base InfluxDB schema to QuestDB
I am using Influxdb in many projects, but I am searching for an alternative and found QuestDB. I want to give it a try, and would like to retain the schema I have at the moment, but converting to ...
- 4,032
0
votes
1
answer
8
views
Check historical write amplification per table with QuestDB
I have some processes ingesting data on QuestDB and I can see some spikes on my disk usage on the server. I am trying to understand which tables are affecting the spikes and found out that on QuestDB ...
- 4,032
0
votes
0
answers
33
views
Unable to Restore SQL Database from Disk. SSMS only sees server filesystem [duplicate]
I have SQL Server 2022 and I am trying to take a .bak from my localhost server instance and restore it to my remote instance (NOT Azure).
When I go to Restore Database I select Device and click the ...
- 1,528
-2
votes
0
answers
14
views
How to implement standard file management and history feature for free in next.js application [closed]
i am working with a next.js project and are building its file management and history. Below is the description of the file management and history plan.
History. A History page to show and a mechanism ...
0
votes
1
answer
13
views
Get First Write Wins deduplication per minute on QuestDB
I have a table capturing data from different sensors. The sensors only send data when there is a change over a threshold, but until the readings get stable again, the sensor can be very noisy, sending ...
- 4,032
0
votes
1
answer
13
views
Making SAMPLE BY/UNION query more robust
Once in a while I have the use case of doing a SAMPLE BY with a FILL to interpolate empty rows for each interval, but with fixed boundaries, for example for 7 days from now. I know this has been asked ...
- 4,032
1
vote
2
answers
40
views
How do I wait for Elasticsearch to finish cloning an index?
I'm doing Elasticsearch reindexing as a multistep process using the JavaScript client library:
Clone index named "old" to a new index named "new"
Delete "old" index
...
- 1,017
-2
votes
0
answers
28
views
How to detect if a given path is synced with a cloud storage service (Google Drive, OneDrive, iCloud, Dropbox, etc.) in C++ or Swift on iOS? [closed]
I am trying to determine whether a given file or directory path is synced with any cloud storage services such as Google Drive, OneDrive, iCloud, Dropbox, or similar services.
I am open to solutions ...
