Alfredo Langhans alanghans

## json2sqlite.lua
-- The author disclaims copyright to this source code.
-- Convert http://redd.it/3bxlg7 to an SQLite database
-- Convert the whole dataset at once like so:
-- find reddit_data -type f -exec time lua json2sqlite.lua {} \;

local cjson = require"cjson"
local sqlite = require"lsqlite3"

local db = sqlite.open("reddit_data.db")
db:exec[[

## json_to_csv.html
<html>

<head>
<style>
textarea {
	height: 300px;
	width: 100%;
}
</style>
<script type="text/javascript">

## 1001-albums-you-must-hear-before-you-die.csv
year|album|artist
1955|In The Wee Small Hours|Frank Sinatra
1956|Ellington at Newport _56|Duke Ellington
1956|Elvis Presley|Elvis Presley
1956|Songs For Swingin' Lovers|Frank Sinatra
1956|Birth of the Cool|Miles Davis
1956|Tragic Songs Of Life|The Louvin Brothers
1957|The Atomic Mr Basie|Count Basie
1957|This is Fats Domino|Fats Domino
1957|Here_s Little Richard|Little Richard
	-- The author disclaims copyright to this source code.
	-- Convert http://redd.it/3bxlg7 to an SQLite database
	-- Convert the whole dataset at once like so:
	-- find reddit_data -type f -exec time lua json2sqlite.lua {} \;

	local cjson = require"cjson"
	local sqlite = require"lsqlite3"

	local db = sqlite.open("reddit_data.db")
	db:exec[[
	<html>

	<head>
	<style>
	textarea {
	height: 300px;
	width: 100%;
	}
	</style>
	<script type="text/javascript">
	year\|album\|artist
	1955\|In The Wee Small Hours\|Frank Sinatra
	1956\|Ellington at Newport _56\|Duke Ellington
	1956\|Elvis Presley\|Elvis Presley
	1956\|Songs For Swingin' Lovers\|Frank Sinatra
	1956\|Birth of the Cool\|Miles Davis
	1956\|Tragic Songs Of Life\|The Louvin Brothers
	1957\|The Atomic Mr Basie\|Count Basie
	1957\|This is Fats Domino\|Fats Domino
	1957\|Here_s Little Richard\|Little Richard