tips

Conversation maker

Had this idea for my next get‑together — a simple prompt that could spark some fun stories.

Tell the story of something you have on you right now.

It sounded random at first, but the more I thought about it, the more I liked it.
Everyone’s carrying a story — in their pocket, on their wrist, in their wallet.

  • A keychain from a trip.
  • A bracelet from someone special.
  • A receipt for a plan that never happened.

No prep needed. Just real moments hiding in plain sight.

Overheard : Worthless friends vs Transactional friends

Codie Sanchez quoting Prof. Arthur Brooks on different types of friendship in a conversation with Shane Parrish.

Worthless friends are the friends that have no transactional value. You don’t want anything from them. They don’t want anything from you. They want to hang out with you. They want to go on a walk with you. They don’t want your email list. They don’t want access to your money. They just want to have a beer on a Friday night. And these friendships end up materially increasing, our happiness, these worthless friends, whereas these transactional friendships actually end up, in many ways, decreasing our happiness

Overheard : Leadership

Leadership isn’t about being the hero. It’s about empowering your team to become heroes themselves.

Google Gemini

For folks that are driven, wired to see an issue and tackle it head-on, it is difficult to not jump in and “try” to help your team whenever they run into an issue. But the reality is that most folks are capable, creative individuals. They just need the space to flex their own problem-solving muscles.

If you team has the skills and experience, let them handle it :-).

HOWTO : Bulk deletes in vi

Use “dG” command, if you want to delete all lines in a file starting from the line under the cursor in vi.

Additional commands to delete lines

  1. dd deletes the whole line under the cursor.
  2. xdd deletes multiple (x) lines, starting at the cursor. For example 10dd deletes 10 lines
  3. d$ deletes to the end of the line, starting at the cursor.

HOW TO : Create free clipart

One can leverage the explosion of generative AI art engines to create your own clip art.

  • Create an image in MidJourney (you can get free credits to create up to 200 images)
    • You can add “clipart” to any image description to get good results
  • Use Removebg to remove any background from the image. (500×500 pixel png images are free)
  • enjoy 🙂

Here’s a clipart that I created using the prompt “moscow mule drink illustration, clipart”

HOWTO : Query json data in SQLite

A self note for querying json data in SQLite. BTW, I think SQLite is an under utilized and under appreciated swiss army tool for data storage and manipulation. And thanks to Richard Hipp, it is free.

If you have a column defined as a json type in your SQLite database, quickest way to search for the data is json_extract. A full set of functions available are documented at https://www.sqlite.org/json1.html

If you have a column named family_details in a table family with the following json in it as an example

{
	"father": {
		"name": "dad",
		"birthday": "1/1/2000",
		"pet_name": "daddy"
	},
	"mother": {
		"name": "mom",
		"birthday": "1/1/2001",
		"pet_name": "mommy"
	},
	"sons": [
		{
			"name": "son_one",
			"birthday": "1/2/2020",
			"pet_name": "sonny_one"
		},
		{
			"name": "son_two",
			"birthday": "1/2/2021",
			"pet_name": "sonny_two"
		}
	],
	"daughters": [
		{
			"name": "princess_one",
			"birthday": "1/2/2020",
			"pet_name": "princy_one"
		},
		{
			"name": "princess_two",
			"birthday": "1/2/2021",
			"pet_name": "princy_two"
		}
	]
}

and you want to print the name of the father, you can use

select json_extract(family_details, '$.father.name') as father_name
from family

json_extract uses the name of the column and the json node as parameters. In this case, we used $(which denotes the root), father and name (under father) as the json node.