Learning SQLite: Advent of SQL Day 1

I am trying to learn SQLite, I want to understand that database. It’s quite simple yet the whole world uses it for various kinds of things ranging from developers’ toy database to spaceships. What a tiny engineering marvel!

I am happy to see this happening: Advent of SQL

What a better time to learn more. I guess I want to start by exploring all the specificities of the INSERT statement in SQLite after exploring most of the things of the CREATE TABLE statement.

I was reading Harry Potter, the chambers of secret, the book for the first time and I came across this quote.

“Never trust anything that can think for itself if you can’t see where it keeps its brain”

– Mr. Arthur Weasley, Harry Potter and the Chambers of secret (Chapter 18)

The quote just rang the bells in me against LLM. Doesn’t it hit? Why do I feel guilty like Ginny who had been writing to the dark lord.

Week #72

A good productive week (I am not sure, I am saying that in the last month of 2025). I would be writing a yearly review in a couple of weeks and this week might lift my spirits up. I was fresh, given time off from work, not really, but given the time to experiment.

I read a lot, fiction, technical, even philosophical, and random Hacker News articles. I read 2 books of Harry Potter. I haven’t read Harry Potter, I have watched the first 3 movies, but not books. I enjoyed it, it was subtly different from movies, I missed the quote “What an Idiot” from the movies, it was not in the book, i was disappointed but the atmospheric adventures was amazing read.

We have seen how to create TABLE loosely Not adhering to the types. Because if we create a table with column name of type text, and insert a integer, it will happily store it as text. It is very flexible as we saw. So, in such CREATE TABLE statement in SQLite, without the STRICT constraint, the types don’t matter.

If you created a table with column type as XYZ it will accept it, because it really doesn’t see that. It will see the data coming in from the insert statement and store it whatever it thinks is the best one for that piece of data. Look at the below example:

Week #71

It was a roller-coaster week. Half of the week, it was travelling and outside. The rest was coping with AI news and code agents. Getting back to work after a week is a bit stressful and brings a bit of hurdle of health. I wasn’t quite well for a couple of days after the trip, and couldn’t really work at my 100% best. So, this weekend I would be pacing up, slowing down when needed to rest with ease. I have a few plans for Advent of Code, I haven’ gotten the time to solve even the first problem, looking forward to the weekend to keeping up with it.

Week #70

As I wrote last week, I would be travelling and out on a break due to weddings at my contry side place, cousins wedding, som heavy travelling no tech access for most of the time. However I had atleast 4 days of work covered so I have few tidbits to share. Weekends, three days of the week and taking leave on evening on wednesday.

I played around with vllms , new different models for different thins ranging from ad hock coding tasks, proper code editing, and document extraction usecases. Didn’t find time to read or watch much.

Week #69

It was a good week. That’s what I can say. I continued writing. I experimented with quite a lot of things. VLLMs, new models, new approaches, tactics, and read a lot of articles as usual.

As I was in the GCP Cloud Log Explorer TUI in the bubbletea golang app, I vibe-coded it, I wanted to feel it. No, I am not using that to publish on GitHub. I would make one from bare hands, what to put in the model, on the screen, when to update what, which keybindings to add where, I will think about each of them and code from scratch. My goal is to learn and build, not just build.

Week #68

It was a great week. A consistent clean week. I wrote around 9k words on my project. I feel good again. I didn’t do much on the weekends as usual. I am slowing down. I did a lot of things at work, experiments, and more experiments on VLLMs and parsing documents. It’s fun times. I think for this weekend, I have plans as this post will cover what my mind is fixated on for the moment, Golang and TUIs, and a pain that is daily buzzing me, cleaning log files to get the actual data. LLMs are good at it, but take a bit of time for such trivial things.

Week #67

It was a slow and steady week. New habits are emerging. It was a pleasant experience, I felt good, I kept myself out of the social media and content spiral doom-scrolling. Why? Because something changed the perspective of action and effect, the piece I was missing was intention.

Action, Intention, and Effect

I heard or read somewhere, that we feel anxious or we waste our time, not because of motivation, rather due to the lack of intentionality of the actions. If you are going to the web with a clear focus and a objective, no force or urge can stop you. Motivation helps but doesn’t carry you all the way. Its not one emotion or quality thing, rather all-hands together approach. You solely can’t rely on focus either, you need your inner fire, you need purpose, you need energy, you need the skills to do it. Nothing comes on its own with a single cause-effect, its a multi-dimensional world of action and effect.

Week #66

It was a silent week, chipping away the days like wasted days. I didn’t do much, honestly, it was tiring and draining. I spent the weekend outside, had a few chores to complete, and didn’t quite get the time to sit at peace. This weekend too, looks the same. Post Diwali rituals, guests, and functions.

I have long left the SQLog to decay, but I intend to pick it back up from tomorrow. Lot of things to do, little mental energy left.