Configurare program

How to create a local Server with MongoDB Compass and import a “. csv” file into the database

MongoDB is an open source non-relational database that stores the data in the form of collections of JSON documents having dynamic schemas. It stores all the related information together which enhances the speed of query processing. This way, it also helps in bringing down the gap between the key-value stores and relational databases. This kind of databases preserves most of the functionalities while offering horizontal scalability.

[mai mult...]

How to Find Your Spotify Wrapped 2021

As the year comes to a close, the popular streaming service has launched Spotify Wrapped 2021. You can look back at the songs, artists, and podcasts you listened to the most over the past year and share them with friends.

What Is Spotify Wrapped 2021?

Spotify Wrapped is a yearly feature that shows stats about your listening habits over the last 12-ish months. It highlights the artists, songs, genres, and podcasts that you listened to most. It’s a great way to look back at the year and share your music taste with friends. For personal results, you’ll need a Spotify account, but everyone else can view a more generalized version of 2021 Wrapped on Spotify’s website. The website shows the top podcasts and music on the platform over the last year.

How to Find Your Spotify Wrapped 2021

You can only view your Wrapped 2021 results using the Spotify app for iPhone, iPad, and Android. If it doesn’t greet you when opening the app, you can search for “spotify:special:2021” from the Search tab.

Search for the Wrapped page.

This will bring you to the Wrapped 2021 landing page. Tap “See How You Listened in 2021” to get started.

Tap "See How You Listened in 2021" to get started.

From here you’ll be looking at an Instagram Story-like carousel of cards. Music will start playing and you’ll be guided through a number of categories to showcase your listening habits. Tap the screen on the left or right to move forward or backward through the cards.

Wrapped 2021 screens.

At the bottom of each card is a “Share This Story” button. Tap this if you’d like to share the current card with your friends on social media. Only a static image of the card’s infographic will be shared, not the video clip.

Tap "Share This Story."

Select the social media platform you would like to share your Spotify Wrapped 2021 results with.

Pick a social media platform.

The other thing you’ll want to check out is the “Your Top Songs” playlist. You can find this on the Wrapped landing page as well. It’s your 100 most-listened songs from the past year.

"Your Top Songs" playlist.

Wrapped is a fun feature, and it’s one of the best reasons to choose Spotify over other streaming services.

[mai mult...]

How to Generate SSH keys in Windows 10 and Windows 11

Laptop screen showing SSH connection

If part of your life includes logging in to a remote server be it for a self-hosted blog, a Nextcloud installation, or sending your latest changes to GitHub, you need SSH keys. In Windows 10 and 11 we are spoiled for choice when it comes to generating new keys. Here’s how to create all the SSH keys you’ll ever need using three different methods. We’ll show you how to generate your initial set of keys, as well as additional ones if you want to create different keys for multiple sites.

Option 1: Generate Keys in the Command Line

Windows 10 has had a built-in OpenSSH client since the April 2018 update. Windows 11 also comes with this feature built-in. To use it open the Windows Command Prompt by hitting the Windows key and typing “cmd”.

Tip: If you use the command line often, we’d highly recommend installing Windows Terminal from the Windows Store (installed on Windows 11 by default). It’s a tabbed program that can run the Command Prompt, PowerShell, and the Windows Subsystem for Linux all in one window. It also has fun features like setting background images.

Whether you use Command Prompt or Windows Terminal, type ssh-keygen and hit Enter. This will automatically generate the SSH keys. In our tests on Windows 11, it created a 2048-bit RSA key. If you’d like to use a different algorithm—GitHub recommends Ed25519, for example—then you’d type ssh-keygen -t ed25519.

A Windows Terminal window showing the command prompt with ssh-keygen command

After you type your command hit Enter, and then you’ll be prompted to give your key a name and save it in a specific location. If you use the defaults then it will save your keys in C:\User[YourUserName].ssh —assuming the C drive is where your user account is stored.

Windows 11 Command Prompt displaying the option of where to save SSH keys.

Next, you’ll be asked to enter a passphrase. We highly recommend you do this to keep your key secure. If you’re worried about forgetting your password check out this round-up of the best password managers on Review Geek. If you really don’t want a passphrase then just hit Enter.

The Windows 11 Command Prompt asking to create a password for the newly created SSH key.

That’s it your keys are created, saved, and ready for use. You will see you have two files in your “.ssh” folder: “id_rsa” with no file extension and “id_rsa.pub.” The latter is the key you upload to servers to authenticate while the former is the private key that you don’t share with others.

A command line window showing all the commands to create SSH keys

Note: If you can’t see your “.ssh” folder in File Explorer, check out our tutorial on how to show hidden files and folders in Windows.

If you wanted to create multiple keys for different sites that’s easy too. Say, for example, you wanted to use the default keys we just generated for a server you have on Digital Ocean, and you wanted to create another set of keys for GitHub. You’d follow the same process as above, but when it came time to save your key you’d just give it a different name such as “id_rsa_github” or something similar. You can do that as many times as you like. Just remember that the more keys you have, the more keys you have to manage. When you upgrade to a new PC you need to move those keys with your other files or risk losing access to your servers and accounts, at least temporarily.

Option 2: Generate Keys in WSL

The WSL Ubuntu command line showing virtually the same SSH key creation process as the Windows Command Prompt.

If you’re a WSL user, you can use a similar method with your WSL install. In fact, it’s basically the same as with the Command Prompt version. Why would you want to do this? If you primarily live in Linux for command line duties then it just makes sense to keep your keys in WSL.

Open up Windows Terminal or the built-in Ubuntu command prompt (assuming you installed Ubuntu Linux). Then it’s very similar to Windows. Unlike Windows, it’s best to specify whether you want an RSA key or something like Ed25519.

Say you wanted to create an RSA-4096 key. You’d type in the following command:

ssh-keygen -t rsa -b 4096

If you wanted Ed25519 then the recommended way is as follows:

ssh-keygen -t ed25519 -C "your@email.address"

It’s recommended to add your email address as an identifier, though you don’t have to do this on Windows since Microsoft’s version automatically uses your username and the name of your PC for this.

Again, to generate multiple keys for different sites just tag on something like “_github” to the end of the filename.

Option 3: Generate Keys With PuTTY

For years, the old school PuTTY program was a popular way to communicate with a server in Windows. If you’ve already got this program on your system it also offers a method for creating SSH keys.

PuTTY comes with a number of helper programs, one of which is called the PuTTY Key Generator. To open that either search for it by hitting the Windows Key and typing “puttygen,” or searching for it in the Start menu.

puTTY and its helper programs listed in the Windows 11 Start menu

Once it’s open, at the bottom of the window you’ll see the various types of keys to generate. If you’re not sure which to use, select “RSA” and then in the entry box that says “Number Of Bits In A Generated Key” type in “4096.” Another alternative is to select “EdDSA,” and then from the drop-down menu that appears below it make sure “Ed25519 (255 bits)” is selected.

Putty Key Generator with red arrows pointing at the key creation options at the bottom of the window.

Now, all you have to do is click “Generate,” and PuTTY will start working. This shouldn’t take too long depending on the strength of your system, and PuTTy will ask you to move your mouse around inside the window to help create a little more randomness during key generation.

Once that’s done click “Save Public Key” to save your public key, and save it where you want with the name “id_rsa.pub” or “id_ed25519.pub” depending on whether you selected RSA or Ed25519 in the earlier step.

Click the 'Save public key' button in PuTTY.

Then to get your private key it takes an extra step. By default, PuTTY generates PPK keys for use with the PuTTy client. If you want OpenSSH, however, at the top of the window select Conversions  > Export OpenSSH Key and then save the file as “id_rsa” or “id_ed25519” with no file ending.

Select the export SSH key option in Putty.

Generating SSH keys is really easy whichever method you choose. We’d recommend going with the Windows Command Prompt option unless you already have PuTTY installed, or prefer Linux and understand that system.

[mai mult...]

How to Find Your Spotify Wrapped 2021

As the year comes to a close, the popular streaming service has launched Spotify Wrapped 2021. You can look back at the songs, artists, and podcasts you listened to the most over the past year and share them with friends.

Spotify Wrapped is a yearly feature that shows stats about your listening habits over the last 12-ish months. It highlights the artists, songs, genres, and podcasts that you listened to most. It’s a great way to look back at the year and share your music taste with friends.

[mai mult...]