teleren/devto huggingface dataset:
What Does an Audio Visual Consultant Do?
Tags: av, avsolution, sigmaavit
Published: 2023-03-29 12:59:46

An organization can understand the need for Audio Visual Consultancy in the present era of business practices. In the fast-moving world, it is not possible to grow without the use of emerging technologies, and audio visual technologies are the most important aspect of dealing with businesses today.

These important services are provided by audio-visual consultants that understand the requirement of organizations very well and provide solutions accordingly. 

In this blog, we will understand the role of an audio visual consultant.


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

##The Role of an Audio Visual Consultant

Sigma AVIT provides strong [AV Integration Distribution](https://sigmaavit.com/av-integration-distribution/) services to organizations so that they can grow and operate easily. The role of an audiovisual consultant is as follows:

**To Evaluate the Client’s Needs**
It is the duty and role of an audio visual consultant to understand the needs of his client. Clients do not have any idea about pieces of equipment and installation and therefore, they hire AV consultants that can understand their needs and provide them with the best possible solutions.

Audio visual consultants look at the budget, pain points, and appropriate solutions for their clients.

**Design Audio Video Installation**
After understanding the needs of the client, Audiovisual consultants provide solutions determining the space and appropriate design to fulfill those needs. This includes details of layout, wiring, and needed equipment.

**Collect Bids from AV Integrator's**
Once the design is completed, the audio visual consultant will prepare a document that includes the bid for AV integrator. 

The bid constitutes the equipment that will be needed for the completion of the design of rooms and other areas. The integrator with a perfect quote is taken to supply the required material and equipment for the completion of the project.
 
**Conclusion**:
Every organization must consult an audio-video consultant because [Audio Visual Consultancy](https://sigmaavit.com/audio-visual-consultancy/) can help them to understand the requirement of equipment that can increase the productivity of the organization. Visit the official website of Sigma for more details.
How to add a popup for chrome extension?
Tags: webdev, programming, tutorial
Published: 2023-03-29 12:56:11

Hello:)
To add a popup html to a chrome extension you will need to add the following code to the manifest.json file

```
"action": {
    "default_popup": "popup.html"
  },
"content_scripts": [
      {
          "matches": [
            "<all_urls>"
          ],
          "js": ["popup.js"],
          "css": ["popup.css"]
      }
  ]
```
and make the `_popup.html file_`, `_popup.css_`, and the `_popup.js _`files.
Classroom And Audio Visual Learning
Tags: automation, av, avsolution, sigmaavit
Published: 2023-03-29 12:54:39

A classroom is a place where children make friends and memories while learning a lot about the world they live in and acquiring knowledge that shapes their minds for the future. The traditional ways of teaching won’t work effectively with the kids of the 21st century, and that’s why [Audio Visual Education](https://sigmaavit.com/solutions-education/) is a need in the present era of the education system. We can see around us that online education businesses have grown massively over the years, and it is impossible to think of any better alternative now.


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

In this blog, we will look at some of the best advantages of Audio Visual Learning in Classrooms. 

##Advantages of Audio Visual Learning in Classroom
Sigma AVIT is the best company for audio-visual services. We believe that Audio Visual Education and [Audio Visual Classroom](https://sigmaavit.com/audio-visual-classroom/) is the need in the present era of the education system. Some great advantages of audio-visual learning in classrooms are as follows:

**Stimulates Imagination**
Audio-visual education is a great way of explaining concepts and ideas to children. The combination of audio and visual stimulates the imagination of children and helps them to think about various topics in a better way. This also makes discussion on various things easier and more interesting. 

**Facilitate Understanding of The Material**
The reason why children love audio-visual education more than traditional ways of teaching is that audio-visual education provides them with information to which they can relate easily. Not every child has a good focus. Some learn through audio, some learn through visuals, and some learn by repeating things (writing or speaking). 

**Encourage Students to Take Action and Learn**  
Another reason why children love audio-visual methods of teaching is that AV teaching methods allow children to learn about things, which they see in their surroundings. They take action, interest, and develop habits of self-learning. 

**Conclusion**:
Every classroom should be an Audio Visual Classroom so that children can learn while having the best time of their life. Moreover, audio visual education is a requirement of the present era. Visit the official website of Sigma AVIT for such useful audio-visual solutions.
Crypto Exposed!
Tags: soroban, sorobanathon, stellar, xlm
Published: 2023-03-29 12:24:31

[](https://youtu.be/Ozcp-MUxhOQ)
In Indian parliament one of the MP wanted to know what's behind crypto. He compared crypto with the stock market and questioned the fundamentals of crypto. So I created a video (linked in the post) explaining the fundamentals of Crypto with the help Stellar and it's developments. 
Stellar have the capability to transform the future of financial ecosystem. And it is already moving towards this goal, for example helping Ukraine in the times of crisis. What more real world use case one would want to see before realising the potential of this new age tech.
https://youtu.be/Ozcp-MUxhOQ
I hope you'll like this short video covering it all.
usePrevious + useEffect?
Tags: react, discuss, frontend, javascript
Published: 2023-03-29 12:19:50

Sometimes I need to run a side effect in React when a certain value in the state changes.

I do this quite often and found that for me the most readable (and understandable) method is to use a hook that stores the previous value of something.

```javascript
export function usePrevious(value) {
  const ref = useRef();
  useEffect(() => {
    ref.current = value;
  }, [value]);
  return ref.current;
}
```

Then when I want to create a side effect that only runs when when a specific variable changes:

```javascript
const [step, setStep] = useState(1);
const [something, setSomething] = useState('Hi world!');
const prevStep = usePrevious(step);

useEffect(() => {
  if (prevStep !== 4 && step === 4) {
    // Do something
  }
}, [step, prevStep, something]);
```

Does anyone else do it like this way? How often do you need this pattern?

## Example

This is one example that I found in a Upload component where I wanted to implement the upload directly in the component. This can be done in a much cleaner way with eg. Redux-Saga

There is a callback `onUploaded` that should be called when the upload is done.

```javascript
useEffect(() => {
  if (progress === null) {
    setProgress(0); // This marks the upload as started
    uploadBlob(blob, setProgress).then(() => {
      setBlobUploaded(true);
      onUploaded(); // Dangerous: This might be out of date by the time it's called
    }).catch(reason => {
      setUploadFailedReason(reason);
    });
  }
}, [blob, progress, onUploaded]);
```

```javascript
useEffect(() => {
  if (progress === null) {
    setProgress(0); // This marks the upload as started
    uploadBlob(blob, setProgress).then(() => {
      setBlobUploaded(true);
    }).catch(reason => {
      setUploadFailedReason(reason);
    });
  }
}, [blob, progress]);


useEffect(() => {
  if (prevIsBlobUploaded === false && isBlobUploaded === true) {
    onUploaded(); // This is safer, but it's not clear what the state of the blob is
  }
}, [isBlobUploaded, prevIsBlobUploaded, onBlobUploaded]);
```
Javascript Control Button Bar
Tags: javascript, web, component
Published: 2023-03-29 12:06:03

---
title:  Javascript Control Button Bar
published: true
description: Our personal touch for website navigation
tags: #javascript #web #component
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hdo9rggtuoy9ttou2i13.png
# Use a ratio of 100:42 for best results.
---

Hello everyone! We are pleased to introduce Monster Button Bar. This control is open source and free to use.

In our video we will guide you through the five buttons that have been added here expemplarily, namely the default button, the status button, the popper button, the confirmation button and the message status button. 




{% embed https://youtu.be/y-JJQOf8gPQ %}


If you have any questions or just want to say a warm hello, don't be shy to hit us up! We'll be happier than a squirrel with a nut to receive positive feedback and cheerful comments from you.



- https://monsterjs.org
- https://www.npmjs.com/package/@schukai/component-form
- https://youtu.be/y-JJQOf8gPQ
Installing Java on Mac.
Tags: java, macos, intellij, beginners
Published: 2023-03-29 11:51:09

Java is a powerful programming language that can be used to develop a wide range of applications. If you're a developer or a student who needs to use Java, you'll need to install it on your Mac. 

In this article, we'll see how to install Java on macOS using SDKMAN, a popular tool for managing Java versions, and other alternatives to try out.


1. [SDKMan](https://sdkman.io/usage)
2. [Home brew](https://formulae.brew.sh/formula/openjdk)
3. [asdf](https://asdf-vm.com/)  
4. [Jabba](https://github.com/shyiko/jabba)
5. [jEnv](https://www.jenv.be/)

### Which is better?


![It deponds](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pce6d4jx32gyzy1bg349.png)

Nope, not gonna say that. I will explain what worked for me.

I have tried HomeBrew, asdf, and sdkman. Here is my analysis of those tools.

**_HomeBrew_** - Steep learning curve (formulae, cask, Tapping, unTapping). 
Worth spending time on if you are accepting home brew as your mac package manager and gonna use it for a long time, not for those who need only java installation.

**_Asdf_** - easy to use,  but community and contributors for the java plugin are less active compared to others.

**_SDKMan_** - Easy to use and active community. I preferred this. it is pretty straightforward. 



### Install using SDKMan
1. Open the terminal and run `curl -s "https://get.sdkman.io" | bash`
2. Then run `source "$HOME/.sdkman/bin/sdkman-init.sh"`
3. Then run `sdk install java 20-tem` to get the latest temurin version or just run `sdk install java` to get the latest stable version of temurin.
4. you can try `sdk list java` for choosing different vendors and install accordingly.
5. packages installed using SDK will be in `$HOME/.sdkman/candidates/java/current`


> It helped me to kick start my development on Mac as newbie to mac and hope it helps you too.
Types of HTTP Status Codes like 404? 503?
Published: 2023-03-29 07:55:49

## Types of HTTP Status Codes

HTTP status codes can be classified into the following five categories. The 100s, 200s, and 300s codes indicate that the communication between the browser and the server is working correctly and are not displayed on the site. It is necessary to be careful of the HTTP error codes called the 400s and 500s.

### 100s Informational

The 100s indicate that the request has been received and is being processed.

### 200s Success

The 200s indicate that the request has been received and processed successfully.

### 300s Redirection

The 300s indicate that additional processing is required to successfully process the request.

### 400s Client Error

The 400s indicate that the request from the client has failed. The four most common codes are:

- ***400 Bad Request***: An error occurs in the request.
- ***401 Unauthorized***: The user does not have access privileges to the site.
- ***403 Forbidden***: The user is prohibited from accessing the site.
- ***404 Not Found***: The site itself cannot be found.

### 500s Server Error

The 500s indicate that the server has failed to process the request. The two most common codes are:

- ***500 Internal Server Error***: An error has occurred on the server.
- ***503 Service Unavailable***: The server is unable to process the request due to heavy traffic.

## How to Handle HTTP Error Codes

|| **400 Bad Request**: An error occurred in the request. | Try using a different browser or device.

|| **401 Unauthorized**: The user does not have access privileges to the site. | Verify membership registration information.

|| **403 Forbidden**: The user is prohibited from accessing the site. | Check access privileges and access links.

|| **404 Not Found**: The site itself cannot be found. | Verify the URL.

|| **500 Internal Server Error**: An error occurred on the server. | Investigate the cause of the server error.

|| **503 Service Unavailable**: The server is unable to process the request due to heavy traffic. | Reduce the load on the site or consider changing the server.

It is not a problem to intentionally delete a page and display an error code. However, if an error code is unexpectedly displayed on a page that should be displayed normally, such as 403 Forbidden, 500 Internal Server Error, and 503 Service Unavailable, carefully investigate the meaning of the code and handle it appropriately.
Compare Colors Palettes
Tags: colors, palette, compare, webdev
Published: 2023-03-29 11:35:10

---
title: Compare Colors Palettes
published: true
description: Convert RGB to HEX in couple clicks
tags: colors, palette, compare, webdev
---
How to [Compare Colors Palettes](https://colorswall.com/palettes/compare?ids=42620,42654,42656,42621)
1. Navigate to [Search](https://colorswall.com/search?q=blue) page.
Click on "Compare" icon  to add Palette in Compare List

2. Click on "Compare" icon  to add Palette in Compare List
![Compare Icon](https://colorswall.com/images/help/palettes-compare/add.jpg)

3. Use controls to change layout view, border of palettes, size of colors
![Controls](https://colorswall.com/images/help/palettes-compare/controls.jpg)

4. Use Drag&drop to change palettes order

5. Press "Compare" button to naviage Compare Color Palettes page and use favorite palette
![Compare Action](https://colorswall.com/images/help/palettes-compare/finish.png)

Video version
{% youtube MLtY70mK-HE %}
Views
Tags: opengauss
Published: 2023-03-29 07:51:22

A view is a virtual table, not a base table. A database only stores the definition of a view and does not store its data. The data is still stored in the original basic table. If data in the base table changes, the data in the view changes accordingly. In this sense, a view is like a window through which users can know their interested data and data changes in the database.

Syntax
Create a view

```
CREATE [ TEMP | TEMPORARY ] VIEW view_name [ ( column_name [, ...] ) ]
     AS query;
Delete a view
```

DROP VIEW  view_name ;

Parameter Description
TEMP | TEMPORARY

Creates a temporary view.

view_name

Specifies the name of the view to be created. It is optionally schema-qualified.

Value range: a string. It must comply with the identifier naming convention.

column_name

Specifies an optional list of names to be used for columns of the view. If not given, the column names are deduced from the query.

Value range: a string. It must comply with the identifier naming convention.

query

Specifies a SELECT or VALUES statement that will provide the columns and rows of a view.

Examples
Create the customer_t1 table. The data in the table is as follows:


```
openGauss=# SELECT * FROM customer_t1;
 c_customer_sk | c_customer_id | c_first_name | c_last_name | amount
---------------+---------------+--------------+-------------+--------
          3869 | hello         | Grace        |             |   1000
          3869 |               | Grace        |             |
          3869 | hello         |              |             |
          6985 | maps          | Joes         |             |   2200
          9976 | world         | James        |             |   5000
          4421 | Admin         | Local        |             |   3000
(6 rows)
Create a view in the customer_t1 table. The view selects only several columns from the customer_t1 table.
```


```
openGauss=# CREATE VIEW CUSTOMER_VIEW AS SELECT  c_first_name, amount FROM customer_t1;
```
CREATE VIEW
You can query the CUSTOMER_VIEW view in the same way as querying a table.

```
openGauss=# SELECT * FROM CUSTOMER_VIEW;
The results are as follows:

```

```
c_first_name | amount
--------------+--------
 Grace        |   1000
 Grace        |
              |
 Joes         |   2200
 James        |   5000
 Local        |   3000
(6 rows)
```
After using the view, you can delete it to release space.


```
openGauss=# DROP VIEW CUSTOMER_VIEW;
DROP VIEW
```
Noty.ai is live on ProductHunt
Published: 2023-03-29 11:23:12

Hey there!

Noty.ai is your Personal AI Meeting Assistant that helps you take notes during meetings, keep transcripts of important conversations and transform them into action items⚡️ 

And now, it offers new powerful features like **Zoom integration** and AI Summaries powered by **ChatGPT**.

⚡️ **The new launch** is live on ProductHunt now!
https://www.producthunt.com/posts/chatgpt-for-zoom-and-google-meet-calls

Please support us by upvoting Noty.ai on ProductHunt. We'd be over the moon if you could share your thoughts about the new Noty.ai features.
Introduction To System Design
Tags: systems, design, 100daysofcode, architecture
Published: 2023-03-29 11:14:51

## System design
System design is the process of creating components of a system, including its architecture, modules, and components, as well as its various interfaces and the data it processes. System design is the process of establishing a system's architecture, components, interfaces, and data to meet predetermined criteria. It is a multidisciplinary field that involves trade-off analysis, balancing competing needs, and making choices concerning design elements that will influence the system as a whole. In order words:

> System Design === Architecture + Data + Components

## Why is system design important
The goal of system design is to offer enough precise data and knowledge about the system and its system pieces to allow implementation compatible with architectural entities described in system architecture models and views. System designs have a few things in common:
- **Dependability**: This refers to the level of reliability, robustness and impact rates of the smaller systems.
- **Availability**: This refers to the amount of time in which a system can receive tasks, process tasks and output results without failure.
- **Scalability**: This refers to the ability of the system to grow without causing technical debt.
- **Efficiency**: This refers to the level of effectiveness, reusability and productivity of the systems.


### Elements of a System
- **Architecture** - This is the blueprint that shows the layout, and behavior of a system. This can be illustrated using flowcharts of other software like [Excalidraw](https://excalidraw.com/).
- **Modules** - These are the smaller sub-systems or components that perform specific tasks.
- **Components** - These can be referred to as clusters of modules that are linked to perform a group of functions.
- **Interfaces** - These are the channels or pipelines which the components use to exchange information.
- **Data** - This is the battery of a system. It is similar to the blood in the human body. It transforms as it moves from one component to another.


## Important System Design Concepts
There are different concepts that we need to know to properly understand how to design systems and they include:
- Load balancing
- Latency
- Sharding
- APIs
- Requirements Gathering
- Security
- Replication
- Caching
- Architecture
- Estimation
- Proxies
- Databases
- Servers

## Conclusion
In this article, we have looked at what system design is all about, its importance and its elements. In the next post, we are going to dive deep into the concepts.

Don't forget to leave a like or comment. Till next time guys.

❤️❤️❤️

[Resume](https://docs.google.com/document/d/1Lcr8tSfNozE9MLOKCDF8CwvZH0g7LWJSq9vu3Rdj0_U/edit?usp=drivesdk) [Portfolio](https://valentinesamuel.vercel.app/) [Twitter](https://twitter.com/frontend_val) [GitHub](https://github.com/valentinesamuel) [LinkedIn](https://www.linkedin.com/in/samuel-val/)
SQL query optimization, 3 min to 0.5 sec
Tags: webdev, database, sql
Published: 2023-03-29 10:57:05

Today, I was working on an SQL query and managed to optimize it. Previously, it took almost three minutes to run, but after optimization, it now takes only 0.5 seconds.

To achieve this optimization, I converted some of the sub-queries into joins. This is because sub-queries tend to take a lot of time when dealing with large amounts of data.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tsj19jwnyuxild24icpt.jpg)
How to prepare for the GATE Exam in 2023
Tags: gatecoaching, bestgatecoaching, topgatecoaching, gate
Published: 2023-03-29 10:55:06

Preparing for the Graduate Aptitude Test in Engineering (GATE) exam requires a well-planned and structured approach. Here are some tips to help you prepare for the GATE Exam in 2023:

Know the GATE Exam Pattern and Syllabus: The first step in preparing for the GATE exam is to thoroughly know the exam pattern and syllabus. This will help you to plan your preparation accordingly.

Create a Study Plan: Prepare a study plan that is realistic, effective, and efficient. Allocate sufficient time to cover all the topics and revise them thoroughly. Make a timetable and stick to it.

Choose the Right Study Materials: Choose the right study materials such as textbooks, reference books, study guides, and online resources. Make sure that the materials cover the entire syllabus.

Solve Previous Year Question Papers: Solve previous year's question papers to get an idea about the exam pattern, the type of questions asked, and the difficulty level. This will also help you to assess your preparation level.

Join a Coaching Institute: If you need guidance and structured preparation, you can join an Engineers Career Group one of the best GATE coaching in Chandigarh, that provides coaching for GATE exam preparation. This will help you to get personalized attention and clear your doubts.

Take Mock Tests: Take mock tests to evaluate your preparation level and identify your weaknesses. Analyze your performance in the mock tests and work on improving your weaknesses.

Stay Motivated: Keep yourself motivated throughout the preparation process. Set achievable goals and reward yourself when you achieve them. Surround yourself with positive people who encourage and support you.

Remember that GATE is a highly competitive exam, and it requires a lot of hard work and dedication to crack it. Stay focused, determined, and disciplined, and you will surely succeed.  I highly recommend Engineers Career Group. Contact us today to learn more about what we can do for you. And for more details, you can visit our site: https://www.engineerscareergroup.in/