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...
Meet Gor
@meetgor.bsky.social
Software developer | Living in the terminal, travelling to databases and the web with CLIs and APIs Blog: https://meetgor.com Newsletter: https://techstructively.substack.com/
Drafting the edition 100 of my newsletter, geez time flies by...
Ah feels fresh to write posts, the good old days The new http Query method www.meetgor.com/posts/http-q...
HTTP QUERY Method
Exploring the new HTTP Query method with first principles, what is the need for new method, and where it sits. We explore the limitations of GET and the unintuitive use of POST methods for filtering
meetgor.com
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
@taggart-tech.com take my money for writing this article, what a banger! taggart-tech.com/reckoning/
I used AI. It worked. I hated it.
I used Claude Code to build a tool I needed. It worked great, but I was miserable. I need to reckon with what it means.
taggart-tech.com
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
What is this job anymore #echo https://waylonwalker.com//ping-46
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...
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.
meetgor.com
well well well! forget the tests! LGTM We know where it comes from🤔
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!
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
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...
meetgor.com
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
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...
Meet Gor | advent-of-sql-2025
Tech blog by Meet Gor
meetgor.com
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...
Advent of SQL 2025: Wish List
meetgor.com
Some thoughts on LLMs and Tom Riddle's Diary. Do you agree, or are you an AI-bro (Malfoy)? www.meetgor.com/thoughts/is-...
Is Tom Riddle's Diary like an LLM? | Meet Gor
meetgor.com
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
Many to Many Relation We saw the basic example of www.meetgor.com/sqlog/sqlite... Relation in the second last post from this, there we just focused on the concept of the relation and not so much on the structure of the junction table. Let's take a look at the schema again:
SQLite SQL: Many to Many Relations | Meet Gor
meetgor.com
Techstructive Weekly edition 60 Learning more SQL, some go and python. Trying to replace doomscroll with reading article and books www.meetgor.com/newsletter/t...
Techstructive Weekly #60 | Meet Gor
meetgor.com
One to One Relations I might missed this basic relationship model as I haven't really found it quite commonly used, but its still used in very specific examples. That one relationship is one-to-one. As the name suggests, it maps one row to exactly one row.
Many to Many Relations We have seen www.meetgor.com/sqlog/sqlite... relationship and also the www.meetgor.com/sqlog/sqlite... relationship. Let's extend it with many-to-many relationship. Here one row can refer to many other rows, but that other row can also be referred by multiple rows.
SQLite SQL: One to Many Relation with Foreign Key | Meet Gor
meetgor.com
Self Join Relations In the last post, we had defined a one-to-many relation between the users table and the posts table. Now, let's create a single table where we can define a one-to-many relationship.
If I could remove something from the history of the internet I would remove AI (chatgpt and all llms) I know it is a profound piece of technology but it will hurt humans in the longer run, brain rot, artless life.
One to Many Relation with Foreign Key Back to the question that we raised in the www.meetgor.com/sqlog/sqlite... post, "What would happen if there are more than one row in the primary table that references the same id in the foreign table?"
SQLite SQL: Foreign KEY table constraint | Meet Gor
meetgor.com
One to Many Relation with Foreign Key Back to the question that we raised in the www.meetgor.com/sqlog/sqlite... post, "What would happen if there are more than one row in the primary table that references the same id in the foreign table?"
SQLite SQL: Foreign KEY table constraint | Meet Gor
meetgor.com
SQLite added generated columns in 3.31 (around Jan 2020) Postgres added generated columns with virtual and as default in v18 (to be released September 2025) There is still a lot to learn in SQL and adoption is still going on, even in the most used databases