Link: https://www.meetgor.com/sqlog/advent-of-sql-2025-day-11
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
I was recently recommended a YouTube video with the following title: <pre style=" display: block; font-family: monospace; font-size: 4px; l...
Link: https://armeet.bearblog.dev/becoming-the-machine/
This is well put. I kind of hate this argument. Why are we comparing ourselves to machines in the first place? We can grind, but with thinking what actually we are doing. Because I equate grind to consistency, it sometimes feels like grind, and we need to overcome that emotion of letting it overtake us. But most of the days, the grind is a joy, we do it because we feel like doing it.
What you need to know about local model tooling and the steps for setting one up yourself
Link: https://www.aiforswes.com/p/you-dont-need-to-spend-100mo-on-claude
Ok, the VRAM and RAM is somethign is quite critical. If you have less RAM and much VRAM, its no use, you need to have sufficient RAM in order to run a good enough model, VRAM wouldn’t handle it.
Source: techstructive-weekly-74
What was the road like when I left?
Link: https://zhach.news/how-i-left-youtube/
Man that was a good read! I resonated with this a lot This duality is exhausting. It forces you to lie by omission to people you respect. You can’t tell your team, “I can’t take that ticket because I need to study dynamic programming.” You just have to work faster. I respect people above and behind me, but I too needed to move in life, support the things I was responsible for, get out of the grave situation I was pushed into. For that, I took some decisions, which I tried for, but nothing came off it, I wasn’t quite sure about the switch and left it when the offer came. Stranded here. I am feeling good here, but if I am not in another company by the end of 2026, something is wrong with me. Let’s see! Good lessons Don’t say: “I tweaked the YouTube watch-time algorithm using X variable. ” Do say: “I optimized a high-throughput distributed system to prioritize user retention metrics, reducing latency by 150ms through a custom caching layer.” Man!! My final conversation with my manager was heart-wrenching. I had prepared a script, anticipating a counter-offer or a guilt trip. Instead, I was met with soft and understanding empathy. Yep The interview fatigue is real, and the conversations are hard, but the clarity you gain on your own value is worth the struggle. Got to go through it once and then there would be no stop for growth. Grass looks green on the other side always! Damm
Constrained decoding seems like the greatest thing since sliced bread, but it often forces models to prioritize output conformance over output quality.
Link: https://boundaryml.com/blog/structured-outputs-create-false-confidence
Spicy take and true! Somewhat true If your task is complex to get things out from image, or understand the context, it might hinder the quality. But if your task is to simply do something straightforward tool calls, structured output beats everything.
Source: techstructive-weekly-74
Link: https://www.da.vidbuchanan.co.uk/blog/annoying-text-editors.html
Ok! I agree and disagree. You need to have a zen mode in your editor, which just is bare bones, and one for full fledged stuff like LSP, AI-auto-complete, syntax highlighting and what not. Editor is just a tool, it can’t code on its own(in 2025, still needs prompting), similarly to use it, it needs preferences.
Source: techstructive-weekly-74
Link: https://youtu.be/Jlqzy02k6B8
Ahh! How many people will say this, but yet we can’t follow it Everything boils down to the fundamentals, having the basic thing to understand when something goes wrong. Rather we make it complex in order to be percieved as smart and even oversmart.
Source: techstructive-weekly-74
Vibe coding gets the job done, but there's no thrill in the build.
Link: https://cassidoo.co/post/vibe-coding-yawn/
It is pathetic, really. Watching it clog some code and done. Sigh what is left out then, to read code? Who loves it. Vibe coding is cool and good if you just want the product in your hands, but if you care about the craft then please write it.
Source: techstructive-weekly-74
Link: https://youtu.be/1JHOY0zqNBY
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.
As someone who has used a static site generator every day at work for years I am on the threshold of believing “actually just writing HTML by hand is probably easier” This becomes obvious when you …
Wow! We are moving at a pace where generating html from LLM is getting easier (not cheaper yet!) than generating it by code, whew! What a time to be in.
Source: techstructive-weekly-74