Skip to content

Instantly share code, notes, and snippets.

View nikodemrafalski's full-sized avatar

Nikodem Rafalski nikodemrafalski

12 followers · 19 following
  • Poznań, Poland
  • 13:12 (UTC +01:00)
View GitHub Profile
@nikodemrafalski
nikodemrafalski / overlapping_intervals.sql
Created December 17, 2020 12:00
Aggregate overlapping intervals
with input as (
select *
from (
values ('1', '2012-01-01' :: timestamp, '2012-01-20':: timestamp),
('1', '2012-01-09':: timestamp, '2012-01-26':: timestamp),
('2', '2012-01-02':: timestamp, '2012-01-07':: timestamp)
) as t(id, date_from, date_to)
),
date_points as (
select id, date_from as p
@nikodemrafalski
nikodemrafalski / gist:aab443c15453af3dd56af3a1a5923ed9
Created September 6, 2017 12:42
Verifying that "nikodem.id" is my Blockstack ID. https://onename.com/nikodem
@nikodemrafalski
nikodemrafalski / bootable.cmd
Created June 6, 2014 09:18 — forked from kjeske/bootable.cmd
DiskPart
List Disk
Select Disk #
Clean
Create Partition Primary
Select Partition 1
Active
Format fs=FAT32 quick
Assign
@nikodemrafalski
nikodemrafalski / Password hashing
Created July 15, 2013 20:48
Password hashing
public static byte[] CreateRandomSalt(int size = 16)
{
var cryptoProvider = new RNGCryptoServiceProvider();
var salt = new byte[size];
cryptoProvider.GetBytes(salt);
return salt;
}
public static string HashPassword(string plainText, byte[] salt)
{
@nikodemrafalski
nikodemrafalski / Nearest decimal index.cs
Created January 11, 2013 15:21
Finds index of nearest number in a sorted decimals array.
private int FindNearestNumberIndex(decimal value, decimal[] array)
{
int index = Array.BinarySearch(array, value);
if (index >= 0)
{
return index; // direct match
}
int indexOfFirstHigherValue = ~index;
if (indexOfFirstHigherValue == 0)
@nikodemrafalski
nikodemrafalski / ILambdaEqualityComparerOfT.cs
Created August 28, 2012 10:42
ILambdaEqualityComparer<T>
/// <summary>
/// Checks object of type <typeparamref name="T"/> for equality using provided delegates.
/// </summary>
/// <remarks>Use this class to avoid creating nested, narrow-scoped implementation of <see cref="IEqualityComparer{T}"/></remarks>
/// <typeparam name="T">Type that comparer will able to compare.</typeparam>
public class LambdaEqualityComparer<T> : IEqualityComparer<T>
{
private readonly Func<T, T, bool> _equalityCheck;
private readonly Func<T, int> _hashCodeProvider;
@nikodemrafalski
nikodemrafalski / clean.cmd
Created August 28, 2012 10:03
Clean bin and obj artifacts directories downstream current directory tree.
for /d /r . %%d in (bin, obj) do @if exist "%%d" rd /s/q "%%d"