CRM

Generate test data

Run migration to create user_stats table

sqlx migrate run --target-version 20240706163534

Run script to generate test data

cd user-stat
cargo run --example gen --release

Run migration to create indexes for user_stats table

sqlx migrate run

Some useful commands

Get indexes size

select pg_size_pretty (pg_indexes_size('user_stats')) size;

Get data size

select pg_size_pretty (pg_relation_size('user_stats')) size;

Create export table

create table export_user_stats as select * from user_stats limit 100;

Use Nginx to proxy gRPC

https://nginx.org/en/docs/http/ngx_http_grpc_module.html

Install Nginx in MacOS

brew install nginx

Configuration Nginx

code /opt/homebrew/etc/nginx/nginx.conf

server {
    listen 8080;
    http2 on;
    server_name localhost;

    location / {
      # The 'grpc://' prefix is optional; unencrypted gRPC is the default
      grpc_pass grpc://[::1]:50000;  # grpcs for grpc with tls/ssl
    }
}

Start Nginx

brew services start nginx

Generate root CA by mkcert

https://github.com/FiloSottile/mkcert

Install mkcert

brew install mkcert

Generate root CA

mkcert -install

Generate certificate for local development

mkcert "*.acme.org" localhost 127.0.0.1 ::1

Look for root CA pem

mkcert -CAROOT

Copy rootCA.pem into fixtures directory

cp /Users/${user}/Library/Application\ Support/mkcert/rootCA.pem ./fixtures/rootCA.pem