teleren/devto huggingface dataset:
Ordenando e Agrupando seus Dados no SQL
Tags: datascience, sql, beginners, tutorial
Published: 2023-07-12 13:00:00

Olá a todos! Hoje, vamos explorar duas das cláusulas mais importantes em SQL: ORDER BY e GROUP BY. Essas cláusulas nos permitem ordenar e agrupar nossos dados.

**1. ORDER BY**

A cláusula ORDER BY nos permite ordenar os resultados de uma consulta em ordem crescente (ASC) ou decrescente (DESC), baseado nos valores de uma ou mais colunas. Por exemplo:

```
SELECT * FROM Alunos ORDER BY Idade ASC;
```

Este comando irá retornar todos os alunos ordenados por idade em ordem crescente. Se quiséssemos em ordem decrescente, simplesmente substituímos ASC por DESC.

Podemos também ordenar por várias colunas. Por exemplo:

```
SELECT * FROM Alunos ORDER BY Curso ASC, Idade DESC;
```

Neste caso, os alunos são primeiramente ordenados pelo nome do curso em ordem crescente. Dentro de cada curso, os alunos são ordenados por idade em ordem decrescente.

**2. GROUP BY**

A cláusula GROUP BY nos permite agrupar linhas que têm os mesmos valores em colunas específicas. Veja este exemplo:

```
SELECT Curso, COUNT(*) FROM Alunos GROUP BY Curso;
```

Esta consulta retornará o número de alunos em cada curso. Neste caso, a função agregada COUNT(*) conta o número de alunos em cada "grupo" de cursos.

GROUP BY deve ser obrigatoriamente usado com funções de agregação como COUNT(*), MAX(), MIN(), AVG(), e SUM(). Estas funções realizam cálculos sobre cada grupo de linhas.

Por exemplo, para encontrar a idade média dos alunos em cada curso, poderíamos usar:

```
SELECT Curso, AVG(Idade) FROM Alunos GROUP BY Curso;
```

Aprender a usar ORDER BY e GROUP BY é fundamental para trabalhar efetivamente com SQL. Essas cláusulas permitem que você manipule seus dados de maneiras poderosas, facilitando a análise e o entendimento de grandes conjuntos de dados. Continue praticando e explorando o que você pode fazer com ORDER BY e GROUP BY.
Dev Vlog - Latest Update
Tags: gamedev, unity3d, csharp
Published: 2023-07-12 12:59:17

Latest Vlog of my game here: Updated 2024-04-11:
{% youtube g1IcBcr5MBM  %}
youtube link: https://youtu.be/g1IcBcr5MBM 


Aiming to create a fast-paced military top down action/strategy game. Might also become a tower defense game, who knows. This is a small scale indie project so far, I hope to scale it up at a later stage. 

Systems which are in place now:
- Damage System (armored, light, standard)
- Vehicle System
- Ammo Types and Ammo Variations which can be swapped on the fly by the player
- Mesh sockets for weapon types
- Manual Reload System with mouse gestures
- A.I. with state machine that scan and fight any layer we select

Next step: 
- Refine Player Controller, make snappy and fast
- Implement more enemy A.I. types, both enemy and player
- More A.I. attacks (grenade throws, rocket launchers etc) 
- More A.I. maneuvers (roll away, evade)
- Make a single player map
- Make tutorial

Long term: 
- Campaign
- Multiplayer

Comments with tips and trix are welcome. I'm very open to feedback, new ideas and what could be tweaked. If anyone want to join this endeavor, please reach out to me! 

Cheers! 
/ Eric
My Journey in Bitcoin Summer Code of Camp: Lessons Learned
Tags: postgres, opensource, contributorswanted, tutorial
Published: 2023-07-12 12:36:32

As a participant in the Bitcoin Summer Code of Camp, I faced several challenges that I would like to share with others who may be going through similar experiences. Here are some bullet points that summarize what I learned:

1. Talk to elders in the same project: While it may seem obvious, you won't have a good idea about the project until you read the documentation and talk to people who have experience with it. Don't be afraid to reach out to seniors and ask questions.
2. Ask for evaluation: Some seniors can help you find the right spot that matches your current skills. Don't be afraid to ask for feedback on your progress and how you can improve.

3. Don't be discouraged if you don't know the technology: Learning a new technology is not the main problem. The challenge is how to apply the technology to the project. Focus on understanding the project requirements and how the technology can help you achieve the project goals.

4. Take your time: Some developers have been watching or working with the company for months, waiting for their chance to participate. You may feel like you're late to the game, but don't rush. Take your time to understand the project, learn the technology, and contribute in a meaningful way.

5. Participate in hackathons for more challenging projects and new stacks: Hackathons help you get fast and act in a very efficient way to learn. They do have labels for the requirements, current skill level needed, etc., which helps you decide if you are ready for this.

Websites for hackathons: Here are some websites for hackathons that you can check out:

[Devpost](https://devpost.com/)
[HackerEarth](https://www.hackerearth.com/)
[AngelHack](https://www.angelhack.com/)

Join open source projects: AGE is also an open source project. If you have any questions or facing any challenges, they provide a very interactive environment for contributors. Don't hesitate to message me if you need any help.
Overall, my experience in the Bitcoin Summer Code of Camp was challenging but rewarding. By following these lessons learned, 
I was able to contribute to the project and improve my skills. Good luck to anyone else who is embarking on a similar journey!
What is your perspective on this "Data API Framework"?
Tags: discuss, opensource, database, data
Published: 2023-07-12 12:30:45

Hey, friends

If there is a Data API Framework with these functionalities listed below, what do you think about this tool(or what would you do with this tool)?

1. You only need to write SQL + Jinja(a template language)and the framework generates APIs and API documentation(based on Open API)for you. 
2. It has API catalog that helps non-tech user to explore your APIs and some simple guides to help him/her connect with other applications, such as Google Spreadsheet, Retool, etc.
3. It supports several databases such as PostgreSQL, DuckDB, ClickHouse, BigQuery and Snowflake. You can also write your own connector.
4. It has some API best practices built-in such as authorization, authentication, error handling, rate-limiting, CORS, pagination, etc.
5. It utilizes DuckDB as a caching layer to improve query performance.
6. It has data privacy mechanisms such as data masking, row/column level security, etc.
7. It supports several deployment mechanisms such as node.js and Docker, etc.



Disclaimer: I am one of the members of the open source project [VulcanSQL](https://vulcansql.com/)
Day 3: Polyfill for Array.flat()
Tags: day3, 100daysofcode, javascript
Published: 2023-07-12 12:30:00

Today, we'll create a polyfill for the Array.flat() method. 
The Array.flat() method flattens nested arrays to a specified depth. Our goal is to create a function called myFlat that will implement this behavior.

```javascript
// Test cases
const array = [1, [2], [3, [3]]];

console.log(array.myFlat()); // Output: [1, 2, 3, [3]]
console.log(array.myFlat(1)); // Output: [1, 2, 3, [3]]
console.log(array.myFlat(3)); // Output: [1, 2, 3, 3]
console.log(array.myFlat(Infinity)); // Output: [1, 2, 3, 3]
```

## Plan

To solve this problem, we'll follow these steps:

- Implement the myFlat function to recursively flatten the array.
- The myFlat function will take an optional depth parameter that specifies the depth to which the array should be flattened.
- Check if the Array.prototype.myFlat property exists.
- If it doesn't exist, create a new property called myFlat on Array.prototype and assign it a function.


Check the comment below to see answer.
Cùng 123b tìm hiểu các loại kèo bóng đá hay nhất
Published: 2023-07-12 12:23:57

[Bóng đá](https://123b.wtf/cung-123b-tim-hieu-cac-loai-keo-bong-da-hay-nhat/) là môn thể thao có lượng người hâm mộ đông nhất hiện nay. Để thỏa mãn niềm đam mê của người chơi, [nhà cái 123B](https://123b.wtf/) đã đưa ra tỷ lệ cá cược, cá loại kèo bóng đá để anh em thỏa mãn. Để tìm hiểu về các loại kèo trong bóng đá, anh em cùng chúng tôi tìm hiểu thông qua bài viết dưới đây
Bật mí cách chiến thắng nhà cái từ các cao thủ
Published: 2023-07-12 12:28:21

Cá cược là hình thức được nhiều người yêu thích. Để thỏa mãn niềm đam mê và có cơ hội kiếm tiền về cho bản thân. Tuy nhiên, không phải ai cũng biết cách chiến thắng nhà cái. Bài viết sau đây sẽ [bật mí cách chiến thắng nhà cái](https://123b.wtf/bat-mi-cach-chien-thang-nha-cai-tu-cac-cao-thu/) để anh em tham khảo.
How to hack http://
Tags: security, webdev, learning, hacking
Published: 2023-07-12 12:26:25

Inspired by this article below, I'll show you how to hack an `http` website!
{% embed https://dev.to/junedang/what-is-https-and-how-does-it-work-3fko %}

---
If you like this article, I would appreciate a comment & like :heart:!
**Thanks!**

---

## 1. What you need
- `http` website with username/password form (no `https`!)
- Wireshark
- Internet connection

### 1.1 Choose http website
Which unencrypted website should I use? Is that unsafe then? Should I look for one online?
**NO!**
I will soon publish my own http website on Github so you can try it out! You can of course also find them here!
{% embed https://github.com/SchBenedikt/http-website %}

### Install Wireshark on your first device
To be able to read the access data yourself, you need a program called "Wireshark".
Have you ever heard of this?
No? / Yes? Feel free to write it in the comments!
We need this. You can easily install this on your device using the link below!
{% embed https://www.wireshark.org/download.html %}
You'll have to tap "Next" quite a few times, but you can leave all the settings as they are.
Also note that other apps will also be installed!
When you start the app it should look like this:
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/832oo0r0jkxjzygpxcr2.png)
### Using XAMPPon your second device
For Windows you can use the app XAMPP for a local web server:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/nbqt97eqsy7pjv8xqwxn.png)
The Github web server files should then be in this folder: `C:\xampp\htdocs`.

## Run website
Now when you are done with the installation, you need to go to this page on your second device: http://localhost/http-website-main/index.html
It should look like this:
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7s97rkkqzshnn3vou53r.png)
**✅ Well done!**
- Open Wireshark and choose your main network with a double click:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rtwhdqknte47b5ldw9mq.png)
- Search for `http` and tip `enter`
This is the filter that only allows http requests
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qvqwn4jv03n95944d9pu.png)
- Tap "Login" in your website
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iiib7h4kjde0hp9d8m4l.png)
- You should be logged in

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/m1vymqmttqsp15euasyz.png)
- Anywhere, there should be something like this with `x-www-form-urlencoded`
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/m66yqjsppdbs145aajrz.png)
- Tap on this
- Scroll down and expand the last one (HTML Form URL encoded):

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

---
Great, you did it!
Note that this is to help you understand how hackers work. This should not be a suggestion to actively use this for hacking!

---
Thanks for your attention, schBenedikt
Juniors Should be Seniors Someday!
Tags: beginners, career, codenewbie, discuss
Published: 2023-07-12 12:03:37

Finding a job as a junior developer is not easy these days, especially when you are from a third-world country, but **Juniors Should be Seniors Someday!**

It's the story of me:

## Real Job Experience
At some point, I think you should put all tutorials, YouTube videos, and personal project experiences into a real job and grow; otherwise, it's hard to be better. But how hard is it to get a good job?

## Rejection
It's been month now that I'm sending multiple applications to companies hoping to get a chance and I get nothing but **Rejection!** So they tell me there were better candidates than me, and it's OK, but after more than 500 rejections, a question comes to mind: **Am I that bad???**


![George's talent](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zfq0p9ecb8cjtqwru82q.jpg)

## Junior Positions
There are way fewer junior positions than senior ones, or they want 3+ years of experience, but how the hell am I going to get 3+ years when I just graduated? I'm guessing the seniors have been seniors since they were born; unfortunately, no junior made it.

## Third-World Theory
So I have a theory. Well,  it's actually not "Third-World Theory", it's more "Dictatorship Country Theory", well more "Terrorist Coun..." (if I got arrested, I was a good boy). I think most of them are rejecting me because of where I'm from. They open my application, see my country, and then boom... **Reject!**

Believe me, I had nothing to do with that; you can blame my parents, I hate this country more than you do; they took our youth, our lives, and... (enough already), and I need job experience so I could leave here as all the people are doing so.

I wish I was there when they opened my application to tell them, "Please at least take a look at my work!".

But as I mentioned in the header, it's just a theory; The truth is, I'm bad. ![I'm OK](https://media.giphy.com/media/e3X9ZcuLp1QgE/giphy.gif)

## Discussion
I nagged a lot, and you may say, "Just be better instead of nagging" but I'm going through tough days, and at the end, I wanted to tell you to just have a little trust in us; We're not that bad (Yes we are). ![Joke](https://media.giphy.com/media/v1.Y2lkPTc5MGI3NjExdndoMmhmb2VqdnBteHgzMnJpdW42MTJnOTNscmw5a2k3YWVxYWhzeiZlcD12MV9pbnRlcm5hbF9naWZfYnlfaWQmY3Q9Zw/l41lYkRVPnYliDnMY/giphy.gif)

The question is, **What should junior developers do to land a job in your opinion?** 
<hr/>

Thanks a lot for taking your time to read and I'd love to hear your ideas and lets connect: **[Portfolio](https://www.alinavidi.dev/) [GitHub](https://github.com/westernal)**
This one Nuxt trick prevents broken deploys
Tags: webdev, nuxt, netlify, beginners
Published: 2023-07-12 12:03:13

Have you ever experienced broken deploys while using Nuxt? It can be frustrating when your build encounters errors, but still proceeds to deploy all the files, resulting in broken pages on your website. Fortunately, I discovered a handy Nuxt trick that prevents such broken deploys and ensures a more reliable deployment process.

In my case, I encountered occasional rate limits while making API calls, which caused some pages to be deployed without any content. However, even with these errors, Nuxt 2 completes the build process with a success code, leading to the deployment of incomplete pages. To overcome this issue, I found a simple solution: adding the `--fail-on-error` flag to the Nuxt build command.

By incorporating the `--fail-on-error` flag, Nuxt is instructed to halt the build process immediately upon encountering any errors. This prevents the deployment of incomplete or broken pages, providing a more accurate representation of your website to visitors. Whether you are using Netlify or any other static hosting platform, this trick can be applied to ensure a reliable deployment process.

With this Nuxt trick in place, you can rest assured that your deployments will only go live when everything has been successfully built without errors. No longer will you have to worry about visitors stumbling upon pages with missing content due to API rate limits or other build failures. The `--fail-on-error` flag acts as a safeguard, ensuring that your website is consistently deployed in a reliable and complete state.

So, if you've been facing issues with broken deploys while using Nuxt, give this simple trick a try. Incorporating the `--fail-on-error` flag into your Nuxt build command will help you avoid incomplete deployments, resulting in a more seamless and error-free website for your users. Remember, a small adjustment like this can go a long way in preventing broken deploys and enhancing the overall user experience.
Transition between pages smoothly with a single line of code
Tags: webdev, html, css
Published: 2023-07-12 11:49:48

[CSS View Transitions](https://developer.chrome.com/docs/web-platform/view-transitions/) is one of the latest additions to Chromium-based browsers, and I decided to try it.

I was following [Dave's instructions](https://daverupert.com/2023/05/getting-started-view-transitions/), and I immediately noticed something that I liked a lot. As soon as I enabled the View Transitions in my browser (since it is still an experimental technology) and added `<meta name="view-transition" content="same-origin">` to every page of my site, I noticed the transition was already working.


![CSS View Transitions in action on my site.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n2ups4jwc0rv8nuj2ymt.gif)

It works in the most basic mode, fading out the current page and fading in the visited page, which is a thousand times better than the default behavior (in my humble opinion). And there you have it—fully functional transitions between your website pages with a single line of code.
How can I avoid content disappearing on my WordPress website?
Tags: wordpress
Published: 2023-07-12 11:41:27

When working with WordPress and utilizing tools like ACF (Advanced Custom Fields), Custom Post Types UI, and a low-code editor such as Elementor, it's typically rare to include GitHub as part of the tech stack.

Have you ever experienced a scenario where content disappeared on your WordPress website? How did your company handle it, and what precautions have you taken within your technical infrastructure to avoid such incidents in the future?
Roof Cleaning and Soft Water Pressure Washing
Published: 2023-07-12 11:41:04

Your home's exterior is subjected to the elements day in and day out, and over time, it can accumulate dirt, grime, and even algae or moss growth. As a homeowner, it's essential to maintain the cleanliness and appearance of your property, and one effective way to achieve that is through roof cleaning and soft water pressure washing.

Roof cleaning is a crucial aspect of home maintenance that often goes overlooked. A dirty roof not only diminishes the curb appeal of your house but can also lead to more significant issues such as roof damage or leaks. By employing professional roof cleaning services, you can ensure that your roof stays in top condition, extending its lifespan and preserving its structural integrity.

Soft water pressure washing is another powerful tool to rejuvenate your home's exterior. Unlike traditional pressure washing that utilizes high-pressure water streams, soft water pressure washing employs a gentler approach. This method uses a combination of low-pressure water and specialized detergents to remove dirt, grime, mold, and other contaminants without causing damage to delicate surfaces like siding, windows, or deck.

When it comes to roof cleaning and soft water pressure washing, it's crucial to hire a reputable and experienced company like [Fernandina Beach Exterior Cleaning](https://fbexteriorcleaning.com/). Their team of skilled professionals understands the intricacies of the cleaning process and employs industry-standard techniques and environmentally friendly products to deliver exceptional results.

Investing in roof cleaning and soft water pressure washing not only enhances the overall aesthetic appeal of your home but also helps protect your investment. By partnering with Fernandina Beach Exterior Cleaning, you can ensure that your home's exterior receives the care and attention it deserves, leaving it looking fresh, clean, and revitalized for years to come.
+Doctor: Innovative and Free Clinic Management Software
Tags: webdev, programming, healthydebate, tutorial
Published: 2023-07-12 11:32:15

## (Bringing healthcare to your fingertips, for Free)

+Doctor Practice and **Clinic Management Software** is tailor-made to address your specific needs according to your specialization helping all Medical Practioners to build and grow their private practice. +Doctor is well-integrated and intelligent software connecting the dots between Patient, Staff and Medical Practitioners. +Doctor allows you to nurture meaningful patient relationships while building a sustainable and financially-viable private physician practice.

## Why Practice Management Software?

### Your data is Everything Choose Confidentiality. Choose +Doctor
Do you know – Your Patient and Clinical data is Spine of your Clinic? This requires confidentiality thus boosting privacy of your Patient... [View More](https://www.plus-doctor.com/data-security.php)


### Technology and Clinical Process Automation FASTag your Clinic with +Doctor
+Doctor is FASTag of your Clinic helping your Clinic gain the required momentum. With the help of automating process management... [View More](https://www.plus-doctor.com/automation-and-fast.php)


### Insure Patient Satisfaction +Doctor is your Premium
+Doctor’s Clinic Management software offering out of the box integrations and amazing features which assist in streamlining clinical...[View More](https://www.plus-doctor.com/insure-patient.php)
📈 More Statistics 📉 for Stack Overflow 2023 survey
Tags: stackoverflow, statistics, svelte
Published: 2023-07-12 11:30:49

So recently, I gathered data from the _2023 developer survey of Stack Overflow_, and I decided to create an account here to share my project.

In the [survey's results](https://survey.stackoverflow.co/2023/#technology-admired-and-desired), on the Desired/Admired part, technologies are sorted by "Desired" only, it's not possible to sort them by "Admired". Also, it would be interesting to rank and compare them with the average between "Desired" and "Admired", as well as the width between the two dots.

It's for these reasons I build a simple display based on the data.

[Browse results](https://mariovieilledent.github.io/)
[Github repo](https://github.com/MarioVieilledent/stackoverflow-better-stats)
Beware of double dollar sign "$$" in a variable in PHP.
Tags: php, softwareengineering, programming, beginners
Published: 2023-07-12 11:20:09

We all know Dollar sign($) is used to declare a variable in PHP. What if we accidentally type dollar sign two times for a variable. This can potentially affect your expected output.

For example, let's say we want to encrypt data. The output of the encrypted data will not be the same for variables with single dollar variable ($x) and double dollar variable ($$x) because the $$x (double dollar) is a reference variable. This reference variable is called variable variables in PHP. Variable variables are simply variables whose names are dynamically created by another variable’s value.

So, we also need to check this kind of mistake while debugging our code if the logic of the code seems alright. 

Happy bug finding!

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

Thank you for reading my article. You can join [code with rubab](https://www.facebook.com/groups/codewithrubab) for web development-related queries & discussions.

Also, you can find me on:

[Linkedin For Regular Posts](https://www.linkedin.com/in/imran-hossain-rubab/)

[My website](https://codewithrubab.com/)

[My Facebook Page](https://www.facebook.com/codewithrubab)

[My Youtube Channel](https://www.youtube.com/@codeWithRubab)