178,908 questions
Advice
0
votes
1
replies
11
views
Tips/Steps to creare a MDM software for Android
Good morning,
I’ve browsed the forum a bit, and while I’ve found some interesting things, I haven’t found anything that really addresses my concerns.
I’d like to create an Android app that functions ...
-3
votes
1
answer
80
views
Deciding between SQLite and PostgreSQL for small project [closed]
For context, I’m currently trying to build a small project that uses Python, Flask and SQLAlchemy that users will be able to download from GitHub and run on their local machines. The eventual goal is ...
0
votes
0
answers
57
views
Table with RLS, FK, text columns takes a lot of time [closed]
I have this table structure which is for a multi-tenant saas based application:
CREATE TABLE IF NOT EXISTS schema_x.table_x
(
col1 integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START ...
- 625
Advice
1
vote
5
replies
101
views
How can I efficiently delete expired records in PostgreSQL?
I'm building a file-sharing application called OmeBox. Each shared item has an expiration timestamp.
In Python, I'm currently storing records like this:
omebox = {
"id": "abc123&...
Best practices
1
vote
8
replies
95
views
SQL Basics: Create a FUNCTION (DATES)
I'm trying to solve a problem on the platform Codewars:
For this challenge you need to create a basic Age Calculator function which calculates the age in years on the age field of the peoples table.
...
-3
votes
1
answer
99
views
Docker compose postgres instance suddenly stopped working [closed]
I'm using Docker compose to run a postgres instance. It has been working fine until now despite not changing anything in the docker compose file. The database doesn't connect and the healthcheck fails....
- 5,007
2
votes
1
answer
86
views
TimescaleDB Continuous Aggregate with multiplication of disparate time series data
I am using a TimescaleDB hypertable to store sensor data. I need help creating a query that will work as a Continuous Aggregate so I can query for years' worth of data at a time.
The data comes from ...
- 1,254
-2
votes
0
answers
51
views
Superbase insert returns 400 "record has no field published" even though the field doesn't exist in my code or table [closed]
I'm building a reading website with Next.js and Supabase. The website lets users upload chapters as files (Word docs, PDFs, or images). When a user tries to upload a chapter file, I get this error:
...
Best practices
2
votes
4
replies
112
views
How to Show Whether a Task Row Is Currently Locked by a Worker
I am building a worker system where idle hardware is expensive, so machines need to pick up new tasks as quickly as possible.
Task durations vary significantly: some take a few seconds, others several ...
-2
votes
0
answers
72
views
Intermittent 15s delay when establishing PostgreSQL connection from .NET (IIS on EC2) to Aurora PostgreSQL RDS [closed]
I'm investigating a strange issue in an ASP.NET Core Web API and have reached a dead end.
Environment:
ASP.NET Core Web API
EF Core + Npgsql
IIS on Windows EC2
Aurora PostgreSQL RDS
EC2 and RDS are ...
- 17
0
votes
2
answers
100
views
PostgreSQL Error [42601] ERROR: syntax error at or near "$1" in context "256), $1", at line 1
I am trying to create the procedure shown here in Amazon Redshift. However, I keep getting this error repeatedly:
[42601] ERROR: syntax error at or near "$1" in context "256), $1"...
- 3,124
-2
votes
0
answers
50
views
PGBouncer doesn't connect after "Notification for Scheduled Maintenance to Azure Database for PostgreSQL" on 5/29/2026, 4:42:00 AM (UTC) [closed]
After "Notification for Scheduled Maintenance to Azure Database for PostgreSQL" on 5/29/2026, 4:42:00 AM (UTC) PGBouncer doesn't connect
https://learn.microsoft.com/en-us/azure/postgresql/...
8
votes
3
answers
316
views
Grouping text rows in equal-sized groups
I have a table containing a lot of typed/named items and I want to create a (materialized?) view to group them together so that a UI can later make it easier for users to select.
Description
The goal ...
- 4,310
Advice
0
votes
2
replies
90
views
Designing a Scalable Code Execution Service (LeetCode-like) for ~20k Users / 1000 Concurrent Users
I am building an online code execution platform similar to LeetCode.
Current Architecture
Fastify Backend
Receives requests from users.
Sends code execution requests to a separate Judge service.
...
- 1
Advice
1
vote
7
replies
110
views
Why does my query insist on a full table scan?
I have a PostgreSQL table partitioned by a datetime field called journeyTime.
If I have a query where the selection criteria is...
WHERE date_trunc('day', journeyTime) = '01-May-2025'
I would expect ...
- 867
