teleren/devto huggingface dataset:
PG
Published: 2023-10-10 17:21:31

1. 

```
{
    "merchantId": "PGTESTPAYUAT",
    "merchantTransactionId": "MT78505dg454335",
    "merchantUserId": "MUIDfsdf343435",
    "amount": 10000,
    "redirectUrl": "https://webhook.site/redirect-url",
    "redirectMode": "REDIRECT",
    "callbackUrl": "https://webhook.site/callback-url",
    "mobileNumber": "9999999999",
    "paymentInstrument": {
        "type": "PAY_PAGE"
    }
```

1. SHA256
This SHA256 online tool helps you calculate hash from string or binary.

```
ewogICAgIm1lcmNoYW50SWQiOiAiUEdURVNUUEFZVUFUIiwKICAgICJtZXJjaGFudFRyYW5zYWN0aW9uSWQiOiAiTVQ3ODUwNWRnNDU0MzM1IiwKICAgICJtZXJjaGFudFVzZXJJZCI6ICJNVUlEZnNkZjM0MzQzNSIsCiAgICAiYW1vdW50IjogMTAwMDAsCiAgICAicmVkaXJlY3RVcmwiOiAiaHR0cHM6Ly93ZWJob29rLnNpdGUvcmVkaXJlY3QtdXJsIiwKICAgICJyZWRpcmVjdE1vZGUiOiAiUkVESVJFQ1QiLAogICAgImNhbGxiYWNrVXJsIjogImh0dHBzOi8vd2ViaG9vay5zaXRlL2NhbGxiYWNrLXVybCIsCiAgICAibW9iaWxlTnVtYmVyIjogIjk5OTk5OTk5OTkiLAogICAgInBheW1lbnRJbnN0cnVtZW50IjogewogICAgICAgICJ0eXBlIjogIlBBWV9QQUdFIgogICAgfQp9/pg/v1/pay099eb0cd-02cf-4e2a-8aca-3e6c6aff0399
```
101 berufliches Vorwärtskommen: Warum gute Taten in der Restzeit verbringen?
Tags: deutsch, career, motivation, discuss
Published: 2023-10-10 17:00:00

Moin Moin,

durch die „guten Taten“ die im [vorherigen Beitrag→](https://dev.to/amustafa16421/100-berufliches-vorwartskommen-gute-taten-in-der-restzeit-5cb9) aufgelistet sind und durch weitere in den Anmerkungen, unterstützen wir unter anderem folgende Wechselwirkung

1. Leute werden zu IT-Fachkräften ausgebildet
2. IT-Fachkräfte entwickeln die IT weiter
3. IT-Fachkräfte fördern den Nachwuchs ( also eigentlich goto „1.“ )

In gewisser Hinsicht ist es ein gewöhnlicher Werdegang: Geben und Nehmen.
Achten wir darauf, dass wir diesen aufrecht erhalten.

Lass uns mittels Kommentaren austauschen.

Beste Grüße,
Mustafa

Oder auch mittels E-Mail: mustafa.kevin.dwenger@posteo.de
Betreff: Austausch
Looking for useful AI products?
Tags: aiproduct, toprankingai
Published: 2023-10-10 16:57:44

We're living in the era of AI, hundreds of AI-powered products released every day, so I create a place to share and upvote for the most useful AI products, we don't have to dive into the AI sea anymore.

[https://topranking.ai](https://topranking.ai/?ref=devto)

![topranking.ai](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0zmgqy63tswr5lq8htw8.png)

### Let build this place together! Because, life is all about sharing, my friends.

P/S: what do you think should be improved? 🤔
SQL 📊 challenge_3 ⚔️
Tags: sql, beginners, database, datascience
Published: 2023-10-10 16:54:40

## Laptop Vs Mobile Viewership New York Times SQL Interview Question 💥

- Assume you're given the table on user viewership categorized by device type where the three types are laptop, tablet, and phone.
- Write a query that calculates the total viewership for laptops and mobile devices where mobile is defined as the sum of tablet and phone viewership.
- Output the total viewership for laptops as laptop_reviews and the total viewership for mobile devices as mobile_views.


####⚠️Note:

- You have to visit the task URL to fully understand what the task needs if you want to add a solution or test your solution.

###### Task URL: [Link](https://datalemur.com/questions/laptop-mobile-viewership )


## My Solution:


```

SELECT 

  SUM(CASE WHEN device_type = 'laptop' THEN 1 ELSE 0 END) AS laptop_views,
  SUM(CASE WHEN device_type IN ('phone', 'tablet') THEN 1 ELSE 0 END) AS mobile_views
  
FROM viewership;

```


### Code Snapshot:


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


#### My Problem 💡 Solving Repo: [Link](https://github.com/mahmoudessam820/Python-JavaScript-Programming-Exercises-)


### Learn SQL 📊


###### SQL 🔥 Get Expertise in SQL with These Top Free Courses💯🏆

🎥 {% youtube 00loCpVmozI%}


### Connect with Me 😊

#### 🔗 Links

[![linkedin](https://img.shields.io/badge/linkedin-0A66C2?style=for-the-badge&logo=linkedin&logoColor=white)](https://www.linkedin.com/in/mahmoud-el-kariouny-822719149/)

[![twitter](https://img.shields.io/badge/twitter-1DA1F2?style=for-the-badge&logo=twitter&logoColor=white)](https://twitter.com/Mahmoud42275)
THE TOOLS I LEARNT DURING MY FIRST TWO WEEKS OF LEARNING PROGRAMMING
Published: 2023-10-10 16:48:13

My name is Ahliyat. I am a secondary school graduate and i recently took a liking to programming. I got enrolled to a full stack development class at Marusoft academy and it’s my third week attending the classes. I was a bit disturbed and confused at first, given the fact that I joined the class two weeks late. I have been able to catch up on most of the tools that were taught before I started.

I learnt a few html tags that are used regularly when coding including;

The h1-h6 tag which is used for creating headings and sub-headings
The P tag for making paragraphs

The B tag to make a content bold

The I tag for italics

The white space collapsing that displays a number of spaces in a code as a single space on the browser

The br tag for adding a line break

The hr element for adding a horizontal line

I learnt that element tags like br and hr are called empty element

The U tag to underline

The S tag to show a content that is not relevant but should not be deleted

The del tag to show content that has been deleted

The ins tag to show an inserted content

The address tag to contain an address(either physical address, email address or phone number)and many more element tags

I also learnt about list, the three types of list which are the ordered list, unordered list and definition list

I learnt the tags for creating each of this lists

I learnt about nested list as well

So far, I have learnt a good number of tools in Programming and i look forward to learning more.
Pytorch codes - Part 1
Tags: beginners, tutorial, python, pytorch
Published: 2023-10-10 16:33:13

#Hi, DEV community 🙋‍♀️

In this post, I will abord some pytorch codes to help with your journey. Most of my knowledge comes from Freecodecamp tutorial, TechwithTim. The Cherno, Programing with Mosh and Fireship (all from youtube). **They deserve credit for teaching me a lot of cool stuff.**🥰

1. Imports

- General:

imports the root package, imports dataset representation and loading

```
import torch
from torch.utils.data import Dataset, DataLoader
```
- Neural Network API:

imports the computation graph, puts the tensor node in the computation graph, imports neural networks, layers ..., import optimizers and the hybrid frontend decorator plus tracing jit.

```
import torch.autograd as autograd
from torch import Tensor
import torch.nn as nn
import torch.nn.functional as F
import torch.optim as optim
from torch.jit import script, trace
```
- Torchscript and JIT

```
torch.jit.trace()

@script 
```
-ONNX

the last line prints a human-readable representation
```
torch.onnx.export(model,dummy data, xxxx.proto)

model= onnx.load("ModelName.proto")
onnx.checker.check_model(model)

onnx.helper.printable_graph(model.graph) #this one
```
-Vision

imports vision datasets. architect and transforms that can be composed

```
from torchvision import datasets, models, transforms

import torchvision.transforms as transforms
```
- Distributed Training

it will distribute the communication and the memory sharing processes

```
import torch.distributed as dist
from torch.multiprocessing import Process
```

3. Data Utilities

- Datasets
abstract class representing datasets, labelling the datasets in form of tensor and concatenation of them

```
Dataset
TensorDataset
Concat Dataset
```
- Data loaders and data samplers

```
DataLoader(dataset, batch_size=1, ...)

sampler.Sampler(dataset, ...)

sampler.XSampler where # Sequencial || Random || SubsetRandom || 
                       WeightedRandom || Batch || Distributed

```
Stay tuned for the part 2 ☆*: .｡. o(≧▽≦)o .｡.:*☆
Demystifying Application Management Software: What Does It Do?
Tags: application, appwritehack, webdev
Published: 2023-10-10 16:28:30

Today’s organizations rely heavily on software applications to streamline operations, enhance productivity, and deliver valuable services. Managing these applications is crucial for maintaining a smooth and secure IT environment.

This is where Application Management Software (AMS) comes into play. Let’s explore what this software does and how it benefits businesses apart from just deploying apps.

Software Updates and Patch Management
Keeping software applications up-to-date is essential for security and functionality. AMS allows IT teams to centrally manage software updates and patches. Admins can schedule and automate the deployment of updates, ensuring that all devices have the latest versions.

License Management
The software helps organizations efficiently manage software licenses. It tracks the number of licenses owned, monitors usage, and ensures compliance with licensing agreements. This helps prevent over-licensing and potential legal issues while optimizing software utilization.

Configuration Management
AMS enables IT administrators to configure and customize application settings for different users or groups. This ensures that applications are tailored to meet specific business needs and user requirements. Configuration management helps improve user experiences and workflow efficiency.

Remote Control and Troubleshooting
When technical issues arise, AMS allows IT teams to provide remote support and troubleshooting. IT administrators can remotely access users' devices to diagnose and resolve problems, reducing downtime and minimizing the need for on-site support visits.

Application Inventory
Maintaining an accurate inventory of installed applications is crucial for IT asset management. This software provides visibility into the software landscape, including details about the installed applications, version numbers, and usage data.

This information helps IT teams make informed decisions about software investments and retire outdated or unused applications.

Analytics and Reporting
Your software provides insights through analytics and reporting features. IT administrators can access data on software usage, license utilization, and performance metrics. This data helps in optimizing software investments, budgeting, and making informed decisions regarding software acquisitions and renewals.

Summing Up
In conclusion, [application management software ](https://quantem.io/solutions/application-management)plays a pivotal role in simplifying the complex task of managing software applications within an organization. AMS solutions by reliable providers like Quantem.io help businesses maintain a secure, efficient, and cost-effective IT environment.
Host is not allowed to connect to this MariaDB server XAMPP
Tags: mysql, php, xamp, mariadb
Published: 2023-10-10 16:23:27

XAMPP is a popular open-source software package that allows developers to set up a local web server environment for testing and developing web applications. One of the components included in XAMPP is MariaDB, a widely used open-source relational database management system.

However, when working with MariaDB in XAMPP, you may encounter the error message, "Host is not allowed to connect to this MariaDB server." In this article, we will explore the causes of this error and provide solutions to resolve it.

Possible Causes of the "Host is not allowed to connect to this MariaDB server" Error:

Access Privileges:

This error often occurs due to insufficient access privileges for the user trying to connect to the MariaDB server. Ensure that the user has the necessary privileges to access the database.
Host Restrictions:

MariaDB server, by default, may restrict connections to specific hosts. If your host is not in the list of allowed hosts, you'll encounter this error.
Firewall or Port Blocking:

A firewall or port blocking issue can prevent the connection between your application and the MariaDB server. Make sure the firewall is not blocking the MariaDB port (usually 3306).
Incorrect Configuration:

Check your application's configuration files to ensure that the host, username, password, and port settings match the MariaDB server configuration in XAMPP.
MariaDB Service Status:

Ensure that the MariaDB service is running in XAMPP. Sometimes, the server might be stopped or not properly started.
 

It's due to crash of User table in MySQL database. The solution is simple. Just follow below step.

Open XAMPP control panel

Click MySQL > Config > my.ini

Add below line under [mysqld] tag
skip-grant-tables

Save my.ini

Restart MySQL server by pressing STOP and START button.

Conclusion:
Encountering the "Host is not allowed to connect to this MariaDB server" error in XAMPP can be frustrating, but it is usually caused by issues related to access privileges, host restrictions, firewall settings, or configuration mismatches.

By following the solutions outlined in this article, you can troubleshoot and resolve this error, ensuring smooth communication between your applications and the MariaDB server within your XAMPP environment
Your Ultimate YouTube Video Download Solution
Tags: videodownload, videodownloader
Published: 2023-10-10 16:14:49

Experience Seamless Video Downloads with VTYoutube - Your Ultimate YouTube Video Download Solution

When it comes to downloading YouTube videos hassle-free, VTYoutube leads the way, offering a meticulously designed solution tailored to your video downloading needs. We recognize the importance of having access to your favorite videos, even when you're offline due to limited internet connectivity.

Our online video downloader is entirely free, putting the power in your hands to effortlessly [download YouTube videos](https://www.opyoutube.com) and enjoy them at your convenience, regardless of your internet connection status.

What sets us apart is our user-friendly interface, ensuring a swift and straightforward process. To initiate a video download, simply paste the video URL into the designated input field. Our online video download system processes your request with lightning speed, providing various video quality options while preserving the pristine quality of the original video. Your chosen video will be promptly saved to your device's local storage through our efficient [YouTube video downloader](https://www.apyoutube.com).

At VTYoutube, we're committed to simplifying and enhancing your online [video downloading](https://www.vtyoutube.com) experience. Whether you're looking to enjoy content offline or save videos for future reference, rely on us to streamline the process with our YouTube video downloader. Try it out now and discover the convenience of downloading videos from the internet with VTYoutube.
Devise Gem
Published: 2023-10-10 15:56:20

# Setting up Devise
```rails generate devise:install```

## Set a root route
Devise wants us to define a root route with:
```ruby
# config/routes.rb

root "boards#index"
```

## Generate user account
Use the generator to create the `User` model and routes.

```rails generate devise user```

```rake db:migrate```

# Explore Devise-provided RCAVs
Restart the application server and find four new routes defined:

- `GET /users/sign_up`
- `GET /users/sign_in`
- `GET /users/sign_out`
- `GET /users/edit`

# current_user
`current_user` is a helper method provided by the Devise gem used to access the logged-in user in controllers or views.

# Add foreign key columns
Associate boards and posts with owners. Modify database tables to add a new foreign key column. 

```
rails generate migration AddUserIdToBoards user_id:integer
```

```
db:migrate
```

and

```
rails generate migration AddUserIdToPosts user_id:integer
```

```
db:migrate
```

# Add foreign keys in controller actions
Now that foreign key columns are in the database tables, visit any controller actions and make sure `current_user.id` is passed to any actions that need it (e.g. boards#create).

# Update sample data task
`user_id` is not required in boards and posts. Open `lib/tasks/dev.rake` and update `sample_data` to include the foreign key when creating sample data.
Whut? [Bug Hunter #1]
Published: 2023-10-10 15:54:44

Announcing BUG HUNTER! A new series where I find bugs on the internet and share them. Its very silly, and not that useful, but it’s fun! #1. It’s right here on dev.to! Take a look:

![It’s strange](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ze5x709vml8remltbj5g.jpeg)
Yeah, weird, right?
Okay, cool!
Cya next time!
"Namo Trading Academy: Your Path to Financial Success in Trading"
Tags: webdev, website, web, tutorial
Published: 2023-10-10 15:52:33

Welcome to [Namo Trading Academy](https://www.namotrading.in/). Your Gateway to Successful Online Trading. Are you ready to embark on a journey towards financial empowerment and investment success! Look no further than Namo Trading Academy, your trusted partner in the world of online trading. We are dedicated to providing top-notch online trading services across various sectors, Stock Trading, Cryptocurrency, Gold. ensuring that you have the knowledge needed to thrive in today's dynamic financial markets.  Choose Namo Trading Academy as your partner in online trading, and unlock the potential to achieve your financial goals. Join us today and experience the difference that dedication, knowledge, and support can make in your trading journey. Let's trade towards a brighter future, together.
Alternative to Coil
Tags: discuss
Published: 2023-10-10 15:51:06

I need help. I can’t find a micropayment platform that is still in business! Coil went out of business and I want to be able to do something like Coil for my dev.to account! Also, I’d rather it not be a bank-type platform that needs my phone and SSN. Does anybody use any platform like that?
Using SQL's OFFSET and FETCH with Window Functions for Efficient Pagination and Total Count
Published: 2023-10-10 15:51:02

In modern applications, efficient data retrieval is crucial for a seamless user experience. One common scenario is paginating results, where a subset of records is displayed, and users can navigate to subsequent pages to view more. Additionally, it's often useful to show the total number of records, giving users a sense of the dataset's size.

SQL provides powerful tools to achieve this, and in this article, we'll explore how to use the `OFFSET` and `FETCH` clauses in conjunction with window functions to paginate results and obtain the total count in a single query.

## The Problem
Consider a scenario where you're building a dashboard for a company's resources. You want to display a list of resources, the number of projects associated with each resource, and the total number of resources. The catch? You only want to show a limited number of resources per page, but you still want to display the total count of resources.
    
A naive approach might involve two separate queries: one to fetch the paginated results and another to get the total count. This is inefficient and can strain the database, especially with large datasets.

## The Solution
The solution lies in SQL's window functions and the `OFFSET` and `FETCH` clauses. Here's a breakdown of the provided SQL code:

1. **Window Function for Total Count**: The line `NbTotalResources = COUNT(*) OVER()` uses the `COUNT` window function to get the total number of resources. The `OVER()` clause ensures that the count is calculated over the entire result set, not just the paginated subset.

2. **Ordering and Pagination**: The `ORDER BY` clause sorts resources by their keys. The `OFFSET` and `FETCH` clauses handle pagination. `OFFSET` skips a specified number of rows, and `FETCH` limits the number of rows returned.

## Code Example:

```sql
SELECT  dbo.Resources.ID as ResourceID,
        dbo.Resources.CompanyID as CompanyID,
        dbo.Resources.ResourceKey as ResourceKey,
        count(dbo.ProjectResources.ID) as NbProjects,
        NbTotalResources = COUNT(*) OVER() 

FROM dbo.Resources (NOLOCK)
    LEFT JOIN dbo.ProjectResources (NOLOCK) ON (dbo.ProjectResources.ResourceID = dbo.Resources.ID )
WHERE dbo.Resources.CompanyID = @companyid
 AND (@searchQuery='' OR dbo.Resources.ResourceKey like '%' + @searchQuery + '%')
GROUP BY dbo.Resources.ID,
        dbo.Resources.CompanyID,
        dbo.Resources.ResourceKey
ORDER BY dbo.Resources.ResourceKey
OFFSET @OffsetX ROWS 
FETCH NEXT @MaxRows ROWS ONLY;
```

## Conclusion

By leveraging SQL's powerful features, developers can efficiently paginate results and obtain aggregate data in a single query. This not only reduces the number of database calls but also ensures that applications remain performant and responsive.
Placeholder Pledge
Tags: hacktoberfest23
Published: 2023-10-10 15:49:42

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### Intro
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and your motivation to participate in Hacktoberfest this year. -->


### Background
<!-- Are you brand new to Hacktoberfest? What about coding in general? Tell us about how you got here -->


### Pledge
<!-- Share with us a bit about your goals during your Hacktoberfest journey this month. Are you a contributor looking to hone your skills or a maintainer looking for some help on a new project? Let us know!  -->
📱 Stay Connected with GBWhatsApp! 🌐
Published: 2023-10-10 15:33:20

📱 Stay Connected with WhatsApp! 🌐

GBWhatsApp is more than just an app; it's a bridge to your loved ones and a gateway to seamless communication. With GBWhatsApp, distance is just a number, and connecting with friends and family is easier than ever. Here's why GBWhatsApp is your go-to messaging platform:

📞 Crystal Clear Calls: Enjoy high-quality voice and video calls with your contacts anywhere in the world.

📬 Instant Messaging: Send text messages, photos, videos, and documents in the blink of an eye.

📦 File Sharing: Easily share files and documents, making collaboration a breeze.

📸 Status Updates: Share your life's moments through Status updates, photos, and videos.

🔒 End-to-End Encryption: Your messages and calls are securely protected with industry-standard encryption.

🌍 Global Reach: Connect with friends and family across borders without international calling fees.

💬 Group Chats: Stay in touch with multiple friends or family members in one convenient group chat.

🎉 Fun and Expressive: Use stickers, emojis, and GIFs to add fun and emotion to your conversations.

🔔 Notifications: Receive instant notifications so you never miss a message.

🔍 Searchable Chats: Find important information in your chat history quickly and easily.

💡 Easy Setup: Simply verify your phone number, and you're ready to start chatting!

Join the GBWhatsApp community today and experience the joy of staying connected with those who matter most.

Download **[GBWhatsApp](https://gbplus.pk) **[Allee](https://allee.store)****

Let's chat! 📲 #WhatsApp #StayConnected
QU'EST-CE QUE LE TRAITEMENT DES EAUX ?
Published: 2023-10-10 15:31:47

Le [traitement des eaux](https://colibri2000.fr/traitements-de-leau/) désigne l’ensemble des processus et techniques utilisés pour purifier, désinfecter et rendre l’eau propre à la consommation ou à d’autres utilisations, en éliminant les impuretés.