Skip to content

Instantly share code, notes, and snippets.

View dionys's full-sized avatar

Denis Ibaev dionys

  • Saint Petersburg, Russia
View GitHub Profile
@dionys
dionys / golf.pl
Last active August 29, 2015 14:02
YAPC::Russia 2014 Perl Golf
#!perl -plaF'[,:]\s'
$n//=pop@F;pop@F;push@$_,@F
for@F}{$i=1;for(;$n;$i++){$n{$_}//=$n
ne$_?$i:0for@$n;@$n=();($n)=grep@$_,keys%n}$_=$n{Erdos}//Inf
@dionys
dionys / places-integrity.sql
Created May 11, 2013 11:38
Firefox places.sqlite restore if its corrupted.
UPDATE moz_historyvisits
SET from_visit = 0 WHERE id IN (
SELECT t1.id
FROM moz_historyvisits t1
LEFT JOIN moz_historyvisits t2 ON t1.from_visit = h2.id
WHERE t2.id IS NULL AND t1.from_visit <> 0);
DELETE FROM moz_inputhistory
WHERE place_id IN (
SELECT t1.place_id
FROM moz_inputhistory t1