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.
The quite power of SQL
The quite power of SQL
Link: https://blog.sturdystatistics.com/posts/sql/
Context
This is true. After all, sometimes, not all new tools are worth using all the time. Sometimes, maybe often times, we need to keep it simple and use the good’ol trusted tools, the simplest ones just like SQL, the dc calculator, how LLMs are using the existing tools to create wide possibilities.
Source: techstructive-weekly-68
Techstructive Weekly 66
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.
Techstructive Weekly #66
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.
Techstructive Weekly #62
Week #62
It was a great week. I didn’t knew I would say that at the start of the week. But hell yes, a promotion, finally. A hope at the end of the tunnel. Hard work pays off in the end. I kept believing and finally able to bring smile on my loved ones.
I quoted last week about home, a family, is not something that is by blood, rather it is the group of people who strive for each others success, for uplifting each other, when one falls down the other roots for him or her, when its harsh time, everyone steps back and stays together. And I was able to experience just that. The true value and meaning of a family and life.
SQLog: Create Table with SELECT
SQLog: Create Table with SELECT
Link: https://www.meetgor.com/sqlog/sqlite-create-table-from-select/
Context
I found it interesting to populate dummy data from existing values. The select statement is so plugable, it just gets into everything.
Source: techstructive-weekly-62
Techstructive Weekly #62
Week #62
It was a great week. I didn’t knew I would say that at the start of the week. But hell yes, a promotion, finally. A hope at the end of the tunnel. Hard work pays off in the end. I kept believing and finally able to bring smile on my loved ones.
SQLite SQL: Create Table with Select
Creating table with Select Query
Sometimes you want to create a new table based on data that already exists,maybe you’re archiving old rows, generating a summary, cloning a table, or transforming data into a new structure. Doing this might require you to write a CREATE TABLE statement with all column definitions, then running one or more INSERT INTO statements to populate it. That’s a lot of work.
Well, SQL is more flexible then you might think, Instead of manually defining columns and inserting data, you write one statement that both builds the table and fills it with the rows returned by your SELECT query. This makes it incredibly useful for backups, and whatever you are doing (hopefully not taking down the prod db).
Techstructive Weekly #61
Week #61
A bit of slow and disappointing week on a personal note. I tried my best to be a backend developer but was not worthy of being one, I was stranded as a product developer. I am not saying I hate being a product developer, it just gets too menial and boring once you know the limitations and the quirks of a product.
Apart from the grill, I learnt a lot about tokenization. I also continued to write occasionally about SQLite in the SQLog, three more entries. Wasn’t able to livestream due to guests and was unwell for the weekend with cold.
SQLite SQL: Collate Column Modifier
SQLite SQL: Collate Column Modifier
Link: https://www.meetgor.com/sqlog/sqlite-collate-column-modifier
Context
Source: techstructive-weekly-61