teleren/devto huggingface dataset:
VSCode Extensions I'm in LOVE with 2.0
Tags: vscode, beginners, programming, productivity
Published: 2023-06-06 18:42:35

[Auto Commit Message](https://marketplace.visualstudio.com/items?itemName=MichaelCurrin.auto-commit-msg)
Starting from an empty commit message, the extension created a recommended message and populated it inside the Git pane of VS Code

![Auto Commit Message](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5qvw96aohfpdelnpj0zw.png)

[To Do Tasks](https://marketplace.visualstudio.com/items?itemName=sandy081.todotasks)
Create a new file and save with todo or tasks file extension.

![To Do Tasks](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bhsqq0bbzu6zj2zxsq7z.png)

[Snippets](https://marketplace.visualstudio.com/items?itemName=tahabasri.snippets)
Code snippets are great additions to anyone who wants to save time while developing. They make it easier to enter repeating code, such as loops, complex HTML structures or reusable methods.

Visual Studio Code already has great support for snippets, including snippets appearance in IntelliSense (Ctrl+Space), tab-completion, as well as a dedicated snippet picker (Insert Snippet in the Command Palette).

![Snippets](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kl54lkvjpnevv3e8qhc6.png)

[Tabnine AI Autocomplete](https://marketplace.visualstudio.com/items?itemName=TabNine.tabnine-vscode)
Tabnine is an AI code assistant that makes you a better developer. Tabnine will increase your development velocity with real-time code completions in all the most popular coding languages and IDEs.

Whether you call it IntelliSense, intelliCode, autocomplete, AI-assisted code completion, AI-powered code completion, AI copilot, AI code snippets, code suggestion, code prediction, code hinting, or content assist, using Tabnine can massively impact your coding velocity, significantly cutting down your coding time.

![Tabnine AI Autocomplete](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fwnobra3dg1tm3zglggg.png)

[MySQL](https://marketplace.visualstudio.com/items?itemName=formulahendry.vscode-mysql)
MySQL management tool.

- Manage MySQL Connections (support SSL connection)
- List MySQL Servers
- List MySQL Databases
- List MySQL Tables
- List MySQL Columns
- Run MySQL Query

![MySQL](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/y8inyombe99luy7loorw.png)

**A cute mention**
[vscode-pets](https://marketplace.visualstudio.com/items?itemName=tonybaloney.vscode-pets)
Digital rubber "ducks" for your VSCode environment.

![vscode-pets](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4v1imt5n0fj4oz69fved.png)


Happy coding!
Working with Modal has never been this easy!!!
Published: 2023-06-06 18:34:15

Create a modal with just HTML using a dialog tag. Here is the complete code:

```
<html>
  <head>
    <style>
      #dialog {
        width: 400px;
        padding: 20px;
        background-color: #f1f1f1;
        border: 1px solid #ccc;
        border-radius: 4px;
      }

      #dialog h2 {
        color: #333;
        font-size: 18px;
        margin-bottom: 10px;
      }

      #dialog p {
        color: #555;
        font-size: 16px;
        margin-bottom: 20px;
      }

      #close {
        background-color: #ddd;
        border: none;
        padding: 10px 20px;
        color: #333;
        font-size: 14px;
        border-radius: 4px;
        cursor: pointer;
      }

      #close:hover {
        background-color: #bbb;
      }
    </style>
  </head>

  <body>
    <button onclick="openDialog()">Open Dialog</button>
    <dialog id="dialog">
      <h2>Dialog Title</h2>
      <p>This is the content of the dialog box.</p>
      <button onclick="closeDialog()">Close Dialog</button>
    </dialog>

    <script>
      function openDialog() {
        document.getElementById("dialog").showModal();
      }
      function closeDialog() {
        document.getElementById("dialog").close();
      }
    </script>
  </body>
</html>
```
How to search for text in a SQL Server stored procedure, function, or view?
Tags: mssqlserver, tsql
Published: 2023-08-30 18:54:59

---
title: How to search for text in a SQL Server stored procedure, function, or view?
published: true
date: 2023-06-06 18:30:00 UTC
tags: MSSQLServer,TSQL
canonical_url: http://www.codetolive.in//ms%20sql%20server/how-to-search-search-for-text-in-a-SQL-Server-stored-procedure-function-or-view/
---

You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.

**_Code:_**

```
SELECT	DISTINCT o.name AS Object_Name, o.type_desc
FROM sys.sql_modules m
INNER JOIN	sys.objects o ON m.object_id = o.object_id
WHERE m.definition Like '%search term%'

```

![](http://www.codetolive.in/assets/images/posts/Codetolive_blog_search_text_in_sql_server.png)
_Fig 1. Search text in stored procedure, function and view using t-sql_
Perfect Code Makes Everyone Lose
Tags: programming, productivity, career, softwareengineering
Published: 2023-06-06 18:07:35

Perfect code may seem like the ideal goal, but aiming for it can actually lead to loss for everyone involved.

## Why?

It sucks up time and resources like a black hole.

Longer hours of work? Check. Higher costs? Double check.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4b63xbeekdusu6n3s9x7.jpg)

It's a quick ticket to burnout and a slow ticket to progress.

While you're busy polishing every bit of your code, important tasks get left in the dust. Does it make you a coding superstar? Nope, just a worker ant stuck in the endless cycle of 'improvements'.

Your team? Stuck trying to decode your masterpiece instead of pushing the project forward. And all for what? A shiny, 'perfect' code that took twice the time and money it should've?

Here's a hint: aim for 'good enough'. It's fast, it's cheap, and it does the job. No hassle, no waste. Just effective problem-solving.

## But what is ‘good enough’ anyway?

I've got a simple checklist:
1. **Does the code meet the spec?** Write code, make sure it meets the requirements and move on.
2. **Does the code follow your codebase rules?** Keeping things consistent is a must for easy reading and maintaining. Use linters and formatters to automate code convention checks.
3. **Does the code pass the tests?** Well, that's if you've got tests to begin with. If not, trying to introduce them outside of the task's initial scope isn't a wise move.
4. **Does the code smell... not too much?** This is going to be specific to your particular case, trust your gut feeling.

As long as you stick to these simple checks, you should be fine. Just don't over-engineer.

## But what is over-engineering?
Over-engineering is like building a spaceship when all you needed was a bike. It's when you take a simple task and inflate it with complexity that isn't necessary.

Maybe you find yourself continuously refactoring the code you've just written, or messing with parts of the code that weren't part of the original problem. Or, adding unnecessary features for a future that may never come. These are flashing red lights on the road from 'good enough' to over-engineering.

Remember, it's about solving the problem at hand, not crafting a masterpiece for the ages.

------------

If you have something to add, please leave a comment.

Follow me on [Twitter](https://twitter.com/mishgun_eth) and connect on [LinkedIn](https://www.linkedin.com/in/mikhail-malyshev-030395237/).
RESTful vs RESTless systems
Tags: webdev, api, architecture, beginners
Published: 2023-06-06 17:49:33

## What is REST?
REST, or Representational State Transfer, is an architectural style for designing distributed hypermedia systems. It is based on the use of HTTP verbs to represent different actions, such as: 
- **GET** for retrieving data
- **POST** for creating data
- **PUT** for updating data, and 
- **DELETE** for deleting data

**RESTful systems** use URIs to identify resources, and they use HTTP headers to provide additional information about the resource, such as its content type.

### Advantages of using RESTful systems:
1. **Scalability**: RESTful systems are scalable because they are based on the use of HTTP, which is a well-established and widely-supported protocol.
2. **Flexibility**: RESTful systems are flexible because they can be used to create a wide variety of applications.
3. **Reusability**: RESTful systems are reusable because they can be used to create different parts of an application independently.

**RESTless systems** are not fully RESTful. They may use HTTP verbs and URIs, but they may not use them in a consistent way. For example, a RESTless system might use the GET verb to create data, or the POST verb to retrieve data.

Hence, **RESTful** is a great choice for building web services. It is easy to learn and use, and it provides a solid foundation for building scalable and maintainable applications. If you are looking for a way to build web services, I highly recommend using **RESTful**.
Configuring Git on a Directory Level
Tags: git, tutorial, productivity
Published: 2023-06-06 17:11:03

When we talk about Git configurations, there are typically three levels we consider: 

1. **System-level configuration**: This is applicable to every user on the system and all their repositories.
2. **Global-level configuration**: This is user-specific and applies to all repositories under the user.
3. **Repository-level configuration**: This is repository-specific and applies to the specific repository only. It's defined in `.git/config` in the root directory of the repository.

However, what if you want to have a configuration that applies to all repositories within a specific directory, but not elsewhere 🤔 Unfortunately this is not natively supported by Git 🫤, but there is a workaround using the `includeIf` directive 🤩.

## Directory-level Git Configuration with `includeIf`

The [`includeIf`](https://git-scm.com/docs/git-config#_includes) directive was introduced in Git version 2.13.0. It allows for conditional inclusion of configuration files based on the repository's path. We can use this feature to simulate directory-level Git configurations. Here's how to do it:

- **Create a directory-specific config file**

   First, create a `.gitconfig` file in the directory where you want to apply directory-level configurations. In this file, you can specify your configurations.

   For example, let's say you create a file at `/path/to/your/directory/.gitconfig`:

   ```
   [user]
       name = Directory Specific Name
       email = directory@email.com
   ```

- **Update your global config file to include the directory-specific file**

   Next, you need to update your global `.gitconfig` file to include the directory-specific file when in the specified directory. You can do this using the `includeIf` directive.

   Edit your `~/.gitconfig` file (or create it if it doesn't exist) and add the following:

   ```
   [includeIf "gitdir:/path/to/your/directory/"]
       path = /path/to/your/directory/.gitconfig
   ```

Now, whenever you're working in `/path/to/your/directory/` or any of its subdirectories, Git will apply the configurations from `/path/to/your/directory/.gitconfig` 🎉.

## Conclusion

The `includeIf` directive provides a powerful way to handle Git configurations. While it's not a native solution for directory-level configurations, it's a practical workaround for when you need different configurations for different project groups, especially when these groups are organised in separate directories.

Remember, the `includeIf` directive was added in Git 2.13.0, so make sure you have a compatible version of Git installed.
Happy Gitting 💻!
Re: using Sqlite for Dev and Postgres for Production
Published: 2023-06-06 17:08:41

> Using Sqlite locally, Postgres in production. New feature is slow -- will this persist in production, or is it a Sqlite thing?

-- [Reddit /r/django thread](https://www.reddit.com/r/django/comments/142gphd/big_database_slow_in_dev_sqlite/)

The slowness will almost definitely persist when deploying to Postgres. Use a tool to measure performance. Two million objects is no big deal.

Consider switching to Postgres on local development. **Any "drift" between production and local is a risk.** We did the "sqlite for dev, Postgres for prod" thing and sometimes bugs would only appear in production, which made them much harder to track down. Sqlite has ~~loose~~ [flexible typing](https://www.sqlite.org/flextypegood.html). This can be disabled, if you want to keep Sqlite local. This will mitigate the risk somewhat and it's an easy change.

Other people on Reddit are like "Sqlite is a toy", I strongly disagree. It's 10x faster than Postgres - with limitations - and usable for 90% of use cases. The fact you're using two different databases for dev and prod is a risk, but not critical.

Source: I'm a Dev/DevOps consultant.
Static IP for AWS HA Architecture
Published: 2023-06-05 17:58:32

In a situation where the client requires IP to point their domain name in their respective DNS but the client Architecture involve Application Load balancer as the entry-point for the users. 

Here the application load balancer only have public resolving DNS name which won't meet the client requirement. Hence we have two options. Our initial thought process will go to the option no 1 using an NLB in-front of the ALB. However, in Network Load Balancer also we either need to attach Elastic IP or it will provide IP's from the AWS ip pool. 

The tricky part is that, the architecture needs to be highly available so we will attach the NLB to two or more availability zones. This steps will give us two or three IP's depending on the number of availability zones. Aws recommends to use the DNS endpoint here also but to meet our situation we take these IP. But in a situation like this the DNS end needs to take care of the routing of traffic to these IP by checking its availability which is not our case. 

So the best solution here is provide the Global Accelerator. We can integrate the same from the Application Load Balancer itself or we can create from the Global accelerator dashboard. 

This will give us two static ip with a public dns endpoint. We can use the IP to point the domain. This IP act as the entry point for the users and the GA will load the application from close region. Since here we are dealing with only one region we can skip the region routing part of GA.
Ispolink Platform Pekerjaan yang Memanfaatkan Blockcahin & AI
Tags: webdev, cryptocurrency, web3, blockchain
Published: 2023-06-06 16:51:33

## [Ispolink Platform Pekerjaan yang Memanfaatkan Blockcahin & AI](https://www.portalcrypto.xyz/2023/05/apa-itu-ispolink-dan-apa-kegunaan-platform-ispolink.html)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/f0sin0lwzolphsgeoe2d.jpg)

Untuk mengatasi salah satu tantangan mendasar yang dihadapi bisnis saat ini menemukan karyawan yang memenuhi syarat, Ispolink memperkenalkan platform pekerjaan perjodohan siklus penuh yang menyederhanakan dan meningkatkan proses perekrutan, memanfaatkan teknologi canggih Blockchain dan AI untuk memungkinkan efisiensi biaya dan waktu rekrutmen internal.

Ispolink bertujuan untuk memberdayakan bisnis yang beroperasi di blockchain dan Industri TI untuk mencari dan menarik talenta terbaik dengan menawarkan kepada mereka seperangkat alat yang komprehensif untuk mengelola seluruh proses rekrutmen secara internal termasuk penyaringan dan seleksi, melakukan berbagai tahapan wawancara, penilaian dan evaluasi yang dapat dilaksanakan dalam platform.

Semua ini dapat dikelola dengan mulus di panel dasbor perusahaan, yang memastikan kelancaran transisi antar tahapan, peningkatan visibilitas untuk pemangku kepentingan internal, penyederhanaan proses perekrutan dan otomatisasi. Dengan cara ini, organisasi akan dapat mengambil kendali penuh atas proses perekrutan mereka dan sangat meningkatkan aliran informasi, penilaian dan pemilihan prospek mereka tanpa mengalihkan pekerjaan penting ini ke pihak ketiga.
Solusi Ispolink
Kami percaya bahwa sangat penting untuk mengalokasikan dan menarik sumber daya manusia secara efisien karena mereka merupakan aset terbesar yang mungkin dimiliki perusahaan.

Source: [www.portalcrypto.xyz](https://www.portalcrypto.xyz/2023/05/apa-itu-ispolink-dan-apa-kegunaan-platform-ispolink.html)
Summoning a Full Stack Developer: Is it One Person or a Tech Army?
Tags: webdev, programming, career, discuss
Published: 2023-06-06 16:47:18

Dear weary recruiters, ever sought after a mythical creature that's part Java guru, part AWS wizard, part Python charmer? Hint: you're shopping for an entire IT department, not a 'Full Stack Developer'.

Greetings, noble recruiters on the quest for the elusive Full Stack Developer. In this realm of tech wizardry, this term has become somewhat of a modern unicorn - rumored to exist, yet strangely hard to locate. Why, you ask? Buckle up, for I am about to burst your fantasy bubble.

Firstly, let's talk about Java, Python, PHP. Such languages, so much diversity! You desire a polyglot savant, someone who can, in the dead of night, while possibly cooking a three-course meal, code proficiently in all these languages. That's like expecting one person to pen a novel in English, Spanish, and Mandarin simultaneously. Simple, right?

Now, let's waltz into the enchanting land of React and Angular. A realm where folks speak only in components and directives. It's a delicate dance, the JavaScript frameworks tango. You're not just asking for someone who can do the steps, but also a choreographer, lighting designer, and costume designer all rolled into one. Dancing with the Stars has nothing on this.

Onward to the mysterious realm of databases - PostgreSQL, Reds, MongoDB. Here, your Full Stack Developer unicorn needs to navigate the vast terrain of data jungles. Think Indiana Jones in khakis, cracking the whip at poor, unsuspecting SQL queries.

Then, there’s the ubiquitous AWS with its loyal knights S3, EC2, ECS, EKS. Are we seeking a Full Stack Developer or a full-on cloud god? A deity who can summon thunderous instances and gentle storage buckets from the infinite ether, all while juggling Linux system administration duties. Easy peasy!

What's this now? You say you also need a champion of Git, CI, TDD, Docker, Kubernetes? That's like asking for a symphony conductor who can play every instrument while simultaneously tuning them, and oh, writing the symphony as well.

So recruiters, let's clarify. What you seek isn’t a Full Stack Developer, that mystical tech creature, but an entire IT department. Yes, a fully staffed, caffeine-fueled, keyboard-tapping, code-deploying IT department. But, by all means, continue your pursuit for that one-size-fits-all tech guru. We'll grab the popcorn.
The Lost and Found Gravel Festival – June 2023
Tags: life, sport, bike, friends
Published: 2023-08-15 21:59:44

---
title: The Lost and Found Gravel Festival – June 2023
published: true
date: 2023-06-06 16:27:49 UTC
tags: life,Sport,bike,friends
canonical_url: https://greenido.wordpress.com/2023/06/06/the-lost-and-found-gravel-festival-june-2023/
---

[![](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.25.05-am.png?w=676)](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.25.05-am.png)

> “Your real resume is just a cataloging of all your suffering.”

The most interesting and rewarding parts of our lives are often the ones that have required the most sacrifice and hard work. When we suffer (e.g. during rides/runs), we are forced to confront our weaknesses and limitations.   
We learn to be resilient and resourceful.   
We develop new skills and abilities.   
We grow.   
In the process, we create a more meaningful life.  
If you can keep your smile – bonus points.

{% youtube BxNxZvHWzTE %}

[![](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.26.58-am.png?w=999)](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.26.58-am.png)

It was a challenging and beautiful route with some actual MTB sections.   
The weather was perfect, and the course was beautiful.   
Overall, excellent organization: route, food, 🍺 and great vibes.  
Gravel is the new hot thing for a good reason.

If you wish to learn more about this wonderful event – check their [website](https://lostandfoundbikeride.com/lost-and-found/about.php).

As we know: “Peace is happiness at rest, and happiness is peace in motion.”

So we did another peace in motion recovery ride that day after the event:

{% youtube OCXgRQSykEg %}

[![](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.26.46-am.png?w=1024)](https://greenido.files.wordpress.com/2023/06/screenshot-2023-06-06-at-9.26.46-am.png)

…and if you wish the video with some good background music:

{% youtube Yw2jX--GR8M %}
How to Create a Bootable USB for Kali Linux on Windows 10
Tags: linux, tutorial, howto, devops
Published: 2023-06-06 16:25:52

## Requirements for Creating a Bootable USB

Before proceeding with the methods, ensure you have the following:

**Windows operating system:** The methods covered in this article are specific to Windows.
**Kali Linux ISO:** Download the Kali Linux ISO file from the official website (https://www.kali.org/downloads/) .
**USB drive:** Use a USB drive with sufficient storage capacity (at least 8GB) to accommodate the Kali Linux ISO and create a bootable environment.

## Method 1: Using Rufus

Rufus is a popular and user-friendly tool for creating bootable USB drives. Here’s how you can use Rufus to create a bootable USB for Kali Linux:

1. Download and install Rufus from the official website.
2. Insert your USB drive into the computer.
3. Launch Rufus and select your USB drive from the “Device” dropdown menu.
4. Under the “Boot selection” section, click on the “Select” button and browse to the location where you saved the Kali Linux ISO file.
5. Ensure that the partition scheme is set to “MBR” and the file system is set to “FAT32.”
6. Click the “Start” button to initiate the process. Rufus will format the USB drive and copy the Kali Linux ISO contents onto it.
7. Once the process is complete, you will have a bootable USB drive for Kali Linux.

## Method 2: Using Etcher

Etcher is another straightforward tool for creating bootable USB drives. Follow these steps to use Etcher:

1. Download and install Etcher from the official website.
2. Insert your USB drive into the computer.
3. Launch Etcher and click on the “Select image” button.
4. Browse to the location where you saved the Kali Linux ISO file, select it, and click “Open.”
5. Etcher will automatically detect your USB drive. If it doesn’t, click on the “Change” button and select your USB drive.
6. Click on the “Flash!” button to start the process. Etcher will format the USB drive and write the Kali Linux ISO contents onto it.
Once the process is complete, you will have a bootable USB drive for Kali Linux.
[Read More](https://hackreveal.com/how-to-create-a-bootable-usb-for-kali-linux-on-windows-10/)