Skip to content

Instantly share code, notes, and snippets.

View Kambaa's full-sized avatar

Kambaa Kambaa

  • Kambaa
  • Istanbul, Turkey
View GitHub Profile
@corporatepiyush
corporatepiyush / db_compare.md
Last active July 21, 2026 04:14
Database Comparison — SQLite · DuckDB · PostgreSQL · MariaDB · ClickHouse · MongoDB

Database Comparison — SQLite · DuckDB · PostgreSQL · MariaDB · ClickHouse · MongoDB

Version claims cross-checked against official release channels on 2026-07-15. Feature statements describe the versions listed in the table below. Where a database lacks a capability, or has it only in part, the closest practical alternative is given as Alternative:.

Database Stable Version Released Support Storage / Execution Model
SQLite 3.53.3 Jun 26, 2026 Format/API support pledged through 2050 Row-oriented B-trees, in-process, single file
@Kambaa
Kambaa / My Cas 6.6.x Notes.md
Last active February 10, 2025 09:11
My CAS 6.6.x Setup Notes

My notes on CAS server installation when learning it. Hope it will be helpful to somebody.

[Update 2025] Because CAS documentation site deprecates and removes the older versions, i've fetched and hosted the 6.6.X version docs to my domain.

Initial/Basic setup.

<!DOCTYPE html>
<html lang="en">
<head>
<title>IVS Playback</title>
<script src="https://player.live-video.net/1.14.0/amazon-ivs-player.min.js"></script>
<script>
document.addEventListener('DOMContentLoaded', () => {
// set stream url
const streamUrl = '[Playback URL]';

Prerequisites

Just to make sure everything works as expected, here are my current Node/AWS CLI versions (in case we need to look up an ARN or something with the CLI)

Node Version

$ node --version
v18.12.1
@Kambaa
Kambaa / semantic-commit-messages.md
Last active November 28, 2023 10:52 — forked from joshbuchea/semantic-commit-messages.md
Semantic Commit Messages

Anlamlı Commit Mesajları

Kodlamalarınızda, iletilen commit'in ne içerdiğinin kısa özetinin sağlanması adına, belirlenmiş bazı kuralları ifade eder. Bu kurallara uyularak hareket edildiğinde, hem yapılan değişikler daha rahat takip edilebilir, hem uygulamada olan değişiklikler (CHANGELOG) daha kolay ayarlanıp proje koduna iliştirilebilinir.

Genel yapı:

Genel olarak commit messajının yapısı şu şekilde ifade edilmektedir:

subject line(konu başlığı - ZORUNLU)
empty line(boş satır - OPSİYONEL)
commit body(commit detayları - OPSİYONEL)
commit footer(alt metin ve imzalar - OPSİYONEL)
ffmpeg \
-f avfoundation \
-framerate 30 \
-video_size 1920x1080 \
-i "3:" \
-f avfoundation \
-framerate 30 \
-video_size 640x480 \
-i "2:" \
-f avfoundation \
$ ffmpeg \
-re \
-stream_loop -1 \
-i /path/to/video.mp4 \
-stream_loop -1 \
-i /path/to/audio.mp3 \
-map 0:v:0 \
-map 1:a:0 \
-c:v libx264 \
-b:v 6000K \
$ ffmpeg \
-re \
-i /path/to/video.mp4 \
-c:v libx264 \
-b:v 6000K \
-maxrate 6000K \
-pix_fmt yuv420p \
-s 1920x1080 \
-profile:v main \
-preset veryfast \
$ ffmpeg \
-f avfoundation \
-video_size 1920x1080 \
-framerate 30 \
-i "2:2" \
-c:v libx264 \
-b:v 6000K \
-maxrate 6000K \
-pix_fmt yuv420p \
-r 30 \
@echo off;
title OTP FETCHER
cd "C:\LDPlayer\LDPlayer9\"
###echo "Launching FileManager on first device on LDMultiPlayer9(index 0), macro defined in LDplayer will run and copy the OTP"
ldconsole.exe launchex --index 0 --packagename com.google.android.apps.authenticator2
## wait for 15 seconds