cpatulea

with h as (
  select *, convert(data using utf8) as data_utf8 from tiki_history
  where data <> convert(convert(data using utf8) using ascii)
),
h1b as (
  with recursive cte as (
        select pageName, version, data_utf8, 0 as ascii, '    ' as c, 1 as pos
        from h
        union all
        select pageName, version, data_utf8,

cpatulea

== Your Last.fm archive ==
This archive contains musical data you sent to Last.fm, conveniently packaged 
as easy-to-process formats. Use them to discover your listening habits, to 
bootstrap your own apps or to sync them with other data.

We're always interested to see what you're doing with your data, so make sure 
to let us know on the forum: http://www.last.fm/forum/21717

== Types of data ==
There are 6 different types of data in this archive, some of them less obvious. 

cpatulea

#!/usr/bin/python
import ast, _ast, os

for root, dirs, files in os.walk('.'):
  for name in files:
    if name.endswith('.py'):
      full = os.path.join(root, name)
      t = ast.parse(open(full).read())
      for n in ast.walk(t):
        if isinstance(n, _ast.Str) and not isinstance(n.s, unicode):

cpatulea

Question: "Python:
>>> LINE A
>>> LINE B
>>> LINE C
False
>>> LINE A; LINE B; LINE C
True

what are the lines? nothing stateful allowed & no __methods."
(https://twitter.com/akaptur/status/395252265117687808).