Skip to content

Instantly share code, notes, and snippets.

2EAAAADAQABAAACAQDGwi38XnDOrmexuS6zUYi/+itio6H4MgQTkZwmvOLVsCkJnJ6LOCMO/xvqYaepL2uZ1pID2pd+/hbHbAJyDI4t/6TRQ7/wAE47YbRVmVg8/QXZJdSlqPYr+EFJ5JoUOiFkn3cH2gg0/+spO3ITsqxOOroD8y48kiZWKnYUHXLZfKQJXS9pLn4GMnyDFFn+T9kRwbljRrsk5XTFtpByfhn5o/OX1C1oqxPEGg/QTjjHHEYceLVMlXz0yu4VFLswLC9JSiaRezYFqHQo1kO7UmAQGEo1IkrghH0D7/blG+DTlApNRpEeCIHXUcBRShhAh6d5Ukda/cPJfBLasz3OCtM4f/pkD+RSKzBE3+CvSh9DOWVjggcMl28FYnot1ItarqgFfYK+T7H+/yDcu2usr2sbHsPohaTqChHlKipW1mNpH5ELaoS62HahfCtnlswJL7dd8gQR+TdndW4eL1V+pcpl3sWgZBwVXOyLVlCJ8DV50GHHoBjr7AzPXcR4GdNp959Ac/YnDxaJKz0CRBGq72k8Qk+nMBZ/3F2BwbvCCd+X2ED3EAy26V/285adX+K7wOcDA4t2GlYRLahC3oqno7iGiyYkZYGq8C+IQSmhezlqtBtQqAd2cU6qIJSY8lPOtByagLDcA6aDJehpLIDEljkvVUR7qAclxZkifojm03
@0x0000000000000001
0x0000000000000001 / ESP8266 with 20x4 i2c LCD.ino
Created October 29, 2015 22:22 — forked from bavensky/ESP8266 with 20x4 i2c LCD.ino
ESP8266 with 20x4 i2c LCD [Arduino IDE]
// ESP8266 with 20x4 i2c LCD
// Compatible with the Arduino IDE 1.6.4
// Library https://github.com/fdebrabander/Arduino-LiquidCrystal-I2C-library
// Bavensky :3
#include <Wire.h>
#include <LiquidCrystal_I2C.h>
LiquidCrystal_I2C lcd(0x20,20,4);
// Author: Phil Pennock
// Based on publicly available data, as described below, so the only creative
// input was the expression in Golang.
package main
/*
An overview is at <http://www.nist.gov/itl/csd/ct/nist_beacon.cfm> and while
the REST API is reliably available (in my experience) the content at
<https://beacon.nist.gov/home> is not, so I'll replicate the data here from
#!/bin/sh
# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.
# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.
# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite
#!/bin/sh
# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.
# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.
# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite
#!/bin/sh
# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.
# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.
# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite