Skip to content

Instantly share code, notes, and snippets.

Xavier L. xhoong

Block or report user

Report or block xhoong

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@xhoong
xhoong / encrypt_openssl.md
Created Oct 8, 2019 — forked from dreikanter/encrypt_openssl.md
File encryption using OpenSSL
View encrypt_openssl.md

Symmetic encryption

For symmetic encryption, you can use the following:

To encrypt:

openssl aes-256-cbc -salt -a -e -in plaintext.txt -out encrypted.txt

To decrypt:

@xhoong
xhoong / slickPlainSQL.scala
Created Mar 14, 2019
Mapping plain SQL in Slick to a case class
View slickPlainSQL.scala
//https://softwaremill.com/comparing-scala-relational-database-access-libraries/
case class MetroSystemWithCity(metroSystemName: String, cityName: String,
dailyRidership: Int)
implicit val getMetroSystemWithCityResult = GetResult(r =>
MetroSystemWithCity(r.nextString, r.nextString, r.nextInt))
val query = sql"""SELECT ms.name, c.name, ms.daily_ridership
FROM metro_system as ms
JOIN city AS c ON ms.city_id = c.id
View Generate ssl certificates with Subject Alt Names on OSX.md

Generate ssl certificates with Subject Alt Names on OSX

We can generate a common CA certificate, and then each project can use this CA certificate to sign and issue a project certificate. Hence the CA certificate is needed to install as a trusted cert, and once the project is signed and issue using this CA cert, the new project certificate will be trusted via chain of trust policy.

Generate a CA key

openssl genrsa -out ca.key 4096

Generate a CA public key, ensure expiry date is exceeding the individual cert

@xhoong
xhoong / windowing.scala
Created Jun 20, 2018 — forked from adamw/windowing.scala
Windowing data in Akka
View windowing.scala
package com.softwaremill.akka
import java.time._
import akka.actor.ActorSystem
import akka.stream.ActorMaterializer
import akka.stream.scaladsl.Source
import scala.collection.mutable
import scala.concurrent.Await
@xhoong
xhoong / Read.md
Created Apr 13, 2018 — forked from ayushmishra2005/Read.md
Store Scala Collection Into PostgreSQL using Slick
View Read.md

Open PostgreSQL and Create a table student in database student.

CREATE EXTENSION hstore;

CREATE TABLE student (
    id     int,
    name   varchar(254) NOT NULL,
    hobbies  text[],
    marks hstore
);
View truncate-log
truncate -s 0 /var/lib/docker/containers/*/*-json.log
View gist:b2912a27cbff5b9cde603a2612917ee6
/**
* Used for reading/writing to database, files, etc.
* Code From the book "Beginning Scala"
* http://www.amazon.com/Beginning-Scala-David-Pollak/dp/1430219890
* http://stackoverflow.com/a/5218279
*/
def using[A <: {def close(): Unit}, B](param: A)(f: A => B): B =
try { f(param) } finally { param.close() }
def writeToFile(fileName:String, data:String) =
@xhoong
xhoong / ambari-api
Created Jul 11, 2016 — forked from glinmac/ambari-api
ambari api examples
View ambari-api
#!/bin/sh
AMBARI_USER=admin
AMBARI_PASSWORD=
CLUSTER_NAME=sandbox
AMBARI_API=http://127.0.0.1:8080/api/v1/clusters/$CLUSTER_NAME
BLUEPRINT_API=http://127.0.0.1:8080/api/v1/blueprints
hostname="hostname.example.com"
service="aservice"
You can’t perform that action at this time.