teleren/devto huggingface dataset:
AWS CodeWhisperer: The Free AI-based Coding Assistant for Developers
Tags: aws, ai, coding, machinelearning
Published: 2023-04-14 20:01:37

Exciting news! AWS has recently introduced an AI-based coding assistant called CodeWhisperer, which serves as an alternative to GitHub Copilot.

The best part is that CodeWhisperer is currently free for individual users.

CodeWhisperer offers intelligent code completion suggestions to developers, enabling them to write better code in a shorter time.

If you're seeking a new AI-based coding assistant, you should definitely give AWS CodeWhisperer a try.

For more detail [click here](https://aws.amazon.com/codewhisperer/).
37 berufliches Vorwärtskommen: Der uneigentliche Weg – Verläufer.
Tags: deutsch, career, motivation, 1min
Published: 2023-04-14 19:43:01

Moin Moin,

wir haben bereits [Erfolg betrachtet→](https://dev.to/amustafa16421/31-berufliches-vorwartskommen-der-eigentliche-weg-erfolgreiche-leute-4m48) und eine Weise des Scheiterns (1) – [den Misserfolg→](https://dev.to/amustafa16421/34-berufliches-vorwartskommen-der-eigentliche-weg-unerfolgreiche-leute-10hc). Hier geht es ums „Verlaufen“ auf dem Karriere-Weg.
Der wesentliche Unterschied zwischen Misserfolg und Verlaufen ist, dass Misserfolg auf dem Karriere-Weg geschieht, beispielsweise durch [mangelnde emotionale Intelligenz→](https://dev.to/amustafa16421/36-berufliches-vorwartskommen-der-eigentliche-weg-unausreichende-emotionale-intelligenz-12), während Verlaufen abseits vom Karriere-Weg geschieht.

Verlaufen ist selbstverständlich _nicht_, das bewusste ändern des Karriere-Wegs.

1. Kennst du Leute die abseits von ihrem eigentlich beabsichtigten Karriere-Weg  voranschreiten ( Verläufer )?
2. Wie meinst du kam es dazu? (2)
3. Wie scheint es dem Verläufer damit zu gehen?
4. Hast du dich selbst mal Verlaufen?

Beste Grüße,
Mustafa

Austausch mittels E-Mail: mustafa.kevin.dwenger@posteo.de
Betreff: Austausch

(1) „Scheitern“ kann ein Zwischenergebnis sein.
(2) Im nächsten Beitrag erwähne ich einiges was hiermit im Zusammenhang stehen kann.
How to Secure PostgreSQL Database – Tips and Tricks
Tags: postgres, database, dbforge, dbforgestudio
Published: 2023-04-14 19:04:09

Database security is an area where new challenges arise every day, and where you must not only respond to threats, but also focus all your efforts on risk prevention.

When talking about database security, it won't be enough to focus on just one or two methods. To begin with, let's take one of the most popular database management systems - PostgreSQL - https://blog.devart.com/how-to-secure-postgresql-database.html

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ssbex3kn5nzpo8vplwz7.jpg)
Normalization of Tables: From 3NF to BCNF
Published: 2023-04-21 20:23:33

---
title: Normalization of Tables: From 3NF to BCNF
published: true
date: 2023-04-14 18:45:31 UTC
tags: 
canonical_url: https://harshmange.hashnode.dev/normalization-of-tables-from-3nf-to-bcnf
---

The third normal form (3NF) ensures that a table is free from transitive dependencies, where non-key attributes depend on other non-key attributes. However, it is still possible for a table to have a set of attributes that depend on only a part of the primary key, which is known as a partial dependency. To address this issue, we can use Boyce-Codd normal form (BCNF) to further normalize the database.

Boyce-Codd normal form (BCNF) is a higher level of normalization than 3NF. It requires that every determinant (an attribute that determines the value of another attribute) in a table must be a candidate key. A table is in BCNF if and only if every non-trivial functional dependency in the table is a dependency on a superkey.

Let's continue with the example from the 3NF normalization. Suppose we have a table called "Departments" that contains information about each department and the books it contains:

| **Department** | **ISBN** |
| Fiction | 978-0316067928 |
| Fiction | 978-0316015844 |
| Fiction | 978-0547928227 |
| Fiction | 978-0590353427 |
| Science Fiction | 978-0312937385 |
| Science Fiction | 978-0451524935 |
| Science Fiction | 978-0345313157 |

This table is in 3NF because it is free from transitive dependencies. However, there is a partial dependency, where the "Department" attribute depends only on a subset of the primary key (ISBN). For example, the "Fiction" department is associated with four different ISBNs.

To normalize this table to BCNF, we need to split it into two tables. The first table, "Departments", will contain information about each department and its ID:

| **Department** | **DepartmentID** |
| Fiction | 1 |
| Science Fiction | 2 |

The second table, "DepartmentBooks", will contain information about each book and the department it belongs to:

| **ISBN** | **DepartmentID** |
| 978-0316067928 | 1 |
| 978-0316015844 | 1 |
| 978-0547928227 | 1 |
| 978-0590353427 | 1 |
| 978-0312937385 | 2 |
| 978-0451524935 | 2 |
| 978-0345313157 | 2 |

In this normalized database, each determinant (ISBN and DepartmentID) is a candidate key. Every non-trivial functional dependency in the table is a dependency on a superkey, which means that the table is in BCNF.

This normalization improves data consistency and maintainability, and reduces data redundancy by eliminating partial dependencies in the original table. However, it also increases the number of tables in the database, which can make it more complex to manage.
A Beginner's Guide to Searching for Elements in Arrays with JavaScript
Tags: javascript, beginnerfriendly, datastructures, linearsearchinjavascript
Published: 2023-04-14 19:03:07

Lets talk about searching an element in an array. There are various algorithm used for this purpose, but the one which I am going to discuss is **Linear Search**. Linear Search is simple and easy to understand. There is also a default javascript method for for linear search, will will talk about it later.

Linear Search is simple it uses a **for loop**, which loops through the given array and returns its index. If the index is a value then we know that the value exist , if its undefined then the value is absent.

```
  let data =[20,40,60,5,10,70,80,99];
        let item=70;
        let index=undefined;

        for(i=0;i<=data.length-1;i++){
             if(data[i]===item)
             {
                index=i;
                 break;
             }
         }
         console.log(index);

         // default method to search an element in array
         console.warn(data.indexOf(item))
```
 You can copy paste the above code and test it. 
The defualt funciton used of searching an element in array is `indexOf()` method. By passing the element that you have in array inside `indexOf()` method it will return its index.
Some interesting Github project to follow
Tags: osdc
Published: 2023-04-14 18:51:43

Hi all,
I took a walk on the trending project on Github so I could follow on interesting ones, and found the following projects:

[Auto-GPT](https://github.com/Torantulino/Auto-GPT) is an experimental open-source attempt to make GPT-4 fully autonomous. Spooky..

[AFFiNE](https://github.com/toeverything/AFFiNE) is a next-gen knowledge base that brings planning, sorting and creating all together. Privacy first, open-source, customizable and ready to use. much like Miro or Notion. 

[GoReplay](https://github.com/buger/goreplay)is an open-source tool for capturing and replaying live HTTP traffic into a test environment in order to continuously test your system with real data.

Will post more interesting founding in the coming weeks.

Cheers, 
Freddy
Futbol and a plain ruby project
Tags: webdev, ruby, beginners, devjournal
Published: 2023-04-14 18:47:30

Alright I have improved the code for my [Futbol project](https://github.com/cece-132/futbol).  This project focused a lot on organization of a very basic ruby app. I learned a ton about modules and inheritance and when it is appropriate to apply one over the other. 

I knew that the main difference is instantiation. A module does NOT need an object to be instantiated in order to use it. We are able to use them anywhere as long as the class has the module `include` syntax. This was helpful in this project for organization.

I didn't need to instantiate `team_statistics` objects in my opinion. I just wanted to be able to manage the behavior of the stat_tracker. 

Inheritance modifies the attributes of an object. The best way to explain this is the you can inherit your parents eye color. On the other hand if you mom went to see Boys II Men at 16. Just because your mother is your parent doesn't guarantee that you will also go to see Boys II Men at 16. 

This is an important distinction when we are trying to decide how to organize our code.
#DEVDiscuss: Rethinking the Modern Web
Tags: devdiscuss, webdev, frontend, react
Published: 2023-04-14 18:40:19

Hey Devs, happy Friday 🦥💚

As always, it's been an eventful week in the tech industry. We've got a lot to talk about! And today I want to discuss...

{% embed https://dev.to/oxharris/rethinking-the-modern-web-5cn1 %}

This post by @oxharris about the state of the sprawling frontend ecosystem 😳😅 

Check out these quotes from the post:
> So it turns out, all of that "vibrant ecosystem" isn't really translating to more "accessible", "functional" apps on the user front, and neither to more "speed" and "productivity" on the developer front!

> The closer you get to Frontend's bottlenecks and to how much of that is tooling-induced the more you are wondering if we just have created more problems with our tools than we've solved!

So...what do you think? 🤔
Video: Accelerate Transformer inference with AWS Inferentia 2
Tags: transformers, hardware, nlp, deeplearning
Published: 2023-04-15 17:09:09

---
title: Video: Accelerate Transformer inference with AWS Inferentia 2
published: true
date: 2023-04-14 18:37:47 UTC
tags: transformers,hardware,nlp,deeplearning
canonical_url: https://julsimon.medium.com/video-accelerate-transformer-inference-with-aws-inferentia-2-6ee531e001f2
---

AWS Inferentia2 is now generally available, and I couldn’t resist testing it with BERT models and comparing results with Inferentia1.

This thing is FAST and looks very cost-effective. Check it out!

{% youtube xyekH12vm0Y %}
How to Connect to MySQL Remotely with SSH PuTTY Tunnels: A Step-by-Step Guide
Tags: mysql, database, dbforge, dbforgestudio
Published: 2023-04-14 18:37:26

Let's take a quick look at the SSH protocol and tunnel, and see how to remotely connect to a MySQL server using an SSH tunnel created with PuTTY, a popular Windows SSH client - https://blog.devart.com/connecting-to-mysql-with-putty-and-ssh-tunnels.html

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cu0ec24xbubdcqtigmz3.jpg)
May the Source Be With You!
Tags: puppet, community, maythefourth, hackathon
Published: 2023-04-14 18:31:08

Did you know that Luke Skywalker only uttered the iconic _May the Force be with you!_ phrase once? It was offscreen, as Lando and Chewbacca headed out to find Boba Fett and rescue Han Solo. In any case, it’s that time of year again and we’d love to spend Star Wars Day with some of our favorite people—you!

Our first annual _May the Source Be With You_ virtual hackathon will happen on May 4th and focuses on improvement to our developer tooling ecosystem. Do you have a pet peeve about the PDK, `rspec-puppet`, `puppet-lint`, the Puppet VSCode extension, or any other tool you use when building Puppet code? Join forces with us to jump in and help defeat those pain points, while growing your own software development skills deeper than writing Puppet code.

## [Sign up here!](https://forms.gle/Fg6BRUynBHMrtuMx5)

We’ll have engineers on hand to guide you through the process, help you understand the codebase, and answer any questions you might have. If you want to help out, but don’t have something in mind already, we’ll have some great beginner friendly tickets to get started on.

A little birdie says that you might even get a bit of exclusive swag for participating, too!

Our long-term goal for this event is to level up more people to help collaborate on these tools. The people who best know the pain points are those who use them every day, and that might be you. We would like to give you the expertise to help us solve these pain points and make building Puppet modules a far more pleasant experience!

Watch this space for more information, and we really hope to see you there.

## Date:
May 4th, 2023

## Times:
This is a global event but we will have two different kick-off sessions, join the session that works best for you:

* [PDT: 10am - 6pm](https://www.timeanddate.com/worldclock/converter.html?iso=20230504T170000&p1=202&p2=179&p3=919&p4=79&p5=3332&p6=236&p7=240)
* [CEST: 10am - 6pm]( https://www.timeanddate.com/worldclock/converter.html?iso=20230504T080000&p1=202&p2=179&p3=919&p4=79&p5=3332&p6=236&p7=240)

## [Sign up here!](https://forms.gle/Fg6BRUynBHMrtuMx5)
ref #1
Tags: chatgpt, refactoring
Published: 2023-04-14 18:21:38

[https://david.coffee/refactoring-code-with-chat-gpt/](https://david.coffee/refactoring-code-with-chat-gpt/)

[https://medium.com/@neonforge/chatgpt-for-developers-how-to-comment-and-refactor-your-code-and-generate-readme-files-324f4e742490](https://medium.com/@neonforge/chatgpt-for-developers-how-to-comment-and-refactor-your-code-and-generate-readme-files-324f4e742490)
For all those devs who are just starting out
Tags: javascript, react, opensource, github
Published: 2023-04-14 18:16:28

Hello everybody!

I want to share this project with you: https://github.com/ezequielbugnon/interview-challenges. The idea is that it can be of great help to everyone looking to improve their programming skills and prepare for technical interviews and start contributing to Open-source projects.

This repository is still in its early stages but I aspire to add a wide variety of programming challenges that cover a wide range of topics from algorithms and data structures to coding problems. Each challenge is designed to test your programming skills and help you improve in specific areas.

In addition, each challenge is linked to solutions provided by anyone who collaborates on this project. I think it can be a great tool for all junior developers.

How to collaborate:

You can provide solutions to existing challenges.
Add new coding challenges.
New features to the design (now in early stages).
Add documentation. Any type of contribution is welcome.


If you are looking to venture into Open-source or solve a technical challenge you don't know where to start, this is a good place, everyone is welcome. Don't hesitate to take a look.
PHP তে Hello, World!
Tags: php, webdev, programming, beginners
Published: 2023-04-14 18:04:12

আজ আমরা দেখবো কিভাবে PHP তে কোড লিখে ওয়েব ব্রাউজারে Hello, World! দেখা যায়।

শুরুতেই আমরা xampp ফোল্ডারে থাকা htdocs এর ভেতর একটি helloworld নামে ফোল্ডার ক্রিয়েট করে তার ভেতর index.php নামে একটি ফাইল নিই। এবার এই ফাইলটা আমাদের কোড এডিটরে ওপেন করে নিচের কোডটুকু লিখে ফেলি।
কোড -

```
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>PHP</title>
</head>
<body>
<h1><?php echo 'Hello, World!'; ?></h1>
</body>
</html>
```

আমরা এবার আমাদের xampp সফটওয়্যারটি ওপেন করে Apache এবং MySQL Start করে নিই। এরপর আমাদের ওয়েব ব্রাউজারে গিয়ে এই লিংকটি প্রেস করে দিলাম localhost/helloworld এবং দেখতে পেলাম Hello, World! লেখাটি প্রিন্ট হয়েছে।

এখন আমরা বুঝবো কিভাবে কি হল! উপরে HTML কোডে PHP লেখা হয়েছে যা h1 ট্যাগের মাঝে। <?php হচ্ছে PHP এর ওপেনিং ট্যাগ এবং ?> হচ্ছে ক্লোজিং ট্যাগ। আর echo হচ্ছে প্রিন্ট করার জন্য একটি স্টেটমেন্ট। এরপর 'Hello, World!' হচ্ছে একটা স্ট্রিং। স্ট্রিং নিয়ে সামনে আলোচনা হবে তাই আপাতত আমরা এই বিষয়টা স্কিপ করে যাচ্ছি। আর ‘’ এর ভেতরে থাকা কথাগুলাই আমরা ওয়েব পেইজে দেখতে পাচ্ছি এবং ; দিয়ে বুঝানো হয়েছে যে, স্ট্রিং টা এখানেই শেষ হয়েছে। মূলত PHP এই Hello, World! কথাটাই কোডের মাধ্যমে ওয়েব পেইজে প্রিন্ট করেছে। আমরা আরো একভাবে প্রিন্ট করতে পারি, যদি আমরা index.php ফাইলের ভেতরই কোড লিখি তাহলে ক্লোজিং ট্যাগ না লিখলেও হবে। আমরা শুধুই PHP তে লিখবো এবং ব্রাউজারে দেখবো। অতএব কোডটা হল -
<?php
echo 'Hello World!';
তবে, যেহেতু আমরা এবার আর HTML এর h1 ট্যাগে কোড লিখি নাই তাই ব্রাউজারে আমরা h1 এর ডিফল্ট টেক্সট স্টাইল পাবো না এমনকি পেইজের টাইটেলও নাই যা আমরা পরবর্তী কোডে লিখিই নাই। আর অবশ্যই, প্রথমবারের কোডটুকু কমেন্ট করে নিবেন এবং দ্বিতীয়বারের কোড লিখার পর ব্রাউজারে গিয়ে একটা রিলোড দিয়ে নেবেন।

তো এভাবেই আমরা PHP তে কোড লিখে ওয়েব ব্রাউজারে Hello, World! দেখতে পারি। আশা করছি আজকের টপিকটা ভালো লেগেছে, ধন্যবাদ।
#PHP 💻 03
How to Use MySQL LEAD and LAG Analytical Functions
Tags: mysql, database, analyticalfunction, dbforgestudio
Published: 2023-04-14 18:00:11

Let's take a look at the LEAD and LAG functions, powerful analytic tools that are often used in MySQL, a popular database management system for many web applications - https://www.devart.com/dbforge/mysql/studio/mysql-lead-and-lag-analytical-functions.html

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/52t19nw5ae8fic6td7nr.jpg)
PHP কি
Tags: php, webdev, programming, beginners
Published: 2023-04-14 17:55:10

আমরা এই টিউটোরিয়াল থেকে যা জানতে চলেছি -
১) PHP কি,
২) এটি কিভাবে কাজ করে,
৩) এটি কি কি করতে পারে এবং
৪) এর সুবিধাগুলো

PHP হল একটি সার্ভার সাইড ল্যাঙ্গুয়েজ যা সাধারণত ওয়েব অ্যাপ্লিকেশন তৈরি করতে, ওয়েব ডেভেলপমেন্টের কাজে ব্যবহৃত হয়, যার ফুল ফরম হচ্ছে - Hypertext Preprocessor.
১৯৯৪ সালে Rasmus Lerdorf পিএইচপি তৈরি করেছেন। তবে, বর্তমানে PHP Development Team দ্বারা এটি পরিচালিত হয়। যখন আমরা আমাদের ওয়েব ব্রাউজারে একটি ওয়েবসাইট ওপেন করি তখন ওয়েব ব্রাউজার ওয়েব সার্ভারকে একটি HTTP Request প্রেরণ করে, যেখানে ওয়েব সাইট’টি রয়েছে। এরপর ওয়েব সার্ভারটি Request গ্রহণ করে একটি HTML Document দিয়ে রেসপন্স করে। চট করে একটি উদাহরণ দেয়া যায়, মনে করি ওয়েব ব্রাউজার হল একটি ক্লায়েন্ট এবং ওয়েব সার্ভার হল একটি সার্ভার। এখন এই ক্লায়েন্ট একটি পেইজ’এর জন্য Request পাঠায় এবং তা ওয়েব সার্ভার পূর্ণ করে দেয়। PHP ওয়েব সার্ভারের ভেতর Run করে, Request’কে Processes করে এবং একটি HTML Document রিটার্ন করে। PHP একটি General-purpose Language. PHP একটি Cross Platform Language কারণ এটি প্রায় সব Major Operating System’এ চলতে পারে, যেমন - Linux, Windows, macOS এসব। PHP প্রায় সকল Leading ওয়েব সার্ভার যেমন - Nginx, OpenBSD, Apache’তে ব্যবহার করা যায় এবং এছাড়াও কিছু Cloud Environment’ও PHP support করে যেমন - Microsoft Azure, Amazon AWS ইত্যাদি। PHP কেবলমাত্র HTML প্রসেস করেই সীমিত নয়। PDF, GIF, JPEG এবং PNG তৈরির জন্য PHP’এর নিজস্ব Built-in Support আছে। একটি লক্ষণীয় বৈশিষ্ট্য হল, PHP একাধিক ডাটাবেস সমর্থন করে, যেমন - MySQL, PostgreSQL, MS SQL, db2, Oracle Database এবং MongoDB’এর মতো ডাটাবেস। PHP’র দুটি প্রধান ব্যবহার রয়েছে - একটি Server-side Scripting ও অন্যটি Command-line Scripting.

PHP যেভাবে কাজ করে -
১) ওয়েব ব্রাউজার ওয়েব সার্ভারে একটি HTTP Request পাঠায়।
২) ওয়েব সার্ভারে থাকা PHP প্রিপ্রসেসরটি PHP কোড প্রসেস করে HTML Document তৈরি করে।
৩) ওয়েব সার্ভার এই HTML Document’টি ওয়েব ব্রাউজারে ফিরিয়ে দেয়।

PHP’র সুবিধা -
১) PHP ওয়েবসাইট সাধারণত খুব দ্রুত Load হয়।
২) PHP খুবই Stable একটি Language
৩) পিএইচপি ওপেন সোর্স এবং বিনামূল্যে ব্যবহার করা যায়।
৪) PHP’র Active Online Community রয়েছে।
#PHP 💻 01
Eftpos Mobile
Published: 2023-04-14 17:22:09

EFTPOS Now is an innovative payment service that enables you to quickly and securely pay for goods and services with just your mobile phone. With [Eftpos mobile](https://www.eftposnow.co.nz/mobile-eftpos-for-hire/), there’s no need to carry around cash or worry about security issues associated with using debit or credit cards. You can simply tap your phone against any compatible contactless terminal to pay directly from your bank account.
Enhance your portfolio: Show your Github repositories as posts in a blog using Github API
Tags: github, portfolio, programming, productivity
Published: 2023-04-14 17:03:08

Some time ago, I decided to build a portfolio application to show my previous work and skills. For that, naturally, I would like to share some code samples.

Since these code samples are all available on repositories at my Github Profile, so why do not use them? 

After two minutes of research, I ended up on [GitHub API](https://docs.github.com/en/rest) documentation and [this is the result](https://sarahjobs.com/code-samples).

**Steps**

The first step was to create the component SliderGit.js. On this component, we will use the famous React hooks useEffect and useState, so we need to import them:

```
import React, { useEffect, useState } from 'react';
```

Then, we need to initialize the state which will hold the repositories information and the loading state

```
const [repo, setRepo] = useState ([]);
```

In the SliderGit.js component, we will get the data from GitHub. I could use two different methods of making network requests: either Fetch or Axios. I decided to use Fetch, as you can see below:

```
// SliderGit.js

 useEffect( () => {
        fetch ('https://api.github.com/users/sarahcssiqueira/repos')
        .then ((res) => res.json())
        .then ((res) => {setRepo(res);
        });
    },
```

Then, I like to console log:

```
console.log(repo);
```

As everything is working as expected:

```
return (
        <section className='articles'>
        {repo.map((repo) => {
          return (
            <article key={repo.id}
                     className="article">
                <Link to={repo.svn_url}
                      className=''>
                      {repo.name}
                </Link>
                <p className=''>
                   {repo.description} 
                  <Link to={repo.svn_url} 
                        className=''> 
                        <BsBoxArrowUpRight/>
                  </Link>
                </p>
                <ul>
                  <li className=''>
                        <BsCalendarDate/>
                        {' '}
                        {new Date(repo.created_at).toDateString()}
                    </li>
                </ul>
                <ul>
                    <li className=''>
                        <AiFillTag/> {' '}
                        {repo.topics}{' '}
                    </li>
                </ul>
                <section className=''>
                  <p className=''>
                    <BsStar className=''/>
                      {' '}
                      {repo.stargazers_count}
                  </p>
                  <p className=''>
                    <VscRepoForked className=''/>
                    {' '}
                    {repo.forks_count}
                  </p>
                </section>
            </article>
            )})}
    </section>
```

The result can be seen at my portfolio on [code samples page](https://sarahjobs.com/code-samples).