iiinova — where your digital self keeps evolving

Meet Gor @meetgor.bsky.social · 27/06/2026

Its here, the 100th edition of my newsletter. Its just a number now, nothing special but feels good. Hand chiseled craft, No AI. But I talk a hell lot about it. techstructively.substack.com/techstructiv...

100

Meet Gor @meetgor.bsky.social · 26/06/2026

Drafting the edition 100 of my newsletter, geez time flies by...

000

Meet Gor @meetgor.bsky.social · 08/04/2026

Ok I am dumb. It makes the language simple. but it does leave a hole..a long hour of finding the error was capital name of the function

010

Meet Gor @meetgor.bsky.social · 08/04/2026

Oh so Go took inspiration from C# for public and private class variables (package level) for convention of PascalCase but skipped the type naming as private or public. Really easy to mess up that... cannot rely on just people's eyes for figuring out based on case. Or I am dumb

110

Meet Gor @meetgor.bsky.social · 03/04/2026

I think we are a few months away from people realizing, oh shit this is crap code! We need some people who can understand this? What are those called? oh the people that get paid for editing text on the screen! I thought they were dead

110

Meet Gor @meetgor.bsky.social · 02/04/2026

Was a bit curious, a bit overwhelmed. Sat down, made and then wrote about it(8k words by the way, new ath, no ai was harmed in the process) What do you think? www.meetgor.com/posts/flight...

meetgor.com

Flight Observatory Mumbai Airspace Case Study

A closer analysis on the airspace around Mumbai's BOM/VABB (CSMIA) Airport. Questioning the intuitions from memories and answering and reasoning through the data.

010

Meet Gor @meetgor.bsky.social · 02/04/2026

probably sifting the good and truthful data was not quite done from the internet from which it was trained on we see a lot of code and discussion with bug that point factually wrong but have text and conversation that say it was correct (assumptions)

000

Meet Gor @meetgor.bsky.social · 20/03/2026

well well well! forget the tests! LGTM We know where it comes from🤔

Screenshot showing an LLM agent (amp) unable to run tests in a golang repo, and saying "forget tests, the logic is sound.". Typical developer like vibe in coding agents

121

Meet Gor @meetgor.bsky.social · 04/03/2026

I am looking forward to connecting to anyone who is looking for an enthusiastic person and nerd about things in detail

000

Meet Gor @meetgor.bsky.social · 04/03/2026

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.

110

Meet Gor @meetgor.bsky.social · 04/03/2026

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

110

Meet Gor @meetgor.bsky.social · 04/03/2026

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

100

Meet Gor @meetgor.bsky.social · 04/03/2026

Life is cruel, you do everything right, yet you are set barefoot in the forest for 14 years

000

Meet Gor @meetgor.bsky.social · 01/02/2026

A bunch of .md files making scifi a reality, what a time to be alive.

000

Meet Gor @meetgor.bsky.social · 21/01/2026

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*

000

Meet Gor @meetgor.bsky.social · 15/01/2026

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!

000

Meet Gor @meetgor.bsky.social · 01/01/2026

Oh my god! I just finished writing a novel (draft 0)

010

Meet Gor @meetgor.bsky.social · 31/12/2025

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

meetgor.com

2025: Year Review

A developer retrospective of the year 2025. A reflection of the goals that I worked towards in tech as a developer. Adopted AI-assisted coding skill as a devloper, wrote 52 editions consistently on my...

020

Meet Gor @meetgor.bsky.social · 29/12/2025

- 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

000

Meet Gor @meetgor.bsky.social · 29/12/2025

- 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

100

Meet Gor @meetgor.bsky.social · 29/12/2025

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

100

Meet Gor @meetgor.bsky.social · 29/12/2025

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

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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!

000

Meet Gor @meetgor.bsky.social · 28/12/2025

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!

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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)

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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?)

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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!

100

Meet Gor @meetgor.bsky.social · 28/12/2025

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...

meetgor.com

Meet Gor | advent-of-sql-2025

Tech blog by Meet Gor

100

Meet Gor @meetgor.bsky.social · 16/12/2025

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...

meetgor.com

Advent of SQL 2025: Wish List

000

Meet Gor @meetgor.bsky.social · 13/12/2025

Some thoughts on LLMs and Tom Riddle's Diary. Do you agree, or are you an AI-bro (Malfoy)? www.meetgor.com/thoughts/is-...

meetgor.com

Is Tom Riddle's Diary like an LLM? | Meet Gor

000

Meet Gor @meetgor.bsky.social · 03/12/2025

Better than doom scrolling I guess

000

Meet Gor @meetgor.bsky.social · 02/12/2025

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.

000

Meet Gor @meetgor.bsky.social · 09/10/2025

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

000

Meet Gor @meetgor.bsky.social · 20/09/2025

Day 32: Many to Many Relation Table (Junction Table) without Row id bsky.app/profile/meet...

000

Meet Gor @meetgor.bsky.social · 20/09/2025

Read more here for interactive SQL codeblocks and playground like environment: www.meetgor.com/sqlog/sqlite...

meetgor.com

SQLite SQL: Many to Many Table without RowID | Meet Gor

000

Meet Gor @meetgor.bsky.social · 20/09/2025

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

100

Meet Gor @meetgor.bsky.social · 20/09/2025

Both the tables users and posts will have rowid referenced or aliased as id of their respective columns as we know because of the special case of INTEGER PRIMARY KEY SELECT rowid, _rowid_, * FROM users; SELECT rowid, _rowid_, * FROM posts;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

This would return error as the rowid doesn't exists. We will still need the rowid in posts and users table as those are the PRIMARY KEY columns.

100

Meet Gor @meetgor.bsky.social · 20/09/2025

The rest of the commands from inserts to selection and all of the things we saw above will remain the same. However, when you query the author_post table, the rowid will not be returned as it doesn't exists. SELECT * FROM author_post; SELECT rowid, * FROM author_post;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

CREATE TABLE author_post (user_id INTEGER NOT NULL,post_id INTEGER NOT NULL, PRIMARY KEY (user_id, post_id), FOREIGN KEY (user_id) REFERENCES users (id),FOREIGN KEY (post_id) REFERENCES posts (id) ) WITHOUT ROWID;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

Hence, we can avoid creating the rowid using the WITHOUT ROWID parameter or option while creating the table. DROP TABLE author_post;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

The answer is very naive and subtle, but might impact the database querying if the author_post has millions and billions of rows. The rowid space will be wasted for no reason.

100

Meet Gor @meetgor.bsky.social · 20/09/2025

This table author_post has primary key identified from the combination of the user_id and post_id column. However, storing rowid makes no sense, as it is just redundant, right? Why would you not want to have the rowid?

100

Meet Gor @meetgor.bsky.social · 20/09/2025

This has 5 posts, two written by Pekka, two written by Glauber, and one co-authored by both Pekka and Glauber. The interesting part here is this rowid SELECT rowid, * FROM author_post;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

This has now populated the following tables: SELECT p. id, p.content AS post, GROUP_CONCAT(u. name, ', ') AS authors FROM posts p JOIN author_post up ON p. id = up. post_id JOIN users u ON u. id = up.user_id GROUP BY p. id;

100

Meet Gor @meetgor.bsky.social · 20/09/2025

-- adding a post co-authored by pekka and glauber INSERT INTO posts(title, content) VALUES('Limbo', 'SQLite in Rust'); INSERT INTO author_post(user_id, post_id) VALUES (3, 5); INSERT INTO author_post(user_id, post_id) VALUES (1, 5);

100