Skip to content

Instantly share code, notes, and snippets.

View tetri's full-sized avatar
:fishsticks:
Aprendendo continuamente

Tetri Mesquita tetri

:fishsticks:
Aprendendo continuamente
53 followers · 158 following
View GitHub Profile
@tetri
tetri / string.replaceAll.js
Last active October 2, 2025 18:47
/*
based on http://stackoverflow.com/questions/1144783/replacing-all-occurrences-of-a-string-in-javascript
according to http://jsperf.com/replace-all-vs-split-join/25
*/
if (!String.prototype.replaceAll)
String.prototype.replaceAll = function (str, find, rep) {
return str.replace(new RegExp(find.replace(/([.*+?^=!:${}()|\[\]\/\\])/g, "\\$1"), 'g'), rep); //faster for Firefox
return str.split(find).join(rep); //faster for Chrome
}
@tetri
tetri / browser.detection.js
Last active October 2, 2025 18:46
browser detection
// as seen on http://jsfiddle.net/9zxvE/383/
// and http://stackoverflow.com/questions/9847580/how-to-detect-safari-chrome-ie-firefox-and-opera-browser
// by http://stackoverflow.com/users/938089/rob-w
var isOpera = !!window.opera || navigator.userAgent.indexOf(' OPR/') >= 0;
// Opera 8.0+ (UA detection to detect Blink/v8-powered Opera)
var isFirefox = typeof InstallTrigger !== 'undefined'; // Firefox 1.0+
var isSafari = Object.prototype.toString.call(window.HTMLElement).indexOf('Constructor') > 0;
// At least Safari 3+: "[object HTMLElementConstructor]"
var isChrome = !!window.chrome && !isOpera; // Chrome 1+
@tetri
tetri / timeout.cs
Last active April 23, 2019 17:33 — forked from clupasq/timeout.cs
C# Timeout implementation
public void ComputeResultWithTimeout()
{
var task = Task.Factory.StartNew(() => ComputeResult("vrau"));
//task.Wait(0999);
task.Wait(1000);
if (task.IsCompleted)
Console.WriteLine($"oba! {task.Result}");
else
@tetri
tetri / postgresql_random_boolean.sql
Last active October 2, 2025 18:46
PostgreSQL random boolean for generate test values
SELECT RANDOM()::INT::BOOLEAN;
@tetri
tetri / RevertWhitespaceChangesInFolder.ps1
Last active December 18, 2024 18:59
Este script em PowerShell automatiza o processo de verificar e descartar alterações em arquivos dentro de uma pasta e suas subpastas em um repositório SVN, quando as diferenças são apenas espaços em branco e quebras de linha extras.
param (
[string]$folderPath,
[switch]$WhatIf
)
function Normalize-Content {
param (
[string]$content
)
# Remove espaços em branco extras, tabs e normaliza as quebras de linha
@tetri
tetri / sp_conta_filtros.sql
Created July 26, 2024 17:25
Consulta que retorna o número de registros por tabela para o usuário informado.
CREATE OR REPLACE FUNCTION public.sp_conta_filtros(p_idusuario numeric)
RETURNS TABLE(tabela character varying, counttabela numeric, countfiltro numeric)
LANGUAGE plpgsql
AS $function$
declare tabelas record;
conta numeric;
begin
drop table if exists __contafiltro;
CREATE TEMPORARY TABLE __contafiltro
(tabela varchar(255), counttabela decimal(18), countfiltro decimal(18)) WITH ( OIDS=FALSE );
@tetri
tetri / base_de_dados_por_criacao.sql
Last active October 2, 2025 18:45
Consulta de todas as bases de dados no servidor PostgreSQL conectado ordenado por data estimada de criação (mais recentes primeiro).
SELECT D.DATNAME AS DATABASE_NAME,
PG_SIZE_PRETTY(PG_DATABASE_SIZE(D.DATNAME)) AS SIZE,
PG_CATALOG.SHOBJ_DESCRIPTION(D.OID, 'PG_DATABASE') AS DESC,
(PG_STAT_FILE('base/' || D.OID || '/PG_VERSION')).MODIFICATION AS ESTIMATED_CREATION_DATE
FROM PG_CATALOG.PG_DATABASE D
WHERE D.DATISTEMPLATE = FALSE
ORDER BY ESTIMATED_CREATION_DATE DESC