Week #78
Some weeks are no for hoarding knowledge, I realize this after writing this edition. And this week is that one, the one that you need to put breaks and not reflect that’s done, but see the road ahead, not how far we have come, but where to go next. What to do next, why build something, why spent 2 years on something. Question, think, understand and let it settle. Everyone is doing that. Some aren’t privileged as I am, I am grateful for that.
Database Internals:Chapter 1
Database Internals:Chapter 1
Link: https://www.youtube.com/live/HibHalGlIes
Context
The difference of the OLAP and OLTP database is so nice. Also the differnce of column based vs row based database type is clear from this. Makes sense and intuitive as well The Binary tree also makes sense.
Source: techstructive-weekly-76
Techstructive Weekly #76
Week #76
It was a good start to the year, finally doing something that I had struggled to do for the past year or so. AI Assisted Programming. Yeah! That was something I finally somewhat understand, and can do it without feeling a slightest of grudge or emotional drama. It took a while to realize it, but here we are. 2026!
Techstructive Weekly #75
Week #75
Oh the middle of end of 2025, and the beginning of 2026. This is a wired post. I let myself back, reflected more. I know it was a fast paced year for software development. People are here to prove it. I just laid it out straight that its never been valuable to be a human, a distinct, natural and earnest human.
Techstructive Weekly #74
Week #74
It was winding down week, 2025, ending slowly, the biggest irony. The year was full of fast-paced, unprecedented models just dropping here and there. It was hard to keep up with the progress. It was getting overwhelming, no one is used to such a level of information. I was dreading with so much power in our hands. I couldn’t handle it and refrained it and thought it was better to focus on learning new things. I kept using AI tools at work, not by choice, but initially through force but then through necessity.
Day 11: Behavior Score
Day 11: Behavior Score
Link: https://www.meetgor.com/sqlog/advent-of-sql-2025-day-11
Context
Advent of SQL 2025 in SQLite Day 10: Misdelivered Presents Day 9: Evergreen Market Orders Day 8: Product Catalog Day 7: Polar Express Mixin Day 6: Days of Delight Day 5: EchoTrack Wrapped
Source: techstructive-weekly-74
Techstructive Weekly #74
Week #74
It was winding down week, 2025, ending slowly, the biggest irony. The year was full of fast-paced, unprecedented models just dropping here and there. It was hard to keep up with the progress. It was getting overwhelming, no one is used to such a level of information. I was dreading with so much power in our hands. I couldn’t handle it and refrained it and thought it was better to focus on learning new things. I kept using AI tools at work, not by choice, but initially through force but then through necessity.
Will Turso be the better SQLite? Interview with Glauber Costa
Will Turso be the better SQLite? Interview with Glauber Costa
Link: https://youtu.be/1JHOY0zqNBY
Context
This was a great interview. I love the mentality. If software built with community in the Linux community can sustain after almost 3 decades, then why can’t a embedded database like SQLite can? Turso is Linux Community but for SQLite (minus the toxic leadership) Pekka is a great, humble and smart leader to be leading the Turso, SQLite rewrite in Rust. I want to contribute to SQLite, but it feels I don’t know enough everytime I touch it, also I started learning SQL for this. I have gone so far and now there is no way I am turning back. I had one itch for geospatial exploration in SQLite for Mumbai city. This weekend might be the time to do it, maybe next year.
Techstructive Weekly #73
Week 73
A pretty slow and sluggish week, but some momentum carried in the end. There was a disappointment after a glimmer of excitement when gemini 3 Flash dropped for the experiments that I was running for extraction of documents. It was maybe just the timing, but after this seeing code execution from chats, it was amazing. A good end to the work week.
Techstructive Weekly #73
Week 73
A pretty slow and sluggish week, but some momentum carried in the end. There was a disappointment after a glimmer of excitement when gemini 3 Flash dropped for the experiments that I was running for extraction of documents. It was maybe just the timing, but after this seeing code execution from chats, it was amazing. A good end to the work week.
I have continued to write Advent of SQL for the past 4 days, and brought back the streak of writing SQLog. I was not able to ship some code over the past weekend. But this weekend, I am pumped. I have time sorted out. Would be shipping some improvements in the website. Oh! I actually added snowball and particles based on season on my website (only index and post pages).