API - portalZINE NMN - development meets creativity

GreenApe is breathing again

30. August 2017

After some downtime, GreenApe is breathing again. I revived the brand with a good friend of mine and we will be reopening shop options shortly.

Michael and I have been friends for a long time. We have been working on many different projects over the years.

He launched GreenApe in 2011 and I helped him with his first steps. A couple of months ago we decided to merge our competences and expand what GreenApe offers and stands for.

From the website: “The GreenApe brand was established in 2011. GreenApe’s career began with the 1st Single Malt Whisky Coffee.

As the first of its kind, our coffee is refined with Original Single Malt Whisky. To this day, he pampers many connoisseurs and gourmets with his unique taste. Now there is another reason to rejoice.

From now on, we are continuously expanding the GreenApe product world with several stylish gadgets and useful accessories. For you this means that you will be able to discover even more beautiful, special or practical things in the future.“

GreenApe is all about lifestyle & leisure products, fun gadgets and unique food & drinks.

Using SQLite in Javascript with sql.js

20. August 2017

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

Font Face Observer … gives you a font promise ;)

20. August 2017

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, Typekit, Fonts.com, and Webtype.

Font Face Observer @ Github

Easy leaderlines for your webpage

20. August 2017

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

Lets fix the short comings of current CSS integrations – EQCSS / Element queries

14. May 2017

“Element queries are a new way of thinking about responsive web design where the responsive conditions apply to elements on the page instead of the width or height of the browser.
Unlike CSS @media queries, @element Queries are aware of more than just the width and height of the browser, you can write responsive conditions for a number of different situations like how many characters of text or child elements an element contains.
Another concept that element queries brings to CSS is the idea of ‘scoping’ your styles to one element in the same way that JavaScript functions define a new scope for the variables they contain.”

Element Query Conditions

Modern API to process – URI – in PHP

14. May 2017

Simple and extensible API
RFC3986 compliant
Implements PSR-7 UriInterface interface
Framework-agnostic

use League\Uri\Parser;

$parser = new Parser();
var_export($parser('http://foo.com?@bar.com/'));
//returns the following array
//array(
//  'scheme' => 'http',
//  'user' => null,
//  'pass' => null,
//  'host' => 'foo.com',
//  'port' => null,
//  'path' => '',
//  'query' => '@bar.com/',
//  'fragment' => null,
//);

use League\Uri\Parser;

$parser = new Parser();

var_export($parser('http://foo.com?@bar.com/'));

//returns the following array

//array(

// 'scheme' => 'http',

// 'user' => null,

// 'pass' => null,

// 'host' => 'foo.com',

// 'port' => null,

// 'path' => '',

// 'query' => '@bar.com/',

// 'fragment' => null,

//);

URI

Client-side JavaScript PDF generation with jsPDF

14. May 2017

A library to generate PDFs in client-side JavaScript.

// Default export is a4 paper, portrait, using milimeters for units
var doc = new jsPDF()

doc.text('Hello world!', 10, 10)
doc.save('a4.pdf')

// Landscape export, 2×4 inches
var doc = new jsPDF({
  orientation: 'landscape',
  unit: 'in',
  format: [4, 2]
})

doc.text('Hello world!', 1, 1)
doc.save('two-by-four.pdf')

// Default export is a4 paper, portrait, using milimeters for units

var doc = new jsPDF()

doc.text('Hello world!', 10, 10)

doc.save('a4.pdf')

// Landscape export, 2×4 inches

var doc = new jsPDF({

orientation: 'landscape',

unit: 'in',

format: [4, 2]

})

doc.text('Hello world!', 1, 1)

doc.save('two-by-four.pdf')

GitHub

A simple javascript database – TaffyDB

14. May 2017

Small file size, extremely fast queries
Powerful JavaScript centric data selection engine
Database inspired features such as count, update, and insert
Robust cross browser support
Easily extended with your own functions
Compatible with any DOM library (jQuery, YUI, Dojo, etc)
Compatible with Server Side JS

// Create DB and fill it with records
var friends = TAFFY([
	{"id":1,"gender":"M","first":"John","last":"Smith","city":"Seattle, WA","status":"Active"},
	{"id":2,"gender":"F","first":"Kelly","last":"Ruth","city":"Dallas, TX","status":"Active"},
	{"id":3,"gender":"M","first":"Jeff","last":"Stevenson","city":"Washington, D.C.","status":"Active"},
	{"id":4,"gender":"F","first":"Jennifer","last":"Gill","city":"Seattle, WA","status":"Active"}	
]);

// Create DB and fill it with records

var friends = TAFFY([

{"id":1,"gender":"M","first":"John","last":"Smith","city":"Seattle, WA","status":"Active"},

{"id":2,"gender":"F","first":"Kelly","last":"Ruth","city":"Dallas, TX","status":"Active"},

{"id":3,"gender":"M","first":"Jeff","last":"Stevenson","city":"Washington, D.C.","status":"Active"},

{"id":4,"gender":"F","first":"Jennifer","last":"Gill","city":"Seattle, WA","status":"Active"}

]);

// Kelly's record
var kelly = friends({id:2}).first();

// Kelly's last name
var kellyslastname = kelly.last;

// Get an array of record ids
var cities = friends().select("id");

// Get an array of distinct cities
var cities = friends().distinct("city");

// Apply a function to all the male friends
friends({gender:"M"}).each(function (r) {
   alert(r.name + "!");
});

// Kelly's record

var kelly = friends({id:2}).first();

// Kelly's last name

var kellyslastname = kelly.last;

// Get an array of record ids

var cities = friends().select("id");

// Get an array of distinct cities

var cities = friends().distinct("city");

// Apply a function to all the male friends

friends({gender:"M"}).each(function (r) {

alert(r.name + "!");

});

TaffyDB / GitHub

Datamuse … a word-finding query engine for developers

24. March 2017

“The Datamuse API is a word-finding query engine for developers. You can use it in your apps to find words that match a given set of constraints and that are likely in a given context. You can specify a wide variety of constraints on meaning, spelling, sound, and vocabulary in your queries, in any combination.”

words with a meaning similar to ringing in the ears
/words?ml=ringing+in+the+ears

Datamuse API

Rocket.Chat – Open Source Web Chat Platform

6. February 2017

Rocket.Chat is am impressive Open Source Web Chat Platform, with a huge amount of features:

BYOS (bring your own server)
Multiple Rooms
Direct Messages
Private Groups
Public Channels
Desktop Notifications
Mentions
Avatars
Markdown
Emojis
Custom Emojis
Reactions
One touch Geolocation
TeX Math Rendering – inline math typesetting
Media Embeds
Link Previews
Sent Message Edit and Deletion
Transcripts / History
File Upload / Sharing
Scalable file sharing – S3 uploads with CDN downloads
Full text search
Live chat / Messaging call center
LDAP Authentication
CAS 1.0, 2.0 support for education institutions and hosting providers worldwide
Support for Okta SSO through SAML v2
I18n – Supports 22 Languages
Hubot Friendly
(Beta) Face to Face Video Conferencing (aka WebRTC )
(Beta) Multi-users Video Group Chat
(Beta) Jitsi integration
Audio calls
Multi-users Audio Conference
Screensharing
….. more

Rocket.Chat

Element Query Conditions

Width-based Conditions

Height-based Conditions

Count-based Conditions

Scroll-based Conditions

Aspect-based Conditions

Meta-Selectors