teleren/devto huggingface dataset:
Database of Databases
Tags: database, catalog, index
Published: 2022-06-23 11:10:21

Databases are an integral part of any software application. Databases have played a critical role for a very long time in the history of computers and software.

Databases come in a wide variety solving different problems and scenarios, that include


- Relational Databases
    - [PostgreSQL][1] - Free & Open source
    - [MySQL][2] - Free & Open source
    - [MariaDB][3] - Free & Open source
    - [SQLite][4] - Free, Embedded & Open source
    - [H2][5] - Free, Embedded & Open source
    - [HSQLDB][6] - Free, Embedded & Open source
    - [DuckDB][7] - Free & Open source
    - [Oracle][8] - Commercial
    - [SQL Server][9] - Commercial

- NoSQL Databases
    - [MongoDB][10]
    - [CouchDB][11]
    - [Cassandra][12]

- Key / Value Stores
    - [Redis][13]
    - [Memcached][14]
    - [Project Voldemort][15]

- Multi-model & Graph Databases
    - [OrientDB][16]
    - [ArangoDB][17]
    - [Neo4J][18]

A lot more and this list can go on. However, there is a comprehensive database of databases that are/were used so far. 

Enter [dbdb.io][19], the _Database of Databases_ created and maintained by [Carnegie Mellon Database Group][20]. The catalog has entries of 841 databases (at the time of writing this article). It is fascinating to see the number of databases that have existed, the history about them and their technical details.

The list provided about is just a tip of the iceberg and the quite popular ones!

The site provides nice search feature. It also has leaderboards grouped under different parameters.

Visit the _"database of databases"_ to learn more!

[1]: https://postgresql.org "PostgreSQL"
[2]: https://mysql.com "MySQL"
[3]: https://mariadb.org "MariaDB"
[4]: https://sqlite.org "SQLite"
[5]: https://h2database.com/ "H2 Database"
[6]: https://hsqldb.org/ "HSQLDB"
[7]: https://duckdb.org/ "DuckDB"
[8]: https://oracle.com/ "Oracle"
[9]: https://www.microsoft.com/en-in/sql-server/sql-server-2019 "SQL Server"
[10]: https://www.mongodb.com/ "MongoDB"
[11]: https://couchdb.apache.org/ "CouchDB"
[12]: https://cassandra.apache.org/ "Cassandra"
[13]: https://redis.io/ "Redis"
[14]: http://memcached.org/ "Memcached"
[15]: http://www.project-voldemort.com/voldemort/ "Project Voldemort"
[16]: https://orientdb.org/ "OrientDB"
[17]: https://www.arangodb.com/ "ArangoDB"
[18]: https://neo4j.com/ "Neo4J"
[19]: https://dbdb.io "Database of Databases"
[20]: https://db.cs.cmu.edu/ "Carnegie Mellon Database Group"
Build a Group Video Call System using PHP,Javascript + WebRTC Day 5
Tags: webrtc, webdev, php, tutorial
Published: 2022-06-23 12:45:40

WebRTC unlocks the possibility that people can create any video chat app they like. The freedom that WebRTC grants makes the technology highly competitive against traditional video chat apps like Skype.In this video we'll cover creating the group video call UI using HTML and CSS
{% youtube 7iX664IOZ1Q %}
Hide password in MongoDb
Tags: mongodb, javascript, beginners, tutorial
Published: 2022-06-23 11:17:15

_As developers, there are times or reasons why we don't want our passwords to be accessible by default when creating our APIs. Here are some ways we can hide our passwords._


![hide](https://media.giphy.com/media/l0G17mcoGBEabVgn6/giphy.gif)

---

####🎯 Prerequisite
NodeJs + Express Knowledge
MongoDb + Mongoose [Basic CRUD functionality knowledge]

---

In this post, I am using <mark>mongoose</mark>. Mongoose provides a straight-forward, schema-based solution to model your application data. It includes built-in type casting, validation, query building, business logic hooks and more, out of the box [Read more here](https://mongoosejs.com/). Basically, mongoose is an ODM [Object Data Modelling] library that helps to write simple queries other than the native/raw MongoDb queries.

#### Method 1
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qyh45qi7167c54qsihbn.png)
Here we are using the mongoose to find all users and removing all passwords using the select. The `-` sign basically negates the function. It means ignore the password from the objects being fetched.

---

#### Method 2
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t4j7bf04uoa2xxhz3b4s.png)
Here we de-structured response object coming from our database using javascript `spread` operator and ignored the password.  
 
  
---

#### Method 3
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/l4ws1n2kz53l7xcm8j12.png)
 This method 3 is an alternative way of writing <mark>Method  1 </mark> using the select query method.

  
---

#### Conclusion
I hope this post was helpful. Thanks for reading.

#### Resources
[Mongoose Documentation](https://mongoosejs.com/docs/api/query.html)

[Javascript Spread syntax - MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Spread_syntax) 

[Mongoose-npmjs](https://www.npmjs.com/package/mongoose)
Laravel 9 Eloquent WHERE Like Query Example Tutorial
Tags: laravel, php, tutorial, webdev
Published: 2022-06-23 12:39:16

When you put the search form in your application, you need to use like query to get matched pattern. The LIKE a query is used in a WHERE clause to search for a specified pattern in a column. You can use the LIKE MySQL keyword and % wildcard character with where clause.

In laravel, using whereLike() eloquent method, you can implement laravel where like search query, laravel where like multiple columns and laravel collection with where like.

## Example 1: Laravel where Like Query use with Eloquent Model
You can use the LIKE MySQL keyword and % wildcard character with the where clause.

The following example represents, how to use it:
```
public function index(){
    $users = User::where('name','LIKE',"%{$search}%")->get();
    return $users;                
}
```
When you dump the above given whereNull query you will get the following SQL query:
```
SELECT * FROM `users` WHERE `name` LIKE '%search%';
```

## Example 2: Using macros with Like
To define a macro, you simply use the macro static method on the class you want to define the macro to. We need to define a macro for the Eloquent class, so we can extend it like this (in the boot method of the service provider):
```
Builder::macro('whereLike', function($column, $search) {
  return $this->where($column, 'LIKE', "%{$search}%");
});
```
The way we can use this macro now is simple:
```
public function index(){
  return User::whereLike('username', $username)
   ->whereLike('email', $email)
   ->get();
}
```

## Example 3: Laravel whereLike with multiple columns using macros
if you want to search with multiple columns then you have to extend this macro to support multiple columns.
```
Builder::macro('whereLike', function($columns, $search) {
  $this->where(function($query) use ($columns, $search) {
    foreach(\Arr::wrap($columns) as $column) {
      $query->orWhere($column, $search);
    }
  });
 
  return $this;
});
```
So now, if we pass a single column (using the array_wrap function we convert it to an array), and search that column, but if we add multiple columns in an array then we loop through all of them and search the search term in all of those columns. Everything is wrapped in an where query because we don't want the whereLike query to mess up any other where queries we can perform on the Eloquent model.

You can use this macro now like this:
```
public function index(){
 return User::whereLike(['username', 'email'], $search)->get();
}
```
**Thank you** for reading this article.
Magento 2 GeoIP Redirect
Tags: magento2, geoipredirect, magento2geoipextension, ipredirect
Published: 2022-06-23 12:34:24

Do you have your business website or eCommerce store?

I know how silly the question is. Of course! everyone has a website of their business or an eCommerce store. But it is quite difficult to give your customer the best shopping experience when you are selling your goods or services worldwide. 

Handling a different region store and domains for each and every country is not an easy task. It demands a lot of effort including human resources, investment of money, time and etc. 

But why go so far when you can have everything in one place by just integrating one plugin?

Magento 2 GeoIP Redirect detects customers/visitors' IP addresses and displays them relevant store views in their local language and currency. 

Additionally, the plugin encourages store owners to expand their business worldwide

## What benefits you will get with Magento 2 GeoIP?

**Automatic GeoIP Location detection**

Magento GeoIP allows the store owner to detect customer's IP addresses automatically.Store owner can detect their location and based on that the store view, language and currency will be changed in their local language and currency. 

**Sale your services and goods worldwide**

GeoIP Magento extension is helpful for those who have different branches in different counties. So that they do not need to make different websites for various countries.

**Allow customer to select their preferences**

Almost all visitors will be redirected to their relevant stores but with the use of Magento GeoIP. However, customers can also change their store view by selecting their preferences displayed in the header. They can change the store view.

**More friendly and convenient**

GeoIP Magento 2 is a more friendly and convenient solution for costumes and store owners. In that case, the customer can easily focus on the shopping instead of the language and currency issues.
Automatic store switcher and GeoIP redirected are useful for improving the store accessibility and usability of users.

Allow your customer to explore your products in their local language and currency and improve customer shopping experience by integrating [GeoIP Redirect for Magento 2](https://www.milople.com/magento-2-extensions/geoip-redirect-m2.html).
Describe floats in CSS and how they work.
Tags: css, html, webdev, beginners
Published: 2022-06-23 12:33:27

In CSS, floats are created by setting the `float` property of an element to a value other than `none`.

```
div {
  float: left;
}
```

Floating an image with text wrapped around it, is a common implementation of the `float` property. An element can be floated right or left, with assignable values of `right`, `left`, `inline-start` and `inline-end`.

Floating an element creates a **Block Formatting Context** on the element, takes the element out of the normal flow of the document, and wraps around itself line boxes that come after the element in the DOM tree.

Items floated to the `left`, move to the left edge of its container and those floated to the `right` move to the right edge.

Multiple items floated to the same edge follow the order in which they appear in the DOM tree, with the first one moved to the edge, then the next one beside it, and so on -- ending up with the last one farthest from the edge. If there is no space to accommodate all floated items, they move to the next line.

In almost all cases, using a float also involves **clearing** it from one item that come after itself, because line boxes (e.g. text nodes) wrap around floated items. Clearing a float from an element results in moving the element below the float.

Floats, along with several clearing techniques, were used to create multi-column layouts, but **flex** and **grid** items are nowadays used for this purpose.

---
References

1. [Floats](https://developer.mozilla.org/en-US/docs/Learn/CSS/CSS_layout/Floats)
2. [float](https://developer.mozilla.org/en-US/docs/Web/CSS/float)
3. [clear](https://developer.mozilla.org/en-US/docs/Web/CSS/clear)
Storyblok React SDK – now with TypeScript support 🎉
Tags: storyblok, typescript, ts, react
Published: 2022-06-23 12:14:22

---
title: Storyblok React SDK – now with TypeScript support 🎉

published: true
description: 
tags: #storyblok, #typescript, #ts, #react
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gztx51t1pj9wl1ml8a4n.png
---

Are you a React developer? We have great news for you: [Storyblok's React SDK](https://github.com/storyblok/storyblok-react) now comes with TypeScript support! 🙌 
You will be able to add typing to your React projects, while having an even better developer experience connecting to Storyblok.

➡️ Do you want to see it in action? Take a look at this [Storyblok React SDK w/ TypeScript live demo](https://stackblitz.com/edit/react-sdk-ts-demo)!

With the new version of [Storyblok's React SDK](https://github.com/storyblok/storyblok-react), you get auto-completion, static typing and warnings in case something doesn’t add up, even if you are not using TypeScript yourself!

Look at this example:

![Adding TypeScript to a React file](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ej2g9lgn37u3j2fyp8u6.gif)

Do you need help implementing TypeScript in your React project? Take a look at [the official TypeScript and React documentation](https://www.typescriptlang.org/docs/handbook/react.html) or [this guide by Kent C. Dodds explaining how to write a React component with TypeScript](https://kentcdodds.com/blog/how-to-write-a-react-component-in-typescript).

➡️ If you want to learn how to integrate Storyblok into your React project, you can follow [our 5 minutes guide to implementing React with Storyblok](https://www.storyblok.com/tp/headless-cms-react).

➡️ Are you using a React based framework? We have you covered, too! We have 5 minutes tutorials for [Next.js](https://www.storyblok.com/tp/add-a-headless-cms-to-next-js-in-5-minutes), [Gatsby](https://www.storyblok.com/tp/add-a-headless-cms-to-gatsby-5-minutes), and [Remix](https://www.storyblok.com/tp/headless-cms-remix)!

At Storyblok, we're working in order to roll out TypeScript support for all our SDKs. [Vue](https://dev.to/storyblok/storyblok-sdks-for-vue-2-and-3-now-with-typescript-support-764) and [Svelte](https://dev.to/storyblok/storybloksvelte-now-with-typescript-support-3ndh) SDKs already support TS, more will be updated soon!

We would love to hear what you think. What do you like about it? What could be improved? Please, share your comments! ⬇️
Setup NeoVim on macOS with plugin manager and Hop (easy-motion)
Tags: neovim
Published: 2022-06-23 12:09:14

1. `brew install nvim`
2. vim-plug: `sh -c 'curl -fLo "${XDG_DATA_HOME:-$HOME/.local/share}"/nvim/site/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim'`
3. Open init.vim
```
" plugins
call plug#begin(stdpath('data') . '/plugged')
Plug 'phaazon/hop.nvim'
call plug#end()

" hop
lua << EOF
require'hop'.setup()
EOF

" remap leader leader to hop word
map <Leader><Leader> :HopWord <CR>
```

Open a file in nvim and type in `:PlugUpdate`, you'll see installation process. Now type in `\\` or double tap whatever your leader key is mapped to, and hop should be working.
Top 10 Sites for your Career!
Tags: career, beginners, productivity, programming
Published: 2022-06-23 12:03:54

Sites for your Career, Tech Skills, Free Online Education, Excel, Resume, and Interview Preparation.

## **Top 10 Sites for your career:**
1. [Linkedin](https://www.linkedin.com/feed/)
2. [Indeed](https://pk.indeed.com/)
3. [Naukri](https://www.naukrigulf.com/)
4. [Monster](https://www.monster.com/)
5. [JobBait](https://www.bayt.com/)
6. [Careercloud](https://www.careercloud.com/)
7. [Dice](https://www.dice.com/)
8. [CareerBuilder](https://www.careerbuilder.com/)
9. [Jibberjobber](https://www.jibberjobber.com/login.php)
10. [Glassdoor](https://www.glassdoor.com/)

************************************************************

## **10 Tech Skills in demand:**
1. Machine Learning.
2. Mobile Development.
3. SEO/SEM Marketing.
4. Data Visualization.
5. Data Engineering.
6. UI/UX Design.
7. Cyber-security.
8. Cloud Computing/AWS.
9. Blockchain.
10. IOT.

************************************************************

## **11 Sites for Free Online Education:**
1. [Coursera](https://www.coursera.org/)
2. [edX](https://www.edx.org/)
3. [Khan Academy](https://www.khanacademy.org/)
4. [Udemy](https://www.udemy.com/)
5. [iTunesU Free Courses](https://www.saylor.org/?)
6. [MIT OpenCourseWare](https://ocw.mit.edu/)
7. [Stanford Online](https://grow.stanford.edu/)
8. [Codecademy](https://www.codecademy.com/)
9. [ICT iitr](eict.iitr.ac.in)
10.[ICT iitk](eict.iitr.ac.in)
11.[NPTEL](https://nptel.ac.in/)

******************************************************************

## **10 Sites to learn Excel for free:**
1. Microsoft Excel Help Center.
2. Excel Exposure.
3. Chandoo.
4. Excel Central.
5. Contextures.
6. Excel Hero b.
7. Mr. Excel.
8. Improve Your Excel.
9. Excel Easy.
10. Excel Jet.

******************************************************************

## **10 Sites to review your resume for free:**
1. [Zety Resume Builder](https://zety.com/)
2. [Resumonk](https://www.resumonk.com/)
3. [Resume.com](https://www.resume.com/)
4. [VisualCV](https://www.visualcv.com/)
5. [Cvmaker](https://cvmkr.com/)
6. [ResumUP](https://resumup.com/choose_your_template)
7. [Resume Genius](https://resumegenius.com/)
8. [Resume builder](https://www.resumebuilder.com/)
9. [Resume Baker](http://www.resumebaker.com/)
10. [EnhanCV](https://enhancv.com/)

******************************************************************

## **10 Sites for Interview Preparation:**
1. Ambitionbox
2. AceThelnterview
3. Geeksforgeeks
4. Leetcode
5. Gainlo
6. Careercup
7. Codercareer
8. interviewUp
9. InterviewBest
10. Indiabix
iOS — How to handle Semantic Auto-Versioning on CI
Tags: ios, iosdev, deployment, auto
Published: 2022-06-23 12:00:31

**Want to automate your deployment with auto-versioning and save 25% of your time**?

In this article we’ll explore How to handle Semantic Auto-Versioning on CI. We will follow semantic versioning.

Basically, the version name will be created with the combination of major, minor, and patch numbers.

**For example, for app version 1.4.0 —**

1 - major number
4 - minor number
0 - patch number

If we want to auto-deploy apps on every commit, we can keep major and minor versions static. Make the patch number dynamic. 

For patch number, we can use the pipeline ID which changes with every commit, thus every build with have a unique version name and number.

**We will need to make 3 changes in our project to support auto-versioning.
**
1. Add VERSION file
2. Update deployment script
3. Update Project files

Once done, you will never have to worry about pushing build on CI. Commit your changes and you will have a build ready on Testflight within a few minutes.

For implementation details, [visit our blog](https://blog.canopas.com/ios-how-to-handle-semantic-auto-versioning-on-ci-c4eec775409).
Challenge Platforms to Learn Java
Tags: challenge, coding, java, quiz
Published: 2022-06-23 11:59:50

[Twitter](twitter.com/insanity_xi)
Some Websites that can help you to improve your coding skills :
https://projecteuler.net/
https://www.hackerrank.com/domains/java
https://unstop.com/coding/practice
https://exercism.org/tracks/java
https://edabit.com/challenges
https://www.codewars.com/

These Sites can Help you to Gamify and Examine your java and coding skills, these are not restricted to Java you can choose Language of your own choice .
Currently I am taking Leet code's 21 days of DP(Dynamic Programming Challenge): [Leet Code 21 days of DP](https://leetcode.com/study-plan/dynamic-programming/?progress=zg6nax7) 
Follow me along in Github classroom https://classroom.github.com/a/FSdoW_nu
Spark AR Creator Badge
Tags: spark, community, animation, opensource
Published: 2022-06-23 11:59:06

Click following to try my effect on instagram---> https://www.instagram.com/ar/575259706898619/?ch=MzM0NjgzNWEyMzQzYWRhZjgwNzRkZTZiMGJjYTg0Yzc%3D

Click following to try my effect on facebook---> 
https://www.facebook.com/fbcameraeffects/tryit/575259706898619/

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/x2ybtp661lacmmnwouge.jpg)
Automating detection of security vulnerabilities and bugs in CI/CD pipelines using Amazon CodeGuru Reviewer CLI
Tags: codereview, codequality, devsecops, awscodeguru
Published: 2022-06-23 11:46:22

Watts S. Humphrey, the father of Software Quality, had famously quipped, “Every business is a software business”. Software is indeed integral to any industry. The engineers who create software are also responsible for making sure that the underlying code adheres to industry and organizational standards, are performant, and are absolved of any security vulnerabilities that could make them susceptible to attack.

Traditionally, security testing has been the forte of a specialized security testing team, who would conduct their tests toward the end of the Software Development lifecycle (SDLC). The adoption of DevSecOps practices meant that security became a shared responsibility between the development and security teams. Now, development teams can, on their own or as advised by their security team, setup and configure various code scanning tools to detect security vulnerabilities much earlier in the software delivery process (aka “Shift Left”). Meanwhile, the practice of Static code analysis and security application testing (SAST) has become a standard part of the SDLC. Furthermore, it’s imperative that the development teams expect SAST tools that are easy to set-up, seamlessly fit into their DevOps infrastructure, and can be configured without requiring assistance from security or DevOps experts.

In a recentl blog post at the AWS DevOps blogs, I demonstrated how you can leverage Amazon CodeGuru Reviewer Command Line Interface (CLI) to integrate CodeGuru Reviewer into your Jenkins Continuous Integration & Continuous Delivery (CI/CD) pipeline. Note that the solution isn’t limited to Jenkins, and it would be equally useful with any other build automation tool. Moreover, it can be integrated at any stage of your SDLC as part of the White-box testing. For example, you can integrate the CodeGuru Reviewer CLI as part of your software development process, as well as run it on your dev machine before committing the code.

Read the full post [here](https://aws.amazon.com/blogs/devops/automating-detection-of-security-vulnerabilities-and-bugs-in-ci-cd-pipelines-using-amazon-codeguru-reviewer-cli/).
Which is best in PyCharm and VSCode
Tags: python, programming, pycharm, vscode
Published: 2022-06-23 11:35:11

VS Code easily defeats PyCharm in the performance metrics. The memory footprint, startup time, and general reactivity of VS Code are considerably better than PyCharm because it doesn't try to be a full IDE and keeps things simple as a text editor.

Numerous Python interpreters are supported by Visual Studio Code. You can manually add virtual environments and change their default interpreters in PyCharm. These settings' biggest drawback is their dullness. Both IDEs have a small amount of delay. There is no winner or loser in this contest between [PyCharm and Visual Studio Code](https://insideaiml.com/blog/PyCharm-vs-VSCode-296).
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ej1y4md68uhjnht2phao.png)