omidp

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

omidp

import io.github.resilience4j.ratelimiter.RateLimiter;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.time.Duration;

@Configuration
public class RateLimiterConfig {

    @Bean

omidp

## Postgresql configuration
set Postgresql max_connections to 250



## HikariCP configuration
spring.datasource.hikari.minimumIdle=0
spring.datasource.hikari.maximum-pool-size=90
spring.datasource.hikari.maxLifetime=900000
spring.datasource.hikari.data-source-properties.useServerPrepStmts=false

omidp

	public byte[] getByte(UUID uuid) {
		ByteBuffer bb = ByteBuffer.wrap(new byte[16]);
		bb.putLong(uuid.getMostSignificantBits());
		bb.putLong(uuid.getLeastSignificantBits());
		return bb.array();
	}

omidp

find . -type d -depth 1 -exec git --git-dir={}/.git --work-tree=$PWD/{} pull \;

omidp

import java.util.*;
import java.util.concurrent.locks.*;

/**
 * A bank with a number of bank accounts that uses locks for serializing access.
 */

public class Bank
{
   private final double[] accounts;

omidp

import org.springframework.util.MultiValueMap;



public class GatewayContext {

    public static final String CACHE_GATEWAY_CONTEXT = "cacheGatewayContext";

    /**
     * cache json body

omidp

vi pdmonitor.sh

###########
#!/bin/sh

while true
do
date
ps -p [PID] -o %cpu,%mem
sleep 5

omidp

import org.apache.http.client.config.RequestConfig;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.impl.conn.PoolingHttpClientConnectionManager;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class ClientHttpPoolConfiguration {

omidp

netstat -anp | grep :80 | grep ESTABLISHED | wc -l
netstat -anp | grep :80 | grep WAITED | wc -l