Blog Spot!


Error Handling in Node.js

Error handling is a pain, and it's easy to get by for a long time in Node.js without dealing with many errors correctly. But building robust Node.js apps requires dealing properly with errors, and it's not hard to learn how.

joyent

Added on 25.May.2016
Tags: js errors nodejs design patterns

MySQL Create Database with UTF8 Character Set Syntax

Create table

CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;

Add user Access

GRANT ALL ON `mydb`.* TO `username`@localhost IDENTIFIED BY 'password';

Add user Access - FULL CONTROL

GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Flush Privileges

FLUSH PRIVILEGES;

Added on 20.May.2016
Tags: sql mysql create

Sending messages in linux terminal

Usage from man wall:

wall [file]

Wall displays the contents of file or, by default, its standard input

simple usage:

$ echo "who's out there" | wall

for bigger text messages:

$ wall << .
who is out there?
.

This would be a "useless use of here documents", because by default the terminal itself will be connected to wall's standard input and wall will start reading from it until it receives an end-of-file character (Ctrl+D):

$ wall
who is out there?
^D

superuser

Added on 14.May.2016
Tags: linux terminal wall message

How to run a command in the background with a delay?

(sleep 300; echo "80" > /sys/class/leds/blue/brightness) &

stackexchange

Added on 14.May.2016
Tags: linux cmd delay background terminal

7 Handy SQL Scripts for SQL Developers

7 Handy SQL Scripts for SQL Developers

  1. Search for Text Inside All the SQL Procedures
  2. Compare Row Counts in Tables From Two Different Databases With the Same Schema
  3. Back Up Multiple Databases at Once
  4. Shrink Multiple Database Logs at Once
  5. Restrict Connection to the Database by Setting Single-User Mode
  6. String Function in SQL to Generate Dynamic Texts
  7. Printing Table Column Definitions

code.tutsplus

Added on 13.May.2016
Tags: sql scripts developers

Search


PHP Libraries


Carbon lib / docs
Idiorm lib / docs
Image Workshop lib / docs
lorenzos/Minixed lib / docs
Parsedown lib / docs
PHP Paginator lib / docs
PHP Redis lib / docs
QrCode lib / docs
Requests lib / docs
Slim lib / docs
Spyc lib / docs
TWIG lib / docs
Upload lib / docs
Validation lib / docs
Zebra Image lib / docs

JS Libraries


AJV lib / docs
BackboneJS lib / docs
Bootstrap Notify lib / docs
C3.js lib / docs
ChartJS lib / docs
FastMD5 lib / docs
HighlightJS lib / docs
jQuery-Storage lib / docs
JS-Cookie lib / docs
Leaflet JS lib / docs
LowDB lib / docs
Marked lib / docs
NeedlyJS lib / docs
ParcelJS lib / docs
RequireJS lib / docs
Swig lib / docs
Toastr lib / docs
Underscore lib / docs
ValidateJS lib / docs
top