bmatthewshea

CERTBOT - Install using Python PIP

Install Certbot using Python PIP (Package Installer for Python) - without using SNAP, APT or SYSTEMD. (Debian/Ubuntu)

---

This guide will help you install LetsEncrypt / Certbot using venv PIP under Debian/Ubuntu.

• This guide has been tested up to Debian 12 / Bookworm.

deniscapeto

import papaparse from 'https://jslib.k6.io/papaparse/5.1.1/index.js';
import { SharedArray } from "k6/data";
import http from 'k6/http';
import { check } from 'k6';

const csvData = new SharedArray("another data name", function() {
    return papaparse.parse(open('./data.csv'), { header: true }).data;
});

const BASE_URL = 'https://www.mywebsiteundertest.com.br'

djfdyuruiry

// uses Apache commons CSV, IO and Lang
import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVPrinter;
import org.apache.commons.io.FileUtils;
import org.apache.commons.io.IOUtils;

import java.io.*;
import java.util.ArrayList;
import java.util.List;

ststeiger

DROP TABLE IF EXISTS CTE_AllTables; 
-- CREATE TEMPORARY TABLE IF NOT EXISTS CTE_AllTables 

CREATE TEMPORARY TABLE CTE_AllTables AS 
SELECT 
	 ist.table_schema AS OnTableSchema 
	,ist.table_name AS OnTableName  
	,tForeignKeyInformation.FkNullable 
	-- WARNING: TableSchema or Tablename can contain entry-separator (';' used) 
	,CAST(DENSE_RANK() OVER (ORDER BY ist.table_schema, ist.table_name) AS varchar(20)) AS OnTableId 

jfrost

\o /tmp/duplicate-indexes.txt

-- check for exact matches
SELECT indrelid::regclass
     , array_agg(indexrelid::regclass)
  FROM pg_index
 GROUP BY indrelid
     , indkey
HAVING COUNT(*) > 1;