Skip to content

Instantly share code, notes, and snippets.

View nanotaboada's full-sized avatar
🏠
Working from home

Nano Taboada nanotaboada

🏠
Working from home
View GitHub Profile
@nanotaboada
nanotaboada / players-sqlite3-ddl.sql
Last active March 29, 2026 15:34
SQLite3 DDL for a small-sized collection of Players.
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "players" (
"id" INTEGER,
"firstName" TEXT NOT NULL,
"middleName" TEXT,
"lastName" TEXT NOT NULL,
"dateOfBirth" TEXT,
"squadNumber" INTEGER NOT NULL,
"position" TEXT NOT NULL,
@nanotaboada
nanotaboada / songs.json
Created January 1, 2024 19:44
A mid-sized collection of Songs in valid (RFC 8259) JSON format. The rank matches Rolling Stone's list of The 500 Greatest Albums of All Time.
[
{
"album": "Highway 61 Revisited",
"artist": "Bob Dylan",
"rank": 1,
"title": "Like a Rolling Stone",
"year": 1965
},
{
"album": "Out of Our Heads",
@nanotaboada
nanotaboada / songs-sqlite3-ddl.sql
Created January 1, 2024 19:43
SQLite3 DDL for a mid-sized collection of Songs. The rank matches Rolling Stone's list of The 500 Greatest Songs of All Time.
BEGIN TRANSACTION;
DROP TABLE IF EXISTS "songs";
CREATE TABLE IF NOT EXISTS "songs" (
"rank" INTEGER NOT NULL,
"title" TEXT NOT NULL,
"artist" TEXT NOT NULL,
"album" TEXT,
"year" INTEGER NOT NULL,
PRIMARY KEY("rank")
);
@nanotaboada
nanotaboada / albums.json
Created January 1, 2024 19:39
A mid-sized collection of Albums in valid (RFC 8259) JSON format. The rank matches Rolling Stone's list of The 500 Greatest Albums of All Time.
[
{
"album": "Whats Going On",
"artist": "Marvin Gaye",
"label": "Tamla/Motown",
"rank": 1,
"year": 1971
},
{
"album": "Pet Sounds",
@nanotaboada
nanotaboada / albums-sqlite3-ddl.sql
Created January 1, 2024 19:29
SQLite 3 DDL for a mid-sized collection of Albums. The rank matches Rolling Stone's list of The 500 Greatest Albums of All Time.
BEGIN TRANSACTION;
DROP TABLE IF EXISTS "albums";
CREATE TABLE IF NOT EXISTS "albums" (
"rank" INTEGER NOT NULL,
"album" TEXT NOT NULL,
"artist" TEXT NOT NULL,
"label" TEXT NOT NULL,
"year" INTEGER NOT NULL,
PRIMARY KEY("rank")
);
@nanotaboada
nanotaboada / books.json
Last active January 17, 2026 09:59
A small-sized (8 items) sample collection of free Books in valid JSON (RFC 8259) format
{
"books":[
{
"isbn":"9781593279509",
"title":"Eloquent JavaScript, Third Edition",
"subtitle":"A Modern Introduction to Programming",
"author":"Marijn Haverbeke",
"published":"2018-12-04T00:00:00.000Z",
"publisher":"No Starch Press",
"pages":472,
@nanotaboada
nanotaboada / dbconfig.xml
Last active September 25, 2015 21:38
Idea for ADO.NET connection string serialization
<conf
host="localhost"
init="northwind"
auth="false"
user="foo"
pass="bar"
file="northwind.mdf"
/>