teleren/devto huggingface dataset:
Create Your First SQL Project: Adding a Customer Table to an E-Commerce Database
Tags: sql, projectbenatar, beginners, programming
Published: 2023-01-10 05:46:53

Resources:

MySQL Workbench (mysql.com/products/workbench)

MySQL documentation on CREATE TABLE statement (dev.mysql.com/doc/refman/8.0/en/create-tabl..)

MySQL documentation on INSERT statement (dev.mysql.com/doc/refman/8.0/en/insert.html)

Guide:

Connect to the database using MySQL Workbench and select the appropriate schema.

Create a new table named "customers" with the following columns:

customer_id (primary key, auto-increment)

first_name (varchar(255))

last_name (varchar(255))

email (varchar(255))

password (varchar(255))

address (varchar(255))

city (varchar(255))

state (varchar(255))

zip_code (varchar(255))

Use the following SQL statement:

CREATE TABLE customers ( customer_id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255), password VARCHAR(255), address VARCHAR(255), city VARCHAR(255), state VARCHAR(255), zip_code VARCHAR(255) );

Insert sample data into the customers table using the INSERT statement. For example:
INSERT INTO customers (first_name, last_name, email, password, address, city, state, zip_code) VALUES ('John', 'Doe', 'johndoe@example.com', 'password123', '123 Main St', 'New York', 'NY', '10001');

Test the table by querying it using the SELECT statement. For example:
SELECT * FROM customers;

Once the table is working correctly, commit the changes to the database.
Congratulations, you have successfully added a customer table to the e-commerce database!
Mastering SQL: A Comprehensive Guide with Resources
Tags: sql, datascience, database, datanalytics
Published: 2023-01-10 05:45:29

Start by learning the basic structure and syntax of SQL. Some good resources for this include the following:
Codecademy's free SQL course: codecademy.com/learn/learn-sql

W3Schools' SQL tutorial: w3schools.com/sql

The official SQL documentation: docs.microsoft.com/en-us/sql

https://youtu.be/Cz3WcZLRaWc

FreeCodeCamp: https://youtu.be/HXV3zeQKqGY

Practice your skills by working through exercises and challenges. Some websites that offer SQL exercises and challenges include:

HackerRank: hackerrank.com/domains/sql

DataLemur:https://datalemur.com/

LeetCode: leetcode.com/tag/database

SQLZOO: sqlzoo.net

Familiarize yourself with the different types of SQL databases. The most popular ones are MySQL, Oracle, and Microsoft SQL Server. Each database has its own specific features and capabilities, so it's important to understand the differences between them.

Learn how to design and implement a database. This includes understanding data types, primary keys, foreign keys, and other database design concepts. A good resource for this is the following tutorial: tutorialspoint.com/sql/sql-database-design...

Learn advanced SQL concepts such as indexing, stored procedures, and triggers. These can help you write more efficient and effective SQL queries.

Stay up to date with the latest SQL developments by following blogs and online communities. Some good resources for this include:

The official MySQL blog: mysqlserverteam.com

Oracle's developer blog: blogs.oracle.com/developer

Stack Overflow's SQL section: stackoverflow.com/questions/tagged/sql

I hope these resources help you master SQL! Let me know if you have any other questions.
500 Internal Server Error In Laravel 9 AJAX
Tags: laravel, ajax, errors, javascript
Published: 2023-01-10 05:30:00

In this article, we will see 500 internal server errors in laravel 9 ajax. 

Also, we can see how to solve or fixed laravel 9 500 internal server error ajax. 

If you are fetching 500 internal server errors in jquery ajax post request in laravel 9. 

Here we will let you know how to fix the ajax post 500 (Internal Server Error) request in laravel 9.

Laravel provides the best security using the csrf token. So, you have each time pass csrf_token when you fire ajax in the post, delete or put a request. 

You can generate csrf token using the csrf_token() helper of laravel 9. we will see you how to generate csrf_token and pass on each ajax request of jquery. 

Also, you can add below meta tag and then you have to simply pass headers. It will automatically pass a token on each post request.

Add Meta tag:

```
<meta name="csrf-token" content="{{ csrf_token() }}">
```

Add JS Code:

```
$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

```

As above both codes, you have to write on each page. So, you can simply put it on the layout page or common header page.
Android Project Structure - In Details
Tags: android, flutter, mobile, programming
Published: 2023-01-10 05:23:37

**Project Structure**
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zsqi882r6ji3hma8q4op.png)
The Android project structure generally contains:
- app
- Manifest file
- Java/Kotlin
- res Directory
- Gradle Script

**app**
It describes the fundamental characteristics of the app and defines each of its components.

**Manifest File**
Manifest file plays an integral role as it provides the essential information about your app to the android system, which the system must have before it can run any of the app’s code.

> Manifest file performs various tasks such as
- It names the Java package for the app as the package name serves as a unique identifier for the application.
- It protects the application by declaring permission in order to access protected parts of the API and interact with other applications.
- Manifest file declares the minimum level of the Android API and lists the libraries which is linked with the application.
- Manifest file list the instrumentation classes. These classes provide profiling and other information as the application runs, but this information is removed as soon the application is publishes. It remains only till the application is in development mode.

The Manifest includes many types of information, the main ones are:
1. Package name
2. Components of the app, such as activities, fragments and services
3. Permissions needed from the user

**Java/Kotlin**
- This folder contains the .java/.kt source files for your project. By default, it includes an MainActivity.java source file.
- Under this, you create all the activities which have .java extensions and all the code behind the application.
- MainActivity.java is the actual file which gets converted to a dalvik executable and runs your app.

**res Directory**
- It is a directory for files that define your app’s user interface. You can add TextView, Button etc. to build the GUI and use its various attributes like _android:layout_width_, _android:layout_height_ etc which are used to set its width and height.
- The res directory is where you put things such as images, strings and layouts. It’s included in every android project, and you can see it in Android Studio res directory.
- Inside of the res directory, are sub folders for the following types of resources. You may have a subset of these directories, depending on the types of the resources you are using in your app.

<u>Different Resource Directories
</u>

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

**Gradle Scripts**
This is an auto generated file which contains compileSdkVersion, buildToolsVersion, applicationID, minSdkVersion, targetSdkVersion, versionCode and versionName.

Thank You!
My AWS Certified Developer Associate experience
Published: 2023-01-10 05:04:04

#**Context** 

- This was my first exam in my cloud journey as i had about to start my project that was on AWS cloud.

- This was the challenge I got from my organization to start completing the certificate in AWS.

- I was in TCS that time so my manager asked me to complete the learning and plan for the exam and they will reimburse the certification cost.

- For a while now, I've been eyeing for this certification, finally committed and booked the exam with 2 months to study for it.

## **Study Experience**

- First, I had purchased [AWS Certified Developer Associate](https://www.udemy.com/course/aws-certified-developer-associate-dva-c01/) course by Stephene Mareek on Udemy.

- This exam was very crucial for me as my management is having their eye on me.

- Initially, I was not able to understand the concepts as it was complete new for me. Then to encounter this issue I had created my AWS free tier account to perform the hand-on labs that boost up my confidence in the conceptualization.
- It took me around 2 months to complete the course with hands-on labs for each service that was in part of my exam.

## **Topics Guidance for exam**

AWS Developer Exam is focused more on AWS Services like DynamoDB, AWS Lambda , Api Gateway ,Cloud Formation , Elastic Beanstalk , X-Ray , Step Functions , CI/CD Services like CodeCommit , CodeBuild , CodeDeploy and CodePipeline etc .

Important Concepts like global and local secondary indexes , provisioned throughput calculation , DAX , exponential backoffs , 4 deployment methods for elastic beanstalk , CodeDeploy — Inplace and blue/green , appspec.yaml file , hooks , CodeBuild — buildspec.yaml , X-Ray SDK, X-Ray Daemon etc .

Some Steps to follow for passing AWS Certified Developer Associate Exam are:
· Take a Course for learning the AWS Services. There are two popular courses offered:
-> Acloud-guru Course by Ryan Kroenberg.
-> Udemy Course by Stephane Maarek.
The Developer Exam is by far the most practical exam among all the associate exams.
· Go through the Study Guide and Sample questions.
· Read the Whitepapers and Faqs.
· Solve practice papers from some sites mentioned below:
 
->[https://www.knowledgehut.com/practice-tests/aws-certified-developer-associate]
->[https://digitalcloud.training/aws-developer-associate-free-practice-exam-questions/]
->[https://www.whizlabs.com/blog/aws-developer-associate-exam-
questions/]

I hope that this guide helps you in building your career with AWS and getting AWS certified,
If you have any doubt or unable to understand any concept feel free to contact me on

- [Linkedin](https://www.linkedin.com/in/aman-gupta-43aab521a/)

- [Instagram](https://www.instagram.com/)

- [Twitter](https://twitter.com/home?lang=en-in)

I also am working on various AWS Services and Developing various AWS and Big Data Projects.

Thank you
An introduction to software quality assurance in embedded systems
Published: 2023-01-10 05:00:00

Software quality assurance (SQA) is the process of verifying that a software system meets specified requirements and standards for quality. In the context of embedded systems, SQA is particularly important, as the software is often critical to the operation of the device and may have strict requirements for reliability and performance.

There are several key components of SQA in embedded systems:

Defining quality standards: The first step in SQA is to define the quality standards that the software must meet. These standards may be specific to the project or may be based on industry-wide best practices.
Developing a test plan: The next step in SQA is to develop a test plan that outlines the testing that will be performed on the software. This may include unit testing, integration testing, system testing, and acceptance testing.
Performing testing: Once the test plan has been developed, the actual testing of the software can begin. This may involve running automated tests, as well as manual testing performed by quality assurance engineers.
Analyzing test results: After the testing is complete, the results are analyzed to determine whether the software meets the defined quality standards. Any issues that are identified during testing are documented and addressed through a process of debugging and re-testing.
Maintaining quality: SQA is an ongoing process, and it is important to maintain the quality of the software over time. This may involve regularly performing testing and making updates or changes to the software as necessary to ensure that it continues to meet the defined quality standards.
Overall, SQA is a critical aspect of embedded software development, as it helps ensure that the software is reliable, efficient, and meets the requirements of the target hardware platform. By following a structured SQA process and regularly performing testing and analysis, developers can ensure that their software is of high quality and meets the needs of end users.
Admin Dashboard Error - Any Idea on What Could be Wrong?
Tags: android, database, 100daysofcode, challenge
Published: 2023-01-10 04:41:14


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

Any idea what could be causing this error when trying to login a just created admin dashboard?

**NB:** This problem has already been solved  but let's see who knows their onions
Most useful chrome extensions for DEVELOPERS
Tags: develop, extension, tooling, help
Published: 2023-01-10 04:25:01

Augury: This is a debugging tool for AngularJS applications that allows you to visualize the application's dependency injection system and performance.

JSON Viewer: This extension formats and highlights JSON data, making it easier to read and debug.

Postman: This is a powerful API development tool that allows you to send HTTP requests and view the responses. It's great for testing and debugging APIs.

Wappalyzer: This extension detects the technologies used on a website, including the content management system, hosting provider, and analytics tools.

Web Developer: This extension adds a toolbar with a variety of web development tools, including a DOM inspector, a CSS style editor, and a JavaScript console.

Lighthouse: This is a performance and auditing tool developed by Google that allows you to audit the performance, accessibility, and best practices of a website.

React Developer Tools: This is a tool for inspecting and debugging React applications. It allows you to view the component hierarchy and the props and state of each component.

PageSpeed Insights: This is another performance tool developed by Google that analyzes the performance of a webpage and provides recommendations for improving its speed.

Redux DevTools: This is a tool for debugging applications built with the Redux state management library. It allows you to view the state changes and actions in your application.
SEOS and their future impact
Tags: seo, searchengine, webdev, learning
Published: 2023-01-10 04:21:49

SEO, or Search Engine Optimization, is the process of optimizing a website to rank higher in search engine results and attract more relevant traffic. As a developer, it's important to understand the basics of SEO and how it can impact your work.

One of the main ways that SEO affects developers is through the technical implementation of the website. This includes things like the structure of the URLs, the use of header tags, and the overall organization of the website's content. Developers need to ensure that the website is properly coded and follows best practices for SEO in order to improve its chances of ranking well in search results.

Another way that SEO impacts developers is through the use of keywords. When developing a website, it's important to include relevant keywords in the content and metadata in order to improve its chances of ranking for those terms. Developers need to work closely with content creators to identify the right keywords to target and ensure that they are properly implemented in the website.

In addition to these technical considerations, developers also need to think about the user experience when it comes to SEO. This includes things like the website's loading speed, mobile-friendliness, and overall ease of use. Google and other search engines prioritize websites that provide a good user experience, so it's important for developers to keep this in mind when building a website.

Overall, SEO is an important consideration for developers as it can have a major impact on the success of a website. By understanding the technical and user experience aspects of SEO, developers can create websites that are optimized for search engines and provide a great experience for users.
Thiết kế App Mobile
Tags: appdesignvn, appdoanhnghiep, appquantri, appbanhang
Published: 2023-01-10 04:11:38

Thiết Kế App Mobile – Thương hiệu Infinity, chuyên gia giải pháp công nghệ hàng đầu Việt Nam. Nhận thiết kế app doanh nghiệp, quản trị, app bán hàng, app hệ thống,… Chuyên nghiệp, uy tín cho các doanh nghiệp Việt.
Website : https://appdesign.vn/
https://dribbble.com/appdesignvn/about
https://linktr.ee/appdesignvn
http://80.82.64.206/user/appdesignvn
http://86x.org/home.php?mod=space&uid=1857457
http://anyflip.com/homepage/siaxa
http://atlas.dustforce.com/user/appdesignvn
http://bioimagingcore.be/q2a/user/appdesignvn
http://flightgear.jpn.org/userinfo.php?uid=31718
http://diendan.lyhocdongphuong.org.vn/profile/61300-appdesignvn/?tab=field_core_pfield_15
http://www.genina.com/user/edit/2939824.page
http://www.kab3.com/home.php?mod=space&uid=2557425
Hotline : 0965 21 86 96
Hastag : #thietkeapp #thietkeapp #appdoanhnghiep #appquantri #appbanhang #apphethong #infinity #thietkeappmobile #doanhnghiepthietkeapp #thiet_ke_app #thiet_ke_app_mobile #thuong_hieu_infinity
Automatically Update Security Group When SSHing into Your Server
Tags: webdev, ssh, aws, ec2
Published: 2023-01-10 04:10:11

Often times I’m working from a coffee shop, a friend or family members house, an airport, or somewhere else random. Then I try to ssh into my server to do something and it hangs. 

### Troubleshooting EC2 SSH Connection Issues
SSH is not particularly helpful in informing you what's happening when you're trying to fix EC2 SSH problems. Eventually I realize there's an EC2 SSH connection timeout because I have to add my IP to the security group before I can ssh.

I made a useful bash script and shortcut to check if ssh is available and if not use the aws cli to add my current ip to the security group then try again.

I know, probably not great adding a public network IP to the security group, but when you gotta get work done you gotta get work done.

Here’s the code:

```bash

function ssh_into_ec2() {
  HOST="ec2-11-111-11-111.us-east-2.compute.amazonaws.com" # Change to your region and ec2 public url
  USER=ec2-user SSH_STRING="ec2-user@$HOST" # Change if you use a different username
  HOST_URL="https://$HOST"
  SSH_KEY=your-key-file.pem # point to your keyfile
  echo "Checking if ssh to $HOST is reachable"
  if timeout 2 nc -z $HOST 22; then
    echo "Reachable. SSHing into $HOST"
    ssh -v -i $SSH_KEY "$USER@$HOST"
  else
    echo "ssh to $HOST not reachable, adding current IP to security group"
    SECURITY_GROUP="your-security-group" # Change to the name of your EC2 server's security group
    PUBLIC_IP=$(curl ifconfig.me)
    aws ec2 authorize-security-group-ingress \
      --group-name $SECURITY_GROUP \
      --protocol tcp \
      --port 22 \
      --cidr $PUBLIC_IP/32
    ssh -v -i $SSH_KEY "$USER@$HOST"
  fi
}
```

Resources that helped make the code:

[How to find if a server is reachable over ssh](https://stackoverflow.com/a/35741530/10302179)
[How to check if nc succeeded in a bash script](https://stackoverflow.com/questions/40778261/stop-script-if-nc-connetion-succeded-in-bash)
[How to check the exit status using an if statement](https://stackoverflow.com/a/26675771/10302179)
[Finding my IP from the command line](https://constellix.com/news/what-is-my-ip-address)
Software Testing Tutorial - 11 Top Websites a Software QA or Software Tester Must Visit.
Tags: webdev, beginners, programming, tutorial
Published: 2023-01-10 03:41:30


In this video l, we are going to learn about the 11 Top Websites a Software QA or Software Tester Must Visit

{% embed https://youtu.be/5GHjZ_VbOVg %}

These are most helpful websites for software testing, you can learn about manual testing, automation testing, performance testing and api testing and many more from them for free of cost. make sure you remember the 11 Top Websites a Software QA or Software Tester Must Visit
-------------------------------------------------------

👪 Join our Community - http://bit.ly/learntesting2019


✅ Automation Community - https://thetestingacademy.com


🐦Follow us on Twitter  - https://twitter.com/itstechmode


📖 Like us on Facebook - https://www.facebook.com/scrolltest


🎤  Listen to our Podcast - https://anchor.fm/thetestingacademy


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

#automationtesting #manualtesting #testautomation #thetestingacademy #scrolltest
🚀 Tools and services I recommend:
Some of the courses that I recommend to become better Automation Tester 🙌🙌

✅Selenium Training and Certification -
https://scrolltest.com/go/edureka


✅Learn Jenkins for QA -
https://bit.ly/learnjenkins-p1


✅Programming Java -
https://bit.ly/learnjava2020-p1


✅Test Automation - 
https://bit.ly/learnautomation2020


✅API Testing - 
https://www.learnapitesting.com


✅Cypress Tutorial with LIVE Projects -
http://cypresstutorial.com
How to store HTML form value in an array
Tags: javascript, html
Published: 2023-01-10 03:24:13

To get input from an HTML input element and store it in an array in JavaScript, you can use the **`value`** property of the input element and the **`push()`** method of the array.

Here's an example of how you can do this:

```html
<!-- HTML code -->
<form id="form">
  <input type="text" id="input1">
  <input type="text" id="input2">
  <input type="text" id="input3">
  <button type="button" onclick="storeInput()">Store Input</button>
</form>

```

```jsx
// JavaScript code
function storeInput() {
  // Initialize an empty array
  const inputArray = [];

  // Get the input elements
  const input1 = document.getElementById("input1");
  const input2 = document.getElementById("input2");
  const input3 = document.getElementById("input3");

  // Get the values of the input elements
  const value1 = input1.value;
  const value2 = input2.value;
  const value3 = input3.value;

  // Add the values to the array
  inputArray.push(value1, value2, value3);

  // Print the array to the console
  console.log(inputArray);
}

```

- The first step is to get the values of the input elements with the **`id`**s "input1", "input2", and "input3" on the button clicked
- To store the values in the **`inputArray`** array. Create an array named inputArray
- You can add as many input elements as you need, and modify the code to store the values in the array as needed.

Note that this code assumes that the input elements are inside a form element with the **`id`** "form". You can modify the code to use a different form element or to get the input elements in a different way.
在 Windows 執行 Gradio 分享連結的注意事項
Tags: gradio, python, firewall
Published: 2023-01-10 03:02:25

[Gradio](https://gradio.app/) 是個很棒的工具, 讓我們可以快速幫程式加上簡易又美觀的網頁介面, 不過如果你在 Windows 使用 Gradio, 並且以 `launch(share=True)` 啟用介面, 很可能會遇到這樣的狀況：

```
# python .\chat_api.py
Running on local URL:  http://127.0.0.1:7860

Could not create share link, please check your internet connection.
```

Gradio 說無法建立共享連結, 只能在本機端提供網頁介面。

這可能是你的 Windows Defender 把 Gradio 擋住了, 在 Windows defender 會看到它發現了垃圾軟體：

![](https://i.imgur.com/G6RW0jW.png)

按一下**檢閱**, 就可以看到被擋住的項目：

![](https://i.imgur.com/ShzMHId.png)

展開就可以發現 Gradio 執行的 frpc_windows_amd64 被當成垃圾軟體了, 只要在**動作清單**中選取**允許在裝置上**就可以了：

![](https://i.imgur.com/hThPNKB.png)

重新執行剛剛的程式, 就會看到產生分享連結了：

```
# python .\chat_api.py
Running on local URL:  http://127.0.0.1:7860
Running on public URL: https://6023a743-e9c0-45df.gradio.live

This share link expires in 72 hours. For free permanent hosting and GPU upgrades (NEW!), check out Spaces: https://huggingface.co/spaces
```

提供給大家參考, 這樣就可以隨時提供網頁介面給大家測試你的程式了。

對了, 如果你不知道 Gradio 怎麼唸？[開發者有說明](https://github.com/gradio-app/gradio/discussions/394), 就是 GRAY-dee-oh。