breakpo

Working together with Chery Commercial Vehicles in Wuhu, China together with Make My Day

2026-07-28T04:15:56.715-04:00

Driving the Future of Electric Fleets: Make My Day Partnering with Chery Commercial Vehicles

As commercial fleets around the world transition toward electrification, the challenge is no longer just about deploying electric vehicles; it is about managing them efficiently at scale.

Nisan Katz and I recently returned from a productive visit to Wuhu, China, where we met directly with our counterparts at Chery Commercial Vehicle.

Chery Commercial Vehicle is a global powerhouse in the automotive space, and working alongside their engineering and strategy teams confirmed a shared vision: the next phase of commercial fleet electrification depends heavily on intelligent software integrations.

During our strategic discussions in Wuhu, we focused on aligning Make My Day’s smart EV fleet management and route optimization algorithms directly into Chery’s growing commercial ecosystem.

Why This Collaboration Matters

Transitioning commercial fleets to EVs introduces operational variables that traditional telematics or internal combustion engine tools were never built to handle:

Dynamic Range and Route Optimization: Factoring in real time battery State of Charge (SoC), cargo payload changes, and route topography to prevent range anxiety without wasting driver time.
Smart Charging Strategy: Balancing vehicle turnarounds with depot constraints and dynamic energy grid tariffs to avoid peak load surcharges.
Ecosystem Integration: Embedding algorithmic optimization directly into the vehicle architecture and fleet operator platforms to provide frictionless control.

By bringing Make My Day’s algorithmic optimization into Chery’s commercial vehicle software ecosystem, we are creating a seamless experience for fleet managers and enterprise operators globally. This collaboration ensures that fleets do not just go electric they operate with maximum efficiency, lower total cost of ownership (TCO), and zero downtime.

Looking Ahead

Our trip to Wuhu is an exciting milestone as we continue expanding our footprint globally and scaling our solutions across international markets.

We are thrilled about the roadmap ahead with Chery Commercial Vehicle and look forward to sharing more updates as our joint efforts roll out.

LinkedIn post, please like and share: https://www.linkedin.com/feed/update/urn:li:activity:7487531872902676480

New: How to connect to mysql database from go - correct way

2026-03-28T10:49:00.000-04:00

The `dbconnect.go` Architecture

In Go, sql.Open doesn't actually connect to the database—it initializes a Pool. This pool is a manager that sits between your code and the database, handing out "check-out" tickets for connections.

1. The Connection (The "Dial")

The DSN string defines the network path. By adding parameters like timeout=30s, you tell the driver how long to wait for the initial handshake before giving up.

2. The Pooling (The "Manager")

By setting SetMaxOpenConns, you create a hard ceiling. If you set it to 10, Go will never attempt an 11th connection. Instead, it makes the next request wait in a queue. SetConnMaxLifetime ensures that old, "stale" connections are killed off before the server (DreamHost) forcibly drops them.

3. The Context (The "Stopwatch")

Using context.WithTimeout is how you control that queue. Without a context, a query might wait forever for a free connection. With a context, you say: "I am willing to wait 5 seconds for a connection; if one doesn't become free by then, cancel the request."

The dbconnect.go file that actually runs the connection:

package dbconnect

import (
    "context"
    "database/sql"
    "log/slog"
    "time"
    "understandmydreams/i18n"

    _ "github.com/go-sql-driver/mysql" // Register the driver
)

var oneConnection *sql.DB

// stats := db.Stats()
// fmt.Printf("Open Connections: %d\n", stats.OpenConnections)
// fmt.Printf("In Use: %d\n", stats.InUse)
// fmt.Printf("Idle: %d\n", stats.Idle)
// fmt.Printf("Wait Count: %d\n", stats.WaitCount) // High number here means your app is slow/blocked

func GetConnection(whereFrom string) (*sql.DB, error) {
    slog.Info("GetConnection: " + whereFrom)
    if oneConnection == nil {
        var err error
        oneConnection, err = createConnection()
        if err != nil {
            return nil, err
        }
    }

    // implement ping
    // err := db.PingContext(ctx)
    // if err != nil {
    //  slog.Error("Database is unreachable", "err", err)
    //  // This is where you'd trigger a retry or shut down
    // }

    return oneConnection, nil
}

// create a real connection to the database
func createConnection() (*sql.DB, error) {
    var err error
 
    // ConnectionString:      fmt.Sprintf("user:password@tcp(host:3306)/database?charset=utf8mb3&timeout=%ds&readTimeout=%ds&writeTimeout=%ds", MaxExecutionTime, MaxExecutionTime, MaxExecutionTime),    
    db, err := sql.Open("mysql", i18n.I18N.ConnectionString)
    if err != nil {
        slog.Error("20241212.01314 createConnection", "err", err)
        return nil, err
    }

    db.SetMaxOpenConns(50)                   // Set max open connections
    db.SetMaxIdleConns(10)                   // Set max idle connections
    db.SetConnMaxLifetime(time.Second * 120) // Set the max lifetime of a connection

    // Create a 5-second deadline for this specific operation
    ctx, cancel := context.WithTimeout(context.Background(), time.Duration(i18n.MaxExecutionTime)*time.Second)
    defer cancel()

    // Setting session-specific parameters
    _, err = db.ExecContext(ctx, "SET SESSION max_execution_time=?", i18n.MaxExecutionTime*1000) // milliseconds 30*1000
    if err != nil {
        slog.Error("20241212.01641 set max_execution_time", "error", err)
        return nil, err
    }

    _, err = db.ExecContext(ctx, "SET SESSION wait_timeout=?", i18n.MaxExecutionTime) // seconds
    if err != nil {
        slog.Error("20241212.01641 set wait_timeout", "error", err)
        return nil, err
    }

    _, err = db.ExecContext(ctx, "SET SESSION interactive_timeout=?", i18n.MaxExecutionTime) // seconds
    if err != nil {
        slog.Error("20241212.01642 set interactive_timeout", "error", err)
        return nil, err
    }

    return db, nil
}

When we need to run a query:

func getMostViewedDreams(limit int) []DreamInfo {
    var dreams []DreamInfo = make([]DreamInfo, 0, limit)
    db, err := dbconnect.GetConnection("getMostViewedDreams")
    if err != nil {
        slog.Error("20250209.02158 getMostViewedDreams: connecting to the database", "error", err)
        return dreams
    }

    ctx, cancel := context.WithTimeout(context.Background(), time.Duration(i18n.MaxExecutionTime)*time.Second)
    defer cancel()
    results, err := db.QueryContext(ctx, "SELECT id,text,views FROM dreams ORDER BY views DESC LIMIT "+fmt.Sprint(limit))
    if err != nil {
        slog.Error("20250209.02200 getMostViewedDreams: selecting", "error", err)
        return dreams
    }
    defer results.Close()

    for results.Next() {
        var cw DreamInfo
        if err := results.Scan(&cw.Id, &cw.Text, &cw.Views); err != nil {
            slog.Error("20250209.02201 getMostViewedDreams", "error", err)
            return dreams
        }

        cw.Summary = textmanipulation.Summarize(cw.Text, " ")

        dreams = append(dreams, cw)
    }

    return dreams
}

Key Takeaway

The Pool prevents you from crashing the database.
The Context prevents the database from crashing your app's performance.
The Lifetime prevents "Broken Pipe" errors on shared hosting.

Do not use anydesk application

2025-12-31T09:11:00.005-05:00

I have recently installed anydesk on my Linux Mint Cinnamon Dell laptop.

Two bad things happened:

It installs itself as an autostart application which starts immediately when a session starts. That's considered bad behavior. I don't need it to autostart just to connect to other computers every few months. I couldn't find inside the application itself how to disable it had to get into my Cinnamon settings startup apps and disable it.

Even worse than that:

2. I started getting weird behavior of Cinnamon. It happened that a new gnome-session was starting in the background causing me to lose the Cinnamon session while working. After running "apt purge anydesk" all problems were solved. That's looks like a bug or some other disturbing behavior.

I recommend other software like teamviewer which does not include the malicious behavior above. I am not affiliated with any other remote desktop application in any way.

Shitty software Anydesk.

Using locate, updatedb, mlocate and plocate on Linux with encrypted home directory

2025-12-29T07:37:00.005-05:00

I love using "locate" command on Linux. Finding files in a blink of an eye. Combining with "updatedb" it works amazingly fast.

I discovered that if your home directory is encrypted (or other directories are encrypted), by default locate command will not find anything in those directories.

The better solution is to build a local indexed database of your files:

updatedb -l 0 -o ~/.my_locate.db -U $HOME

And then using this database to search for files:

locate -d ~/.my_locate.db "part file name"

You may also want to edit:

cat /etc/updatedb.conf

And look at disregarded directories and filesystems: PRUNEPATHS, PRUNEFS

Someone using Tencent servers have been attacking my websites

2025-12-24T10:36:00.001-05:00

Someone using Tencent servers have been attacking my websites, mostly from China, Singapore, Vietnam, but also the US and Brazil.

I usually have around 1K people surfing my website at any given time. Occasionally my website https://www.gematrix.org is getting published in a blog about Gematria and numeric values and I get higher traffic organically.

This attack was happening on multiple websites I own, not just this one, but the attack was made more brutally on Gematrix and at this website I investigated it.

Lately, my website started crushing down. Did not worked properly. Responses were very slow. Looking a bit more deeply into it, I could see I have around 12K visitors at the same second in my website which caused the delay. Like thousands of thousands requests per seconds.

I did two things:

1. One of them is what I call "scale better": I have improved the way I handle requests, improved the caching and improved the database querying, schema and access. Thanks god I am using Go language which is very fast as term of execution, running time and compilation. With in less than a day I had a version of the website that can handle all of this traffic without shutting down, it even reached much higher traffic and the CPU load of the server also dropped significantly.

I don't use any external services like Cloudflare or others. I do everything myself.

2. Second, I started investigating what is actually happening and why. Where are those attacks coming from? What are they doing? Do they try DDOS to block my websites or "just" crawling unconditionally.

Here is how I stopped them:

I don't care if it is a DDOS attack or an aggressive crawling method - it should not be done!

I tried updating the robots.txt file, but it did not helped. Chinese bots are disregarding it, which is a shame, I really prefer the web in a more innocent way that you respect the site requests for delay. Setting the robots.txt crawl-delay to one every 5 seconds did not helped.

User-agent: *
Crawl-delay: 5
Allow: /

I was still getting more than 10K requests per second.

Investigating more deeply into it I noticed 70% of the traffic coming from China. Checking the IPs range I was able to locate around 100 IPs that the attack was coming from. I blocked them and the attack stopped - for a few hours.

After a few hours the attack continued, now most of the traffic came from Singapore, Vietnam - So I found the range of the attacking IPs and blocked them too. It helped for a few hours.

It then started again, from the US, Germany, Brazil and more.

At this point, looking at the IPs and running reverse lookup on the new range of IPs and also the older one - I discovered that they are all coming from a specific company called Tencent cloud computing - A huge conglomerate from China.

Thankfully Tencent provide the ranges of IPs they hold. All I had to do is to take all those ranges (Around 5,720,000 different IPs) and block them. And so I did.

I just blocked ALL the traffic from Tencen IP ranges.

For now it seems that the attack have stopped.

Here is the code to load and blocks all Tencent IP ranges. I am sure I might have blocked a few innocent people, but I think Tencent should check better what people are doing with their servers.

Links:

1. Tencent Cloud Computing

2. Tencent IP ranges (on their website)

3. Code for blocking Tencent traffic on github

package abuseip

import "net"

var ipRanges []*net.IPNet = []*net.IPNet{}

func IsTencentCloudComputingIP(ip net.IP) bool {
    for _, ipRange := range ipRanges {
        if ipRange.Contains(ip) {
            return true
        }
    }
    return false
}

func LoadTencentCloudComputingIPRanges() {
    // Parse the CIDR range once
    _, blockRange, _ := net.ParseCIDR("43.128.0.0/13")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("1.12.0.0/14")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("124.220.0.0/14")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("49.232.0.0/14")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("81.68.0.0/14")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("1.116.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("106.52.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("111.230.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("118.24.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("119.28.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("121.4.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("123.206.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("42.192.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("82.156.0.0/15")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("101.244.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("101.32.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("106.54.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("106.55.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("109.244.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("111.229.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("114.132.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("115.159.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("118.89.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("119.45.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("124.156.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("128.108.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("129.204.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("129.211.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("129.226.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("129.28.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("132.232.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("134.175.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("139.155.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("139.186.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("139.199.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("140.143.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("148.70.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("150.109.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("150.158.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("152.136.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("159.75.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("162.14.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("162.62.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("170.106.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("175.178.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("175.24.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("175.27.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("193.112.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("43.160.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("49.51.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("62.234.0.0/16")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("101.33.0.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("118.195.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("154.8.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("182.254.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("188.131.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("192.144.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("203.195.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("211.159.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("212.129.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("212.64.0.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("42.187.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("42.194.128.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("94.191.0.0/17")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("118.126.64.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("122.152.192.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("146.56.192.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("172.81.192.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("45.40.192.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("58.87.64.0/18")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("119.27.160.0/19")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("210.73.160.0/19")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("103.234.0.0/22")
    ipRanges = append(ipRanges, blockRange)

    _, blockRange, _ = net.ParseCIDR("103.95.224.0/22")
    ipRanges = append(ipRanges, blockRange)
}

Creating and adding to Linux file manager a right-click action using nemo_action

2025-12-07T11:24:00.003-05:00

When using the file manager I like files to be sorted by date descending. Hence seeing the newest files and directories first on top and the ones I recently updated.

The problem is when you have nested directories and you update a file in a sub directory.

For example, consider this directory structure:

- flights
+- Athens 2026-01
+- Hotels

If I add or update something in the "Hotels" directory, the "Athens 2026-01" directory does not pop up because I updated a sub-dir.

For this, I like the command "touch" in Linux. Touch allows me to change the timestamp of a file or a directory (and also creates new files and more).

I wanted to add the option inside the GUI of Linux file manager to right-click and "touch" a directory or a file.

I used nemo_actions (nemo actions) option to do so.

Step 1: Open the Actions Directory
Nemo looks for custom actions in a specific hidden folder.

Open your file manager (Nemo).

Press Ctrl + H to show hidden files.

Navigate to: .local -> share -> nemo -> actions (Full path: /home/YOUR_USERNAME/.local/share/nemo/actions)

Step 2: Create the Action File
Right-click in the empty space of this folder and choose Create New Document -> Empty Document.

Name the file: touch.nemo_action (The name doesn't strictly matter, but the .nemo_action extension is mandatory).

Open this new file with a text editor and paste the following code:

[Nemo Action]
Name=Touch (Update Timestamp)
Comment=Update the timestamp of selected files/folders to now
Exec=touch %F
Icon-Name=preferences-system-time
Selection=notnone
Extensions=any;
Quote=double

Step 3: Test It
You usually do not need to restart Nemo.

Go to any other folder (e.g., Downloads).

Select a file or directory.

Right-click it.

You should now see "Touch (Update Timestamp)" in the menu. Clicking it will update the "Modified" date to right now.

My Tiny Spreadsheet Extension - A spreadsheet that lives in your browser

2025-10-14T15:06:00.005-04:00

Download now

The problem

You need a simple fast spreadsheet
Google Sheet is clutters up
Excel files are lost
Google Sheets are saved on the cloud
You need an account to use Google Sheet

The solution: My Tiny Spreadsheet Extension

A small spreadsheet inside your browser
Data is saved locally
It's fast
It's good for smart note taking

Install Extension

https://freesheet.io

GeekCon 2025 - Building an Arcade Machine (rhythm machine)

2025-09-21T08:55:00.003-04:00

GeekCon is by far the best conference I have ever participated in.

If you are not that familiar about GeekCon, so shortly, once every year, around September we gather from all around Israel and outside of it, a bunch of heavy geeks, makers, developers, scientists and crazy technology savvy people to build crazy projects, non profit for a full weekend. Learn more.

Some examples from this year 2025, a robotic Lama that follows you and spit on you, a huge keyboard and a missile defense system that throws chairs on missiles, and more ...

This year, I went to GeekCon with my son and from his choosing we have decided to build an arcade machine, with a rhythm game. You need to press the buttons by the rhythm

The spec was like this:

Writing the game (rhythm machine game) in Python
Running the game on a Raspberry Pi (Version 5)
Connecting the buttons and reading the buttons state on the RaspberryPi
Using the buttons in the game
Building the arcade box itself (+printing buttons)

We 3D printed buttons for Arcade Machine here

Get and see the code (Pyhton) here (on github)

Here are some photos from the conference itself:

Here are some past event projects from GeekCon I have made:

https://www.c2kb.com/geekcon/

#geekcon #raspberrypi #pyhon #arcade #opensource

Setting program_name in mysql session_connect_attrs allows you to see the name of the program connected

2025-05-20T08:26:00.006-04:00

I am using mysql for quite some time now.

I have noticed that looking at client connections using mysql workbench so an interesting column called "Program". I can see that the program column indicate "MySQL Workbench":

This column can be very useful and help to filter different mysql database connections.

It took me a while to understand how to set up this column data.

So first thing I needed to do is understand where is this column name is actually coming from. I inspected the "SHOW FULL PROCESSLIST" command by mysql - but I did not get any answer there.

I then looked at the query the mysql workbench itself running to get this data "Program" column:

Using the "show details" button in the "client connections" view, show me this:

Copying the query, it looks like that:

SELECT t.PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USER,
t.PROCESSLIST_HOST,
t.PROCESSLIST_DB,
t.PROCESSLIST_COMMAND,
t.PROCESSLIST_TIME,
t.PROCESSLIST_STATE
,t.THREAD_ID,
t.TYPE,
t.NAME,
t.PARENT_THREAD_ID,
t.INSTRUMENTED,
t.PROCESSLIST_INFO,
a.ATTR_VALUE
FROM performance_schema.threads t LEFT OUTER JOIN performance_schema.session_connect_attrs a ON t.processlist_id = a.processlist_id AND (a.attr_name IS NULL OR a.attr_name = 'program_name') WHERE t.TYPE <> 'BACKGROUND'

It seems that mysql saves some extra data on the connection within the table performance_schema.session_connect_attrs and specifically the attr_name column.

The performance_schema.session_connect_attrs table, which allows you to store custom key-value pairs associated with a client connection. This is invaluable for identifying and monitoring connections from different applications or parts of your system.

MySQL provides a mechanism for client applications to send a set of key-value pairs (connection attributes) to the server during the connection handshake. These attributes are then exposed in the performance_schema.session_connect_attrs table (and session_account_connect_attrs for the current user's connections).

Commonly used attributes include _client_name, _client_version, _os, _pid, _platform, and program_name. You can also define your own custom attributes. Attribute names starting with an underscore (_) are reserved for internal MySQL use.

Here is how you can us Go (Golang mysql drive) to set this key-value pairs and most important the program_name field which later on views as "Program" inside MySQL Workbench.

user := "your_user"
    password := "your_password"
    host := "localhost"
    port := "3306"
    database := "your_database"

    // Define your custom connection attributes
    connectAttrs := "program_name:MyGoApp,environment:development,module:data_access"

    // Construct the DSN string
    // The `connectionAttributes` parameter is added to the query string part of the DSN.
    dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?connectionAttributes=%s",
        user, password, host, port, database, connectAttrs)

My Zed editor config setting json file

2025-05-10T14:38:00.003-04:00

I am using Zed editor, mostly for Go and web development. It is fast, yet not mature enough though I am still using it.

Here is my settings.json file for configuration:

// Zed settings
//
// For information on how to configure Zed, see the Zed
// documentation: https://zed.dev/docs/configuring-zed
//
// To see all of Zed's default settings without changing your
// custom settings, run `zed: open default settings` from the
// command palette (cmd-shift-p / ctrl-shift-p)
{
"ui_font_size": 16,
"buffer_font_size": 16,
"theme": {
    "mode": "system",
    "light": "One Black",
    "dark": "One Dark"
},
"tab_size": 4,
"languages": {
    "HTML": {
      "prettier": {
        "allowed": false
      }
    }
}
}

Building and compiling Go code to Windows on a Linux machine

2025-03-15T14:42:00.001-04:00

GOOS=windows GOARCH=amd64 CGO_ENABLED=1 CXX=x86_64-w64-mingw32-g++ CC=x86_64-w64-mingw32-gcc go build ./

Building an emulator machine for AAOS from a given images

2025-03-13T09:10:00.001-04:00

Recently the company I am working with have started working on AAOS (Android Automotive Operating System) version of Google Android and the need to develop, test and deploy the our Android App to the SDV (Software Defined Vehicle) version of the OEM bare OS implantation of Android Automotive (please notice, not Android Auto which is something else).

Here are a few installation procedures we followed since we needed to do in order to be able to run the AAOS machine in emulator on a Linux Ubuntu machine.

You will need around extra 60GB on your HD

Topics:

1. Download the machine image

2. Download and install Android-Studio

3. Create an empty project of Android Automotive and download the relevant SDKs

4. Open the downloaded machine to your Android/Sdk directory of system-images

5. Create a device from the new image

6. Run the machine (some problems with graphics / NVIDIA / Vulkan and GPU)

1. Download the machine image

- Receive the machine from you OEM contact

2. Download and install Android-Studio

- Android Studio Download

3. Create an empty project of Android Automotive and download the relevant SDKs

4. Open the downloaded machine to your Android/Sdk directory of system-images

a. Find your Android directory system-images ~/Android/Sdk/system-images/.

b. Create a directory called 'android-34' or any version you need.

c. Inside create a directory called 'your-oem-image-machine'.

d. Inside create a directory called 'x86_64'.

e. Extract the OEM image date into the x86_64 directory.

The full path should look like this: ~/Android/Sdk/system-images/android-34/connect_car_emulator/x86_64/

The content of the directory is the image data:

data
package.xml
VerifiedBootParams.textproto
userdata.img
source.properties
devices.xml
build.prop
advancedFeatures.ini
vendor.img
ramdisk.img
ranchu
encryptionkey.img
system.img

5. Create a device from the new image

Choose your relevant image from the list of images

- Open advanced settings and set:

Graphics: Hardware

Boot option: Cold boot

Ram: 8192MB

VM Heap: 512MB

Internal storage: 8192MB

* Make sure you have chosen the correct AVD image with the correct name:

- Then create you machine

6. Run the machine (some problems with graphics / NVIDIA / Vulkan and GPU)

Running the machine might be a bit tricky on Linux / Ubuntu machine so here are some heads up to notice:

Make sure to set export bash global parameters to the correct path:

export ANDROID_SDK_ROOT=~Android/Sdk
export ANDROID_HOME=~Android/Sdk
export PATH=$PATH:/emulator:/platform-tools:/tools

Running the machine:

~/Android/Sdk/emulator/emulator -avd your_avd_name -gpu host -feature -Vulkan

You can list all your avds (Android Virtual Devices) with:

~/Android/Sdk/emulator/emulator -list-avds

You can also try those parameters to run with CPU instead of GPU which are quite slow:

~/Android/Sdk/emulator/emulator -avd our_avd_name -gpu swiftshader_indirect -no-snapshot-load