JM ADITIVA jmptrader

When builing large strings with lots of concatenations in PL/SQL, custom approach like "use varchar2(32000) buffer to reduce the number of dbms_lob calls" makes sense even for Oracle 12.1.0.2.0.

The response time improvement is 4..300+ times :) depending on the DB version and API you use.

Note that simple v_clob || TO_CHAR (SYSTIMESTAMP) || ', ' ==> v_clob || TO_CLOB(TO_CHAR (SYSTIMESTAMP) || ', ') trick (note the extra to_clob) makes 24 times improvement for 11g. The trick is bad for 12c where results in 1.5x degradation.

The code was published 4 year ago as an answer to "How to Quickly Append VARCHAR2 to CLOB": http://www.talkapex.com/2009/06/how-to-quickly-append-varchar2-to-clob.html?showComment=1343235921606#c9077980873875311325

Prerequisites

Create a file called `oci8.pc`

ora=<instaclient-install-dir>
gcc=

How to Setting Up a Comodo SSL Cert

I advice you to buy SSL Certs from officially Comodo only , or some SSL reseller whose you trust.

These are the steps I went through to set up an SSL cert. Purchase the cert

Prior to purchasing a cert, you need to generate a private key, and a CSR file (Certificate Signing Request). You’ll be asked for the content of the CSR file when ordering the certificate:

openssl req -new -newkey rsa:2048 -nodes -keyout example_com.key -out example_com.csr

Moved to git repository: https://github.com/denji/golang-tls

Generate private key (.key)

# Key considerations for algorithm "RSA" ≥ 2048-bit
openssl genrsa -out server.key 2048

# Key considerations for algorithm "ECDSA" ≥ secp384r1
# List ECDSA the supported curves (openssl ecparam -list_curves)

Flexbox Off Canvas Menu

Forked from Oliver Knoblich's Pen Flexbox Off Canvas Menu.

A Pen by John Laine on CodePen.

License.

	#pragma once
	#include <string>
	#include <iostream>
	#include <fstream>
	#include <sstream>

	class csvfile;

	inline static csvfile& endrow(csvfile& file);
	inline static csvfile& flush(csvfile& file);

	== Visual Studio .NET 2003 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 8.00
	# Visual Studio .NET 2003
	VisualStudioVersion = 7.1


	== Visual Studio 2005 (DO NOT COPY THIS LINE) ==
	Microsoft Visual Studio Solution File, Format Version 9.00
	# Visual Studio 2005
	VisualStudioVersion = 8.0

	// Package deepcopy provides a function for deep copying map[string]interface{}
	// values. Inspired by the StackOverflow answer at:
	// http://stackoverflow.com/a/28579297/1366283
	//
	// Uses the golang.org/pkg/encoding/gob package to do this and therefore has the
	// same caveats.
	// See: https://blog.golang.org/gobs-of-data
	// See: https://golang.org/pkg/encoding/gob/
	package deepcopy

	package main
	import (
	"net/http"
	)

	func redirect(w http.ResponseWriter, req *http.Request) {
	http.Redirect(w, req,
	"https://" + req.Host + req.URL.String(),
	http.StatusMovedPermanently)
	}

	package main

	// #include <stdlib.h>
	// #include "wrapper.c"
	import "C"
	import "unsafe"
	import "fmt"

	func read(filename string) string {
	f := C.CString(filename)