SQLite Quote Database That I Use for My Lockscreen

I’ve been using Zen Quotes API for a while now. It’s a great app that provides quotes for my lockscreen. But I was unable to filter based on author. So I decided to create my own personal quote API. First I needed a source of quotes. I found datasets of quotes on Kaggle Quotes Dataset and Quotes-500K. I think these datasets were created by scraping the web for quotes. The Plan Create sqlite database to store quotes. Create table quotes with columns quote, author, tags. Import quotes from the dataset. Perform READ operations on the database. easy peasy. The Implementation The problem is that one dataset is in csv format and the other is in json format. We need a common format to import the quotes into the database. I decided to convert the json dataset to csv format. Time to flex my command-line-fu. ...

October 22, 2024 · 3 min · 513 words · Jahangir Alam Rocky

From Membrane to Mechanical: Arduino Nano (CH340x) and Hardwired hell

Still working on it! 🚧

September 17, 2024 · 1 min · 5 words · Jahangir Alam Rocky

Private Obsidian Sync with GitHub for my Linux and Android

Obsidian is a great note-taking app that I use for my personal notes. I have been using it for a while now and I have a lot of notes that I want to keep private. I also want to sync my notes across my Linux and Android devices. First I initialized a git repository in my Obsidian vault folder. And pushed it to a private GitHub repository git@github.com:jahangir1x/obsidian-vault.git A typical obsidian vault has .obsidian folder that contains the configuration and metadata of the vault. I have created a bash script sync.sh that will sync the vault with the GitHub repository. ...

September 17, 2024 · 2 min · 357 words · Jahangir Alam Rocky