We spent 8 hours last Tuesday watching one query tank our entire API

Our checkout service had a query joining orders, line_items, products, and inventory. no indexes on the foreign keys. at 2pm traffic spiked, query went from 40ms to 8+ seconds, connections pooled up,

Ditched RDS for DynamoDB on Lambda, now my DB isn't the bottleneck anymore

We were getting crushed by connection limits on an RDS Postgres instance. Tiny t3.micro, maybe 100 concurrent connections max, and we kept hitting the ceiling around 50-60 simultaneous Lambda invocati

Does anyone know why connection to database get ideal or disconnected?

Facing a consistent issue with PostgreSQL database. For not using database after few minutes either on backend or some database client tool. I think the connection between the cloud hosted database and database client tool goes into ideal state (or s...

How to get login time and logout time of multiple users/students using Django views?

So I have written a view for getting login time and logout time of a student. Now I want to perform the same procedure for n number of students so how should I do it? Please Help. Here's my code from views.py: def timestamp(request): TodayStartda...

Which database do you prefer when using Node.js?

I'm currently learning NodeJs using MongoDb as my db.

Looking for guidance on Using Pgpool2 in production.

Hi guys, currently we are deciding the architecture or a application and for backend we are using Django and PostgreSQL as database. And want to add fail-safe strategy. So recently I came across "Pgpool ||". So is it ok to use pgpool in production? I...

How to create a view with inner join with variables in PostgreSQL?

I am using PostgreSQL DB. I need to create a view which comprises of a query with joins on multiple tables but I am stuck at a point. Please read the below table definition and the Query which I have created. Tables: Students --------- id -> UUID fu...

Error when setting up PostgreSQL

In a Dockerfile I'm trying to set up a PostgreSQL on an Ubuntu installation but these 2 lines gives me an error: RUN apt-get install -y postgresql RUN systemctl enable postgresql && systemctl start postgresql The error is: RUN systemctl enable postgr...

What kinds of projects should use MongoDB?

What are the most important metrics to track for PostgreSQL performance?

Appreciate any insight you can provide!