Skip to content

Instantly share code, notes, and snippets.

View elpescador-nl's full-sized avatar

elpescador-nl

View GitHub Profile
@elpescador-nl
elpescador-nl / levenshtein_limit_n.sql
Last active October 27, 2026 20:46
Levenshtein function with a limit n
DROP FUNCTION IF EXISTS levenshtein_limit_n;
DELIMITER //
CREATE FUNCTION levenshtein_limit_n(s1 VARCHAR(255), s2 VARCHAR(255), n INT)
RETURNS INT
DETERMINISTIC
BEGIN
DECLARE s1_len, s2_len, i, j, c, c_temp, cost, c_min INT;
DECLARE s1_char CHAR;
@elpescador-nl
elpescador-nl / Build_nginx_brotli_FreeBSD.md
Created April 28, 2020 13:51
Build nginx with brotli support on FreeBSD
@elpescador-nl
elpescador-nl / Build_nginx_brotli_ubuntu.md
Created May 24, 2020 15:17
Build nginx with brotli on Ubuntu 18.04

Implement brotli in nginx on Ubuntu 18.04

Build the packages

Install dependencies for building packages...

sudo apt install dpkg-dev build-essential zlib1g-dev libpcre3 libpcre3-dev unzip

Go to build folder...

@elpescador-nl
elpescador-nl / levenshtein-mysql.sql
Created May 21, 2020 21:54
Levenshtein function for MySQL
DROP FUNCTION IF EXISTS levenshtein;
DELIMITER //
CREATE FUNCTION levenshtein(s1 VARCHAR(255), s2 VARCHAR(255))
RETURNS INT
DETERMINISTIC
BEGIN
DECLARE s1_len, s2_len, i, j, c, c_temp, cost INT;
DECLARE s1_char CHAR;