no, editing is
no, editing is
I am looking forward to connecting to anyone who is looking for an enthusiastic person and nerd about things in detail
I have worked with golang extensively in the past 3 years be it side projects or open source projects.
I love building and tinkering with apis, databases and clis in the terminal.
Learning to adopt the new techniques to develop faster and effective software.
At solar labs
I worked deeply in backend system for
- developing time of use and analytical apis and dashboards
- optimized database queries by 7% by the heavy loaded endpoints
- developed automation scripts and excel reports on the platform for user facing dashboards
Previously I have worked at
- Docsumo
Improved financial document extraction using llms by 27%(numbers not important to me, the care and the dedication is)
Created apis and services for financial analysis on the platform
Lead the reasearch and development for fraud and categorisation services
Life is cruel,
you do everything right, yet you are set barefoot in the forest for 14 years
A bunch of .md files making scifi a reality, what a time to be alive.
AI labs ceo predicting the number of months away from the developer free world is like a developer giving an estimate for his task.
"It will be done in 2 week, probably" maybe*
Cursor doesn't count the non-interactive actions while working inside the agent. Wow! What a shame. Vibe coded perhaps.
I don't manually accept diffs, they're already there, so i just read as it hives the green red background more info if i accept it i forget.
Sigh!
Oh my god!
I just finished writing a novel (draft 0)
Here goes the 2025 year into the past
A quite revolutionary year for software development, it just changed the way I thought about software.
It leaves us with a gazillion things to learn
#2025wrap
meetgor.com/2025-review
- Rohinton Mistry
I wanted diwali vibes indian stories, thought not quite i wanted, but the mood, the nostalgia and the emotion was all I needed. The book had put me in questions that no one ever can. The perspective of a family is not confided in four walls but four relations
- Toshikazu Kawaguchi
The sweet tales of time travelling cafe are so wonderful and almost gives a cope(escapism) from the world yet puts you on the path to still walk for your people. Such a beautiful blend of reality and fiction. I can't believe I read 5 books in a series
Some authors have stood out to me these year that I would be forever grateful for
- Ami Ganatra
Ramayana, Mahabharata, she bought facts, relatable views and modern day links to the tale, all 3 books are like gateway drug to indian mythology. I now need to read the actual legends
Wow!
I read 6 books in 2024
and in 2025?
23
Couldn't have been a better year.
I have thoughts on why I read like a monster!
I want to sit and write about each book, i have notes and couldn't put more words for the feelings these authors have written
Really a huge shoutout to @aaronfrancis.com for teaching it enthusiastically, its contagious! Can't wait to add more to my sqlog series, diving deeper into SQLite.
The lore in the problems was epic! I am inspired to create something like that!
And many naunced things that I think are quite lame to share it.
But anyways, I loved these problems, the soptify wrapped like artists problem was sooooo good.
I actually felt I understood and solved something really cool, something real!
The missing dates, so many cool problems!
8. Calculating rolling averages with sliding window using window functions
9. Full text search in SQLite
10. Counting the number of occurrences of a word in a string
11. Recursive CTEs to traverse a network like path
4. Window Functions (like groups but more customizable)
5. Generating series of dates in SQLite using recursive CTE
6. Using json functions to extract list and key-value pairs from json string
7. CTEs in SQLite cannot have DELETE or INSERT queries (sigh! ruined day 10 solution)
What all did I learn?
1. JOINs (the crucial difference in lift, right and inner join)
2.CTE and Subquery (those are the same things, CTEs help you to reuse and name it as sub-query)
3. UNION and UNION ALL (why even have union all hhh?)
I completed a advent challenge for the first time (it was just 15 days, I feel happy and sad about that)
But I am mostly happy and content with the things I learnt and got to do in SQL.
I know can confidently say, I know the bare minimum SQL!
Wrapped the Advent of SQL 2025 in SQLite
Thanks @aaronfrancis.com for the dope quality teaching and explanaitons and @Kelsey Petrich for the lovely lore behind each puzzle.
I blogged about it for all 15 days
www.meetgor.com/series/adven...
Solving the advent of sql by Aaron Francis' database school (but it sqlite)
Nice world building around elves. Looking forward to getting annoyed with how dumb or smarter dumb the elves get in the remaining 14 days.
www.meetgor.com/sqlog/advent...
Some thoughts on LLMs and Tom Riddle's Diary.
Do you agree, or are you an AI-bro (Malfoy)?
www.meetgor.com/thoughts/is-...
Better than doom scrolling I guess
Streamed regularly in the first half of 2025, then somehow lost the consistency in the 2nd half. Looking forward to coming back on stream in december.
It feels good to develop something useful with AI, i don't know how it works, but I know what I want to make.
Pretty good. It takes some iterations, some conscious reading and knowing the actual problems to solve.
Maybe AI coding is a skill, it gets better over time
Day 32:
Many to Many Relation Table (Junction Table) without Row id
bsky.app/profile/meet...
Read more here for interactive SQL codeblocks and playground like environment:
www.meetgor.com/sqlog/sqlite...
Only in the case of author_post or junction table, where the primary key is used as a combination of other two foreign keys, we don't need the rowid as the junction table doesn't have any unique data in it, it is just the mapping of two existing data records in the other two tables in the database