Skip to content

Instantly share code, notes, and snippets.

View vst's full-sized avatar
😳

Vehbi Sinan Tunalioglu vst

😳
View GitHub Profile
@vst
vst / README.md
Last active June 3, 2020 01:28
Expected Qualities of a Modern Data Access Layer backed by an RDBMS (Personal Opinion)
  1. High-Level and Accessible: Data should be made available via an API which doesn't require any (1) proprietary, idiosyncratic access technology, (2) custom query language, (3) a particular language, or (4) a particular run-time environment. In other words, users should be able to issue queries using a query language, over a communication protocol and on a run-time environment which they already are familiar with and be able to possess and maintain comfortably on a personal computer with minimal effort and no extra costs.
  2. Liberal: Consumers should be able to issue read/write queries
@vst
vst / inpututils.py
Last active March 22, 2020 12:30
Various functions to inspect and normalize value inputs
"""
This module provides various functions to inspect and normalize value inputs.
Reference: https://gist.github.com/vst/f377006ebe30f3a90d5d54366430ccee
"""
__all__ = ["identity", "strnorm", "is_positive_integer", "as_positive_integer"]
import re
from functools import wraps
@vst
vst / xlsxutils.py
Last active March 22, 2020 12:28
.xlsx utilities
"""
This module provides various functions to work with XLSX file.
Reference: https://gist.github.com/vst/269aceb5a54de0adf2cb23e3482895f8
"""
__all__ = ["read_workbook_data", "read_worksheet_data"]
from typing import Any, Dict, Iterable
@vst
vst / README.md
Last active March 11, 2020 04:02
Setting up an OpenFAAS Gateway (using Docker Swarm)

Setting up an OpenFAAS Gateway (using Docker Swarm)

Note: For the Docker Swarm setup, check out the official guide.

bash setup.sh [<OPENFAAS-HOME-DIRECTORY>]

whereby OPENFAAS-HOME-DIRECTORY defaults to /data/openfaas.

@vst
vst / README.md
Last active March 11, 2020 03:58
Setting up a Local Docker Registry

Setting up a Local Docker Registry

Note: Follow the official guide.

bash setup.sh myusername mypassword
  • Authentication information is stored under /data/docker/registry/auth.
  • Storage directory is set to be /data/docker/registry/storage.
@vst
vst / packages.list
Last active November 9, 2018 02:02
List of Debian/Ubuntu Packages I usually need on a fresh installation
ack
axel
curl
emacs
git
htop
jq
mc
network-manager
pandoc
@vst
vst / macro.vba
Created September 19, 2018 02:59
Open/Libre Office Save All Sheets as CSV
' Run the SaveAllAsCSV subroutine.
' Creates a CSV file from the active sheet under the given directory.
'
' Based on https://forum.openoffice.org/en/forum/viewtopic.php?t=41284
sub SaveAsCSV(filename As String)
' Declare the document variable:
dim document as object
' Get the document:
@vst
vst / todoist.py
Last active March 17, 2018 22:01
A command line tool for Todoist
## Got this script initially from https://gist.github.com/kbl/5970131
###########
# IMPORTS #
###########
import ConfigParser
import argparse
import json
import os
#!/usr/bin/env perl
=head1 NAME
sample.pl - Sample Perl Script
=head1 SYNOPSIS
perl sample.pl
perldoc sample.pl
@vst
vst / casts.py
Created December 29, 2015 10:54
"""
Provides a cast operations module.
>>> cast_to_decimal(1.0001)
Decimal('1.0001')
>>> cast_to_decimal(1)
Decimal('1')
>>> cast_to_decimal("1.0001")
Decimal('1.0001')
>>> cast_to_decimal(Decimal("1.0001"))