3,293 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
68
views
PgCat sometimes routes write queries to replicas
I’m testing a TimescaleDB cluster (1 primary + 2 replicas) behind PgCat, running in Docker Swarm.
Sometimes write queries (CREATE TABLE, INSERT) fail with:
psycopg.errors.ReadOnlySqlTransaction: ...
3
votes
2
answers
105
views
Will calling Engine.dispose() in a forked process cause errors in another process?
When using SQLAlchemy in a forked process, the recommended approach per sqlalchemy documentation (EDIT: originally linked 1.3 docs) is to call engine.dispose() immediately upon initializing the forked ...
1
vote
4
answers
124
views
RLS usage on low-medium sized projects. +Security concerns [closed]
Consider this simple Row Level Security example:
CREATE TABLE accounts (
id integer PRIMARY KEY,
email text,
password text,
);
-- creating RLS policy
ALTER TABLE accounts ENABLE ROW LEVEL ...
1
vote
0
answers
53
views
Connection management while maintaining requests.Session
What I found
While using the requests library for HTTP requests, I noticed that there were many TCP connections in the FIN_WAIT2 state on the server. Through code analysis, I found that these ...
2
votes
1
answer
59
views
Does the pg.Pool from node-postgres support acquireTimeoutMillis?
I'm having a hard time with an app that has some spikes in connections. I think if acquireTimeoutMillis was working these would be queued pre-database. Trying to set it in testing doesn't seem to be ...
0
votes
0
answers
89
views
Use singleton HttpClient in .NET Core for multiple API endpoints calls
According to
[1]: https://learn.microsoft.com/en-us/dotnet/fundamentals/networking/http/httpclient-guidelines, the recommended approach for handling HTTP requests is to use singleton or static ...
0
votes
0
answers
33
views
AWS Lambda with pg Pool and RDS Proxy: "Connection terminated unexpectedly" when processing SQS messages
We are using pg Pool in our Lambda function.
Our connectDb function looks like this:
const config = {
database,
user: username,
password,
max: max_pool,
idleTimeoutMillis,
...
0
votes
0
answers
68
views
Connection pool in oracle python is taking a lot of time to execute insert/update query
self.connection = oracledb.create_pool(
protocol=self.protocol,
host=self.host,
port=self.port,
service_name=self.service_name,
ssl_server_cert_dn=self.ssl_server_cert_dn,
user=...
0
votes
2
answers
103
views
How do I configure an existing tomcat 7 web application to use a postgres database pool
I have legacy (Java 8) web application running with tomcat 7 that uses postgres database and castor-0.9.6.jar. As we have been hitting postgres connection limits I want to switch to using a database ...
0
votes
2
answers
48
views
Can we separate connection pool for heavy background processing versus UI?
We have a Spring 5.3 web application with Hibernate 5.6 and a c3p0 connection pool. Our application does lots of background processing (data import/export), plus there are usually a handful of users ...
0
votes
0
answers
35
views
C3P0 Test Connection On Checkout NOT working
Any ideas why I'm getting "invalid" connections from the pool?
Using:
mysql-connector-java-5.1.49.jar
c3p0-0.11.2.jar
Java 8
C3P0 config:
pool.setJdbcUrl(url);
pool.setUser(user);
pool....
0
votes
0
answers
139
views
Connection Pooling Challenges with MongoDB and AWS Lambda
I'm facing an issue related to MongoDB connections while sending push notifications to users three times a day — morning, noon, and evening.
I have a Lambda-based service that uses SQS and MongoDB. A ...
0
votes
0
answers
39
views
RabbitMQ Channel Pooling
I have a service with 5 RabbitMQ workers, each running in its own process. Currently, every worker creates its own connection and channel, resulting in 5 connections and 5 channels. To reduce the load ...
1
vote
1
answer
40
views
Is a db connection pool necessary in Node.js if await is non-blocking and libuv handles I/O?
I'm building a Node.js backend and trying to understand the role of database connection pooling more deeply.
Since Node.js is single-threaded and uses an event loop with non-blocking I/O via libuv, I ...
3
votes
1
answer
719
views
How Does Connection Pooling Work In Django?
If I'm not wrong, currently there are two ways to have connection pooling in Django:
Native Connection Pooling (Django 5.x)
Using PGBouncer
I want to know that how connection pooling works behind ...