clevertonh

A simple knex sample

knexjs ( http://knexjs.org/ ) is SQL query builder.
This gist is a simple knexjs sample.

Installation

1. Clone this gist to a local folder
2. Run npm run build in the local folder

Usage & Database Schema

• node index.js --createSchema : Create the database schema. (The default SQL client is sqlite3. The schema is created by db_schema.js )

clevertonh

Traefik and Portainer on Docker Swarm with Letsencrypt

Reproducing a Traefik with SSL and Portainer setup on a 2 Node Docker Swarm

Install Docker:

Install Docker on both nodes with a Bootstrap Script:

$ curl https://gitlab.com/rbekker87/scripts/raw/master/setup-docker-ubuntu.sh | bash

clevertonh

/**
 * Script simples para importação de dados de cotação da Bovespa
 *
 * Requisitos:
 *   - Node.js instalado
 *   - instalar as dependencias: npm install extract-zip moment request
 *
 * Exemplo de uso: node script_simples_importaca_cota_hist_bovespa.js 05022019
 *
 * Post relacionado: https://albertosouza.net/artigos/22-importando-dados-bovespa

clevertonh

Secured HLS setup with Nginx as media server

This example is part of this article.

This is an example for an HLS delivery with basic security. Nginx compiled with nginx-rtmp-module & secure-link is used as media server. Features:

• Domain filtering
• Referrer filtering
• Embed buster

clevertonh

function displayFields(form,customHTML){ 

    var codigo = parseInt(getValue("WKNumState"));
    
    var api = fluigAPI.getUserService().getCurrent();
    
    log.info(">>>>>>>>>>> " + api);

    switch (codigo) {

clevertonh

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

clevertonh

#!/bin/bash

# The following steps, which were tested on Ubuntu 18.04 LTS and on the Ubuntu-powered Linux for Windows Subsystem on Windows,
# will:
#
# * Compile a recent version of OpenSSL (you can skip this step and use your package maintainer's version if you prefer, but you
#                                        might have to tweak a few bits)
# * Create a separate set of configuration files suitable for configuring a basic CA capable of signing EV certificates
# * Create such a CA (hackerca.local / HackerCA EV Root CA)
# * Create a certificate request for a site, hackersite.local, belonging to company "Barclays PLC [GB]"

clevertonh

function doGet(e){
  Logger.log(e);
  var op = e.parameter.action;

  var ss=SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1UUBGKGvm4b9LOhqbdh0UDG6vYz9Phr1DqGyg8DvCiUc/edit?usp=sharing");
  var sheet = ss.getSheetByName("Sheet1");


  if(op=="insert")
    return insert_value(e,sheet);

clevertonh

//NodeJS
var express = require('express');
var app = express();
var http = require('http').Server(app);
var fs = require('fs');
var io = require('socket.io')(http);

app.use(express.static(__dirname, '/'));

io.on('connection', function(socket){

clevertonh

# Note (November 2016):
# This config is rather outdated and left here for historical reasons, please refer to prerender.io for the latest setup information
# Serving static html to Googlebot is now considered bad practice as you should be using the escaped fragment crawling protocol

server {
    listen 80;
    listen [::]:80;
    server_name yourserver.com;

    root /path/to/your/htdocs;