20. August 2017

Using SQLite in Javascript with sql.js

Fun Fun Fun :)

var sql = require('sql.js');
// or sql = window.SQL if you are in a browser

// Create a database
var db = new sql.Database();
// NOTE: You can also use new sql.Database(data) where
// data is an Uint8Array representing an SQLite database file

// Execute some sql
sqlstr = "CREATE TABLE hello (a int, b char);";
sqlstr += "INSERT INTO hello VALUES (0, 'hello');"
sqlstr += "INSERT INTO hello VALUES (1, 'world');"
db.run(sqlstr); // Run the query without returning anything

var res = db.exec("SELECT * FROM hello");
/*
[
	{columns:['a','b'], values:[[0,'hello'],[1,'world']]}
]
*/

// Prepare an sql statement
var stmt = db.prepare("SELECT * FROM hello WHERE a=:aval AND b=:bval");

// Bind values to the parameters and fetch the results of the query
var result = stmt.getAsObject({':aval' : 1, ':bval' : 'world'});
console.log(result); // Will print {a:1, b:'world'}

// Bind other values
stmt.bind([0, 'hello']);
while (stmt.step()) console.log(stmt.get()); // Will print [0, 'hello']

// You can also use javascript functions inside your SQL code
// Create the js function you need
function add(a, b) {return a+b;}
// Specifies the SQL function's name, the number of it's arguments, and the js function to use
db.create_function("add_js", add);
// Run a query in which the function is used
db.run("INSERT INTO hello VALUES (add_js(7, 3), add_js('Hello ', 'world'));"); // Inserts 10 and 'Hello world'

// free the memory used by the statement
stmt.free();
// You can not use your statement anymore once it has been freed.
// But not freeing your statements causes memory leaks. You don't want that.

// Export the database to an Uint8Array containing the SQLite database file
var binaryArray = db.export();

var sql = require('sql.js');

// or sql = window.SQL if you are in a browser

// Create a database

var db = new sql.Database();

// NOTE: You can also use new sql.Database(data) where

// data is an Uint8Array representing an SQLite database file

// Execute some sql

sqlstr = "CREATE TABLE hello (a int, b char);";

sqlstr += "INSERT INTO hello VALUES (0, 'hello');"

sqlstr += "INSERT INTO hello VALUES (1, 'world');"

db.run(sqlstr); // Run the query without returning anything

var res = db.exec("SELECT * FROM hello");

[

{columns:['a','b'], values:[[0,'hello'],[1,'world']]}

]

// Prepare an sql statement

var stmt = db.prepare("SELECT * FROM hello WHERE a=:aval AND b=:bval");

// Bind values to the parameters and fetch the results of the query

var result = stmt.getAsObject({':aval' : 1, ':bval' : 'world'});

console.log(result); // Will print {a:1, b:'world'}

// Bind other values

stmt.bind([0, 'hello']);

while (stmt.step()) console.log(stmt.get()); // Will print [0, 'hello']

// You can also use javascript functions inside your SQL code

// Create the js function you need

function add(a, b) {return a+b;}

// Specifies the SQL function's name, the number of it's arguments, and the js function to use

db.create_function("add_js", add);

// Run a query in which the function is used

db.run("INSERT INTO hello VALUES (add_js(7, 3), add_js('Hello ', 'world'));"); // Inserts 10 and 'Hello world'

// free the memory used by the statement

stmt.free();

// You can not use your statement anymore once it has been freed.

// But not freeing your statements causes memory leaks. You don't want that.

// Export the database to an Uint8Array containing the SQLite database file

var binaryArray = db.export();

sql.js @ Github

20. August 2017

Font Face Observer … gives you a font promise ;)

Font Face Observer

is a fast and simple web font loader. You can use it to load fonts and customise your browser’s font loading behaviour.

Font Face Observer gives you control over web font loading using a simple promise based interface. It doesn’t matter where your fonts come from: host them yourself, or use a web font service such as Google Fonts, Adobe Typekit, Fonts.com and Webtype.

var font = new FontFaceObserver('My Family', {
  weight: 400
});

font.load().then(function () {
  console.log('Font is available');
}, function () {
  console.log('Font is not available');
});

var font = new FontFaceObserver('My Family', {

weight: 400

});

font.load().then(function () {

console.log('Font is available');

}, function () {

console.log('Font is not available');

});

Font Face Observer @ Github

20. August 2017

Easy leaderlines for your webpage

Quickly draw a leader line in your web page.

<div id="start">start</div>
<div id="end">end</div>

1 2	<div id="start">start</div> <div id="end">end</div>

// Add new leader line from `start` to `end` (HTML/SVG elements, basically).
new LeaderLine(
  document.getElementById('start'),
  document.getElementById('end')
);

// Add new leader line from `start` to `end` (HTML/SVG elements, basically).

new LeaderLine(

document.getElementById('start'),

document.getElementById('end')

);

Leaderline @ Github

10. August 2017

GreenApe – Makes Your Life Better

Custom theme and integration for the relaunch of GreenApe.
GreenApe is a brand that was dormant for some time. I am currently reviving it together with a friend of mine.

WordPress Backend
English / German
Custom design, all designed in house
Custom template based theme (TWIG / TIMBER / GULP / SASS)
Custom plugin for internal functionality
Detailed Product Presentation
Analytics
SEO
AMP
Social Integration (Facebook, Twitter, Instagram)
Maintenance
Hosting
Custom eCommerce integration
Newsletter
Shorturl Service
Detached Lifestyle Blog
Logo Redesign / Branding
Product Design

GreenApe

1. August 2017

GreenApe Kill me Quick Power Espresso Label 2017

Custom front and back labels for the coffee packaging. Currently only available in Germany.

GreenApe Kill me Quick Power Espresso

18. June 2017

Hexagons & grids do not mix … are you sure ?

CSS responsive grid of hexagons allows you to easily create just that for images and some text. Nice way to present a portfolio.

The hexagon grid is responsive according to the width of the container (#hexGrid)
Hexagons keep their aspect ratio according to their width
The number of hexagons per row is adaptive and changes from 5 to 2 on media query break points
A title and short text slide in on hexagon hover and focus
Hexagons and can be cycled through with tab (keyboard navigation)

GitHub

18. June 2017

Unicode slugs with ease

What is a slug ?
A slug is a part of a URL which identifies a particular page on a website in a form readable by users. It’s the nice part of the URL, which explains the page’s content. In WordPress, it’s the editable part of your URL that you can edit when writing a new post.

nSlug allows to create those urls for any language easily.

use NSlug\SlugGenerator;

$options = [
    'limit'     => null,
    'delimiter' => '-',
    'lowercase' => true,
];

$slugGenerator = new SlugGenerator($options);

// English strings.
echo $slugGenerator->generate('Hello World'); // Prints 'hello-world'.
echo $slugGenerator->generate('Life is too short!'); // Prints 'life-is-too-short'.

// Arabic strings.
echo $slugGenerator->generate('صباح جميل'); // Prints 'صباح-جميل'.
echo $slugGenerator->generate('مساء الخير'); // Prints 'مساء-الخير'.

use NSlug\SlugGenerator;

$options = [

'limit' => null,

'delimiter' => '-',

'lowercase' => true,

];

$slugGenerator = new SlugGenerator($options);

// English strings.

echo $slugGenerator->generate('Hello World'); // Prints 'hello-world'.

echo $slugGenerator->generate('Life is too short!'); // Prints 'life-is-too-short'.

// Arabic strings.

echo $slugGenerator->generate('صباح جميل'); // Prints 'صباح-جميل'.

echo $slugGenerator->generate('مساء الخير'); // Prints 'مساء-الخير'.

GitHub

18. June 2017

Tasty CSS-animated hamburger menu icons

Hamburgers is a collection of tasty CSS-animated hamburger icons. Also included is the source as a Sass library. It’s modular and customizable, so cook up your own hamburger.

<link href="dist/hamburgers.css" rel="stylesheet">

<button class="hamburger hamburger--collapse" type="button">
  <span class="hamburger-box">
    <span class="hamburger-inner"></span>
  </span>
</button>

</span>

</button>

GitHub

18. June 2017

Export SVG Animations for the Web with Snap.SVG Animator

Snap.svg Animator is an open sourced plugin for Animate CC that exports animations for the web rendered in SVG.

It uses the Snap.svg JavaScript library to dynamically draw SVG content at runtime. Snap.svg is a JavaScript library created by Dmitry Baranovskiy, who also created Raphaël.js.

A simple API allows you to write and manipulate SVG content in the browser.

Adobe Plugin / Snap.SVG

14. May 2017

Secure BCrypt hashed passwords for WordPress

“wp-password-bcrypt is a WordPress plugin to replace WP’s outdated and insecure MD5-based password hashing with the modern and secure bcrypt.”

GitHub