teleren/devto huggingface dataset:
SQL "BETWEEN" Operator
Published: 2021-09-27 04:17:48

Take the following query directive:
"Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2356."

Imagine you have a table that has multiple records of stations with northern latitudes of various values - some above, some below, and some within the criteria range.  For testing purposes, all edge cases will be represented.  There may even be some values that are exactly at the critera range values.  Remember the criteria is "greater than" and "less than".

You have two choices:
#1. To write your query to include a combination condition (where statement), such as:
"select sum(lat_n) from station 
WHERE lat_n > 38.7880 
AND lat_n < 137.2356"

#2. Or you could use "BETWEEN"
"select sum(lat_n) from station 
WHERE lat_n BETWEEN 38.7880 AND 137.2356"
*** BETWEEN can be a comparison operator for number, text or date values.  You can even find the inverse of the range with NOT BETWEEN

Syntactically, #2 is cleaner and a little bit more readable.  But are they exactly identical?

BETWEEN is "inclusive" - the result will include the criteria, if it exists.  It is essentially "greater than or equal to (>=)" and "less than or equal to (<=)".  They are not identical solutions.

You could "manually" alter the range beginning and ending but you would need to know the exact level of specificity of the decimal in the data field.  You could just add "1" and make the  beginning of the range 39.7880 but that would still leave everything between 38.7881 and 39.7879 values that *should* be included in the result but won't be.  You could add 1 to the last decimal and make the beginning of the range 38.7881 but then you would miss 38.78805, if it were to exist.  Unless you know the specificity of the data, this kind of manual alteration really could produce inaccurate results.

I'm thinking, unless you want the results to be inclusive of the range, my rule of thumb will be to use the combination where statement using "greater than (>)" and "less than (<)".  If the result needs to return values greater than 38.7880, then that could be anything from 38.7881 or 39 or even 38.7880000000000001.  I can easily make this approach "inclusive" if I want to.  Just knowing that "BETWEEN" is inclusive will make me be more careful about choosing to use it.
5 essential Web UX laws
Tags: javascript, webdev, design, tutorial
Published: 2021-09-27 04:12:06

## 1. JAKOB’S LAW
Users spend most of their time on other sites. This means that users prefer your site to work the same way as all the other sites they already know. Websites do better the more standardized their design is.

![jakob](https://4ciipx2wt5iq3qj5qr4cu74k-wpengine.netdna-ssl.com/wp-content/uploads/2021/07/Jakobs-Law.png)

## 2. FITT’S LAW
The time it takes someone to select an object in the screen depends on how far the cursor is from the object and the size of the object.
Thus, the longer the distance and the smaller the target’s size, the longer it takes.

![fitt](https://4ciipx2wt5iq3qj5qr4cu74k-wpengine.netdna-ssl.com/wp-content/uploads/2021/07/Fittss-Law-1.png)

## 3. MILLER’S LAW
The average person can only keep 7 (plus or minus 2) items in their working memory.
Organize content into smaller chunks to help users process, understand, and memorize easily.

![miller](https://4ciipx2wt5iq3qj5qr4cu74k-wpengine.netdna-ssl.com/wp-content/uploads/2021/07/Millerss-Law.png)

## 4. LAW OF PROXIMITY
Objects that are near, or proximate to each other, tend to be grouped together.
- Proximity helps to establish a relationship with nearby objects.
- Proximity helps users understand and organize information faster and more efficiently.

![proximity](https://4ciipx2wt5iq3qj5qr4cu74k-wpengine.netdna-ssl.com/wp-content/uploads/2021/07/Law-of-Proximity.png)

## 5. HICK'S LAW
The time it takes to make a decision increases with the number and complexity of choices. Hick’s Law is a fairly commonsense idea: the more choices you present to a person, the longer they take to make a decision. It’s essentially a fancier way to describe the KISS rule: Keep It Simple, Stupid!

![hick](https://4ciipx2wt5iq3qj5qr4cu74k-wpengine.netdna-ssl.com/wp-content/uploads/2021/07/Hicks-Law.png)

Thanks for reading!
CTA Button Update
Published: 2021-09-27 03:59:06

**Current state**
My group's button right now is currently changing when you hover over it and focus on it.  You can click on it and have it take you to the link as well.  We also have a working icon.

**Difficulties**
So far it has been difficult to get the icons to change if you hover over it.  I also am still struggling to fully understand web components because it is so different from coding I have done in the passed.  It has also been a challenge to figure out how to use npm/yarn and the command line.

**Items Learned**
I have definitely been learning a lot about GitHub.  Before this class I had very limited experience working with it.  I feel a lot more comfortable forking, making repos, and pushing/pulling code. I also was not familiar with web components or different kind of frameworks at all. I am starting to understand web components more and how they work.  This class has also made me more attentive of different web pages and how they are designed.  Another thing I learned was how to actually use the inspect feature.  Before I knew how to inspect webpages but not how to use it to help me debug and come up with different solutions.

Here is a link to my current button: https://github.com/table-in-the-corner/invisi-button/tree/noelle
Click me
Tags: webdev, javascript, css, html
Published: 2021-09-27 03:35:16

Or, don't. A button can still react. 

Something you don't think about in every day life is how others who are less fortunate than you have to navigate life and the modern day world of technology. You don't know what's missing until the day someone needs it. There are so many amazing advances and aids, but they are rendered entirely useless if your design doesn't accommodate for them. 

There is so much that goes into a button that thousands of users may click every single day, and there are so many applications and emotions that can go behind a single "click" or hit of the enter button. You've probably used a button to submit a college or job application, to send a message that makes or breaks your year, or even something just as simple as viewing another webpage. I'll have to click publish and regret all my choices after I finish writing this.  

I think the most difficult thing I've encountered with creating a call to action (CTA) button is the amount of freedom I've been allotted. And, the amount of time I don't want to spend on my other assignments. I love the world of design and programming that can be combined with creating web components. That being said, I spent two hours researching how to design in a button in CSS just to make it look cool when you hover over it or focus on it. That's when you find out there's a ten times more efficient way to make something. For example, incorporating reflect to make the colors flip. And sometimes those things come with experience. 
![Screen Shot 2021-09-26 at 11.04.35 PM](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1jk5aiixv42g0ysvbq9z.png)
![Screen Shot 2021-09-26 at 11.04.45 PM](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/15i2sdu5dysg1q48fn22.png)
While I was able to get the bookmark icon working in class, you learn about the dependencies and libraries involved with creating web components. Without the contributions of others, I wouldn't be able to get a simple bookmark icon without hours and hours of work. You also learn that *the dinosaur icon requires another library, and that's why you can't see it when you try to implement it*.

There's still some work to be done. I haven't implemented disable yet. 

Here's my thing: https://github.com/runtimeErrorsMadeEasy/ctaButton

Here's what I was listening to when I wrote this:
https://open.spotify.com/track/3QcWLlzSUFFWotRzxv6rbQ?si=1fd5fe1d244e49ef
Progress with Button up to Sept 26
Published: 2021-09-27 03:34:39

## Issues:

My partner and I have been looking into different parts of the button to resolve issues. One goal issue I am trying to resolve is having the button change size with the size of the screen. We have gotten the button to be centered but I am struggling with creating the correct code to make it adjust. Another thing that is an issue with our button since we are new to this process is getting the disabled aspect to work on the button completely.

## Success:
We did get the icon feature to work with our button after learning more about it in class! Our button does have the basic features of being able to hover over it and keyboard accessibility. We will continue to work on it together to simplify our code and to also add more features!

Here is a link to our code: https://github.com/table-in-the-corner/invisi-button-group1a.git
How To Create Dynamic Bar Chart In Laravel
Tags: laravel, php, javascript, barchart
Published: 2021-09-27 03:31:59

In this post we will see how to create dynamic bar chart in laravel. Here, we will create product model for bar chart example or bar chart in laravel, we have show all steps for dynamic bar chart example as below, 

So, let's see how to create dynamic bar chart in laravel.

```
Step 1 : Install Laravel for Dynamic Bar Chart Example

Step 2 : Add Migration and Route

Step 3 : Add Route

Step 4 : Create Controller And Model

Step 5 : Create Blade File for Dynamic Bar Chart Example
```

You can see output as below screen print.

![How To Create Dynamic Bar Chart In Laravel](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i445csoyunwssrdlq9jq.png)

---

> **_[Read More : How To Create Dynamic Bar Chart In Laravel](https://techsolutionstuff.com/post/how-to-create-dynamic-bar-chart-in-laravel)_**
Button Project Update
Published: 2021-09-27 03:31:23

So far, I feel I have learned a fair amount about web components and I have thoroughly enjoyed learning/practicing front-end concepts.  It has been somewhat difficult to learn the syntax and proper coding formats, but honestly it has not been the hardest I have seen so far.  Experimenting with different tools and researching different methodologies has been fun and fairly time-consuming.  Creating the button at first was pretty difficult because I felt like I did not know where to start, but once I gained some momentum I felt confident in modifying and improving my button.  The concept of pushing to Github from my local device has been tricky to learn, but certainly useful.  The use of icons I feel is a nice addition to the tool belt.  

{% github https://github.com/PaddysHub/Button1 %}
Camera Vũng Tàu
Published: 2021-09-27 02:39:24

Camera Anh Khoa là công ty chuyên chung cấp và lắp đặt các thiết bị an ninh tại khu vực Vũng Tàu.
Với nhiều sản phẩm chất lượng, mẫu mã thiết kế đẹp mắt đồng thời giá cả cực kỳ hấp dẫn.
Để biết thêm chi tiết về sản phẩm và chương trình khuyến mãi của quý khách hàng vui lòng tham khảo tại https://cameravungtau.vn/
Manual Brew
Tags: coffee, coffeebeans
Published: 2021-09-27 02:34:20

ALAT MANUAL BREW YANG SERING DIGUNAKAN 
Selain coffee mesin alat yang sering digunakan didalam membuat biji kopi menjadi minuman ada banyak , mulai dari tradisional sampai alat yang sudah dimodifikasi .
Manual Brew, seperti namanya adalah cara untuk menyeduh kopi secara manual tanpa menggunakan mesin espresso. Coffee yang dihasilkan dengan cara ini umumnya kopi tanpa ampas dan sebuah teknik penyeduhan kopi yang dilakukan menggunakan alat-alat yang dioperasikan secara manual oleh para pembuatnya.
Kegunaannya hampir sama dengan coffee mesin yang membedakan adalah metodenya dan cita rasa kopi pada saat diseduh . tak jarang pengunjung dari luar kota datang kembali hanya untuk coffee manual brew,Rasanya seperti kopi hitam tetapi tidak  memiliki tingkat ketajaman rasa seperti espresso ataupun Americano .
Contoh alat-alat manual brew yang sering digunakan:
•	Chemex 
•	V60 
•	Khalita 
•	Syphon 
•	Mokka pot 
•	French prees
•	dan lainnya

Itulah alat manual brew dan perlengkapan alat pembuat kopi manual supaya tidak kebingunagn saat mencarinya.

source :https://allaboutknowledge11.blogspot.com
Web Component Progress
Tags: devjournal
Published: 2021-09-27 02:25:48


[Link to our progress](https://github.com/justinkelly124/CTA-Button/tree/main/Group19j)
## Issues
So far we have the general features and functions of the web component, but there is still a lot of work that can be done. The part I seem to be struggling with the most is the HTML implementation of the button. Being the first component we are developing for this course, I am particularly focused on making the button accessible for future use. One detail of the button that needs improvement is its documentation. I understand that this is one of the upcoming tasks, and I look forward to getting more experienced in this part of the development process.

## Learning
The simple-icon web component was the first library I have implemented into a project using a package management tool. I found the import to be very straightforward, and was quickly browsing the various icons to experiment with the look and feel of the button. This experience helped me to understand how we could use other web components in future development. In addition to the library import, I learned a lot about the structure of HTML, and also how to more effectively implement the `<a>` tag within an application.
Open source web3 projects to contribute to?
Tags: web3, hacktoberfest, discuss
Published: 2021-09-27 02:24:57

So I dropped a Tweet about this, but it probably makes more sense to have a post about it to keep a list of potential open source web3 projects more searchable.

{% twitter 1442286856889147394 %}

So what do you all have awesome people in regards to web3 open source projects that are looking for contributors?

Let's go!
CTA Button Update
Published: 2021-09-27 02:11:12

**Current State**

Currently, my partner and I, Andrew, are in a decent spot.  We have a very basic button at this point.  We have been following our in class lectures very closely as they have been very helpful to us.  We just got some of our initial issues solved in class on Thursday, including issues with GitHub.  We also just added in our icon in class on Thursday.  We have the save icon on our button right now but we may change that to another icon in the big list that we were given. 

**Difficulties**

Our biggest issues with this project thus far have really come from GitHub. My partner and I have little to no experience using GitHub so it is taking us a while to get used to doing basic tasks like pushing code. Besides that, we have run into issues with quotes ("") in the code.  We found out in class on Thursday that there is actually issues when copying and pasting code and that where our problems came from. I had sent my partner a snippet of code that I had and it was pasted incorrectly in our code. 

**Items Learned**

I have actually learned a lot thus far in this project.  I have gained a lot of skills regarding coding HTML and also using the command line to perform tasks. I have never really used the command line in other classes.  Like I spoke about earlier, I have also learned a lot about using GitHub as well.  I am looking forward to completing our button and seeing the final product.  

Repo: https://github.com/PaddysHub/CTAButton.git
Lessons from Making a Call-to-Action Button
Published: 2021-09-27 01:30:48

For the past couple weeks my class has been working on a call-to-action button. These buttons are categorized as the most important on the page—think like the “Sign Up Now” button on every website you’ve ever been on. So naturally, my group decided to recreate the [login button from Club Penguin](https://play.cprewritten.net/) PS: You have to click Play Now! first. 

Recreating an old clunky, Flash button in Open Web Components is actually way dumber and more annoying than you would think. I started the component by getting the penguin animation down. Normally you would do hover animations in CSS, BUT we are changing the source of the image in the DOM. Therefore, CSS can’t do anything for us. Enter JavaScript. This was easily achieved (and later improved by my teammate Jonah) by attaching event listeners to our button for mouse enter and mouse exit. When the mouse enters the button, change the image. When the mouse leaves the button, change the image back to the original. 

Once we finished the main animation of the button, Jonah and I started splitting the work. He would be in charge of button logic, and I would do the styling. I was able to follow a demo to figure out how to get the properties to change the CSS variables. However, I think there is an easier way to do this, which I will refactor to if possible. I have found that CSS work is more annoying in web components, or maybe I’ve just never put this much detail into a single button. But I keep finding myself making more syntax errors in CSS than ever before with the OWC workflow. We are still in the process of determining what properties of the styling we should expose in our component, so the rest of the CSS will be finished this week.

Admittedly, there is still a lot of work to be done on this button, since my team has been busy with other work. We plan to create a small, medium, and large size for the button, so the user won’t be able to mess up the penguin animation (that’s the most important part of our button, duh). Other than that, we just need to finalize the styling of the button and work on accessibility. 

{% github PenStat/PenStat-CTA %}
JS Based VAT Calculator
Published: 2021-09-27 01:25:25

In this guide, I'm going to walk through some of the coding that goes into the [vat calculator](https://vatcalculator.com/) tool that was recently developed.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z8ma32rrtxmeojhgdm8c.jpeg)

**Why we picked JS.**
This is where we will explain why JS was selected.
**Common flaws due to currency**
Due the different currencies that can be used when calculating VAT, this is where we will explain some flaws that can arise and how to resolve.
Collaborating and Contributing
Tags: opensource
Published: 2021-09-27 01:20:03

I had an easy time finding a partner to work with this week on Slack, but unfortunately I was transported to hospital for an unexpected injury.  Oh the pain... Life is like a box of chocolates I suppose. 
Anyway, when I got back, my partner had already helped add markdown features to my project. I had forked his project before but unfortunately, someone else had already worked on markdown.  
I had fun fixing issues within my own project.  I did run into a few issues like being unsure how to use CMake. I eventually figured it out with some research and was able to add [versioning](https://github.com/drew5494/the-great-site-generator/issues/7), as well as [cross compatibility](https://github.com/drew5494/the-great-site-generator/issues/9). 
I was surprised to learn about new features in C++17 that make cross platform much easier such as  ``` std::filesystem::path ```
It was nice having a partner to fix issues with my code. I have never merged a pull request for my own project before and it was a really cool process that I hope to continue to do again in the future. 
Some issues with my project include not having [support for titles in HTML](https://github.com/drew5494/the-great-site-generator/commit/dcf391589f759ff76c5ba5719ce96d54cb61db41), which is supposed to detect two blank lines after the title. Another issue included [not working with other platforms](https://github.com/drew5494/the-great-site-generator/issues/9) and also [not supporting folders](https://github.com/drew5494/the-great-site-generator/issues/3).  I was able to fix majority of the issues filed and enjoyed finding ways to solve them. Closing the issue with a solution was very rewarding. 
Testing and reviewing to ensure everything is working accordingly was time consuming but worth it in the end. Having a project that works well for everyone and doesn't have too many bugs is always a priority.
Call To Action Project Update 
Tags: webdev, javascript
Published: 2021-09-27 01:06:26

#Progress So Far
For my IST 402 project, we were assigned to make a call to action button that will be able to work on every platform. My partner and I have hit a few bumps in the road but overall it is going great! We have created a lot of our Javascript code in VSCode. 

#Difficulties
I would say our biggest difficulties lay within the terminal. For some reason running our program can be a bit harsh. We tend always run into some sort of problem. I know I have not had the most amount of experience when it comes to using the terminal so this is an amazing learning experience. We have found ourself running into problems mostly with being having the ability to push and pull to our Git repositories which is very important for our CTA button.

#Success
I think we succeed most with problem solving together. When we come together we do great on finding a solution to the problem. I also find the coding not to horrible to understand since I had prior experience which is really helpful for this class. 

#Critical Learning Points 
This project has been really great in sharpening my skills in the basic fundamentals in javascript. It is great to be able to work with HTML, CSS and more all at once. One thing I have deemed very important when making my CTA button is how the git repositories actually work. Since this is the area where I struggle most, I do find it great to use this as a learning opportunities. It is cool to see how a push and pull can update information that fast for you. I'd say it is really nice to be working in a group because we can bounce idea's off each other on how to fix whatever problem that has risen among us. 

Repository: (https://github.com/IST-402-Group-1/FPHHbutton)