 
      
    | You are here | www.binovarghese.com | ||
| | | | | buttondown.com | |
| | | | | In a SQL database, you can set up a foreign key with REFERENCES: nullbitmap=# CREATE TABLE ab (a INT PRIMARY KEY, b INT); CREATE TABLE nullbitmap=# INSERT... | |
| | | | | stepchange.work | |
| | | | | In this post, we explore the limits of single-node Postgres and what optimizations can extend its usefulness as a primary application database before requiring more advanced scaling solutions. Monolithic ecommerce app on RDS PostgreSQL Let's use a real-world scenario, a monolith web application that uses PostgreSQL as the application database running on AWS RDS. The RDS instance is a 2xlarge. The resources are: * 8 vCPUs * 64 GB Memory * 20,000 Max I/O operations per second (IOPS) In ou | |
| | | | | sqlmaria.com | |
| | | | | Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I'm finally getting around to keeping that promise with t... | |
| | | | | iridakos.com | |
| | | A step by step tutorial to dockerize a Rails application and run it in Docker with PostgreSQL and Redis. | ||