Skip to content

Instantly share code, notes, and snippets.

View octavian-nita's full-sized avatar

Octavian Nita octavian-nita

6 followers · 72 following
View GitHub Profile
@octavian-nita
octavian-nita / create-db.my.sql
Last active August 29, 2015 14:01
Create MySQL database and user and grant rights (precedes many tool installations like WordPress, Koken, etc.)
CREATE DATABASE IF NOT EXISTS kabuki DEFAULT CHARACTER SET = 'utf8' DEFAULT COLLATE 'utf8_general_ci';
GRANT USAGE ON *.* TO 'koken'@'localhost' IDENTIFIED BY 'Midori1981';
GRANT ALL PRIVILEGES ON kabuki.* TO 'koken'@'localhost';
FLUSH PRIVILEGES;
@octavian-nita
octavian-nita / fisher-yates.sql
Created August 6, 2014 08:59
The Fisher-Yates shuffle in PL/SQL
DECLARE
TYPE tab_t IS TABLE OF VARCHAR2(20);
tab tab_t
:= tab_t('11',
'22',
'33',
'44',
'55');
cnt NUMBER;
idx NUMBER;
@octavian-nita
octavian-nita / spell-number.sql
Created August 6, 2014 09:05
Spelling numbers in PL/SQL
CREATE OR REPLACE FUNCTION spell_number(p_number IN NUMBER)
RETURN VARCHAR2 AS
TYPE myarray IS TABLE OF VARCHAR2(255);
l_str myarray := myarray(
'',
' thousand ',
' million ',
' billion ',
' trillion ',
@octavian-nita
octavian-nita / backup.groovy
Last active March 31, 2018 00:07
Back up a directory to your email (+ nice utility to detect the code base of a class)
#!/usr/bin/env groovy
import javax.activation.*
import javax.mail.*
import javax.mail.internet.*
@Grapes ([
@Grab (group = 'javax.activation', module = 'activation', version = '1.1.1'),
@Grab (group = 'javax.mail', module = 'mail', version = '1.4.5')
])
@octavian-nita
octavian-nita / index.xhtml
Created August 6, 2014 09:38
XHTML 1.0 strict template [deprecated]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>An XHTML 1.0 Strict document</title>
<style type="text/css">
@octavian-nita
octavian-nita / index4.html
Last active August 29, 2015 14:04
HTML 4.01 strict template [deprecated]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>An HTML 4.01 Strict document</title>
</head>
<body>
<p>... The document content goes here ...</p>
@octavian-nita
octavian-nita / NoCacheServlet.java
Last active April 5, 2017 15:02
Disable browser caching for servlet response; http://stackoverflow.com/questions/49547/making-sure-a-web-page-is-not-cached-across-all-browsers
// ...
response.setContentType("text/plain");
response.setCharacterEncoding("UTF-8");
response.setContentLength(tx.length());
response.setStatus(HttpStatus.OK.value());
response.setHeader("Access-Control-Allow-Origin", "*");
@octavian-nita
octavian-nita / header.php
Created August 6, 2014 09:48
HTML-enabled site description in WordPress
<!-- header.php -->
<!-- h2 class="site-description"><?php bloginfo( 'description' ); ?></h2 -->
<h2 class="site-description"><?php echo html_entity_decode(get_bloginfo('description')); ?></h2>
@octavian-nita
octavian-nita / Logging.java
Created August 6, 2014 09:50
java.util.logging basic setup
private static final Logger LOG = Logger.getLogger(MyClass.class.getName());
static {
Logger rootLogger = Logger.getLogger("");
rootLogger.setLevel(Level.INFO);
rootLogger.addHandler(new ConsoleHandler());
Handler fileHandler; // set up a file handler as well...
try {
fileHandler = new FileHandler("file.log"); // a file in the current working directory
@octavian-nita
octavian-nita / visible-ip.js
Created August 22, 2014 09:48
Callback on getting the current visible IP address in Node.js, using basic proxy authorization
'use strict';
var ip;
function visibleIp(callback) {
if (ip || (ip = process.env['VISIBLE_IP'])) {
return process.nextTick(function() { callback(null, ip); });
}