Blog | portalZINE NMN | Development meets Creativity

20. January 2018

Working with MongoDB? … Use Robo 3T

Robo 3T gives you the full power of the MongoDB shell, but also allows you to easily save, load, edit your queries, do copy/paste, view your results as JSON/trees/tables… and get a decent autocompletion!

It is cross-platform, free and open-source (GitHub repo here).

10. January 2018

Puron Metals

Custom theme and integration for a GREENTONIC client. GREENTONIC did the design & layout.

WordPress Backend
English / German
Custom template based theme (TWIG / TIMBER / SASS)
Custom plugin for internal functionality
Detailed Product Presentation
Analytics
SEO
AMP
Social Integration
Maintenance

PURON Metals

9. January 2018

GreenApe T42 Feuerkieker – Schwarztee

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

GreenApe T42 Feuerkieker – Schwarztee

9. January 2018

GreenApe T42 Kräuterschorle – Kräutertee

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

GreenApe T42 Kräuterschorle – Kräutertee

1. January 2018

GreenApe Fortune Teller Barbados Rum 2018

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

GreenApe Fortune Teller Barbados Rum

7. November 2017

KAIAKOO – Adventure Coaching goes online!

A new customer website goes online. KAIAKOO offers private and group coaching events, fire walks and more.

KAIAKOO – Adventure Coaching

1. September 2017

GreenApe 1st Single Malt Whisky Coffee Label 2017

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

GreenApe 1st Single Malt Whisky Coffee

30. August 2017

GreenApe is breathing again

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.

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

Font Face Observer @ Github