teleren/devto huggingface dataset:
Introducing BookWheat, The ultimate twitter bookmark tool
Tags: redishackathon
Published: 2022-08-28 18:50:02


### Overview of My Submission
i always had an issue of saving important resources and tweets on twitter. so to tackle this issue i built bookwheat. bookwheat is a twitter bot which can save the tweets which you feel are important. alongside this it also supports discord integration! this means after a quick set up, you can now automatically send the tweets which you feel are important straight to the discord text channel of your choice!

### Submission Category: 
Wacky Wildcards

### Video Explainer of My Project!
you can understand how bookwheat was made and the which tools were used, by watching this YouTube video!
{% embed https://youtu.be/UKb11J7cTY0 %}

[Note]: # (This is where you can embed the optional bonus video you created to accompany your submission. Ensure your video is published publicly to YouTube and you’ve used the embed tag here to share it with us. By opting to include a video, you will be eligible for BONUS prizes. Learn more in the announcement post.)

### Language Used
BookWheat was made using python!


### Link to Code

{% embed https://github.com/realhardik18/Book-Wheat %}

- - - 

* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
What is Oracle Explain Plan?
Tags: oracle, database
Published: 2022-08-28 18:49:17

---
title: What is Oracle Explain Plan?
published: true
description: Oracle Explain Plan Definitions and Examples
tags: #oracle #databases
# cover_image: https://direct_url_to_image.jpg
# Use a ratio of 100:42 for best results.
---
This guide describes how to use the Oracle EXPLAIN PLAN statement. You will be able to get acquainted not only with the dry theoretical component of the question, but also with practical examples of how to apply it in your daily work - https://www.devart.com/dbforge/oracle/studio/oracle-explain-plan.html
Simple Oracle Database Migration with dbForge Tools
Tags: oracle, oracledatabase, databasemigration, database
Published: 2022-08-28 18:46:06

---
title: Simple Oracle Database Migration with dbForge Tools
published: true
description: Oracle database migration methods and tools
tags: #oracle #oracledatabase #databasemigration #databases
# cover_image: https://direct_url_to_image.jpg
# Use a ratio of 100:42 for best results.
---
There are several different ways to migrate an Oracle database, and in this article we will try to cover the most popular ones - https://www.devart.com/dbforge/oracle/studio/oracle-database-migration-tool.html
Food Delivery App
Tags: redishackathon, eventdriven, java, react
Published: 2022-08-28 18:42:13

### Overview of My Submission

This is a very simple food delivery app. It allows to search for food and then order and delivery it to your home.

The idea behind this was to build an event-driven distributed system. It contains 5 microservices which communicates with each other via events (most of the time). 

Apart from that I wanted to try to implement a simple event [sourcing system](https://microservices.io/patterns/data/event-sourcing.html) in which all business events are stored as a sequence of state-changing events.

In this project all these concepts are covered with Redis. 

But this is not everything! It also uses other Redis modules, e.g. RedisJSON  and Redis Search to show how easy it's to build a reliable system with Redis.

### Submission Category: Microservice Mavens

### Video Explainer of this project

{% youtube https://youtu.be/j2OgyTJFc14 %}

### Language Used

* Java/Spring
* JS/React


### Link to Code

{% github https://github.com/wkrzywiec/food-delivery-redis %}

### Additional Resources / Info

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

![food search](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3hvi5j29mdp6rfds0sfr.png)

![order](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0ips14rx215mzu23ar1o.png)
 
 ![active-orders](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5hzgx98wazuk9n98wfy2.png)
 
![completed orders](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rclkf465kcveugro43mg.png)


- - - 


* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
MySQL SHOW DATABASES: List All Databases in Different Ways
Tags: mysql, mysqldatabase, database, databasemanagement
Published: 2022-08-28 18:41:51

---
title: MySQL SHOW DATABASES: List All Databases in Different Ways
published: true
description: Let's review how to show all database list in mysql
tags: #mysql #mysqldatabase #databases #databasemanagement
# cover_image: https://direct_url_to_image.jpg
# Use a ratio of 100:42 for best results.
---
In this article, you can check out a detailed guide on how to show all databases in MySQL and filter them by specific criteria - https://www.devart.com/dbforge/mysql/studio/how-to-show-all-database-list-in-mysql.html
WatchYaari - Watch videos together with your friends
Tags: redishackathon
Published: 2022-08-28 18:41:00

### Overview of My Submission
WatchYaari is a platform where friends can watch youtube videos together while connected over a video chat. It is primarily built using MEAN stack, WebRTC, socket.io & Redis.

The idea for the same originated back in April 2020 when people were socially distant due to COVID-19 outbreak & while talking to bunch of friends over a video call, the need for hanging out with friends during social distancing was the bootstrap point of WatchYaari.
Initially we had started off with youtube but the plan was to extend integrating with various OTT platforms.


### Submission Category: 
MEAN/MERN Mavericks
I have used Redis in the following 2 ways:

1. As a primary database instead of MongoDB (i.e. replace “M” in MEAN/MERN with “R” for Redis).
2. Added caching and advanced searching capabilities using JSON and Search modules.


### [Video Explainer of My Project]

{% embed https://youtu.be/h9V-9zfZmUc %}

### Language Used
JS/TS/Node.js


### Link to Code
{% embed https://github.com/AkhilJSON/watchyaari %}


- - - 

[Note]: # (Please ensure  that the footer content below is part of your post when publishing. Please delete this note in parentheses but do not delete the content below.)


* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
How To Optimize MySQL Tables using dbForge Studio for MySQL
Tags: mysql, mysqltables, database
Published: 2022-08-28 18:38:43

---
title: How To Optimize MySQL Tables using dbForge Studio for MySQL
published: true
description: The table maintenance tool provided by dbForge Studio for MySQL allows you to perform a wide variety of table optimization tasks: parse, optimize, validate, checksum, and restore.
tags: #mysql #mysqltables #databases
# cover_image: https://direct_url_to_image.jpg
# Use a ratio of 100:42 for best results.
---
In this article, we will show you how dbForge Studio for MySQL can efficiently optimize MySQL database tables - https://www.devart.com/dbforge/mysql/studio/optimize-mysql-table.html
How calculation affects the evens and odds
Tags: mathematics, beginners
Published: 2022-08-28 18:33:00

# Odds and Evens
**Numbers** could either be odd or even. Arithmetic operations we do like addition, subtraction, multiplication and division would have an effect on the number being even or odd. That's what we are going to study.<br> 
 
Even numbers are the numbers which are multiples of 2. Odd numbers are the numbers which are NOT multiples of 2. Odd numbers leave a remainder when its divided by 2.<br> 
 
Consider arbitrary integral constants a and b,<br> 
Even numbers have a form of 2a<br> 
Odd numbers have a form of 2a + 1<br> 
<br>
# Addition<br> 

## even + even<br> 
 
 = 2a + 2b<br> 
 = 2(a + b)<br> 
 = even<br> 
 
## even + odd<br> 
 
 = 2a + 2b + 1<br> 
 = 2(a + b) + 1<br> 
 = odd<br> 
 
## odd + odd<br> 
 
 = 2a + 1 + 2b + 1<br> 
 = 2 + 2a + 2b<br> 
 = 2(a + b + 1)<br> 
 = even<br> 
<br>
# Subtraction<br> 
 
We could leverage the fact that negative of an even is still even. The same goes for odd numbers. So Addition rules naturally apply for<br> 
Subtraction rules.<br> 
<br>
# Multiplication<br> 
 
## even ✕ even<br> 
 
 = 2a ✕ 2b<br> 
 = 4ab<br> 
 = 2(2ab)<br> 
 = even<br> 
 
## even ✕ odd<br> 
 
 = 2a ✕ (2b + 1)<br> 
 = 4ab + 2a = 2(2ab + a)<br> 
 = even<br> 
 
## odd ✕ odd<br> 
 
 = (2a + 1) ✕ (2b + 1)<br> 
 = 4ab + 2a + 2b + 1<br> 
 = 2(2ab + a + b) + 1<br> 
 = odd<br> 
<br>
# Division<br> 
 
Divisions become scary irrational fast. They cant be classified as even or odds. I'm skipping it because Its not the territory I'm are going to step in.<br> 
<br>
# Exponents<br> 
 
Exponents are just multiplications over and over again. So we could use the findings from above. **But it only works for positive non-zero n.**<br> 
 
## even ^ n<br> 
 
 = even ✕ even ✕ even ✕ ... n times<br> 
 = even<br> 
 
## odd ^ n<br> 
 
 = odd ✕ odd ✕ odd ✕ ... n times<br> 
 = odd<br> 
<br>
# Factorial<br> 
Factorial of a number is simply the product of the series from that number to 1. Hence it also contains 2 in the product chain. It makes it even! **But it only works when n is greater than 1.**<br> 
 
## n!<br> 
 = n ✕ (n − 1) ✕ (n − 2) ✕ ... ✕ 2 ✕ 1<br> 
 = 2 (n ✕ (n − 1) ✕ (n − 2) ✕ ... ✕ 3 ✕ 1)<br> 
 = its even<br> 

# Conclusion

| +    | even | odd  |
|------|------|------|
| even | even | odd  |
| odd  | odd  | even |

| −    | even | odd  |
|------|------|------|
| even | even | odd  |
| odd  | odd  | even |

| ✕    | even | odd  |
|------|------|------|
| even | even | even |
| odd  | even | odd  |

For non zero positive powers,

| ^    | even | odd  |
|------|------|------|
| even | even | even |
| odd  | odd  | odd  |

Factorials,

| n                  | n!   |
|--------------------|------|
| greater than 1     | even |
| not greater than 1 | odd  |
RedBoard: a collaborative whiteboard driven by Redis
Tags: redishackathon, rust, react, eventdriven
Published: 2022-08-28 18:29:00

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

### Overview of My Submission

RedBoard is a demonstration of a collaborative whiteboard app driven by Redis's real-time features.

I've been fascinated by Figma's multiplayer editing technology since 2019 when they published [this article](https://www.figma.com/blog/how-figmas-multiplayer-technology-works/) about how it works. I wanted to use this hackathon as an opportunity to attempt to implement a minimal reproduction of that technology using as much as I could infer from that article and some other material that Figma has shared publicly. I am grateful to their engineering team for taking the time to share what they have built and learned with all of us!

The high-level design of RedBoard is based heavily on [this architecture diagram](https://www.figma.com/community/file/989634471195357925) shared by the Figma team to demonstrate using FigJam to make such diagrams, but is of course greatly simplified and uses only Redis for storage and messaging. Journaling is implemented using Redis Streams, and checkpointing folds those streams into RedisJSON values. Not depicted in that diagram is presence, or the real-time broadcasting of actions taken by other users on the same board. Presence is implemented using Pub/Sub.

The backend is implemented using Redis and Rust, and the frontend is implemented with React and Recoil, a.k.a. the RRRR stack 🙂. The two communicate using a two-phase protocol over a WebSocket connection, and the backend app essentially constitutes a very simple real-time document store using Figma's multiplayer change coordination strategy.

This project was a great learning experience and if nothing else it helped to me truly recognize just how difficult it is to build a system like this with production quality and at large scale. Furthermore, using Redis to handle all of the data needs provided inspiration for some new ways I plan to use Redis in my professional work at [StructionSite](https://structionsite.com).

### Submission Category: 

Wacky Wildcards

### Language Used

Rust

### Link to Code

{%embed https://github.com/lukewestby/redboard %}

### Additional Resources / Info

- Blog post about Figma's multiplayer technology: https://www.figma.com/blog/how-figmas-multiplayer-technology-works/
- Figma multiplayer architecture diagram: https://www.figma.com/community/file/989634471195357925
- Recoil: https://recoiljs.org/

- - - 

* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
AWS EC2 Metadata sidecar using Nginx
Published: 2022-08-28 18:27:00


## AWS EC2 Metadata viewer using Nginx Docker Image

![](https://cdn-images-1.medium.com/max/2000/1*sxiSakblhBpaVnDa__ZXWA.png)

This one is just a hobby docker image to **view**/ look out for the **ec2 instance’s metadata** using a UI/ html hosted inside/ via **nginx docker image**.

While managing the AWS ec2 instances checking the instance metadata via curl is very manual and very repetitive work. So to fetch the same using some UI would be very easy for most us.

So here I was with the same challenge of removing the unwanted repeated stuff via curls and commands.

## Prerequisites

 1. AWS knowledge, AWS ec2 instance, etc. ❕

 2. Docker installed on ec2 instance (obviously) ❕

 3. ⚠️**Be Aware of the fact that your metadata will be available over web via html. As exposing/ sharing metadata might be** **security threat**. (for hobby purpose or private ips it might be ok or public ip with proper security group etc.)

 4. ❗️ **Metadata v1** for ec2. Extra work would certainly be required to expose v2 (that is based on tokens etc. and provides extra security over the metadata v1)

![](https://cdn-images-1.medium.com/max/2770/1*HYG_dB0w4UpvuZJiytgsTg.png)

The Docker image can be accessed using the pull command as below:-

    docker pull neuw/aws-ec2-nginx
>  Source code of the same is [here](https://github.com/neuw/aws-ec2-nginx) available on Github

For Running the command the container the command is like below:-

    docker run -itd --name nginx -p 80:80 neuw/aws-ec2-nginx

And after the UI will be available at :-

    http://machine_host_or_ip:port/metadata.html

Replace hostname or ip and port accordingly

And UI should be available as below by default

![](https://cdn-images-1.medium.com/max/2000/1*7Bxwo7uupKh2YC4FxUYbAg.png)

In the first input box you can change the url to /latest/** and it will show you response accordingly.

Example:- **/latest/meta-data**

![](https://cdn-images-1.medium.com/max/2102/1*7IqeFyH_ux7FZjOcssMGcA.png)
>  Further one may use the following **user-data** script while bootstrapping the ec2 instance(applicable for the AWS Linux 2 AMI only), details below:-

    #!/bin/sh
    
    yum update

    # install docker and start the docker service
    yum install docker -y
    service docker start

    # add ec2-user to the docker group
    usermod -a -G docker ec2-user

    # pull the image that was mentioned above
    docker pull krnbr/ec2-nginx:latest

    # run the same image as a container available on host's port 80
    docker run -itd --name nginx -p 80:80 neuw/aws-ec2-nginx

Change port 80 to something more specific - And this image can run as sidecar to your other images, for debug purpose in lower environments
Sales Forecast Machine Learning Tutorial [Python]
Tags: machinelearning, datascience, python, googlecloud
Published: 2022-08-28 18:14:09

Hey what's going on guys, this is a new machine learning tutorial for sales forecast using different metrics such as mean squared error, mean absolute error and R2 score; and this is made with Linear Regression model.

Hope you enjoy the video, it's a bit long I tried not to edit even with the errors I left them and went through each error/bug without editing it.

{%youtube 20fbgWm5M2o%}

Thank you DEV community

data set link : https://github.com/BekBrace/Sales-Forecast-data-csv
Skylunch: API for aviators
Tags: redishackathon, kotlin, webdev
Published: 2022-08-28 17:22:40

### Overview of My Submission

`Skylunch` is a simple, non-blocking api built using [Spring Webflux](https://docs.spring.io/spring-framework/docs/current/reference/html/web-reactive.html) that, provided with an airport code, will return a list of restaurants with their ratings and other details.

### Submission Category:

MEAN/MERN Mavericks

### Language Used
Kotlin/Spring

### Link to Code
{% embed https://github.com/siph/skylunch %}

- - - 

* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
why i get response before request status in command prompt, although i have got right output in postman?
Tags: mern, node, javascript
Published: 2022-08-28 17:20:00


![cmd ss](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2onknpi30l3pf01wgbtx.png)
![cmd ss2](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/70avl88gufwj1g2whi6e.png)
![postman](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8xzz969e95pvb23ddeki.png)


in cmd ss2, why console.log r shown before request GET /api/categories 200 334.691 ms - 1078??

here, i want to get all categories, my code runs good but i cannot understand command prompt part??

category controller-->

`exports.list=(req,res)=>{
    //console.log(req);
    Category.find().exec((err,data)=>{
        if(err)
        {
            return res.status(400).json({
                error: errorHandler(err)
            })
        }
       let r=res.json(data);
       console.log(r);  
       return r;
    })
}`
category route-->

`const express=require('express')
const router=express.Router()//new router object
const{ create,categoryById,read,update,remove,list }=require('../controllers/category');
const{ requireSignin, isAuth, isAdmin }=require('../controllers/auth');
//const {userSignupValidator}= require('../validator');
const{ userById }=require('../controllers/user');

router.get("/category/:categoryId",read);

router.post("/category/create/:userId",requireSignin,isAuth,isAdmin,create);//sir told requireSignin,isAuth,isAdmin, as mw and create as only method

router.put("/category/:categoryId/:userId",requireSignin,isAuth,isAdmin,update);

router.delete("/category/:categoryId/:userId",requireSignin,isAuth,isAdmin,remove);

router.get("/categories",list);

router.param("categoryId",categoryById);

router.param("userId",userById);
module.exports=router;`
Pic Placeholder: categorised image placeholders
Tags: redishackathon, javascript, showdev, nextjs
Published: 2022-08-28 16:46:00

### Overview of My Submission
⏩ TLDR: Pic placeholder is a stylish image placeholder with 6 categories (animals, cats, dogs, houses, landscapes & people) which collectively sums up to 500+ images. 

[Demo](https://picc.vercel.app/).

![demo image](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ucx7mtmm0g4lo116gf1k.png)

**The Idea**: Usually I use lorem picsum to get placeholders, but they didn't allow searches by categories, so I made mine.

This solution uses images from _unsplash_, where the image details were converted to JSON and placed in _redis(redis json)_ enabled with _redis search_ for filtering by categories. The actual images are stored on _aws s3_. The client and api were built using NextJS.

&nbsp;
### Submission Category: 
- Microservice Mavens (app also falls technically in the MEAN/MERN Mavericks)

&nbsp;
### Video Explainer of My Project
{% youtube Ji_q9ZADONE %}

### Language Used
- Javascript (NextJS, Node)

### Link to Code
{% github arndom/pic-placeholder %}

&nbsp;
### Additional Resources / Info
Demo Video ⏬

{% youtube 2K7QKsOiSSg %}

[Try it out](https://picc.vercel.app/).

- - - 


* _Check out [Redis OM](https://redis.io/docs/stack/get-started/clients/#high-level-client-libraries), client libraries for working with Redis as a multi-model database._
* _Use [RedisInsight](https://redis.info/redisinsight) to visualize your data in Redis._
* _Sign up for a [free Redis database](https://redis.info/try-free-dev-to)._
CV and portfolio queries
Published: 2022-08-09 19:13:00

Hi! I'm currently creating my CV and my portfolio as a trainee fullstack developer and some doubts have come to my mind the last days. I would really appreciate that some good and patient person could stop for one second and give me some help😥
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zj5rpj6wborl7ybeoo2l.gif)
 

1. First of all, I am not very sure if openly showing my lack of knowledge of some frameworks (i.e.: I have started to learn React on my own cause the bootcamp I am currently participating in doesn't include it in the stack) will be the best practice. 

2. Second: I am a teacher- English, French and Spanish teacher, to be more specific! And I have been a teacher for the last 12 years! Should I take it off of my CV? Everyone is telling me that it doesn't matter, but I do think that it has given me certain skills which are essential.

3. I have already started different projects that I would like to include in my portfolio, but they are not finished. I just don't want to show my Github profile with ONLY bootcamp and team projects. I would like to include projects that actually show my skills. Should I just finish one project and set it as the main one or should I continue working on the three different projects I've started and let them see my profile like that?


#### Apart from this, would you send CVs to companies when these points are not ready yet? My bootcamp will finish on October and I would like to go through several interviews before.
 

Thank you in advance and sorry for the drama!! hahaha