Discover gists

I ran into the battle of running all of my VMs and the host node under a single public IP address. Luckily, the host is just pure Debian, and ships with iptables.

What needs to be done is essentially to run all the VMs on a private internal network. Outbound internet access is done via NAT. Inbound access is via port forwarding.

Network configuration

Here’s how it’s done:

Create a virtual interface that serves as the gateway for your VMs:

Optimizing postgresql table for more than 100K inserts per second

Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:

	<?php


	public function onEdit( $param )//</ini>
	{
	try
	{
	if (isset($param['key']))
	{
	$key = $param['key'];

	git clone https://github.com/OpenDevin/OpenDevin.git
	cd OpenDevin
	conda create -n od python=3.10
	conda activate od
	docker ps
	(optional) install docker if not already installed
	docker pull ghcr.io/opendevin/sandbox
	export OPENAI_API_KEY={your key}
	(optional I had to install rust) curl --proto '=https' --tlsv1.2 -sSf [https://sh.rustup.rs](https://sh.rustup.rs/) \| sh
	(optional) restart terminal

	<?php

	class Funcao
	{
	public static function remover_acento($texto)
	{
	$caracteres = array(
	'Š'=>'S', 'š'=>'s', 'Ð'=>'Dj','Â'=>'Z', 'Â'=>'z', 'À'=>'A', 'Á'=>'A', 'Â'=>'A', 'Ã'=>'A', 'Ä'=>'A',
	'Å'=>'A', 'Æ'=>'A', 'Ç'=>'C', 'È'=>'E', 'É'=>'E', 'Ê'=>'E', 'Ë'=>'E', 'Ì'=>'I', 'Í'=>'I', 'Î'=>'I',
	'Ï'=>'I', 'Ñ'=>'N', 'Å'=>'N', 'Ò'=>'O', 'Ó'=>'O', 'Ô'=>'O', 'Õ'=>'O', 'Ö'=>'O', 'Ø'=>'O', 'Ù'=>'U', 'Ú'=>'U',

	# Kernel sysctl configuration file for Linux
	#
	# Version 1.14 - 2019-04-05
	# Michiel Klaver - IT Professional
	# http://klaver.it/linux/ for the latest version - http://klaver.it/bsd/ for a BSD variant
	#
	# This file should be saved as /etc/sysctl.conf and can be activated using the command:
	# sysctl -e -p /etc/sysctl.conf
	#
	# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and sysctl.conf(5) for more details.

	<?php

	TTransaction::open(self::$database);

	$vendas = Venda::where('cliente_id','=', $cliente_id)->load();

	$lista_vendas = array();

	foreach ($vendas as $venda) {
	array_push($lista_vendas, $venda->toArray());

	<?php

	$cep = str_replace(['.','-'], ['',''], $cep);

	$cpf = str_replace(['.','-'], ['',''], $cpf);

	$cnpj = str_replace(['.','/','-'], ['','',''], $cnpj);

	$celular = str_replace(['(',')','-',' '], ['','','',''], $celular);

	<?php

	TScript::create( "
	setInterval(function () {
	Adianti.waitMessage = 'Carregando';
	__adianti_post_data('form_PedidosList', 'class=PedidosList&method=onReload');
	return false;
	}, 10000); // 10000 milliseconds => 10 segundos
	");

	<?php

	use PHPMailer\PHPMailer\PHPMailer;
	use PHPMailer\PHPMailer\Exception;

	/* SMTP - CONEXÃO
	587 > TLS
	465 > SSL

	G-MAIL: