teleren/devto huggingface dataset:
7 MySQL Database Management Labs to Boost Your Skills 💻
Tags: coding, programming, tutorial, mysql
Published: 2024-06-17 20:08:08


Dive into the world of MySQL database management with these 7 comprehensive lab projects from LabEx! Whether you're a beginner or an experienced database administrator, these hands-on tutorials will equip you with essential skills to manage and optimize your MySQL databases. 🔍

## Explore the Power of MySQL Database Management 🔍

### 1. [Largest Population by Country (Lab)](https://labex.io/labs/301350)
In this project, you'll learn how to access a MySQL database, import data, and query the top 10 countries by total population from the city table.

### 2. [Other Basic Operations](https://labex.io/labs/178587)
This lab will teach you the crucial concepts of indexing, creating views, and performing backup and recovery operations in MySQL.

### 3. [Managing Database Indexes in MySQL (Lab)](https://labex.io/labs/301274)
Discover how to effectively manage indexes in a MySQL database, including adding an index to the title field of the course table in the edusys database.

### 4. [Query Population of All Countries (Lab)](https://labex.io/labs/301388)
Enhance your SQL querying skills by learning how to retrieve population data for all countries from a MySQL database.

### 5. [Manage MySQL User Permissions (Lab)](https://labex.io/labs/301430)
Dive into the world of user management in MySQL, as you create a new local user named "Rong" and grant them access to the performance_schema database.

### 6. [Average Salaries Per Department (Lab)](https://labex.io/labs/301284)
Explore SQL queries to calculate the average salary for each department in a database and display the results in descending order.

### 7. [Modifying the Teacher Table Using PreparedStatement (Lab)](https://labex.io/labs/301362)
Learn how to use JDBC and PreparedStatement to delete data from a MySQL database table, focusing on the benefits of PreparedStatement over regular SQL statements for improved security and performance.

Dive in and start your MySQL database management journey today! 🚀 Don't forget to check out the lab links for hands-on practice and skill-building. Happy learning! 🎉

---

## Want to learn more?

- 🌳 Learn the latest [MySQL Skill Trees](https://labex.io/skilltrees/mysql)
- 📖 Read More [MySQL Tutorials](https://labex.io/tutorials/category/mysql)
- 🚀 Practice thousands of programming labs on [LabEx](https://labex.io)

Join our [Discord](https://discord.gg/J6k3u69nU6) or tweet us [@WeAreLabEx](https://twitter.com/WeAreLabEx) ! 😄
Discover the truth about Dmitry Gunyashov and his involvement with Freewallet.
Published: 2024-06-17 19:48:53


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

Our latest article delves deep into Gunyashov's background, exposing the intricate details of his operations and uncovering the hidden connections that have allowed him to continue his fraudulent activities for years. From his early beginnings to his current status, we leave no stone unturned in our quest to reveal the reality behind his public persona.

In our investigation, we have compiled comprehensive information that not only highlights Gunyashov’s deceptive tactics but also sheds light on the broader network he operates within. This is a must-read for anyone who wants to understand the full scope of the Freewallet scam and its implications for the cryptocurrency community.

Stay informed and protect yourself from potential scams. Visit our main page for the full story and explore other insightful articles that will keep you updated on the latest developments in this ongoing saga.


Read the full article on Dmitry Gunyashov here and don’t forget to check out our homepage for more investigative reports and critical updates.

Visit dmitrygunyashov.info to stay ahead and stay safe.
interactive cylinder cat
Tags: codepen
Published: 2024-06-17 20:01:32

I wondered what a cylindrical cat looks like, so I coded one - I achieved the 3D cylinder effect by combining different kinds of rotations. You can rotate the cat by clicking / touching on it face or tail, and roll the cat by dragging. The cylinder cat also walks around the screen.

{% codepen https://codepen.io/Ma5a/pen/eYaGyry %}
Do you have an open-source project ?
Tags: opensource, webdev, beginners, javascript
Published: 2024-06-17 19:50:28

First-Issues is an initiative to curate easy pickings from open-source projects, so developers who’ve never contributed to open-source can get started quickly.

Open-source maintainers are always looking to get more people involved, but new developers generally think it’s challenging to become a contributor. We believe getting developers to fix super-easy issues removes the barrier for future contributions.

This is why https://firstissues.dev/ exists. While we are building the MVP, we are on the look out for open source projects that are actively maintained and have atleast 3 good first issues.

If you are open source maintainer and looking for contributors, please share your Github repository to get featured on the app.
<h2>Explorando las Funciones Avanzadas en Javascript</h2><p>
Tags: javascript
Published: 2024-06-17 19:42:03

<strong>Javascript</strong> es un lenguaje de programación tan versátil que puede ser utilizado tanto en el front-end como en el back-end. Sin embargo, uno de los pilares fundamentales de este lenguaje son sus funciones. Las funciones en Javascript no solo permiten la reutilización de código, sino que también juegan un papel crucial en la creación de aplicaciones más eficientes y robustas.</p><h3>Introducción a las Funciones</h3><p>Las funciones en Javascript son bloques de código diseñados para realizar una tarea específica. Se pueden definir utilizando la palabra clave <em>function</em>, seguida del nombre de la función, un conjunto de paréntesis y, finalmente, un bloque de código encerrado entre llaves. Un ejemplo básico sería:</p><pre><code>function saludar() {    console.log('¡Hola Mundo!');}saludar();  // Imprime “¡Hola Mundo!” en la consola</code></pre><h3>Funciones Anónimas y Arrow Functions</h3><p>En Javascript, también puedes crear funciones anónimas y <em>arrow functions</em>. Estas últimas ofrecen una sintaxis más compacta y son especialmente útiles cuando se trata de funciones de una sola línea. Por ejemplo:</p><pre><code>const saludar = () => console.log('¡Hola Mundo!');saludar();  // Imprime “¡Hola Mundo!” en la consola</code></pre><h3>Funciones como Ciudadanos de Primera Clase</h3><p>Una de las características más poderosas de Javascript es que las funciones son <em>ciudadanos de primera clase</em>. Esto significa que pueden ser asignadas a variables, pasadas como argumentos a otras funciones y retornadas desde funciones. Aquí hay un ejemplo:</p><pre><code>function operar(operacion, a, b) {    return operacion(a, b);}const suma = (x, y) => x + y;console.log(operar(suma, 5, 3));  // Imprime 8</code></pre><h3>Closures</h3><p>Un concepto avanzado pero extremadamente útil en Javascript es el de <em>closure</em>. Un closure es una función que tiene acceso a las variables de su ámbito exterior incluso después de que la función exterior haya terminado de ejecutarse. Esto permite la creación de funciones privadas y es útil para mantener el estado. Aquí vemos un ejemplo sencillo de un closure:</p><pre><code>function crearContador() {    let contador = 0;    return function() {        contador++;        console.log(contador);    }}const incrementar = crearContador();incrementar();  // Imprime 1incrementar();  // Imprime 2</code></pre><h3>Conclusión</h3><p>Las funciones en Javascript son una herramienta extremadamente versátil y poderosa. Desde la creación de closures hasta la definición de funciones anónimas y arrow functions, las posibilidades son infinitas. Si te interesa profundizar más en las funciones de Javascript y aprender sobre sus características avanzadas, te recomiendo que visites este <a href='https://synzen.org/15-funciones-en-javascript/'>enlace sobre #15 Funciones en Javascript</a>, donde encontrarás información detallada y ejemplos más específicos.</p>
💥Notcoin (NOT) drops by over 15% drop in price
Published: 2024-06-17 18:56:16


Since the conclusion of the most recent airdrop claim period on Sunday, the crypto known as Notcoin (NOT) has experienced a huge decrease of 18.3%, falling from $0.02071 to $0.0175.

As of the time this article was written, the price of Notcoin is $0.01804, and its total market capitalization is $1.85 billion.

The trade volume of Notcoin has decreased by more than twenty percent during the course of the past twenty-four hours, reaching a total of eight hundred and ninety-nine million dollars.

This decrease is accompanied by a more widespread correction in the market, with Notcoin currently trading at a price that is more than 37% lower than its all-time high of $0.02896.

Despite this, it continues to be the 57th largest cryptocurrency by market capitalization, outperforming renowned projects such as Jupiter and zkSync in terms of the buzz around it.
Notcoin has acquired a sizeable user base, having 11.5 million holders, with at least 2.5 million confirmed as on-chain participants. This is despite the fact that the crypto has experienced negative growth.

Notcoin is a cryptocurrency that is only partially developed. It is based on the TON blockchain and initially acquired popularity by means of an airdrop that was distributed to users of a popular tap-to-earn game that is based on Telegram.

Notcoin's rapid acceptance and favorable attention from the cryptocurrency world can be attributed to the widespread success of the game.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/p3o4v95e15wcvhnlp6qo.png)
#babylonjs Browser MMORPG #indiegamedev Ep21 - Spatial Hash Grid Area of Interest
Tags: babylonjs, indiegamedev, devlog, mmorpg
Published: 2024-06-17 18:54:23

Hello
I'm working on  POC (prove of concept) implementation of monsters system. I managed to achieve first milestone which is loading entities into engine.
And finally i have occasion to show You how my hash grid area of interest is working.
Engine is refreshing area of interest data each second and it sends info to the clients to show/remove entity. There're two visibility ranges. First is lower (eg 50 units)  it describes distance below which entity should be visible and second visibility range (eg 100 units) is bigger and it's use to hide entities. This way I'm avoiding sending create/remove entity command when some entity is on the edge of visibility and potentially I'd have to show/hide and resend entity each spatial hash grid update.

Keep in mind that it's not working on radius but on bounding boxes (rectangles) and entities visibility is not symmetrical. This implementation is far more efficient and actually not having it symmetrical doesn't change anything. Eventually I'll setup it to comfortable range and players will no care about it.

{% youtube 1siK2BjyZVg %}
Closure 🫥
Tags: javascript, closure
Published: 2024-06-17 18:51:26

> In JavaScript, a closure is a feature where an inner function has access to the outer (enclosing) function’s variables. This includes the outer function’s parameters, variables declared within the outer function, and variables declared in the global scope.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7nyzf3ttk8ymvoeiyw3c.png)
#### Example: 

```
function outherFunction(outVar) {
    let icon = '☺️'
    return function innerFunction(innerVar) {
        let excMark = '!!!'

        console.log('Outer:', outVar)
        console.log('Inner:', innerVar)
        console.log(`Together:  ${icon} ${outVar} ${innerVar} ${excMark}`)
    }
}
let newFN = outherFunction('Hello')
newFN('World')

// Outer: Hello
// Inner: World
// Together:  ☺️ Hello World !!!
```
#  FUNNY EXAMPLES FOR CLOSURE
EXAMPLE 1:

```
function aboutTeller(lie) {
    return {
        tellAbout : function() {
            console.log(lie)
        },
        changeAbout : function(truth) {
            lie = truth
        }
    }
}
const aboutMe = aboutTeller('I am senior developer.');
aboutMe.tellAbout()
aboutMe.changeAbout('I am junior developer.');
aboutMe.tellAbout()

// I am senior developer.
// I am junior developer.
```
EXAMPLE 2:
```
// A collector squirrel
function collectorSquirrel() {
    let nuts = 0;
    return {
        stored : function (numNuts) {
            nuts += numNuts;
            console.log(`Squirrel stored ${numNuts} nuts into the wood.`)
        },
        has : function () {
            console.log(`Squirrel has ${nuts} nuts.`)
        }
    }
}
let mySquirrel = collectorSquirrel()


mySquirrel.stored(3)
mySquirrel.has()

// Squirrel stored 3 nuts into the wood.
// Squirrel has 3 nuts.
```
// EXAMPLE 3:
```
// Time traveler
function timeTravel() {
    time = new Date().getFullYear()
    return {

        travelTo: function(desiredTime) {
            console.log(`Hello! Welcome to ${time + desiredTime}. Have a nice time!`)
        },

        reset: function() {
            time = new Date().getFullYear()
            console.log(time)
        }
    }
}
let thisTime = timeTravel()

thisTime.travelTo(10) // Hello! Welcome to 2034. Have a nice time!

thisTime.reset() // 2024
```

// EXAMPLE 4:
```
// The Motivational Coach
function motivationalCoach () {
    const phrases = [
        "You're doing great!",
        "Keep up the good work!",
        "You can do it!",
        "Believe in yourself!"
    ];

    return function() {
        let phrase = phrases[Math.floor(Math.random() * phrases.length)];
        console.log(phrase)
    }
}

let motivateMe = motivationalCoach()
motivateMe() // You can do it!
```
🤯Notcoin (NOT) Faces 11% Decline Post-Airdrop
Published: 2024-06-17 18:51:23


The well-known cryptocurrency Notcoin (NOT) has seen a significant 18.3% decline, dropping from $0.02071 to $0.0175, since the end of its recent airdrop claim period on Sunday. At the time of writing, Notcoin is trading at $0.01804 with a market cap of $1.85 billion. In the last 24 hours, Notcoin’s trading volume has dipped by more than 20%, settling at $809 million. This decline accompanies a broader market correction, with Notcoin now trading over 37% lower than its peak value of $0.02896. Nonetheless, it remains the 57th largest cryptocurrency by market capitalization, surpassing prominent projects like Jupiter and zkSync in the hype.

Despite this downturn, Notcoin has amassed a sizable user base, boasting 11.5 million holders, with at least 2.5 million confirmed as on-chain participants. Notcoin is a partially new crypto that operates on the TON blockchain and gained initial attraction through an airdrop to users of a popular Telegram-based tap-to-earn game. 

The game’s success led to Notcoin’s rapid adoption and favorable attention from the crypto community. Concurrently, the TON blockchain itself has experienced a surge, recently surpassing its previous all-time high and exceeding $8.08. Active wallet addresses on TON have surpassed 577848, indicating significant ecosystem growth.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ag51tnqrodiplb772mzz.png)
🚀3 Altcoins to Watch After the ETH ETF Market Launch: Pepe (PEPE), Optimism (OP) and Rebel Satoshi Arcade (RECQ)
Published: 2024-06-17 18:50:45


🚀 Ethereum ETF Launch: Altcoins Ready to Shine

🔹 Rebel Satoshi Arcade (RECQ): 5,000% Growth Potential
Built on Ethereum, RECQ blends memes, NFTs, and GameFi, making it a standout investment. With a presale token price of $0.0044 and an upcoming rich ecosystem, experts predict a monumental 5,000% rally post-launch.

🔹 Pepe (PEPE): Surging Towards New ATHs
Pepe has emerged as a top memecoin on Ethereum, surpassing other meme narratives. With expectations of further ATHs amid ETH ETF momentum, it remains a top pick for budget-friendly altcoin investors.

🔹 Optimism (OP): Scaling Ethereum to $10
Optimism addresses Ethereum's scalability with optimistic rollups, gaining traction among developers. Positioned for a rally past $10, it's poised to capitalize on the impending bull run driven by the ETH ETF market.

🔹 Conclusion
After the launch of ETH ETFs, Pepe, Optimism, and Rebel Satoshi Arcade stand out as prime altcoins to watch. Positioned for substantial gains in Ethereum's expanding ecosystem, they present lucrative opportunities for savvy investors.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dfazmsrabs6vn1domug9.png)
🔥🔥🔥Best Cryptocurrencies to Watch This Week
Published: 2024-06-17 18:49:53


Exciting Crypto Opportunities This Week

🔹 CYBRO Presale: High-Yield Investments
CYBRO is drawing attention with its exclusive token presale, offering a potential ROI of 1200% at a token price of $0.025. With lucrative staking rewards, airdrops, and more, it's gaining traction among crypto whales and influencers.

🔹 Notcoin (NOT): Strong Uptrend
NOT has surged 180.80% in a month and shows positive indicators with an RSI of 54.01 and slight MACD positivity. Trading between $0.0148 to $0.0260, it faces resistance at $0.0329 and support at $0.0105.

🔹 Pepe (PEPE): Overview and Prediction
PEPE trades between $0.00001 and $0.00002, showing a 19.19% increase in a month and 817.56% over six months. With an RSI of 56.13, it's poised for impulsive moves.

🔹 Toncoin (TON): Overview and Prediction
TON has surged by 266.37% in six months, trading between $6.48 to $7.82. With resistance at $8.52 and support at $5.85, it shows strong upward momentum.

🔹 Solana (SOL): Overview and Prediction
SOL ranges from $151.91 to $173.96, with resistance at $185.81 and support at $141.71. Despite recent declines, it has risen by 94.32% in six months.

🔹 Conclusion
While NOT, PEPE, TON, and SOL show potential, CYBRO stands out with its upcoming launch and unique yield opportunities on Blast blockchain. Early investors can participate in the presale for favorable terms, positioning CYBRO as a promising contender in the current market.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tsqe6w5zhv9tb5uvx6x3.png)
👀XRP Price Recovers Past 100 SMA: Bullish Indicators Ahead?
Published: 2024-06-17 18:49:19


📉 XRP Price Shows Signs of Recovery
XRP experienced losses below $0.4650 but found support near $0.4600, initiating a recent recovery wave similar to Ethereum. Bulls managed to break above key resistance levels at $0.4680 and $0.4720, and even surpassed the $0.5000 zone. A high of $0.5049 was reached before the price started correcting lower.

📈 Current Price Levels and Resistance Zones
Currently, XRP is trading above $0.4850 and the 100-hourly Simple Moving Average. Resistance is anticipated near $0.4950, with a pivotal level at $0.4980. Further up, significant resistance lies around $0.5050, and a close above this could propel XRP towards $0.5250 and potentially $0.5320. Continued momentum might lead to a test of the $0.5500 resistance.

📉 Potential Downside and Support Levels
Failure to surpass the $0.4980 resistance may prompt a downside movement. Initial support is near $0.4850 and the 100-hourly SMA. Further down, a major support level awaits at $0.4720. A break below this could trigger bearish momentum towards the $0.460 support in the near term.

📊 Technical Indicators
The hourly MACD for XRP/USD is showing bullish momentum, while the hourly RSI is above the 50 level, indicating positive price action.

Summary:
XRP's recent recovery above key resistance levels suggests bullish potential, with resistance zones identified at $0.4980, $0.5050, and higher. Support levels are seen at $0.4850 and $0.4720, with technical indicators favoring further upside.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wwxadxvaxj686tbry3dg.png)
Setting up a React environment
Tags: react, vscode, env, frontend
Published: 2024-06-17 18:48:51

React is a widely go-to library built with JavaScript used to build interactive and dynamic interfaces. To run any React application, we need to first set up a ReactJS development environment. This article provides a step-by-step guide to installing and configuring a functional React development environment.

Prerequisite 
1.Node.js and npm: React development significantly depends on Node.js and npm (Node Package Manager). They can be downloaded and installed from the official Node.js website [here](https://nodejs.org/).

2.Code Editor: Select a code editor that matches your preferences. Popular options are Visual Studio Code, Sublime Text, and Atom. You can download Visual Studio Code [here](https://code.visualstudio.com/).


Using Create-react-app command 
Step 1: Go to the folder where you want to create the project and open terminal 

Step 2: Open the terminal in your application directory and enter the following command:
```
npx create-react-app <Application_Name>
```

Step 3: Move into the newly created folder by using the command:
```
cd <Application_Name>
```

A default application will be created with a standard project structure and necessary dependencies.

Step 5: To start the application, enter the following command in the terminal:
```
`npm start`
```
Step 6: The browser will display the following output:


![react description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xoq7oa6qkihz7cj8684i.png)

Step 7: Based on your project needs, you may need to install extra dependencies. Popular choices include state management libraries like Redux or Mobx, routing libraries such as React Router, or UI component libraries like Material-UI or Ant Design. You can add these dependencies using npm or yarn:
npm install package-name

Conclusion

Establishing your development environment for React is the essential first step in creating robust web applications. Create React App streamlines this process, allowing you to start coding quickly without the hassle of exten sive setup. As your expertise grows, you can explore more complex configurations and integrate various libraries to customize your environment to fit your needs.

React's extensive ecosystem of tools and libraries makes it an excellent choice for building dynamic and efficient user interfaces. So, get ready to dive into React and start building impressive web applications! With your development environment prepared, you're set to begin your React adventure. Happy coding!
💥Polkadot (DOT) Struggles Near $6.30 – Is Now The Time To Accumulate?
Published: 2024-06-17 18:48:49


📉 Polkadot (DOT) Faces Technical Challenges
Polkadot is grappling with bearish technical indicators as it dips below the Ichimoku Cloud, indicating a clear downtrend. Both the conversion line and baseline hover above the current price, exacerbating negative sentiment. The token struggles to breach the stubborn $7 resistance, recently slipping to $6.16, causing concern among investors.

📊 Oversold Conditions and Potential Bounce
Despite the downtrend, Polkadot finds solace near the lower Bollinger Band, hinting at oversold conditions. This could spark a short-term bounce if buying pressure increases. Attention is focused on the $6.20 consolidation zone as a pivotal support level. Holding here might pave the way for a bullish reversal, targeting resistance at $6.30.

📈 Analyst's Bullish Perspective Amidst Bearish Market
Amidst the bleak sentiment, analyst Michaël van de Poppe remains optimistic. He sees DOT's descent to critical support as an opportunity to accumulate at a discount. Van de Poppe highlights the growing interest in Real World Assets (RWAs) and the expanding Polkadot ecosystem as catalysts for potential growth. He identifies key support at $5.67-$6.11 and outlines resistance levels at $9.30 and $17.00 for a bullish breakout scenario.