teleren/devto huggingface dataset:
SQL LOGIC FUNCTIONS
Tags: sql, database, 30daysofsql, nairobiaicommunity
Published: 2023-05-08 17:49:47



SQL (Structured Query Language) is a programming language designed for managing and querying data in a relational database. SQL has a set of logics that can be used to filter, sort, and manipulate data. Here are some commonly used SQL logics:

1. SELECT: This is used to retrieve data from one or more tables. You can specify which columns to retrieve and use conditions to filter the results.

2. WHERE: This is used to filter the results based on one or more conditions. You can use operators like =, <, >, <=, >=, and <> to compare values.

3. AND/OR: These are used to combine multiple conditions. AND requires all conditions to be true, while OR requires at least one condition to be true.

4. ORDER BY: This is used to sort the results based on one or more columns. You can specify ASC (ascending) or DESC (descending) order.

5. GROUP BY: This is used to group the results based on one or more columns. You can use aggregate functions like COUNT, SUM, AVG, MIN, and MAX to perform calculations on the grouped data.

6. JOIN: This is used to combine data from two or more tables based on a related column.

7. UNION: This is used to combine the results of two or more SELECT statements.

8. HAVING: This is used to filter the results of a GROUP BY query based on aggregate function values.

These are just some of the SQL logics used to manipulate and query data in a relational database. There are many more functions and operators that can be used to perform complex data operations.
My lecture at the Stockholm Tech Show 2023.
Tags: cloud, database
Published: 2023-05-08 17:42:39

Stockholm. Sweden. On 3-4 May 2023 Kistamässan Exhibition & Congress Centre was transformed into the most important tech event of the year. A diverse array of inventions, cutting-edge labs, trends, talks about what is to come in the near future, new networks, and lectures was found at the Stockholm Tech Show 2023.

Many companies were represented at the conference, such as Ericsson, Volvo, Intel, Siemens, HCL Software, Suse, CatAB, Paessler PRTG, Westbase, and others.

I was happy to have the opportunity to share my knowledge and experience with the conference participants.

I gave a lecture on 'Managed Databases in Clouds at high scale'.

It was the talk about databases in clouds; provisioning, topology, configuration, cost, parameters, performance, monitoring, security, logs management, backups, restores, disaster recovery approaches, stability, and scale. 

I discussed the challenges in Cloud-based solutions for databases. 

The lecture was targeted to DevOps, DataOps, DBAs, Production, R&D, Architects, Support Engineers, Site Reliability Engineers, and any other audience.

It was a great honor for me to participate in this wonderful event.

Here are some photos.

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mh9tbj26749kuvjm862h.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b3ceo9qhx1tb4s4oitsj.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qqpkit53e6gsc1w41b5r.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/272ec5rn0gjun6aax762.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ni20iy8utruigrj55sat.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/em7826wj1cxv5wrfxo6s.jpg)

![Stockholm Tech Show 2023](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3w7t0tham4yeu5ltyvi7.jpg)
What is Data Engineering?
Tags: data, engineer, beginners
Published: 2023-05-08 17:34:14

In 2023, data engineering has been listed as one of the most in-demand and lucrative tech careers, with an estimated growth rate of 11% over the next decade.

At its core, data engineering involves the creation of systems and infrastructure that enable organizations to collect, store, process, and analyze large amounts of data. Think of it as building the plumbing that makes data flow possible. Data engineers create data pipelines that extract raw data from various sources, transform and clean it, and load it into databases or data warehouses where it can be easily accessed and analyzed by data analysts and data scientists.

To do this, data engineers use a variety of tools and technologies, including programming languages like Python and Java, databases like SQL and NoSQL, and cloud computing platforms like AWS and Azure. They are also familiar with data warehousing concepts and techniques, such as ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform), which involve the movement of data from one system to another.

On a day-to-day basis, a data engineer might work on tasks like designing and implementing data pipelines, troubleshooting issues, managing data quality, and ensuring data security. They might also work closely with data analysts and data scientists to ensure that the data being collected and processed is relevant and useful.

Job titles for data engineers can vary, depending on the specific focus of the work and the organization. Some common titles include Big Data Engineer, Data Warehouse Engineer, ETL Developer, and Database Developer. Regardless of the title, data engineers play a crucial role in ensuring that an organization’s data is accurate, accessible, and useful.

If you’re someone who enjoys working with technology and problem-solving, data engineering can be a fulfilling career path. As data becomes increasingly important to businesses across all industries, the demand for skilled data engineers is only set to increase. Do you find data engineering interesting? Would you choose data engineering as a career?
How Do You Say... "Epoch"
Tags: discuss, watercooler
Published: 2023-05-08 17:24:09

As a technologist, there are a lot of words and acronyms we often only read or type out but don't say out loud (commands/services/etc). So, I asked a bunch of folks how they pronounce some of them and recorded the result. For example...

For example: "[Epoch](https://en.wikipedia.org/wiki/Epoch_(computing))"

> In computing, an epoch is a date and time from which a computer measures system time. Most computer systems determine time as a number representing the seconds removed from particular arbitrary date and time. 

How do you pronounce it?
Nullable column Sort trick(Laravel)
Tags: laravel, programming, php, webdev
Published: 2023-05-08 16:57:48

A quick trick to sort a table based on the column that may contain nullable values ignoring the null, otherwise the orderBy won't work correctly.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qis4gbx34l7who6gf44r.png)
of course, my example contains another trick which to return a sorted relation through the model.
Storybook GPT
Tags: githubhack23, webdev, react
Published: 2023-05-08 16:09:30

## What I built 
A web application that coverts React components into Storybook stories using OpenAI API.

### Category Submission
Wacky Wildcards

### App Link
[https://storybook-gpt.vercel.app](https://storybook-gpt.vercel.app)

### Screenshots 
![Application](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/f6yg35ohlc2xnephxut4.gif)

### Description 
Storybook GPT is a web application that can be used to convert React components into Storybook stories. It is using OpenAI API to convert the components and it is built with NextJS 13, the React framework for the web that supports server components, streaming, and layouts. It also uses TypeScript for type safety and TailwindCSS for styling. With Storybook GPT, you can easily create and share interactive UI components for your projects.

### Link to Source Code 
[https://github.com/eduardconstantin/storybook-gpt](https://github.com/eduardconstantin/storybook-gpt)

### Permissive License 
MIT

## Background (What made you decide to build this particular app? What inspired you?) 
I started to see more and more applications that use the OpenAI API and I wanted to try it out. One of these apps is [this one](https://github.com/whoiskatrin/sql-translator) made by Kate.

### How I built it (How did you utilize GitHub Actions or GitHub Codespaces? Did you learn something new along the way? Pick up a new skill?) 
Fired up a Github Codespace (with the lowest specs) and started to develop right away by installing NextJS 13 with TailwindCSS. Design was made in Figma. I learned a few things along the way, like creating a codespace is not hard at all and is way more convenient to start one than cloning the project locally. I learned how to use the OpenAI API and the new app router from NextJS. Besides all of this I also came with a few more ideas applications that can use the OpenAI API. 

### Additional Resources/Info
In order to use the application the user need to add their OpenAI API. They can get one from [here](https://platform.openai.com/account/api-keys) by creating an account.
Building Smart Contracts with Cudos Blockchains
Tags: webdev, cudos, smartcontract, blockchain
Published: 2023-05-08 16:02:56


**Introduction**:
Cudos Blockchains is a decentralized platform that provides a secure and scalable infrastructure for building and deploying blockchain-based applications. With Cudos Blockchains, developers can easily create smart contracts using the Solidity programming language and deploy them to a high-performance blockchain network.

In this article, we'll explore the process of building a simple smart contract using Solidity and deploying it to the Cudos blockchain.

## Prerequisites
:
To follow along with this tutorial, you'll need to have the following:

A basic understanding of blockchain technology and smart contracts
A development environment set up for Solidity programming
A Cudos wallet and CLI tools installed
Getting Started:
To get started, create a new Solidity file and add the following code:

```
`// SPDX-License-Identifier: GPL-3.0
pragma solidity >=0.7.0 <0.9.0;

contract MyContract {
    uint256 public myNumber;
    
    function setNumber(uint256 _number) public {
        myNumber = _number;
    }
    
    function doubleNumber() public {
        myNumber = myNumber * 2;
    }
}`
```
This is a simple smart contract that stores a number and provides two functions for modifying it. The setNumber function allows anyone to set the value of myNumber to any uint256 value they choose, and the doubleNumber function multiplies the current value of myNumber by 2.

## Deploying to the Cudos Blockchain:

To deploy this contract to the Cudos blockchain, you'll need to compile it into a WebAssembly binary format and then use the Cudos CLI tools to store it on the blockchain. Here's an example command:

```
cudos-cli tx wasm store my_contract.wasm --from my_wallet_address
```

Replace `my_contract.wasm` with the filename of your compiled Solidity code, and my_wallet_address with the address of your Cudos wallet.

## Interacting with the Smart Contract:

Once your contract is deployed, you can interact with it using the Cudos blockchain API. Here's an example of how to set the value of myNumber to 42:

```
cudos-cli tx wasm execute <contract_address> '{"setNumber": {"_number": 42}}' --from my_wallet_address

```
Replace <contract_address> with the address of your deployed contract, and my_wallet_address with the address of your Cudos wallet.

## Conclusion:
In this tutorial, we've explored the process of building a simple smart contract using Solidity and deploying it to the Cudos blockchain. Cudos Blockchains provides an easy-to-use platform for developing and deploying blockchain-based applications, and with the power of smart contracts, developers can create decentralized applications that are secure, transparent, and highly scalable.

## Links:

Cudos Blockchains documentation: https://docs.cudos.org/
Solidity programming language: https://docs.soliditylang.org/en/v0.8.7/
Cudos CLI tools: https://docs.cudos.org/developers/cli/
56 berufliches Vorwärtskommen: Wie sieht zureichende emotionale Intelligenz bei Software-Entwicklern aus?
Tags: deutsch, career, motivation, discuss
Published: 2023-05-08 15:54:00

Moin Moin,

Anhand [der klaren Rollenverteilung in Software-Entwicklungsprojekten→](https://dev.to/amustafa16421/53-berufliches-vorwartskommen-wie-sieht-eine-klare-rollenverteilung-in-software-entwicklungsprojekten-aus-3pii), schauen wir uns nun emotionale Intelligenz am Beispiel des Entwicklers C an.

Rollen:
A: Datenbank, Berichte und Datenumwandlung
B: CRUD-Seiten und Anwendungslogik
C: Systemprüfung, Dokumentation und Training

Selbstwahrnehmung:
C merkt einige Tage nach Projektstart, dass er müder ist als sonst. Er stellt fest, dass ihn seine Aufgaben anfangs nicht fordern.

Gefühlsverwaltung:
C lässt sich seinen Umstand erst mal nicht anmerken und schaut nach einer Lösung. Er ist wieder wach, gelassen und motiviert.

Einfühlungsvermögen:
C fällt beim Nachdenken auf, dass B daheim Überstunden macht. 
C zieht in Erwägung, dass dies an der Anwendungslogik liegen könne.
Seine Lösung: Er übernimmt die CRUD-Seiten.

Beziehungsverwaltung:
Er beruft ein Team-Gespräch ein.
Dort schildert er seinen Umstand und fragt die Kollegen nach ihren jeweiligen Umstand und Eindrücken. A sei gut ausgelastet. Laut B sei die Anwendungslogik eine Vollzeitbeschäftigung.
Das Team einigt sich darauf, dass C die CRUD-Seiten übernimmt.

Und wenn sie die Software noch entwickeln, so sind sie dabei zufrieden.

1) Wie bewertest du diesen Vorgehen von C? ( 5-Sterne-Maß ), 
Ausführungen willkommen.

Lass uns mittels Kommentaren austauschen.

Beste Grüße,
Mustafa

Austausch mittels E-Mail: mustafa.kevin.dwenger@posteo.de
Betreff: Austausch
UIs visually, backend in Python
Tags: python, vue, indie, opensource
Published: 2023-05-08 15:53:19

![Screenshot](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/en92q0e04f6cssp71i4l.png)

I've been working on a data apps platform, an alternative to Streamlit and Dash. It uses FastAPI, websockets and Pydantic. It runs the user app in a separate process and communicates via multiprocessing pipe.

It's faster and has a visual editor, which I built from scratch using Vue. I integrated Monaco for code edition.

It'd be great to discuss where you think the data apps space is going. Keen to hear all types of feedback. Also more than happy to discuss the technical details if you're building something similar/related. 

[github repo](https://github.com/ramedina86/streamsync)
[live demo app](https://hello.streamsync.cloud)
Translating CSS Games in Real Life Webpages-2
Published: 2023-05-08 15:51:56

Let’s glance into the Game FLEXBOY FROGGY, By Playing the 24 first basic levels of the Game you will learn to align, direct and justify your content with the following properties:
align-items, justify-content, flex-direction, flex-wrap, and many more.
All listed properties come with values for the object or content, position, and behavioural manipulations using Cascading Style Sheets.
The link below it is a simple first step of the Game on your road to learning CSS.
From the clip, we tried to align the frog to stay on green the leave by using the property align-item and value flex-end and for the second level, we tried three different values to centre, space-between and space-around. where the frogs are aligned on the left with the value centre and for the two values the frogs were set away from the leaves.
https://www.linkedin.com/feed/update/urn:li:activity:7061075261949100032/
Exam Topics Free - Helpful Exam Preparation Guidelines
Published: 2023-05-08 11:36:53

The meeting ended close to midnight. In the course of the talk, of same published and then  retracted rules on the usage of mock exam grades the weekend after a-level consequences had been published, with separate emergency conferences held that sunday. Shortly after, of same subsidized down and scrapped its grades in favour of these assessed with the aid of the use of colleges for every a-levels and gcses. Exam Topics Free The mins display that of equal had essential doubts approximately the statistical technique it used to award grades, with a meeting on 4 august being attentive to that the board have become Exam Topics Free “very worried about the danger of some college university students, mainly so-known as outliers, being supplied unreliable outcomes”. Commercial the board’s members “famous reluctantly that there was no legitimate and defensible way to address this pre-consequences.

https://examtopicsfree.com/
Translating CSS Games in Real Life Webpages-1
Tags: css
Published: 2023-05-08 15:13:46

Web development, creation, or design doesn't only stop at the creation of interactive and friendly visuals that make our access, research, or works on the world wide web-friendly and easy. It came up with a new revolutionary trend of information management in our century.
 
For the creation of websites, we always need a handful of experience in technologies that will design and create a website, this Technologies kept us active and friendly in assessing the world wide Web, and this has made them an icon of imitation by upcoming aspiring technologist in the field of web creation, it is a big dream to all to learn and develop strong skills for.
 
To learn the skills for this development, you need to take a strong road map that is feasible and not time-consuming, most developers end up in Front-End design and development of the website, and others that are enthusiastic about it are cut short at an early stage due to low motivation, mentorship, and guide.
 
Most learners lose interest in the second stage of Front -end development which is Cascading Style Sheets-CSS, due to it difficulty in understanding the way to arrange your web content, even though nowadays UI/UX design has come up with solutions to some of the hitches.
 
To learn CSS-Cascading Style Sheets you must confront it and push it harder as it is the gateway to the next level of web development in the aspect of programming web content and managing data using JavaScript and Structured Query Language (SQL).
 
To make it easier there are a lot of sites providing Online Games to learn CSS-Cascading Style Sheets such as https://flexboxfroggy.com, https://lnkd.in/dfwDVmVQ, https://lnkd.in/dy6R4r3c, https://lnkd.in/dZPU-fZC, and many More Sites.
 
I will recommend you to start with https://flexboxfroggy.com, it has 24 level at first stage and it is quite easy and self-explanatory.
1. From the below picture, the Frogs are not aligned or on there respective color related leaf
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ib8z539ju9i0l7fte9o2.png)

2. After adding the line 
`#pond {
  display: flex;
justify-content:center;
}`
The Frogs were aligned to there respective leaves.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zpuj4y6ttwcqikiadoa1.png)
I'm tired of searching job
Tags: webdev, javascript, programming, beginners
Published: 2023-05-08 15:07:50

Looking for work can be a challenging and sometimes discouraging process, but it's important to stay motivated and positive throughout your search. Remember that every rejection is an opportunity to learn and grow, and every interview is a chance to showcase your skills and personality.


It's important to take care of yourself during your job search, both physically and mentally. Make sure you're getting enough rest, eating well, and exercising regularly. Reach out to friends and family for support, and consider connecting with other job seekers online or in person.


Remember that finding a job is a journey, not a destination. Keep an open mind and be willing to explore different industries and positions. Be persistent and proactive in your search, and don't be afraid to ask for help or advice from others.
Above all, believe in yourself and your abilities. You are capable of achieving your goals and finding the job that's right for you. Stay motivated, stay positive, and keep pushing forward. Good luck with your job search!


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cykfpxwkp8xwg3t74is5.jpeg)
7 Indie Game Developer Communities
Tags: gamedev, indiegam, beginners, programming
Published: 2023-05-08 15:00:00

Are you an Indie Game Developer? Then, this blog is for you.

There are plenty of communities out there filled with thousands of game developers. We’ve gathered some of the biggest, the most classic, and the most useful game development communities that are currently active.

When you join a game development community, not only can you solve problems and obstacles with the help of experienced devs but you can also make friends and great partnerships along the way.

Here are The Best Game Development Communities for Indie Developers in 2023.

## 1. r/gamedev

Let’s kick off this list with Reddit and the only gamedev subreddit aka r/gamedev.

This community includes more than 700k enthusiasts from all around the world and hosts all topics regarding game development such as programming, math, art, music, business, marketing, and more. In a Reddit community or subreddit, you’ll be able to post, read other users’ posts, comment, and vote (via upvotes and downvotes) on both posts and comments. At the top of the sub, you’ll find a pinned post explaining the main rules for interacting with the community.

## 2. r/IndieGames

This is the perfect complement to the first community we listed. In the IndieGames subreddit, the number 1 rule is to show off footage or images about the game that you’re posting about.

That means you can post whatever you want about your game and promote it all you want within this community.

## 3. Indie Game Developers

Now we’re moving to Facebook, with Indie Game Developers IGD, a community boasting more than 120,000 members. Indie Game Developers is a great place for game devs that want to share resources and information with fellow developers on Facebook.

## 4. TIGForums from TIGSource

Derek’s partly responsible, alongside a group of other indie devs, for the creation of TIGSource – one of the most emblematic indie game dev sites of the last two decades.

---
Continue Reading......

This Blog is Originally Published at The Last Words

Read More from Here:[7 Indie Game Developer Communities](https://thelastwords.wiki/indie-game-developer-communities/)
MAXIM88 - Nhà cái cá cược hàng đầu Việt Nam hiện nay
Published: 2023-05-08 14:28:59

https://linkmaxim88.com/ Chinh phục được mọi tầng lớp bet thủ✔️ MAXIM88 được công nhận là nền tảng cá cược trực tuyến đáng chơi nhất 2023✔️✔️✔️
linkmaxim88@gmail.com
27 đường Lê Văn Lương, quận Cầu Giấy, Hà Nội
https://scrapbox.io/teammaxim88
https://wakelet.com/@teammaxim88
https://heylink.me/teammaxim88/
https://pantip.com/profile/7544526#topics
https://boosty.to/teammaxim88
https://velog.io/@teammaxim88