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

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

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

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

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

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:

meetgor.com

SQLite SQL: Many to Many Relations | Meet Gor

100

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

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

meetgor.com

Techstructive Weekly #60 | Meet Gor

000

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

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.

100

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

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.

meetgor.com

SQLite SQL: One to Many Relation with Foreign Key | Meet Gor

100

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

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.

100

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

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.

000

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

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

meetgor.com

SQLite SQL: Foreign KEY table constraint | Meet Gor

100

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

meetgor.com

SQLite SQL: Foreign KEY table constraint | Meet Gor

100

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

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

000

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

Foreign KEY Table constraint Foreign Keys are the fundamentals of any relational databases, as they are the ones that make the connection or the relations among the tables in our database system.

100

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

The PRIMARY KEY constraint is not actually a column constraint, it is a table constraint. In the previous section we learnt about how to handle single column-level PRIMARY KEY. In this section we'll understand how to use PRIMARY KEY as table constraint,

110

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

The PRIMARY KEY column constraint The PRIMARY KEY constraint is not actually a column constraint, it is a table constraint. But in this section, we'll only learn about how to handle single column-level PRIMARY KEY.

100

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

The CHECK column constraint sqlite.org/lang_createt... This is a column constraint that allows us to define certain conditions that we want to evaluate before inserting the column for the row and populate it accordingly. In this post, we will check, what and when used.

sqlite.org

CREATE TABLE

create-table-stmt: hide

100

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

We saw certain limitations of the DEFAULT column constraint clause, that it can't generate dynamic values based on other columns or some other dynamic population. For overcomming those kind of constraints, there is one more specific constraint, the GENERATED sqlite.org/gencol.html column constraint.

sqlite.org

Generated Columns

100

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

DEFAULT Constraint The DEFAULT constraint in SQLite is used to specify a default value for a column, if not provided, then the column will be populated with the NULL value as the default value. According to the docs:

100

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

Unique Constraint The UNIQUE constraint ensures that a column in a table contains no duplicate values. Like, if you add an UNIQUE constraint to a column, then no two rows can have the exact/same value for that column. The documentation is more nuanced.

100

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

The NOT NULL constraint is a column-level constraint that will prevent the insertion/updation of a NULL value in that column record. What is NULL? In SQLite, specifically, a NULL is a value indicating that a value is not known or just not there.

100

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

Create Table with column constraints We have seen the table creation with column types, we now need to look into the constraints or limitations that we can add to those columns, in order to make the data-model more robust and add some basic validations before doing any updation

100

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

If you want to store values in a column with a specific type, you need to specify one of the following types in order to store that value in relatively type specific data.

100

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

What if you only wanted one column. If you create specify a column name in create table, then there will be actually 2 columns created, one that you specified and the other which is hidden as rowid, unless you mentioned rowid as the column.

100

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

We have explored enough sqlite dot commands, now I want to explore the actual nuts and bolts of SQL in SQLite, what better place then to create tables. The CREATE TABLE as the name suggest will create a table in a sqlite database. What is a table? > set of relations

100

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

The .headers command is crucial as might effect the way the result set is displayed. The first row would be set to the name of the columns in the output of the relevant commands like .output, .once, or even your simple standard out queries if it is set on .headers on .header on

100

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

If you wanted to use a specific separator for columns and rows while displaying the result set / table, you can use the .separator dot command which can take 2 arguments, first as the separator for the column and the second for the row.

100

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

The SQLite shell is a great way to test out and run bunch of queries, but the output might be squished or cluttered. You might need to view the output in a specific way, and the creators of SQLite were already hearing your screams.

100

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

If you are in a sqlite shell and forgot to change directory or want to navigate to a separate directory, you can do that with the .cd dot command. .cd /path/to/directory This is better than doing .shell cd /path/to/directory because it doesn't open a separate terminal process

100

Meet Gor @meetgor.bsky.social · 30/08/2025

Shell dot command If you are in middle of a sqlite shell session, and you don't want to quit the shell to run arbitrary shell command, you can simply use the .shell <command> to execute any shell commands right from within the sqlite shell. How handy is this!

100

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

I just added SQL Code blocks that can run and show the output like an interactive playground using wasm and js libraries This makes anyone write and play with sql examples in my blogs www.meetgor.com/logsql/sqlit...

meetgor.com

Meet Gor | SQLite: Randomly order rows

010

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

Yesterday, while exploring the .read command I discovered a little hack. We know you can read arbitrary sqlite shell commands from the .read | operator, even the dot commands. So, you can even use .read itself again.That means we can call the same file to read inside the script

100

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

The .read dot command is a quick handy command to import and run your SQL queries in the current session. You can just pass a SQL file (usually a query ending with ; it will execute each query one by one) .read filename

100