teleren/devto huggingface dataset:
ChatGPT helps to fix errors in SQL code
Published: 2023-02-20 19:53:09

Say hello to the newest addition to the world of artificial intelligence – ChatGPT! You may have heard of this innovative project before, but did you know that it can help you with your technical SQL questions? That's right, with ChatGPT's help, you can now make the most out of your SQL queries.

Introducing [SQLize.online](https://sqlize.online) – an online SQL playground that has integrated ChatGPT as its virtual assistant. Integrating the chatbot into the platform's API was a relatively easy task, but fine-tuning the chatbot's responses was a different story. It took considerable time and effort to make sure the chatbot's answers were accurate and easy to understand.

With ChatGPT's help, you can now get answers to your technical SQL questions without ever leaving the SQL playground. Simply type in your question, and ChatGPT will do the rest. 

![SQL question answered by GPT](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/j5j7grgmywi7ka8ex2hk.png)

The AI assistant can even help you correct any mistakes in your SQL queries with just one click of a button! Take a look at the example below, which shows how ChatGPT can help you correct mistakes in your SQL code:


![SQL error screenshot](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/l0b0s90gwu9xwtwbdhe8.png)

![GPT solution](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lfi5ffucw8qd5a5eljqw.png)

ChatGPT is truly a game-changer when it comes to finding and fixing errors in your SQL code. Not only does it save you time and effort, but it also helps you become a better SQL developer by providing you with accurate and optimized solutions.

While ChatGPT is still a relatively new technology, it has already made a significant impact in the world of SQL. As with any new technology, there may still be some room for improvement, but we're confident that ChatGPT will continue to evolve and improve over time.

In conclusion, if you're looking to optimize your SQL development process and become a more efficient developer, ChatGPT is the perfect tool for you. Try it out for yourself on [SQLize.online](https://sqlize.online) and let us know what you think!

P.S. This article was also written by ChatGPT :)
Launch and connect Windows-EC2 using RDC
Tags: aws, cloud, awscommunity, 100daysofcloud
Published: 2023-02-20 19:32:41

[51/100] #100DaysOfCloud Today, I created and connected to an EC2 Instance running the latest Windows free tier AMI and then connected to it from your machine using RDC. Installed Internet Information Services (IIS), created a custom webpage and hosted it on that EC2 Instance.

You can connect to Amazon EC2 instances created from most Windows Amazon Machine Images (AMIs) using Remote Desktop. Remote Desktop uses the Remote Desktop Protocol (RDP) to connect to and use your instance in the same way you use a computer sitting in front of you (local computer). It is available on most editions of Windows and is also available for Mac OS.
The license for the Windows Server operating system allows two simultaneous remote connections for administrative purposes. The license for Windows Server is included in the price of your Windows

You can try do it by yourself by following the steps from the link below: [GitHub](https://github.com/aaditunni/100DaysOfCloud/blob/main/Journey/051/Readme.md)
Help Needed with Matching 4 Walking Animations for a Top-Down Character Controller
Tags: unity3d, animator, csharp
Published: 2023-02-20 19:29:26

Hey there, fellow readers! I'm seeking your expertise to help me solve a challenging problem. I'm an amateur game developer trying to match four walking animations (forward, back, and strafe left and right) for a top-down character controller. I want my character's movements to look like the ones in this example: https://sharpcoderblog.com/blog/top-down-character-controller-example.

Now, I must admit that I'm not a coding expert, but I'm willing to learn. If you can explain it to me like you would to a child, that would be awesome! Recently, I've been making progress in understanding how to read C#, but I'm struggling to comprehend the animator and blendtree concepts. As a pixel artist, this is all new to me, and I'm stuck.

I'm seeking your advice on how to drive animation conditions from the script to the animator to get the animations to play according to the player's rotation that's driven by the cursor position. I would appreciate any help you can provide. Thank you in advance!
Thoughts on the fall of FTX
Tags: blockchain
Published: 2023-02-20 12:55:44


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

I will put these into two categories, first are the easily verifiable and second is the more speculative.  My take on all of this is that a company setup like this and an individual with an unproven track record should never have been considered a sound investment. Especially at the scale it was invested into.   

## Verifiable
FTX and all the related companies were not part of a holding company.
FTX did not have a board.
FTX did not have a CFO.

## More speculative
FTX’s crash is estimated to be twice the size of Enron.  $25 billion vs $50 billion.
FTX executives used a messaging service where their messages were automatically deleted after a short period of time. 
FTX did not have to “transfer” user funds to Alameda.  When user’s deposited funds, they went directly to an Alameda bank account.  


How did this happen?  One interesting opinion is that there is a problem with an investment culture that regularly turns individuals into a “tech geniuses”.  Investors were lured into investing billions into a very young and unproven entrepreneur.  On top of that, there is an unspoken rule that a VC firm will not speak ill of a startup they consider investing into and then find red flags.  You can understand their situation by imagining a startup deciding which firms to pitch too and avoiding a firm that is known to share red flags with other VCs.  

Refs: various episodes from [Shows - Your Top Crypto Resource - Unchained Podcast](https://unchainedpodcast.com/category/shows/)
How to Redirect to an external website with Remix
Tags: remix, webdev, typescript, react
Published: 2023-02-20 18:48:29

[Remix](https://remix.run) has a useful `redirect` helper function which helps to quickly create a new redirect Response. You can use this function to redirect from a `loader` or `action` to another app route and another website.

```ts
import { redirect } from "@remix-run/node";

export const action = async () => redirect("https://vanxh.dev");
```

Just return a `redirect` response with the URL you want to redirect. You can also pass a status code as a second argument, which defaults to `302`.

You can do the same from a `loader`:

```ts
export const loader = async () => redirect("https://vanxh.dev");
```
Twitter Pin Based OAuth in NodeJS / Typescript
Tags: typescript, node, twitter, oauth
Published: 2023-02-20 18:45:46

This is how you can use [twitter pin based oauth](https://developer.twitter.com/en/docs/authentication/oauth-1-0a/pin-based-oauth) in node.js / typescript.

## Steps:

**Step 1**
Install `@vanxh/tw-oauth` in your project
```bash
npm install @vanxh/tw-oauth
# or
yarn add @vanxh/tw-oauth
```

**Step 2**
Import TWoauth
```ts
import { TwoAuth } from 'twoauth';
```

**Step 3**
Create a new TWoauth instance
```ts
const tw = new TwoAuth("API KEY", "API SECRET");
```

**Step 4**
Get an authorization URL
```ts
const { token, tokenSecret, authorizationUrl } = await tw.getAuthorizationUrl();
console.log(authorizationUrl);
```

**Step 5**
Use the pin you get after authentication on the authorization URL in Step 4 to get the access token and access token secret.
```ts
const { accessToken, accessTokenSecret } = await tw.getAccessToken(pin, token, tokenSecret);
```

## Full Usage Example
Check out the library on [github](https://github.com/vanxh/tw-oauth).
```ts
import { TwoAuth } from 'twoauth';
import inquirer from "inquirer";
import open from "open";

const tw = new TwoAuth("API KEY", "API SECRET");

const { token, tokenSecret, authorizationUrl } = await tw.getAuthorizationUrl();
console.log("Please visit the following URL to authorize the app.");
console.log(authorizationUrl);
open(authorizationUrl);

const { pin } = await inquirer.prompt([{
  type: "number",
  name: "pin",
  message: "Paste the PIN here:",
  filter: (value) => (value >= 0 && value <= 9_999_999) ? value : Promise.reject(`Invalid PIN: ${value}`)
}]);

const { accessToken, accessTokenSecret } = await tw.getAccessToken(pin, token, tokenSecret);
console.log("Access Token:", accessToken);
console.log("Access Token Secret:", accessTokenSecret);

// Use the access token and access token secret to make API calls to Twitter API.
```
Episode 23/07: Signals
Tags: angular, javascript, webdev, programming
Published: 2023-02-20 17:40:17

As mentioned last week, the Angular team published a pre-RFC that they will integrate Signals.

{% embed https://youtu.be/qrECSAaMC58 %}

Compared to the revolution standalone components brought, signals' impact will be way bigger. Unsurprisingly, that announcement caused quite some thrill in the community.

[Official Announcement](https://github.com/angular/angular/discussions/49090)

So what are Signals? Compared to other frameworks, we don't have to run the rendering/DOM update process manually. zone.js does it for us. Every time a DOM event happens, or an asynchronous task ends, zone.js notifies Angular.

Why? Because these are the places where our application code runs and potentially changes state. So Angular goes through all the components, searches for changes, and updates the DOM. That is what we call Change Detection.

![Animation showing current Change Detection](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zkzt71oafw9h843akuzs.gif)

With Signals, we apply our changes to reactive data structures that Angular is subscribing to. So the framework knows exactly when and where a change happened. And that without the help of zone.js

![Animation showing Change Detection with Signals](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hdfjtu524a0d0scscgdh.gif)

What are the next steps? We have to wait for the detailed RFC. But you can already try it out.

Enea Jahollari found the Signals Branch on GitHub, extracted it, and provided a running application on [Stackblitz](https://stackblitz.com/edit/angular-ednkcj).

For more information, watch Brandon Roberts' video with Alex Rickabaugh.

{% embed https://www.youtube.com/watch?v=ov0rSrZT4lk %}

It is clear that the introduction of Signals will be a monumental milestone. We get more performance with less complexity. A lot of performance patterns will require a rethinking or will even become unnecessary (like OnChanges, OnPush).
AWS Amplify, another cool dude for developers to act?
Tags: aws, amplify, build, devops
Published: 2023-02-20 17:37:43

AWS Amplify is a development platform provided by Amazon Web Services (AWS) that allows developers to build and deploy web and mobile applications quickly and easily. It simplifies the development process by providing a range of tools and services that help to streamline the building, testing, and deployment of applications. 

Here, we'll take a closer look at AWS Amplify and its key features.

**Features of AWS Amplify:**
Easy to use: AWS Amplify is designed to be easy to use, with an intuitive user interface that allows developers to build and deploy their applications quickly and easily.

_Integrations:_ AWS Amplify integrates with a wide range of services and platforms, including Amazon S3, Amazon Cognito, and AWS Lambda. This makes it easy to add new features and functionality to your applications.

_Continuous Deployment:_ AWS Amplify supports continuous deployment, which means that changes to your application can be automatically deployed to the cloud as soon as they are ready.

_Scalability:_ AWS Amplify is designed to be highly scalable, which means that it can handle large amounts of traffic and data without any issues.

_Security:_ AWS Amplify provides a range of security features, including user authentication and authorization, data encryption, and network isolation. This ensures that your applications are secure and protected from unauthorized access.

_Analytics:_ AWS Amplify provides built-in analytics that allow you to track user behavior and app performance. This helps you to optimize your app for better user engagement and increased revenue.

**How to get started with AWS Amplify:**
Getting started with AWS Amplify is easy. Here are the basic steps:

_Sign up for AWS:_ To use AWS Amplify, you'll need an AWS account. Sign up for an account on the AWS website if you don't already have one.

_Install the Amplify CLI:_ The Amplify Command Line Interface (CLI) is a tool that allows you to create and manage your Amplify projects. Install the Amplify CLI on your local machine.

_Create an Amplify project:_ Use the Amplify CLI to create a new Amplify project. This will generate a set of AWS resources that are required to build and deploy your application.

_Build and deploy your application:_ Build and test your application locally, and then use the Amplify CLI to deploy your application to the cloud.

AWS Amplify is a powerful development platform that simplifies the process of building and deploying web and mobile applications. Its wide range of features, easy-to-use interface, and integration with other AWS services make it an ideal tool for developers of all skill levels. Whether you're building a simple web app or a complex mobile app, AWS Amplify can help you to build, test, and deploy your application quickly and easily.
Simplify Ballerina Workflow on GitHub with setup-ballerina Action
Tags: githubactions, ballerina, ballerinalang
Published: 2023-02-20 17:09:46


The post covers the use of the `setup-ballerina` GitHub Action to automate the installation of the Ballerina (Swan Lake) distribution in the GitHub Action environment. 

The following code block shows how you can configure the GitHub Action to build your Ballerina project. You can find a working example of this in this [repository](https://github.com/hasithaa/example-setup-ballerina/).

![`setup-ballerina` in action](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/a3sw6oneauy7hol8ml53.png)

* The `setup-ballerina` GitHub Action `v1` release requires a mandatory input of the Ballerina Swan Lake distribution version in the form of "Swan Lake channel" as listed in the `bal dist list` command. i.e. `2201.3.0`, `2201.3.2`, etc. This will install Ballerina on workflow environment and `bal` command is added to the `PATH`. 
* This action is supported on Ubuntu, MacOS, and Windows, and facilitates easy integration of Ballerina into your GitHub workflow.
* After you install Ballerina command, you can use `run` to execute the `bal` command. 

---

With the introduction of `setup-ballerina`, users now have the option to choose between [`ballerina-action`](https://github.com/marketplace/actions/ballerina-action) and [`setup-ballerina`](https://github.com/marketplace/actions/setup-ballerina-language) for using Ballerina in their GitHub Actions workflows.

This provides greater flexibility and choice for users, allowing them to choose the option that best suits their specific workflow needs. A comparison of the two options can help users make an informed decision based on factors such as Architecture and full `bal` command support.

| GitHub Action | `setup-ballerina` | `ballerina-action` |
| ------------- | ----------------- | ---------------- |
| Architecture  | Composite Actions | Docker container |
| Supported Ballerina Versions | Swan Lake | 1.x and Swan Lake |
| Full `bal` Command Support | Yes      | Limited to `bal build` and `bal push` |


In summary, setup-ballerina provides more flexibility and full bal command support. The choice of which action to use ultimately depends on your specific needs and workflow requirements.

---

Originally, [setup-ballerina](https://github.com/hasithaa/setup-ballerina/) was one of my pet projects that have now been officially part of the [Ballerina platform](https://github.com/ballerina-platform/setup-ballerina/).
Release 0.30.0 of Spellcheck (GitHub) Action - a maintenance release
Tags: release, opensource, githubaction
Published: 2023-02-20 17:04:28

---
title: Release 0.30.0 of Spellcheck (GitHub) Action - a maintenance release
published: true
description: Maintenance release to keep things moving
tags: release, opensource, githubaction
---
I have just uploaded version 0.30.0 of the Spellcheck GitHub action to the [GitHub Marketplace](https://github.com/marketplace/actions/github-spellcheck-action) and [DockerHub](https://hub.docker.com/r/jonasbn/github-action-spellcheck).

The core component [PySpelling](https://pypi.org/project/pyspelling/) has been updated with several fixes and the base Docker images has also been updated.

It was my hope that one of the fixes in PySpelling addressed issue [#121](https://github.com/rojopolis/spellcheck-github-actions/issues/121), but that does not seem to be the case after some testing, so the problem is possibly deep in the bowels of `aspell`.

As mentioned in the [release announcement for 0.29.0](https://dev.to/jonasbn/release-0290-of-spellcheck-github-action-a-maintenance-release-3773), I prefer _baby steps to moon landings_, so this is pretty light weight, but if something breaks, the changes are few, problems hopefully easier to pinpoint and rolling back will not be a hassle.

Version 0.30.0 is available on the GitHub marketplace and will be supported for the next 365 days.

Which leads me to that I need to address the [end of life](https://github.com/rojopolis/spellcheck-github-actions/wiki#sunset-policy) for the versions:

- 0.21.0
- 0.21.1
- 0.22.0
- 0.22.1

I have not [dug](https://dev.to/jonasbn/do-you-know-sourcegraphs-code-search-308n) into how actively these versions are put to use, but it will probably require a few PRs.

# Change log for 0.30.0

## 0.30.0, 2023-02-20, maintenance release, update not required

- PySpelling updated from version 2.8.1 to 2.8.2, including several fixes
  - FIX: Ensure that Aspell actually uses the encoding passed to it for dictionaries.
  - FIX: Use a disallow list for problematic or unsupported arguments to the underlying spell checker instead of using a more restrictive allow list.
  - FIX: Fix logic bug in JavaScript filter.
- Lifted from  the [release notes for PySpelling](https://github.com/facelessuser/pyspelling/releases/tag/2.8.2)

- Docker image updated to Python 3.11.2 slim via PR [#142](https://github.com/rojopolis/spellcheck-github-actions/pull/142) from @dependabot. [Release notes for Python 3.11.2](https://docs.python.org/release/3.11.2/whatsnew/changelog.html)
Wirex Virtual cards are now live
Tags: blog, crypto, wirex, cryptos
Published: 2023-02-20 16:45:45

[Wirex](https://justyy.com/out/wirex) now supports adding a Virtual Card in the App. The Virtual Card is just same like credit card except that it doesn't have a physical card. That means, you can use the virtual card online only.

However, you can't add this to Apple Wallet, so it is limited use.

The [wirex](https://helloacm.com/earning-passive-income-by-staking-coins-usdt-etc-on-wirex-x-accounts/) cards (even the physical one) do not support Apple Wallet, it would be great if this can be added to apple wallet, so that the benefits can be maximized.

> We're excited to announce the launch of our virtual cards*! No need to worry if you forgot your card at home, we know it happens – now you can get all the benefits from your app!

>  Wirex is now offering virtual cards to help you make payments and transfers quickly, securely, and conveniently.

> With your Wirex virtual card, you can make payments without having to use cash or a physical card. You can also set spending limits and track your transactions in real-time. Plus, our virtual cards are accepted anywhere where your physical card is accepted!

> That's not all. You will still get Cryptoback™ rewards at the same rate at which you do with your physical card - same rewards, less fuss!  

> Plus, it can be yours in no time!

> If you're looking for an easy and secure way to make payments, then the virtual card is for you. Open the app and activate yours to experience the convenience and security of virtual cards for yourself!


![unnamed.png](https://cdn.steemitimages.com/DQmQiH8bwJ7GBUen18ouBSfXQ14YQaovFHv54NMveGZTdrA/unnamed.png)




<hr/>

### [Steem](https://steemyy.com) to the Moon!
You can swap the STEEM/SBD to USDT (TRC-20) via [Steem2USDT](https://steemyy.com/steem2usdt.php)
Git add . vs Git add -a vs Git add -u
Tags: git
Published: 2023-02-20 16:28:14

The difference between those three commands can be inferred from their parameters and flags.

```bash
Git add . 
```

**What does . mean?**

That's right. It means the current directory. So, `git add .` adds all files and folders located in the current directory including hidden files/folders.

```bash
Git add -a
```

`-a` flag is the shorter version of the `--all` flag, and as can be inferred it means adding all files and folders, but isn't that what `git add .` does? Well, you missed "the current directory" part. *I know you haven't missed it, smart guy, I am just playing with you* .

Getting back to the point, `git add -a` adds all files or folders in the whole repository, not just the current directory.

So that means if you modified a file in the repo main directory, `cd`'ed into a sub-directory, modified another file then ran the earlier command `git add .` you will only add the file in the subdirectory.

```bash
git add -u
```

`-u` flag is the shorter version for `--update` flag, and again as can be inferred, it means updating files and folders but there is a caveat, new files/ folders are not tracked,

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

and thus they can't be updated. So basically that means modified and deleted files/folders are added but not newly created ones.
What are your goals for the week?
Tags: discuss, motivation
Published: 2023-02-20 16:23:13

What are your goals for this week?
 
- What are you building? 
- What will be a good result by week's end?
- Are you attending any events this week?
- Did you meet your goals last week?

I'll start.

**Last Week's Goals**

- [:x:] Update Portfolio.
- [:white_check_mark:] Continue Job Search.
- Continue new project. Did some CSS challenges.
- [:white_check_mark:] Blog.
- [:white_check_mark:]Encourage and help members in our Virtual Coffee's February Challenge, Getting job ready.
- [:white_check_mark:]Attend AWSome Day on Wed. * Was webinar on their services. I was hoping for some hands on walk through. 


**This Week's Goals**

- Update Portfolio.
- Continue Job Search.
- Continue new project.
- Blog.
- Encourage and help members in our Virtual Coffee's February Challenge, Getting job ready.
- Attend Job Fair

**This Month's Goals**
- Gain more followers here. I would like to have more followers on DEV than I had on the bird site. 


You've read my goals so I'll throw that question back to you.

What are your goals for the week?

```
-$JarvisScript git push
```
React + Vite + Ts templates for you
Tags: react, vite, typescript
Published: 2023-02-20 16:16:45

Hi there. I want to share with you two repos for building (guess what) react apps, powered by vitejs and typescript. They include i18n, caching, custom http client (no more axios), tailwindcss, vitest and file-config based routing (no more a single file with all yout routes). Any feedback is welcome 

https://github.com/Pedro-Velazquez/revit (with material design)
https://github.com/Pedro-Velazquez/vint (with ant design)