Skip to content

Instantly share code, notes, and snippets.

View sakshatshinde's full-sized avatar
🍧
Eating icecream

Sakshat sakshatshinde

🍧
Eating icecream
View GitHub Profile
@sakshatshinde
sakshatshinde / tracing.rs
Created May 13, 2023 05:06
Basic tracing example
use anyhow::Result;
use axum::routing::get;
use axum::Router;
use std::net::SocketAddr;
use tracing::{info, Level};
use tracing_subscriber::FmtSubscriber;
#[tokio::main]
async fn main() -> Result<()> {
// logging init
@sakshatshinde
sakshatshinde / ORACLE_SQL_HISTORY.md
Last active January 9, 2023 15:11
How to check historic values of a cell in Oracle SQL DB

Few ways to peek into your DB's history

SELECT salary FROM emp AS OF TIMESTAMP TIMESTAMP '2021-12-31 23:59:59.999999999' WHERE  id = 1111

SELECT deptno, dname, VERSIONS_STARTTIME, VERSIONS_XID, VERSIONS_OPERATION 
FROM dept VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - INTERVAL '20:00' MINUTE TO SECOND AND SYSTIMESTAMP 
WHERE deptno = 10;

SELECT * FROM table_a WHERE ora_rowscn &gt;= timestamp_to_scn(trunc(sysdate));
@sakshatshinde
sakshatshinde / uplayID.py
Last active February 2, 2020 10:33
A simple way to find installed games' uPlay IDs with python
'''
There are folders in -> C:\\Program Files (x86)\\Ubisoft\\Ubisoft Game Launcher\\data
The names of the folders are "Uplay IDs" of the installed games.
'''
import winreg, os, re
# Finding Uplay IDs by going through the uPlay data folder
def getUplayIDs(filePath = 'C:\\Program Files (x86)\\Ubisoft\\Ubisoft Game Launcher\\data'):
listOfFiles = os.listdir(filePath)
@sakshatshinde
sakshatshinde / [GUIDE] linux-zen Arch Linux systemd-boot.md
Last active May 1, 2024 12:37
A guide to install linux-zen kernel on Arch Linux for systemd-boot

A simple guide to install linux-zen (The "Zen" kernel) on Arch Linux for Systemd-boot

Firstly run the following command with the appropriate privilege:

sudo pacman -S linux-zen linux-zen-headers

When asked for confirmation, type 'y', press ENTER

Now the kernel is installed on your system. We need to tell systemd-boot to boot with the newly kernel installed.