Skip to content

Instantly share code, notes, and snippets.

@laacz
laacz / ios-addressbook.sql
Created August 30, 2011 12:16
SQL query to extract essential info from addressbook in iOS backup
--
-- This is SQL query to extract AddressBook info from respective sqlite3 file from iOS backup.
-- It has been tested only on my own backup, so, if anything is wrong, fork, edit, and stuff.
--
-- # parse-manifest.py from http://stackoverflow.com/questions/3085153/how-to-parse-the-manifest-mbdb-file-in-an-ios-4-0-itunes-backup
--
-- $ python ../parse-manifest.py | grep AddressBook.sqlitedb
-- -rw-r--r-- 000001f5 000001f5 1654784 1312812502 1312812502 1287387943 (31bb7ba8914766d4ba40d6dfb6113c8b614be442)HomeDomain::Library/AddressBook/AddressBook.sqlitedb
--
-- $ sqlite3 31bb7ba8914766d4ba40d6dfb6113c8b614be442
@josheinstein
josheinstein / InstallClickOnceApp.cs
Created July 19, 2012 15:57
Install ClickOnce application programmatically (C#)
using System;
using System.Collections.Generic;
using System.Deployment.Application;
using System.Linq;
using System.Text;
using System.Threading;
namespace InstallClickOnceApp
{
@randrews
randrews / telegram.lua
Last active April 18, 2023 04:32
Split a telegram string into component words
function load_dictionary(filename)
local dictionary = {}
for line in io.lines(filename) do
if line:match("^%l%l+$") then
insert(dictionary, line .. "$")
end
end
-- We're cutting all single-letter words, but
@ibotdotout
ibotdotout / robot-packtpub.txt
Last active July 22, 2016 11:10
Robotframework script to claim free packtpub book
*** Settings ***
Library Selenium2Library
*** Variables ***
${USER} [email protected]
${PASSWORD} password
${BROWSER} phantomjs
${HOME URL} https://www.packtpub.com/packt/offers/free-learning
@bishboria
bishboria / springer-free-maths-books.md
Last active October 3, 2024 09:17
Springer made a bunch of books available for free, these were the direct links