CommandK

commandk

From Paris to Berlin: How to Create Circuit-Breakers in Kotlin

París markat Berlín markar: Kunjamas Kotlin markanx interruptores ukanakax lurasispa

De París a Berlín: cómo crear disyuntores en Kotlin

Paristik Berlinera: nola sortu etengailuak Kotlinen

מפריז לברלין: כיצד ליצור שוברי חשמל בקוטלין

パリからベルリンへ: Kotlin でサーキットブレーカーを作成する方法

ពីប៉ារីសទៅប៊ែរឡាំង: របៀបបង្កើតសៀគ្វីបំបែកនៅ Kotlin

파리에서 베를린까지: Kotlin에서 Circuit-Breaker를 만드는 방법

Nuo Paryžiaus iki Berlyno: kaip sukurti grandinės pertraukiklius Kotline

No Parīzes līdz Berlīnei: kā izveidot slēdžus Kotlinā

Dari Paris ke Berlin: Cara Membuat Pemutus Litar di Kotlin

பாரிஸிலிருந்து பெர்லின் வரை: கோட்லினில் சர்க்யூட் பிரேக்கர்களை உருவாக்குவது எப்படி

The Basics of Debian GNU/Linux

Hello, community!  I’m Anna, and I have been professionally engaged in Android Development for three years. In this article, I’d like to tell you in detail about Android Studio - a powerful tool for creating Android apps. Android Studio is an integrated development environment (IDE) for working with the Android platform, announced on May 16, 2013, at the Google I/O conference. Android Studio can be installed on Windows, Mac, and Linux. It was built on top of IntelliJ IDEA. The IDE is free to download and use. You can download Android Studio . To properly set up this program, follow .  After you have successfully installed and configured android studio, you can watch on working with this tool. This can make it much easier for you to get started in Android Studio. by this link these guidelines a few tutorials Android Studio has layouts for creating the UI, which is where you usually start working on an application. It contains tools for developing solutions for smartphones and tablets, as well as new technology solutions for Android TV, Android Wear, Android Auto, Glass, and additional contextual modules. New features come with every new version of Android Studio. In Android Studio you can write, test, and run your code. You can also create and customize an emulator and use them instead of real devices to run your Android apps. The first thing that needs to be said is every Junior Android Developer should master the work in Android Studio and use all the main features of this powerful and useful tool. One should note here that even though Android Studio is a complex tool, including many features, there are several useful lifehacks that will greatly simplify the work in this IDE. When I started actively use these lifehacks during my working days, the quality and speed of my work increased significantly. I have compiled a list of these lifehacks and I’m happy to share them for you. Lifehack 1 - Don’t neglect Android Studio’s tips of the day. The first thing that needs to be said is Android Studio creators made sure not only that all developers can comfortably work in this IDE with high performance, but also that they have the opportunity to how to write code better. Therefore, every day when you open Android Studio for the first time, you will see a tip of the day window. This is a small window in the middle of your screen that contains useful tips on how to organize your work with Android Studio. Some developers prefer to just close this window, but I strongly recommend that you don't be lazy and spend 5-10 minutes of your time per day reading these tips. Perhaps it will be very useful to you. As for me personally, when I acquired the useful habit of always reading the tip of the day, my work speed increased. In addition, some of my colleagues also appreciated the benefits of these small daily Android Studio tips. Tip of the day’s window looks like this: If you want to see more tips, click “Next Tip“, otherwise just close the window. Lifehack 2 – Learn and actively use Android Studio hotkeys. Another lifehack that can significantly speed up and simplify your work on code in Android Studio is hotkeys. I strongly recommend that you master the basic hotkeys of Android Studio and use them daily. As for me personally, I often use the following Android Studio hotkeys during my work: on macOS- Build Control+F9 / Command+F9 on macOS - Build and run Shift+F10 / Control+R on macOS - Reformat code Control+Alt+L / Command+Option+L on macOS - Optimize imports Control+Alt+O / Control+Option+O on macOS - Save all Control+S / Command+S on macOS - Synchronize Control+Alt+Y / Command+Option+Y on macOS - Find in file/class Control+F / Command+F on macOS - Find in project Control+Shift+N / Command+Shift+O on macOS - Open current editor tab in new window Shift+F4 / Shift+F4 on macOS - Go to line Control+G / Command+L on macOS on macOS - Replace Control+R / Command+R on macOS - Find in path Control+Shift+F / Command+Shift+F on macOS - Go to XML Control+B / Command+B on macOS - Commit project to VCS Control+K / Command+K on macOS - Update project from VCS Control+T / Command+T on macOS - View recent changes Alt+Shift+C / Option+Shift+C on macOS - generate code Alt+Insert / Command+N on macOS - Extract method Control+Alt+M / Command+Option+M on macOS - Extract variable Control+Alt+V / Command+Option+V on macOS - Extract field Control+Alt+F / Command+Option+F on macOS - Extract constant Control+Alt+C / Command+Option+C on macOS - Extract parameter Control+Alt+P / Command+Option+P As for me personally, the mentioned Android Studio hotkeys are quite enough. Based on my experience, I can assume that these combinations may be enough for the daily work of a Android developer. Perhaps you will also make a list of your favorite hotkeys over time. Android Studio hotkeys full list includes hotkeys for writing code, debug, version control, navigation, view layouts, refactoring etc. If you want to study all Android Studio hotkeys in more detail, you can always see their full list in the official documentation by this link. Lifehack 3 - Choose the Android Studio theme that suits you best. This tip may seem trivial, but it is useful and can make your work in android studio more comfortable. Unfortunately, I did not immediately pay attention to this fact and for a long time I worked in Android Studio using a white theme. I quickly got tired and did not feel satisfaction from my work. After I changed the theme to dark, my work became more comfortable and productive. But of course, you can choose the theme that is most comfortable for you. In fact, I would advise you to set up Android Studio so that you can work with this tool as comfortably as possible. at the very beginning of working To set up your favorite Android Studio theme go to File tab and click on Settings. Further, you can find Theme under the . Choose your theme from the drop-down list and click on Apply and Ok. Done! Appearance & Behaviour -> Appearance There are several ways to change theme in Android Studio. More detailed information you can find . by this link Lifehack 4 - Use Key Promoter X plugin. Above, I have listed only a small part of the hotkeys that can be used while working in Android Studio. It may seem to you that there are too many of them and it is unrealistic to remember all these key combinations. There is a great solution - use Key Promoter X. Key Promoter X is a plugin that allows you to learn hotkeys gradually, step by step. When you utilize the mouse on a button inside the IDE, the Key Promoter X presents the keyboard hotkeys that can be used instead. And if there is no hotkey for this action, it will advise you to start it. To install this plugin, just find it in the following path: Type Key Promoter X in search field. Download the plugin and restart the Android Studio. Done! Preferences → Plugins → Marketplace. Lifehack 5 - Use Rainbow Brackets plugin. Brackets are used to group a number of code statements. For you it can becomes hard when you can't find the block of code that you want. Rainbow Brackets provide rainbow colors to the brackets which will eventually help you to keep track of code blocks better. To use rainbow brackets in your code, just go to . Settings -> Plugins -> Install Rainbow Brackets Perhaps some of these lifehacks are already familiar to you, and some you will hear for the first time. In any case, I sincerely hope that this article will be helpful to Junior Android Developers who are in the early stage of their career. You can also write in the comments to the article what life hacks you already use to work with Android Studio. And if you are just thinking about starting your career in Android development, I advise you to read my article on . Good luck! how to become an Android developer from scratch in 2023

The Most Useful Android Studio Lifehacks You Should Master to Speed up Your Work

Introduction The that is small in appearance but powerful. After installing the open-source RetroPi emulator, it is an all-purpose retro game console that can run tens of thousands of games from Sony, Nintendo, and Sega. For example, Super Mario, Contra, Metal Slug, and Crash Bandicoot can all be played. Next, I will tell you how to make a game console with Raspberry Pi step by step. Raspberry Pi is an ARM-based microcomputer 1 Burn-in System The RetroPie image can be downloaded from the official website at 1.1 Download Mirror . retropie.org.uk/download/ 1.2 Mirror-Writing AS for how to burn the image to the SD card, you can refer to some professional articles. For example, the method of writing img image to the SD card with Terminal on the mac, if you use Windows, it is the same. After formatting the SD card, use the tool Win32DiskImager to write into the mirror image. And then, insert the card into the Raspberry Pi, connect the monitor, and power on. Note: The power supply voltage of the Raspberry Pi is constant 5V, and the current must be sufficient, at least with a power adapter of more than 2A. If the current of the Raspberry Pi is too low, an automatic restart may occur. 2 Simulator Configuration When we connect the Raspberry Pi to the monitor, the system startup interface looks good, don't get excited, it will take a while to play the game. If you have a gamepad, plug it into the Raspberry Pi via USB. Press any key, and the system will automatically detect your gamepad. 2.1 Key Button Configuration The purpose of the key configuration is to allow your controller to accurately control the games in this simulator. By pressing the corresponding buttons on the controller, there is only one chance. Once the set is wrong, the buttons must be reconfigured. If happened, how to reconfigure it? At this time, plug the keyboard into the USB port of the Raspberry Pi, press the F4, you can enter the command line interface of the system, then enter the command exit, you can restart the system and reconfigure the keys. Suggestion: If it is a PS handle, the main corresponding keys are as follows: A→ O key →X key B X→ Triangle key →Square key Y When the key configuration is completed, you will see the following interface, 13 GAMES AVAILABLE, which is 13 setting menus. Due to copyright issues, the official website has removed all self-contained games. If you want to play the game, you still have to find rom resources yourself. 2.2 Connect to WiFi When we configure the buttons, our controller can easily control our simulator. We start the menu settings. Find the WiFi option, and connect the RetroPie to WiFi first. When entering the WiFi password, it is better to use the keyboard to enter numbers for convenience. Remember the current IP address after connecting to WiFi, for example, my current IP address is: 192.168.99.125 3 Game Installation 3.1 Resources Game resources can go to the search engine "game name (keyword) + rom", you can find resources. 3.2 Installation After the RetroPie system is installed, the smb file transfer service is automatically enabled. Under the same local area network, you can directly transfer the game rom to RetroPie through the smb service. The specific operations are as follows: : Under the Mac system, press the command+K key in the Finder interface. Step 1 : Enter the IP address you just wrote down, click connect, and select the guest user connection and password interface. Step 2 : Mount Volume Select: roms Step 3 : At this time, you will see many folders of game emulators, put the game roms you got into the specified folder. If it is a Ps one game, its suffix is img, putting it in the folder psx. If it is a Nintendo game with the suffix nes, just drag it over. Step 4 : Restart the system, you will find that the game has been installed. Step 5 Finally, enjoy your time!

How to Make a Retro Game Console Based on Raspberry Pi?

Let’s face it we all have been there, trying to fiddle with managing our emulators and dev devices. And at max, we would do is try to manually manage it. Let me make this clear I am not talking about tests here as that’s all related to the code. My focus here is on managing the device/emulator that’s paired with your dev environment/system (..and to your IDE — Android Studio, if you still use Eclipse you are simply oblivious to the joys of coding in Android ). [here is a long blank stare from me to you] Technically there is a tool called ADB (Android Debug Bridge) which maintains your connection with your device/emulator and the dev environment/system. From the , it is described as wikipedia is the command line tool provided in the Android SDK package. stands for Android Debug Bridge which allows you to communicate with an emulator instance or connected Android-powered device to: adb adb 1. Manage the state of an emulator or device.2. Run shell commands on a device.3. Manage port forwarding on an emulator or device.4. Copy files to/from an emulator or device. Ok… that sounds something of use but not convincing enough for you to try and play with it yet. Let me try and put forward some of the problems as a dev you are facing every day (..and yet no one admits to them whenever it comes up in a conversation 🙄..) and how can we solve this. Uninstalling an app Oh yeah ..you are used to hitting in the IDE (or the keyboard shortcut for the same) and BOOM the apk installs in the device. But what do you do to uninstall the apk? oh yeah I know ..you will open up your device/emulator and manually uninstall the app by dragging it to the trash bin in the home screen and hit yes when prompted to uninstall it. Hard ain’t it? Yeah, it is. Run [Rolling eyes] ADB can make it as simple as executing just a command adb uninstall <package_name> if you wish to keep the data and cache directory intact but uninstall the app just add as an option to the command -k adb uninstall [-k] <package_name> means it is an optional parameter [ ] Of course, you can install an app too via adb install [-r] [-s] <package_name> the options available to the command are : reinstall the app, keeping its data : install on SD card instead of internal storage -r -s That looks neat. Direct ADB commands to specific devices when you have multiple of those connected Ok this one is my favorite 🙃 So here is the thing. You have like 5–6 devices connected to your dev environment and now you want to do some work with a specific device at a time. Piece of 🍰 Easy you say, right? Like you can just fire up your Android Studio and execute the app in some specific device. Not so early 😅. Let me complete. You want to execute commands in a certain order 🙄 ..yeah it isn’t easy as you thought before , eh 🤔 For our example here let’s assume we have like 3 devices and 2 emulators running, named as , , , , . device_1 device_2 device_3 emu_1 emu_2 Our end goal is to be able to execute some adb command on devices/emulator in order such as emu_1 device_3 device_1 device_2 emu_2 Cool ? Now first of all let me give you the magic commands to handle this situation. Lets look at what's available to us adb -d <command> What this will do is it will directs command to the only connected USB device. Naice 🙂 You can also use to directs command to the only connected Emulator adb -e <command> But we wanna go a step ahead and orchestrate commands in a pattern (..by writing a bash script, obviously). But to do that I need to specifically direct commands to the device I want to control. adb -s <device_id> <command> Get the device id by using adb devices Now we are talking 😎. Now the only thing I gotta do is create a bash script something like this #!/bin/bash adb -s <emu_1_id> <some_command>adb -s <device_3_id> <some_command>adb -s <device_1_id> <some_command>adb -s <device_2_id> <some_command>adb -s <emu_2_id> <some_command> where doesnot have to be the same. <some_command> ..and save it as execute_cmds_as_symphony.sh make it executable by running chmod +x execute_cmds_as_symphony.sh execute it by running ./execute_cmds_as_symphony.sh That’s all there is. Every time you wanna run it like this just run the bash script 🤓 😎 That’s like creating a symphony with your devices, except for the fact it is not ..gonna be a symphony in the first place. And its just code executing🤔 But you get my point , right😅 Connect wirelessly with your device Read my post “ ” to learn how to set it up. Life without wires: ADB over WiFi Device does not show up in the Android Studio deploy list There are times when the device would not show up in your IDE. Possible issue could be that adb is not responding. To fix that simply kill the server and start it again. # Kill the server if it is runningadb kill-server # Start the serveradb start-server I have seen that you also need to uncheck and then check inside Android Studio as an extra step. ADB Integration To get Device Information # Prints about the current state of the device: offline | bootloader | deviceadb get-state # Prints the serial number of the deviceadb get-serialno # Prints the device pathadb get-devpath Copy file to/from device/emulator You can advocate about trying to copy files from your device by opening up some software and then dragging and dropping things onto your desktop. But I am a fan of automating things and the above-mentioned method is completely fine if you are doing that for one file and only once or twice. It changes when you wanted to do the same task again and again. When you want to automate things commands come in handy. You can even add them to a script and run it every time one of the tasks completes. adb To push a file/dir to device adb push <local> <remote> where is file in your local system i.e and is file location in device/emulator i.e <local> my_image.png <remote> /sdcard/Downloads/my_image.png adb push ~/Downloads/my_image.png /sdcard/Downloads/my_image.png To pull a file/dir from device adb pull <remote> [<local>] where is file in your local system i.e and is file location in device/emulator i.e <local> my_image.png <remote> /sdcard/Downloads/my_image.png adb pull /sdcard/Downloads/my_image.png my_image.png Acting as a Developer utility-belt Generate Public/Private Key adb keygen <filename> The private key is stored in , and the public key is stored in Any existing files are overwritten. <file> <file>.pub Get a bug report # Prints to the standard outputadb bugreport # Writes to a file named bugreport.txtadb bugreport > bugreport.txt Get list of all connected devices adb devices Logging Of course, this is inbuilt into the IDE, but it is worth knowing that it is not just a window which you use in Android Studio, but so much more. Let’s check out its power when used from terminal # Dumps log entries from 3 log buffers: main, events and radioadb logcat # Dumps log entries in long formatadb logcat -v long # Dumps log entries into rotated log files on the deviceadb logcat -f /sdcard/Download/Android.log -r 1024 -n 8 # Dumps only error log entries generated from the “AndroidRuntime” process, including Java exceptionsadb logcat AndroidRuntime:E *:S # Clears (flushes) the entire log and exitsadb logcat -c # Dumps the log to the screen and exitsadb logcat -d # Writes log message output to a file. The default is the “stdout — Standard Output”adb logcat -f <filename> # Prints the size of the specified log buffer and exitsadb logcat -g Logcat Format To define the format of each log entry that is dumped , you need to set the output format for log messages # The default is brief formatadb logcat -v <format> # Display priority/tag and the PID of process issuing the message (the default format)adb logcat -v brief # Display PID with the log infoadb logcat -v process # Display the raw log message, with no other metadata fieldsadb logcat -v raw # Display the date, invocation time, priority/tag, and PID of the process issuing the messageadb logcat -v time # Display the priority, tag, and the PID and TID of the thread issuing the messageadb logcat -v thread # Display the date, invocation time, priority, tag, and the PID and TID of the thread issuing the messageadb logcat -v threadtime # Display all metadata fields and separate messages with blank linesadb logcat -v long Filter your log data A few people would say that we can always use appended to the . Well, you are right you can, but there are some neat tricks hidden in the actual implementation of logcat and you should look at them too. | grep “filter_text” adb logcat adb logcat <options> <process-tag>:<priority-code> When filters are provided, the command will dump log entries that are generated from specified processes with priorities higher than the specified code, plus all log entries that generated from unspecified processes.A wildcard character, , can be used to represent all processes logcat * List of all priority codes that can be used in the “logcat” command: — Verbose (lowest priority) V — Debug D — Info (default priority) I — Warning W — Error E — Fatal F — Silent (highest priority, on which nothing is ever printed) S To control the device This is pretty well known to people who are into Modding their device. But for people who aren’t going to mess with their device, here is what you can do with ADB # Remounts the /system partition on the device read-writeadb remount # Reboots the device, optionally into the bootloader or recovery programadb reboot [bootloader|recovery] # Reboots the device into the bootloaderadb reboot-bootloader # Restarts the adbd daemon with root permissionsadb root # Restarts the adbd daemon listening on USBadb usb # Restarts the adbd daemon listening on TCP on the specified portadb tcpip <port> Some other base functionality I am just going to list some more commands, just because well they exist! 😋 # Show help about all commands for adb, check this to get info about more commands in adbadb help # Shows the version number for adbadb version Comment/Suggestions always welcome. If you would like to get more of such android tips and tricks, just hop onto my Github repository. I keep updating it constantly. Android Tips & Tricks Keep on crushing code!🤓 😁 P.S.: was first published at my blog This post Crushing C.O.D.E I would like to mention that wrote a plugin for Android Studio and IntelliJ IDEA called [ ], which allows you to do some of the common and straightforward interactions with ADB inside IntelliJ platform i.e Android Studio. Do check it out too 🙂 @pbreault ADB Idea Github Thanks for reading! Be sure to click below to recommend this article if you found it helpful. ❤ You can connect with me on , , , , and Github Twitter Linkedin Facebook Dribbble Google+

Do you like to ADB?

“Hey Copilot”: Microsoft Brings Voice Commands to Windows AI

In the fast-evolving world of cloud-native development, Kubernetes has taken the crown as the go-to solution for container orchestration. But let’s be honest—as powerful as it is, the command-line tool kubectl can feel like an unforgiving spellbook. Remembering flags, writing endless YAML, and debugging pods with cryptic logs isn’t exactly fun. Now, imagine being able to ask your cluster, in plain English, "Hey, scale my nginx app to 5 replicas" — and having it just do it. That’s what kubectl-ai is here to offer. kubectl kubectl-ai What Is kubectl-ai? kubectl-ai is an AI-powered command-line assistant that acts as an interpreter between your natural language and Kubernetes operations. It's not an official Google product, but it was incubated inside Google Cloud and is open source. The magic? You speak in English. It thinks in YAML and kubectl commands. kubectl-ai kubectl No more looking up the syntax for kubectl logs -n myspace mypod -c mycontainer. You can now just say: kubectl logs -n myspace mypod -c mycontainer kubectl-ai "Check logs for the nginx container in the hello namespace" kubectl-ai "Check logs for the nginx container in the hello namespace" Behind the scenes, it parses your intent, generates the correct command, executes it, and even explains the result. Why It Matters For anyone who has ever: Mistyped a kubectl command
Forgotten the name of a resource
Spent hours writing YAML files that barely pass validation Mistyped a kubectl command Forgotten the name of a resource Spent hours writing YAML files that barely pass validation kubectl-ai is a breath of fresh air. It supports popular LLMs like: Google Gemini
OpenAI (GPT-4)
Azure OpenAI
X.AI's Grok
Local models via ollama and llama.cpp Google Gemini OpenAI (GPT-4) Azure OpenAI X.AI's Grok X.AI Local models via ollama and llama.cpp ollama llama.cpp This means you can fine-tune the experience to your performance needs, budget, or data privacy concerns. AI in Action: How It Works When you give it a prompt, kubectl-ai does three things: Understands Your Intent It parses natural language using your selected LLM.


Generates kubectl Commands It translates intent to valid commands. For example:
kubectl-ai "create a deployment named nginx with 3 replicas using nginx:latest"

Will likely run:
kubectl create deployment nginx --image=nginx:latest
kubectl scale deployment nginx --replicas=3



Explains and Executes It can optionally run the commands and give you a human-readable summary of what happened. Understands Your Intent It parses natural language using your selected LLM. Understands Your Intent It parses natural language using your selected LLM. Understands Your Intent Generates kubectl Commands It translates intent to valid commands. For example:
kubectl-ai "create a deployment named nginx with 3 replicas using nginx:latest"

Will likely run:
kubectl create deployment nginx --image=nginx:latest
kubectl scale deployment nginx --replicas=3 Generates kubectl Commands It translates intent to valid commands. For example: Generates kubectl Commands kubectl-ai "create a deployment named nginx with 3 replicas using nginx:latest" kubectl-ai "create a deployment named nginx with 3 replicas using nginx:latest" Will likely run: kubectl create deployment nginx --image=nginx:latest
kubectl scale deployment nginx --replicas=3 kubectl create deployment nginx --image=nginx:latest
kubectl scale deployment nginx --replicas=3 Explains and Executes It can optionally run the commands and give you a human-readable summary of what happened. Explains and Executes It can optionally run the commands and give you a human-readable summary of what happened. Explains and Executes Getting Started 1. Install it Download the latest release from the GitHub releases page: releases tar -zxvf kubectl-ai_Darwin_arm64.tar.gz
chmod a+x kubectl-ai
sudo mv kubectl-ai /usr/local/bin/ tar -zxvf kubectl-ai_Darwin_arm64.tar.gz
chmod a+x kubectl-ai
sudo mv kubectl-ai /usr/local/bin/ 2. Authenticate Your Model Set your API key for the model of your choice: export GEMINI_API_KEY=your_api_key_here
export OPENAI_API_KEY=your_openai_api_key_here export GEMINI_API_KEY=your_api_key_here
export OPENAI_API_KEY=your_openai_api_key_here 3. Start Chatting with Kubernetes kubectl-ai "What's going on with the nginx deployment?"
kubectl-ai "Scale it to 5 replicas" kubectl-ai "What's going on with the nginx deployment?"
kubectl-ai "Scale it to 5 replicas" You can also run it interactively: kubectl-ai
>> list pods
>> describe the first one
>> exit kubectl-ai
>> list pods
>> describe the first one
>> exit Real-World Scenarios 1. Quick Debugging Quick Debugging kubectl-ai "why is the nginx pod crashing?"
cat logs.txt | kubectl-ai "explain this error" kubectl-ai "why is the nginx pod crashing?"
cat logs.txt | kubectl-ai "explain this error" 2. Faster Deployment Faster Deployment kubectl-ai "create a deployment for redis with 2 replicas"
kubectl-ai "expose the deployment as a NodePort service" kubectl-ai "create a deployment for redis with 2 replicas"
kubectl-ai "expose the deployment as a NodePort service" 3. Scaling and Updates Scaling and Updates kubectl-ai "double the capacity of nginx"
kubectl-ai "update the image of nginx to nginx:1.25" kubectl-ai "double the capacity of nginx"
kubectl-ai "update the image of nginx to nginx:1.25" AI Models? Your Choice Want speed? Go with gemini-2.5-flash-preview. Need something local? Fire up a 12B parameter gemma3 model with Ollama: gemini-2.5-flash-preview gemma3 kubectl-ai --llm-provider=ollama --model=gemma3:12b-it-qat kubectl-ai --llm-provider=ollama --model=gemma3:12b-it-qat Or switch to OpenAI: kubectl-ai --llm-provider=openai --model=gpt-4 "restart the nginx deployment" kubectl-ai --llm-provider=openai --model=gpt-4 "restart the nginx deployment" Highlights and Challenges 🔥 What Makes It Cool Truly conversational Kubernetes
Multi-model support
CLI-first with plugin-like experience
Explains actions and results in human language Truly conversational Kubernetes Truly conversational Kubernetes Multi-model support Multi-model support CLI-first with plugin-like experience CLI-first with plugin-like experience Explains actions and results in human language Explains actions and results in human language ⚠️ Things to Watch AI-generated commands may still require human review, especially in production
API keys must be kept secure AI-generated commands may still require human review, especially in production API keys must be kept secure Final Thought kubectl-ai is the kind of tool that makes you wonder why this hasn’t existed all along. It doesn’t replace kubectl — it enhances it. With smart model integrations and an intuitive user experience, it lowers the barrier to entry and supercharges productivity. kubectl-ai kubectl Whether you’re just getting into Kubernetes or you live in the terminal, kubectl-ai is a tool worth trying.

This AI Tool Turns Kubernetes Commands Into Conversations

This One Command Lets You Live-Edit UIKit Apps Like It's SwiftUI

This pages describes how to remotely control youtube running within a browser from the command-line. In practice this sort of script may not be used directly from the command-line but rather attached to a keyboard shortcut or run from another script that forms a larger process. keyboard shortcut This approach only works for Linux due to the limitations of the Chrome extension it uses. If you have programming experience you may be able to adapt the approach for another operating system. I would direct anyone interested in doing this to mozeidon as an example of a remote control from Chrome which can be run from the command-line. mozeidon Chrome This approach only works for Chromium-based browsers. I got it working with Brave, but Vivalid is another Chrome-based browser. How this works This entire page is effectively alternative and more complete documentation for streamkeys which, almost incidentally provides this feature. This page, however, focuses on command-line usage for Linux - documents and works around some issues in streamkeys, and is an easy-to-find article on the topic of controlling youtube from the command-line. streamkeys Streamkeys was written with the intention of controlling youtube, or other media players, running with Chrome from any other tabs. However, incidentally it also provides support for MPRIS which is a generally linux protocol for controlling multimedia players from the command-line. This standard can be used to cotrol youtube playback from the command-line. You can do things like: Stop the player
Skip forward
Get the current position in the audio. Suitable for adding to notes or shared with others.
Get the length of the video Stop the player Skip forward Get the current position in the audio. Suitable for adding to notes or shared with others. Get the length of the video Obtaining the may be particularly useful when combined yt-dlp to obtain subtitles for the video. yt-dlp Setting everything up Unfortunately stream has been removed from the Chrome extension store, has a build process that depends on deprecated libraries, and requires an out of date build process. It does however still work. You need to download streamkeys, build it, and manually add it to Chrome. This may be good experience for you if you ever intend to develop a browser extension. Requirements: uv is needed to use an old version of python required by node-gyp which is required by node-sass


nvm is required to use an old version of node used for building the extension


python3-dbus is needed for the interface used to communicate with the extension from the command-line


playerctl is a command-line tool to communicate with mediaplayers (includig streamkeys after some configuration). uv is needed to use an old version of python required by node-gyp which is required by node-sass uv is needed to use an old version of python required by node-gyp which is required by node-sass uv node-gyp node-sass nvm is required to use an old version of node used for building the extension nvm is required to use an old version of node used for building the extension nvm node python3-dbus is needed for the interface used to communicate with the extension from the command-line python3-dbus is needed for the interface used to communicate with the extension from the command-line python3-dbus playerctl is a command-line tool to communicate with mediaplayers (includig streamkeys after some configuration). playerctl is a command-line tool to communicate with mediaplayers (includig streamkeys after some configuration). playerctl Both of these tools are standard, broadly used develoment tools To install requiments: sudo apt-get install pipx


sudo apt-get install python3-dbus


pipx install uv


Follow the instructions here to install nvm. Note that nvm updaes you shell configuration and requires you to reload this configuraiton aor restart your shell sudo apt-get install pipx sudo apt-get install pipx sudo apt-get install pipx sudo apt-get install python3-dbus sudo apt-get install python3-dbus sudo apt-get install python3-dbus pipx install uv pipx install uv pipx install uv Follow the instructions here to install nvm. Note that nvm updaes you shell configuration and requires you to reload this configuraiton aor restart your shell Follow the instructions here to install nvm. Note that nvm updaes you shell configuration and requires you to reload this configuraiton aor restart your shell Follow the instructions here nvm nvm To make a build of streamkeys: cd ~/.local. I like to keep third-party installed code here - but you may store your code elsewhere.


Clone streamkeys. git clone git@github.com:berrberr/streamkeys.git


cd streamkeys


Create a  uv virtualenv with an old python uv venv --python=3.10


Activate the uv virtual virtualenv source .venv/bin/activate


Install node 16 nvm install 16


Enable node 16 nvm use 16


Add this python python --version should return 3.10 and node --version should 16.


Set up the build environment with npm install


Create the extension npm run dev cd ~/.local. I like to keep third-party installed code here - but you may store your code elsewhere. cd ~/.local. I like to keep third-party installed code here - but you may store your code elsewhere. ~/.local Clone streamkeys. git clone git@github.com:berrberr/streamkeys.git Clone streamkeys. git clone git@github.com:berrberr/streamkeys.git git clone git@github.com:berrberr/streamkeys.git cd streamkeys cd streamkeys cd streamkeys Create a  uv virtualenv with an old python uv venv --python=3.10 Create a  uv virtualenv with an old python uv venv --python=3.10 uv venv --python=3.10 Activate the uv virtual virtualenv source .venv/bin/activate Activate the uv virtual virtualenv source .venv/bin/activate source .venv/bin/activate Install node 16 nvm install 16 Install node 16 nvm install 16 nvm install 16 Enable node 16 nvm use 16 Enable node 16 nvm use 16 nvm use 16 Add this python python --version should return 3.10 and node --version should 16. Add this python python --version should return 3.10 and node --version should 16. python --version node --version Set up the build environment with npm install Set up the build environment with npm install npm install Create the extension npm run dev Create the extension npm run dev npm run dev To install streamkeys: Locate the extension ./build/unpacked-dev


Go to the extension page in chrome "chrome://extensions"


Add a developer extension with the path of build/unpacked-dev Locate the extension ./build/unpacked-dev Locate the extension ./build/unpacked-dev ./build/unpacked-dev Go to the extension page in chrome "chrome://extensions" Go to the extension page in chrome "chrome://extensions" Add a developer extension with the path of build/unpacked-dev Add a developer extension with the path of build/unpacked-dev build/unpacked-dev To enable streamkeys for use with debug (MPIRS), you must run a script. Find the id of the streamkeys extension. Go to brave://extensions/ and click on the Details of streamkeys package. This should have an ID - copy this ID.
Run the script python3 ./build/unpacked-dev/native/mpris_host_setup.py install $ID with this ID. Find the id of the streamkeys extension. Go to brave://extensions/ and click on the Details of streamkeys package. This should have an ID - copy this ID. brave://extensions/ Run the script python3 ./build/unpacked-dev/native/mpris_host_setup.py install $ID with this ID. python3 ./build/unpacked-dev/native/mpris_host_setup.py install $ID The command playerctl pause should now pause youtube and playerctl play start it. playerctl pause playerctl play Usage You can use playerctl from the command-line. You may like to explore the documentation. This script can be wrapped for ther purposes. playerctl I use the following scripts (amongst others): skip: Skip 10 seconds forward (or number of seconds given) skip #!/bin/bash
playerctl position | perl -pe "\$_ = \$_ + ${1-10}" | xargs playerctl position; playerctl position #!/bin/bash
playerctl position | perl -pe "\$_ = \$_ + ${1-10}" | xargs playerctl position; playerctl position back: Skip 10 seconds backwards (or number of seconds given) back #!/bin/bash
skip ${1:--10} #!/bin/bash
skip ${1:--10} pos: Return the position into the video pos #!/bin/bash
playerctl position #!/bin/bash
playerctl position yt-position: Return the percentage through the video yt-position #!/bin/bash
length=$(playerctl metadata  | grep length | awk '{ print $3 }')
pos=$(playerctl position)
perl -e 'my ($a,$b) = @ARGV; print(int($a * 1000000 / $b * 100) . "%\n")' "$pos" "$length" #!/bin/bash
length=$(playerctl metadata  | grep length | awk '{ print $3 }')
pos=$(playerctl position)
perl -e 'my ($a,$b) = @ARGV; print(int($a * 1000000 / $b * 100) . "%\n")' "$pos" "$length" yt-link: Return a link to the video 10 seconds ago yt-link #!/bin/bash
mozeidon tabs  get  | jq '.[] | .[] | select(.url | test("youtube\\.com")) | .url ' -rc | { read line ; echo $line\&t=$(playerctl position | perl -pe '$_ -= 10') ; } #!/bin/bash
mozeidon tabs  get  | jq '.[] | .[] | select(.url | test("youtube\\.com")) | .url ' -rc | { read line ; echo $line\&t=$(playerctl position | perl -pe '$_ -= 10') ; } I use this script (and others) to refer to videos while taking notes in Obsidian. If you are interested in note taking you might like to read my review of note taking in Obsidian. Obsidian review of note taking in Obsidian Alternatives ytmdesktop is a desktop app for youtube which can be remotely controlled via http. There tends to be a risk that such players attached to a changing website like google will stop working unless they have dedicated maintainers. ytmdesktop remotely controlled via http You may prefer to download media from youtube using yt-dlp to download media and play it in another player. yt-dlp A shortcut to jump to the youtube tab may be sufficient for your uses. I have down this before with a combination of key simulation with xdotool interacting with the tab selection feature and wmctrl to raise windows. You can aso used mozeidon to select tabs xdotool wmctrl It is to be noted that the youtube website provides a variety of social and recommednation featues that other approaches do not support. References yt-dlp
mozeidon yt-dlp yt-dlp mozeidon mozeidon About me I am @readwithai. I create tools for reading, research and agency sometimes using the markdown editor Obsidian. @readwithai Obsidian I also create a stream of tools that are related to carrying out my work. stream of tools I write about lots of things - including tools like this - on X. My blog is more about reading and research and agency. X blog

Remotely Control Youtube With This Command-line Approach on Linux

Introduction SQL is not just about querying data—it also includes powerful commands to modify data within tables. These Data Manipulation Language (DML) commands, such as INSERT, UPDATE, and DELETE, enable you to add, modify, or remove rows in a database. In this article, we’ll explore these commands with practical examples. Sample Table: Employees Let’s start with a sample Employees table to demonstrate the examples: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

70000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

72000

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

70000

IT 1. INSERT: Adding Rows to a Table The INSERT command is used to add new rows to a table. Task: Add a new employee, Frank, who is a Tester in the QA department with a salary of $60,000. INSERT INTO Employees (EmployeeID, Name, Position, Salary, Department)
VALUES (6, 'Frank', 'Tester', 60000, 'QA'); Result: The table now includes the new employee: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

70000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

72000

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

70000

IT



6

Frank

Tester

60000

QA 2. UPDATE: Modifying Existing Rows The UPDATE command allows you to modify data in existing rows based on specific conditions. Task: Give all Developers in the IT department a 10% salary increase. UPDATE Employees
SET Salary = Salary * 1.10
WHERE Position = 'Developer' AND Department = 'IT'; Result: The salary for Alice, Charlie, and Eve has been updated: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

77000

IT



6

Frank

Tester

60000

QA 3. DELETE: Removing Rows From a Table The DELETE command removes rows from a table based on a condition. Task: Remove all employees in the QA department. DELETE FROM Employees
WHERE Department = 'QA'; Result: Frank has been removed from the table: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

77000

IT 4. MERGE (UPSERT): Combining Insert and Update The MERGE statement is used to insert new rows or update existing rows based on a match condition. This is also known as “upsert”. Task: If an employee with EmployeeID = 5 exists, update their position to “Lead Developer”. Otherwise, insert a new employee. MERGE INTO Employees AS Target
USING (SELECT 5 AS EmployeeID, 'Eve' AS Name, 'Lead Developer' AS Position, 80000 AS Salary, 'IT' AS Department) AS Source
ON Target.EmployeeID = Source.EmployeeID
WHEN MATCHED THEN
    UPDATE SET Position = Source.Position, Salary = Source.Salary
WHEN NOT MATCHED THEN
    INSERT (EmployeeID, Name, Position, Salary, Department)
    VALUES (Source.EmployeeID, Source.Name, Source.Position, Source.Salary, Source.Department); Result: Eve’s position has been updated to “Lead Developer”: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Lead Developer

80000

IT 5. TRUNCATE: Quickly Clearing All Rows The TRUNCATE command removes all rows from a table, but unlike DELETE, it does not log individual row deletions, making it faster. Task: Clear all rows from the Employees table. TRUNCATE TABLE Employees; Result: The table is now empty, but the structure remains intact. 6. DROP: Removing the Entire Table The DROP command deletes a table and its data permanently. Task: Remove the Employees table from the database. DROP TABLE Employees; Result: The Employees table no longer exists. Summary SQL provides a wide range of commands to modify data and table structures. Here’s a quick recap: Command Use Case INSERT: Add new rows to a table.
UPDATE: Modify data in existing rows.
DELETE: Remove specific rows from a table.
MERGE: Combine insert and update logic (upsert).
TRUNCATE: Quickly clear all rows in a table.
DROP Remove the entire table structure and data. These commands allow you to keep your database up-to-date, clean, and well-organized. Practice these examples on your own database to gain confidence in modifying data with SQL! Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn. Happy exploring!👋 Introduction SQL is not just about querying data—it also includes powerful commands to modify data within tables. These Data Manipulation Language (DML) commands, such as INSERT, UPDATE, and DELETE, enable you to add, modify, or remove rows in a database. In this article, we’ll explore these commands with practical examples. Data Manipulation Language (DML) Sample Table: Employees Let’s start with a sample Employees table to demonstrate the examples: EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

70000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

72000

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

70000

IT EmployeeID

Name

Position

Salary

Department 1

Alice

Developer

70000

IT 2

Bob

Designer

65000

Design 3

Charlie

Developer

72000

IT 4

Diana

Manager

90000

HR 5

Eve

Developer

70000

IT EmployeeID Name Position Salary Department EmployeeID EmployeeID Name Name Position Position Salary Salary Department Department 1 Alice Developer 70000 IT 1 1 Alice Alice Developer Developer 70000 70000 IT IT 2 Bob Designer 65000 Design 2 2 Bob Bob Designer Designer 65000 65000 Design Design 3 Charlie Developer 72000 IT 3 3 Charlie Charlie Developer Developer 72000 72000 IT IT 4 Diana Manager 90000 HR 4 4 Diana Diana Manager Manager 90000 90000 HR HR 5 Eve Developer 70000 IT 5 5 Eve Eve Developer Developer 70000 70000 IT IT 1. INSERT: Adding Rows to a Table The INSERT command is used to add new rows to a table. Task : Add a new employee, Frank, who is a Tester in the QA department with a salary of $60,000. Task INSERT INTO Employees (EmployeeID, Name, Position, Salary, Department)
VALUES (6, 'Frank', 'Tester', 60000, 'QA'); INSERT INTO Employees (EmployeeID, Name, Position, Salary, Department)
VALUES (6, 'Frank', 'Tester', 60000, 'QA'); Result : The table now includes the new employee: Result EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

70000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

72000

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

70000

IT



6

Frank

Tester

60000

QA EmployeeID

Name

Position

Salary

Department 1

Alice

Developer

70000

IT 2

Bob

Designer

65000

Design 3

Charlie

Developer

72000

IT 4

Diana

Manager

90000

HR 5

Eve

Developer

70000

IT 6

Frank

Tester

60000

QA EmployeeID Name Position Salary Department EmployeeID EmployeeID Name Name Position Position Salary Salary Department Department 1 Alice Developer 70000 IT 1 1 Alice Alice Developer Developer 70000 70000 IT IT 2 Bob Designer 65000 Design 2 2 Bob Bob Designer Designer 65000 65000 Design Design 3 Charlie Developer 72000 IT 3 3 Charlie Charlie Developer Developer 72000 72000 IT IT 4 Diana Manager 90000 HR 4 4 Diana Diana Manager Manager 90000 90000 HR HR 5 Eve Developer 70000 IT 5 5 Eve Eve Developer Developer 70000 70000 IT IT 6 Frank Tester 60000 QA 6 6 Frank Frank Tester Tester 60000 60000 QA QA 2. UPDATE: Modifying Existing Rows The UPDATE command allows you to modify data in existing rows based on specific conditions. Task : Give all Developers in the IT department a 10% salary increase. Task UPDATE Employees
SET Salary = Salary * 1.10
WHERE Position = 'Developer' AND Department = 'IT'; UPDATE Employees
SET Salary = Salary * 1.10
WHERE Position = 'Developer' AND Department = 'IT'; Result : The salary for Alice, Charlie, and Eve has been updated: Result EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

77000

IT



6

Frank

Tester

60000

QA EmployeeID

Name

Position

Salary

Department 1

Alice

Developer

77000

IT 2

Bob

Designer

65000

Design 3

Charlie

Developer

79200

IT 4

Diana

Manager

90000

HR 5

Eve

Developer

77000

IT 6

Frank

Tester

60000

QA EmployeeID Name Position Salary Department EmployeeID EmployeeID Name Name Position Position Salary Salary Department Department 1 Alice Developer 77000 IT 1 1 Alice Alice Developer Developer 77000 77000 IT IT 2 Bob Designer 65000 Design 2 2 Bob Bob Designer Designer 65000 65000 Design Design 3 Charlie Developer 79200 IT 3 3 Charlie Charlie Developer Developer 79200 79200 IT IT 4 Diana Manager 90000 HR 4 4 Diana Diana Manager Manager 90000 90000 HR HR 5 Eve Developer 77000 IT 5 5 Eve Eve Developer Developer 77000 77000 IT IT 6 Frank Tester 60000 QA 6 6 Frank Frank Tester Tester 60000 60000 QA QA 3. DELETE: Removing Rows From a Table The DELETE command removes rows from a table based on a condition. Task : Remove all employees in the QA department. Task DELETE FROM Employees
WHERE Department = 'QA'; DELETE FROM Employees
WHERE Department = 'QA'; Result : Frank has been removed from the table: Result EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Developer

77000

IT EmployeeID

Name

Position

Salary

Department 1

Alice

Developer

77000

IT 2

Bob

Designer

65000

Design 3

Charlie

Developer

79200

IT 4

Diana

Manager

90000

HR 5

Eve

Developer

77000

IT EmployeeID Name Position Salary Department EmployeeID EmployeeID Name Name Position Position Salary Salary Department Department 1 Alice Developer 77000 IT 1 1 Alice Alice Developer Developer 77000 77000 IT IT 2 Bob Designer 65000 Design 2 2 Bob Bob Designer Designer 65000 65000 Design Design 3 Charlie Developer 79200 IT 3 3 Charlie Charlie Developer Developer 79200 79200 IT IT 4 Diana Manager 90000 HR 4 4 Diana Diana Manager Manager 90000 90000 HR HR 5 Eve Developer 77000 IT 5 5 Eve Eve Developer Developer 77000 77000 IT IT 4. MERGE (UPSERT): Combining Insert and Update The MERGE statement is used to insert new rows or update existing rows based on a match condition. This is also known as “upsert”. Task : If an employee with EmployeeID = 5 exists, update their position to “Lead Developer”. Otherwise, insert a new employee. Task MERGE INTO Employees AS Target
USING (SELECT 5 AS EmployeeID, 'Eve' AS Name, 'Lead Developer' AS Position, 80000 AS Salary, 'IT' AS Department) AS Source
ON Target.EmployeeID = Source.EmployeeID
WHEN MATCHED THEN
    UPDATE SET Position = Source.Position, Salary = Source.Salary
WHEN NOT MATCHED THEN
    INSERT (EmployeeID, Name, Position, Salary, Department)
    VALUES (Source.EmployeeID, Source.Name, Source.Position, Source.Salary, Source.Department); MERGE INTO Employees AS Target
USING (SELECT 5 AS EmployeeID, 'Eve' AS Name, 'Lead Developer' AS Position, 80000 AS Salary, 'IT' AS Department) AS Source
ON Target.EmployeeID = Source.EmployeeID
WHEN MATCHED THEN
    UPDATE SET Position = Source.Position, Salary = Source.Salary
WHEN NOT MATCHED THEN
    INSERT (EmployeeID, Name, Position, Salary, Department)
    VALUES (Source.EmployeeID, Source.Name, Source.Position, Source.Salary, Source.Department); Result : Eve’s position has been updated to “Lead Developer”: Result EmployeeID

Name

Position

Salary

Department



1

Alice

Developer

77000

IT



2

Bob

Designer

65000

Design



3

Charlie

Developer

79200

IT



4

Diana

Manager

90000

HR



5

Eve

Lead Developer

80000

IT EmployeeID

Name

Position

Salary

Department 1

Alice

Developer

77000

IT 2

Bob

Designer

65000

Design 3

Charlie

Developer

79200

IT 4

Diana

Manager

90000

HR 5

Eve

Lead Developer

80000

IT EmployeeID Name Position Salary Department EmployeeID EmployeeID Name Name Position Position Salary Salary Department Department 1 Alice Developer 77000 IT 1 1 Alice Alice Developer Developer 77000 77000 IT IT 2 Bob Designer 65000 Design 2 2 Bob Bob Designer Designer 65000 65000 Design Design 3 Charlie Developer 79200 IT 3 3 Charlie Charlie Developer Developer 79200 79200 IT IT 4 Diana Manager 90000 HR 4 4 Diana Diana Manager Manager 90000 90000 HR HR 5 Eve Lead Developer 80000 IT 5 5 Eve Eve Lead Developer Lead Developer 80000 80000 IT IT 5. TRUNCATE: Quickly Clearing All Rows The TRUNCATE command removes all rows from a table, but unlike DELETE, it does not log individual row deletions, making it faster. Task : Clear all rows from the Employees table. Task TRUNCATE TABLE Employees; TRUNCATE TABLE Employees; Result : The table is now empty, but the structure remains intact. Result 6. DROP: Removing the Entire Table The DROP command deletes a table and its data permanently. Task : Remove the Employees table from the database. Task DROP TABLE Employees; DROP TABLE Employees; Result : The Employees table no longer exists. Result Summary SQL provides a wide range of commands to modify data and table structures. Here’s a quick recap: Command Use Case Command Use Case INSERT: Add new rows to a table. UPDATE: Modify data in existing rows. DELETE: Remove specific rows from a table. MERGE: Combine insert and update logic (upsert). TRUNCATE: Quickly clear all rows in a table. DROP Remove the entire table structure and data. INSERT: Add new rows to a table. UPDATE: Modify data in existing rows. DELETE: Remove specific rows from a table. MERGE: Combine insert and update logic (upsert). TRUNCATE: Quickly clear all rows in a table. DROP Remove the entire table structure and data. These commands allow you to keep your database up-to-date, clean, and well-organized. Practice these examples on your own database to gain confidence in modifying data with SQL! Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn . Happy exploring!👋 LinkedIn

Stories, News & Mentions about COMMANDK

Categories

Trending Topics

Stories, News & Mentions about COMMANDK

Commandk’s Stories on HackerNoon

Categories

Trending Topics