teleren/devto huggingface dataset:
COMMON MISTAKES TO AVOID IN SQL QUERY WRITING
Tags: sql, database, datascience, data
Published: 2024-03-03 11:05:25

Structured Query Language (SQL) is a powerful tool for managing and manipulating relational databases. However, crafting effective SQL queries requires attention to detail to avoid common mistakes that can lead to inefficiencies, errors, or security vulnerabilities. In this article, we’ll explore some of these pitfalls and provide insights on how to steer clear of them.


**NEGLECTING INDEX USAGE**: 
Indexes play a crucial role in optimizing query performance. Failing to use indexes on columns frequently used in WHERE clauses can result in slow queries. Always ensure that your tables are

**WILDCARD USAGE**: 
Wildcard characters like ‘%’ can be powerful tools, but they should be used judiciously. Misusing them in WHERE clauses can lead to inefficient queries. Clearly define your search criteria to avoid retrieving more data than necessary.

**IMPROPER JOIN USAGE**: 
JOIN clauses are fundamental for combining data from multiple tables. Incorrect join conditions or missing joins altogether can yield inaccurate results. Always double-check and test your JOIN clauses to ensure they correctly link related tables.

**SYNTAX ERRORS**: 
Simple typos or syntax errors can cause queries to fail. Regularly review your queries for correctness and use tools that provide syntax highlighting to catch potential errors before execution.

**CASE SENSITIVITY ISSUES**:
Be mindful of case sensitivity in SQL. While some database systems are case-insensitive, others are case-sensitive. Inconsistencies in case usage for table and column names can lead to errors.

**INCOMPLETE TRANSACTIONS**: 
When performing multiple database operations, use transactions to ensure data integrity. Incomplete transactions can leave your database in an inconsistent state if an error occurs midway through a series of operations.

**FAILURE TO USE PREPARED STATEMENTS**: 
Protect your database from SQL injection attacks by using prepared statements or parameterized queries. This ensures that user input is treated as data, not executable code.

**OVERLOOKING NULL VALUES**:
Take into account the possibility of NULL values in your data. Handle them appropriately in your queries to prevent unexpected results.



In conclusion, mastering SQL query writing involves not only understanding the language's syntax but also being aware of potential pitfalls. Regular testing, code reviews, and adherence to best practices can help you write efficient, secure, and error-free SQL queries. By avoiding these common mistakes, you'll enhance the performance and reliability of your database interactions.
Radix updated and new dev cards!
Tags: blockchain, dlt, pos, iot
Published: 2019-05-02 11:51:08

---
title: Radix updated and new dev cards!
published: true
description: 
tags: #blockchain #dlt #POS #IOT
---

So, as far as [development](https://www.radixdlt.com/roadmap) goes we are getting closer to our technical go-live (scheduled for Q4 2019) goals - the Node Runner software is nearly done at 95%, the Asset-Backed Tokens API is at 90%, with the Utility Token Toolkit dragging behind a bit, with 70% completion.

For defining our development productivity, we’re using the Scrum/Agile methodology here at Radix. We define what needs to be delivered using User Stories and measure our productivity by our sprint velocity, which are the number of Story Points completed in an average two-week sprint. From now on, we’ve decided to share with everyone what which [Sprint](https://docs.radixdlt.com/alpha/develop/sprint-reviews) consists of in our knowledge base.

We’ve also released two interesting use cases - a [POS card system](https://docs.radixdlt.com/alpha/learn/use-cases/card-payment-system), which can not only be used for simple transactions - it’s a slightly more complex solution, which gives insight to spending habits and can also store loyalty points.

We’ve also prepared Radix branded developer cards - if you are thinking of using those for building an app, please let me know, or contact Radix at any social media account.

Check those cards out [here](https://twitter.com/radixdlt/status/1123512208154136576) 

The second use case is an [IOT](https://docs.radixdlt.com/alpha/learn/use-cases/internet-of-things) solution focused on exploring the possibility of a temperature controlled logistic system on the ledger.

Our community has grown a lot thanks to [Takeshi](https://twitter.com/Takeshi_TGAL), who has created both a [Medium](https://medium.com/radix-japan-unofficial) channel with Japanese translations of our articles handle to distribute those articles - [RadixJapan](https://twitter.com/RadixJapan). Thanks a ton, Takeshi!

If you have any questions - join The Radix Community!

[Telegram] (https://t.me/radix_dlt) for general chat
[Telegram Announcement Channel] (https://t.me/RadixAnnouncements) for announcements
[​Discord] (https://discord.gg/7Q7HSZZ) for developers chat
[​Reddit] (https://reddit.com/r/radix) for general discussion
[Forum] (https://forum.radixdlt.com/) for technical discussion
​[Twitter] (https://twitter.com/radixdlt) for announcements
[​Email] (https://radixdlt.typeform.com/to/nyKvMV) newsletter for weekly updates
Mail to [hello@radixdlt.com] (hello@radixdlt.com) for general enquiries
"Java Adventures" Learing About Oops Concepts
Tags: oops
Published: 2024-03-03 10:42:42

Title: "Java Adventures"


**Introduction**:
Hey little Java explorers! Today, we're diving into the magical world of Object-Oriented Programming (OOP) using Java. Imagine Java as a superhero language, and OOP as its superpower. Let's embark on this exciting journey together!

 
**Objects are like Superheroes:**

Imagine your favorite superheroes - each with unique powers and characteristics.
In Java, objects are like superheroes. They have special powers (methods) and wear costumes (attributes).

 
**Classes: The Superhero Academy:**

Classes are like superhero academies where superheroes are born.
If "Superhero" is a class, then "Batman" and "Superman" are objects (instances) of that class.

 
**Encapsulation: Secret Identities:**

Superheroes keep their true identities secret.
In Java, encapsulation is like hiding the superhero's details. Only essential information is visible outside.

**Inheritance: Passing on Powers:**

Imagine if a new superhero inherits powers from their parent.
In Java, inheritance is like passing on powers from one class (parent) to another (child).

 
 
**Polymorphism: Shape-Shifting Heroes:**

Some superheroes can change their forms to fit different situations.
In Java, polymorphism is like a superhero changing their actions based on the context.

 
**Abstraction: Superhero Comics:**

Superhero comics tell us about their adventures without revealing every detail.
Abstraction in Java is like showing only essential features, hiding unnecessary complexities.
Let's Code: Creating a Superhero!

We'll create a Java program where you design your superhero.
Define the superhero class, set attributes (name, powers), and create methods (fly, saveTheDay).
Playing with Superheroes:

Time to create different superheroes and make them do amazing things.
Your Java program is like a superhero playdate where they interact with each other.

Conclusion:
Congratulations, young Java explorer! You've just discovered the wonders of OOP in Java. Now, go on and create your own superhero squad using these incredible programming concepts. The coding adventure awaits!
Chrome 'N' Ubuntu - Linux
Published: 2024-03-03 10:36:21

> **Download Site**

https://support.google.com/chrome/a/answer/9025926?hl=en&ref_topic=9025817&sjid=9687412310203740272-AP

https://www.google.com/chrome/?platform=linux

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

> **Downloaded File**

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

`google-chrome-stable_current_amd64.deb`

> **Installation Steps**

`sudo dpkg -i google-chrome-stable_current_amd64.deb`

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

> **UN-Install Chrome**

`sudo apt purge google-chrome-stable`

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3zabcyc9h29zpbkdab0w.png)
How to start contributing to open source
Tags: beginners, tutorial
Published: 2024-03-03 10:26:32

I think many programmers want to start or try contributing to open source and one of the best ways in my opinion is the repo [first-contribution](https://github.com/firstcontributions/first-contributions) it is for beginners that dont know how to start.
It gives a step by step guide how to do things like fork a repo or how to make a pull request.
How to change C++ Language Standard in JetBrains Rider
Published: 2024-03-03 10:18:30

## Problem

As a new Rider user, I encountered this error after starting my new C++ project, because the IDE Language Standard for C++ by default is C++14.

```
0>ConsoleApplication1.cpp(6,23): Error C7525 : inline variables require at least '/std:c++17'
```

I struggled to find the exact place to change the language standard in my C++ project, so I would like to share how to do it.

## Solution

- Right-click on your project folder, then choose **Properties**.

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

- Find the C/C++ tab.

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

- Scroll down, look for C++ Language Standard then you can choose the standard you want.

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

_Note: is possible that you have to change it in multiple configurations, depending on what you use._

Enjoy!
DataDen Comin Soon: Tailor Your Data, Your Way
Tags: datastructures, database, data, webdev
Published: 2024-03-03 09:51:42

Very happy to announce we will launch the newest addition to Keep #Coding Family soon (or soonish); DataDen - Plugin that extends the functionality of the library with table component.


**Advanced data structure**

The latest and most advanced data structure allows customizing each column (sort, width, resize, field) and matches values from each row to a column in which the `field` equals a given key value.

**Draggable columns**

Experience seamless interactivity with our draggable columns feature. Effortlessly rearrange your data grid to suit your workflow, ensuring optimal organization and efficiency. Just click, drag, and drop to customize your data display exactly as you need.

**Pagination**

Explore efficient data navigation with our pagination example. Learn to seamlessly handle large datasets by integrating simple, intuitive pagination controls.

**Column search**

Discover the power of quick data retrieval with our search column feature. Easily locate the information you need within your DataDen grids for a more streamlined and productive data management experience.

**Cell formatting**

Enhance your data grid with our versatile cell formatting options. Tailor each cell's appearance for clarity and impact, using colors, fonts, and styles that make your data speak volumes. Perfect for highlighting critical insights and personalizing your data view

**Compact version**

Unlock the full potential of your data grid with advanced CSS customization. Style every aspect to match your brand or personal preference, from colors and fonts to layouts. Create a visually cohesive and highly functional data interface with ease.

So don’t hesitate to join DataDen’s Waiting List: Get front-row seats to the future of Data Grid.
In due course, you will receive an exclusive discount that you can use to purchase Data Den Plugin (& more!)

https://getdataden.com/general/waiting-list/
Rajasthan BSTC Syllabus PDF Download
Tags: jobs, exam
Published: 2024-03-03 09:37:50

##Rajasthan BSTC Syllabus and Exam Pattern 
 Directorate of Elementary Education Bikaner conducts Pre Basic School Training Certificate examination every year. Candidates who are going to participate in the Basic School Teaching Certificate Entrance Exam need to check the Rajasthan BSTC Entrance Exam Syllabus. We have given the details of subject wise Rajasthan BSTC 2024 Syllabus. Candidates have to check the **[Rajasthan BSTC Syllabus](https://jobsrajasthan.com/rajasthan-bstc-syllabus/)** PDF  from the link given in the description below  .

## BSTC Syllabus & Exam Pattern 2024

BSTC Syllabus & Exam Pattern 2024 : Rajasthan BSTC exam (Pre D.El.Ed 2024) will be conducted in 2024. Recently Directorate of Elementary Education, Bikaner has been appointed as the examination agency. For the last few years, the Directorate of Elementary Education, Bikaner has also been conducting the Pre-D.El.Ed examination.  Candidates will be given a total of three hours for  BSTC Exam 2024 . Rajasthan BSTC 2024 Syllabus in which candidates will be asked 200 questions for a total of 600 marks. 

## BSTC Exam Pattern 2024

BSTC Exam Pattern 2024 : In BSTC exam, 50 questions will be asked from mental ability subject, 50 questions will be asked from teaching ability subject, 20 questions will be asked from English subject, while 30 questions will be asked from Hindi or Sanskrit subject. This examination will be conducted in offline mode. Raj BSTC Exam 2024  will be conducted at the state level. In this examination, all the questions will be asked from the candidates with multiple choice. There will be three parts of the exam consisting of Hindi, Sanskrit and English. All candidates will have to solve the English part. Candidates have to attempt one from both Hindi and Sanskrit.

The

1.  question paper will be objective type and will contain multiple choice questions.
2. The question paper will be in both English and Hindi languages.
3. There will be 4 sections in the examination and each section will consist of 50 questions.
4. Here the exam will be for a total of 600 marks in which a total of 200 questions will be asked.
5. Each question carries 3 marks.
6. Time duration of question paper 3 hours.
7. No negative marks will be deducted for any wrong answer.
Rajasthan Anganwadi Bharti 2024
Tags: jobs, career, community
Published: 2024-03-03 09:35:00

## Rajasthan Anganwadi Bharti Notification

Recently, the official notification of Anganwadi recruitment has been issued for the vacant posts in Gram Panchayat of Jhalwad district, you can see the complete information by downloading the notification before applying.

Women and Child Development Department, Rajasthan has released the notification for recruitment to the posts of Anganwadi worker, Anganwadi assistant, mini Anganwadi worker for unemployed women of the state on its official website. Eligible and interested women candidates for Rajasthan Anganwadi Recruitment 2024  can visit the official website of the department and download the application form. After downloading the application form, they can send their complete educational qualification along with related documents in the prescribed format through registered post speed post to the address prescribed by the department. . Departmental advertisement, application form, selection process, last date and other important information of Rajasthan Anganwadi Vacancy  is given in detail below.

## Rajasthan Anganwadi Vacancy 2024 Notification PDF

Notification of Rajasthan Anganwadi Recruitment 2024 is issued separately district wise. The same Rajasthan Anganwadi recruitment is done at the Panchayat level in every district. Since notifications are issued separately for all the districts, the last date for all is different. Rajasthan Anganwadi Recruitment 2024 is done at different Panchayat level in the Tehsil of each district. Whichever district's notification is issued for Rajasthan Anganwadi recruitment, we immediately update its information here. Candidates must keep checking the official website of Anganwadi from time to time for the latest updates of all the upcoming and ongoing recruitments of Rajasthan. [Rajasthan Anganwadi Bharti](https://jobsrajasthan.com/rajasthan-anganwadi-bharti/) 2024 official notification and all important links are provided below.
Step-by-Step Guide: Creating a Virtual Machine in Azure
Published: 2024-03-03 09:20:43

Virtual machines play a crucial role in modern cloud computing, offering flexible and scalable computing resources.
Step 1: Logging into Azure Portal
Open your web browser and navigate to https://portal.azure.com 
Sign in using your Azure account credentials.

Step 2: Navigating to Virtual Machines
After logging in, you’ll land on the Azure dashboard. In the left-hand menu, click on “Virtual machines”
This will take you to the Virtual machines section, where you can manage your VMs.

Step 3: Creating a New Virtual Machine
Click the “+ Add” button to start creating a new virtual machine.
The process begins with configuring the basics of your VM:
Subscription: Choose the appropriate subscription.
Resource Group: Create a new or select an existing resource group.
Virtual machine name: Give your VM a unique name.
Region: Choose the data center region closest to you.
Availability options: Select the availability preferences.
Image: Choose the operating system image you want to use.



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

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

Step 4: Choosing VM Configuration
Under “Size,” select the appropriate configuration for your VM based on CPU, memory, and storage requirements.
Carefully review the available sizes and consider your workload needs.

Step 5: Setting Up Authentication and Security
Under “Authentication type,” choose either an SSH public key or a password. Depending on your choice, provide the necessary credentials.
Configure inbound port rules to allow remote access via SSH or RDP.
Define public inbound ports for external connectivity.

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

Step 6: Configuring Disks and Storage
Under “Disks,” choose the OS disk type (Standard HDD, Standard SSD, Premium SSD).
Adjust the OS disk size according to your needs.
Note: Choose Standard SSD for practice purposes

Step 7: Network Configuration
In the “Networking” section:
Choose an existing virtual network and subnet or create new ones.
Assign a public IP address if needed.
Configure network security groups to control traffic.

Step 8: Management and Monitoring
Under “Management,” enable diagnostic settings for monitoring.
Configure boot diagnostics for troubleshooting.
Explore extensions for adding extra functionality.

Step 9: Review and Validation
Review all your configuration settings to ensure accuracy.
Validate that your selections align with your intended VM setup

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

Step 10: Deploying the Virtual Machine
Click the “Create” button to initiate the VM creation process.
Azure will begin provisioning your virtual machine based on your configuration.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s5p0e8tgecs5qkjxwqbd.png)
Now you have successfully deployed the Virtual Machine in your Virtual Network.
Chocolatey Auto install Windows
Tags: windows, tutorial, discuss
Published: 2024-03-03 09:08:38


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

Execute as an administrator to automatically install packages.

You enjoy your coffee.

The installation process is undertaken by him.

Thank you for your attention.
How to Open a PSD File Without Photoshop
Tags: csharp
Published: 2024-03-03 07:43:01

If you work with graphic design files, you are probably familiar with the PSD file format, which is commonly associated with Adobe Photoshop. However, what if you don't have access to Photoshop or simply prefer to work in a different programming language? In this case, you can use C# to open and manipulate PSD files without the need for Photoshop.

To accomplish this, you can utilize the `ImageSharp` library, which is a powerful image processing library for .NET that supports various image formats, including PSD. Below is a simple example of how you can open a PSD file using C#:

```csharp
using SixLabors.ImageSharp;
using SixLabors.ImageSharp.Formats.Png;
using SixLabors.ImageSharp.PixelFormats;
using SixLabors.ImageSharp.Processing;

// Load the PSD file into an image object
using (Image<Rgba32> image = Image.Load("example.psd"))
{
    // Save the image as a PNG file
    image.Save("example.png", new PngEncoder());

    // Perform image processing operations here
    // For example, resize the image
    image.Mutate(x => x.Resize(image.Width / 2, image.Height / 2));

    // Save the processed image as a new PNG file
    image.Save("example_resized.png", new PngEncoder());
}
```

In the above code snippet, we first load the PSD file (`example.psd`) into an `Image` object using the `Image.Load` method. We then save the image as a PNG file using the `Save` method with a `PngEncoder` object.

Additionally, you can perform various image processing operations on the loaded image, such as resizing, cropping, or applying filters, by using the `Mutate` method. Finally, you can save the processed image as a new PNG file.

By using C# and the `ImageSharp` library, you can easily open and manipulate PSD files without the need for Photoshop. This allows you to work with PSD files programmatically and integrate them into your applications seamlessly. Give it a try and explore the possibilities of working with PSD files in C#!
Weekly reading digest #29
Tags: php, symfony, backend, softwareengineering
Published: 2024-03-03 09:00:00

[Mapping an array](https://drops-of-php.hi-folks.dev/02-array/01-arr-array_map/)

[Never write another loop again](https://dev.to/klnjmm/never-write-another-loop-again-3np0)

[Capturing remote code coverage in E2E tests with PHPUnit](https://alejandrocelaya.blog/2024/02/23/capturing-remote-code-coverage-in-e2e-tests-with-phpunit/)

[Rethinking Database Migrations: The Diminishing Role of the down() Method in PHP Frameworks](https://medium.com/@nemanjamilenkovic_58178/rethinking-database-migrations-the-diminishing-role-of-the-down-method-in-php-frameworks-f3f42b5315aa)

[The PHP Foundation: Impact and Transparency Report 2023](https://thephp.foundation/blog/2024/02/26/transparency-and-impact-report-2023/)

[Why PHP continues to be a popular but divisive programming language](https://thenextweb.com/news/why-php-continues-to-be-a-popular-but-divisive-programming-language?ref=dailydev)

[Choosing a frontend framework](https://sebastiandedeyne.com/choosing-a-frontend-framework)

[Composition over Inheritance](https://acairns.co.uk/posts/composition-over-inheritance)

[Constructive vs Predicative Data](https://www.hillelwayne.com/post/constructive/)

[New Miro Template for Designing Bounded Contexts](https://www.singlestoneconsulting.com/blog/new-miro-template-for-designing-bounded-contexts)

[Buscando el Product Market Fit y Arquitectura Hexagonal [In Spanish]](https://danilat.com/weblog/2024/01/23/hexagonal-product-market-fit)