A List of GitHub Flavoured Markdown Emoji Markup
A full list can be found here: https://api.github.com/emojis
If an emoji is missing from this gist, please comment in the following format to let me know, and I will add it.
| #!/bin/bash | |
| # This script takes a clean Ubuntu Server 24.04 LTS image and installs and configures | |
| # everything needed to deploy a production-ready PostgreSQL server. | |
| set -euo pipefail | |
| # --- AESTHETICS --- | |
| GREEN='\033[0;32m' |
A List of GitHub Flavoured Markdown Emoji Markup
A full list can be found here: https://api.github.com/emojis
If an emoji is missing from this gist, please comment in the following format to let me know, and I will add it.
If you are not interested in the technical details and only want to get Listen to work:
echo fs.inotify.max_user_watches=524288 | sudo tee -a /etc/sysctl.conf && sudo sysctl -p| create or replace | |
| function partition_insert_trigger() returns trigger | |
| language 'plpgsql' as $$ | |
| declare | |
| column_name text := TG_ARGV[0]; | |
| columnt_format text := TG_ARGV[1]; | |
| column_value timestamp; | |
| table_name text; | |
| insert_stmt_tpl text := 'insert into %I select ($1).*'; | |
| insert_stmt text; |
https://www.youtube.com/watch?v=QlzoegSuIzg
To build a minimal linux distro, we need three parts:
When the system boots, it loads the kernel, which loads busybox.
| ./configure --prefix=/etc/nginx \ | |
| --sbin-path=/usr/sbin/nginx \ | |
| --modules-path=/usr/lib/nginx/modules \ | |
| --conf-path=/etc/nginx/nginx.conf \ | |
| --conf-path=/etc/nginx/nginx.conf \ | |
| --error-log-path=/var/log/nginx/error.log \ | |
| --pid-path=/var/run/nginx.pid \ | |
| --lock-path=/var/run/nginx.lock \ | |
| --user=nginx --group=nginx \ |
For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.
Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.
You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.