DEV Community: ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ

Slack vs MS Teams > Message Searching

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Tue, 11 Feb 2020 03:36:19 +0000

Why don’t MS Teams apply Truncation Search Algorithm?

https://tryshift.com/blog/apps-hub/microsoft-teams-vs-slack/

Search

Both MS Teams and Slack allows searching through all chat sessions, putting an end to the nightmare of trying to find one comment among thousands. If you’ve opted for the free version of Slack, however, the search function only applies to the 10,000 most recent messages.

Microsoft’s WhoBot tool helps with search in MS Teams. This search bot crawls your entire company intranet to surface the data you’re looking for. It also helps you access subject matter experts within your organization so you can find the best person for what you’re looking for.

Anyway Slack allows you to search through 10,000 most recent messages by using Truncation Search Algorithm while MS Teams doesn’t allow this.

Example : I have a message “ReplySlack” in both Slack and MS Teams.

Slack : try searching with “ReplyS*” and found the message.

MS Teams : try searching with “ReplyS*” and can not found the message.

What is a wildcard?

Slack Review: Messaging, Calls, Integrations and Other Features

ILIKE condition in Oracle SQL

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Tue, 11 Feb 2020 03:32:19 +0000

Using Case Sensitivity (alternative to ILIKE)

Photo by White.RainForest ∙ 易雨白林. on Unsplash

LIKE

The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another, the LIKE conditions match a portion of one character value to another by searching the first value for the pattern specified by the second.

The following query finds the salaries of all employees with the name ‘SM%’. Oracle interprets ‘SM%’ as a text literal, rather than as a pattern, because it precedes the LIKE keyword:

SELECT salary 
    FROM employees 
    WHERE 'SM%' LIKE last\_name;

ILIKE

There are noILIKEcondition in Oracle SQL, but you still can have alternative way to do it.

Using Case Sensitivity (alternative to **ILIKE)**

Case is significant in all conditions comparing character expressions that the LIKE condition and the equality (=) operators. You can use the UPPER function to perform a case-insensitive match, as in this condition:

UPPER(last\_name) LIKE 'SM%'

REF : https://docs.oracle.com/cd/B13789_01/server.101/b10759/conditions016.htm

How to use pbcopy on Ubuntu

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Fri, 13 Dec 2019 09:51:04 +0000

this command line enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.

pbcopy on a mac enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.

You can replicate pbcopy on ubuntu by utilising a similar tool called xclip which does exactly the same. However its syntax is a little too verbose and I prefer to use OS X pbcopy command.

how to configure pbcopy on ubuntu

If you haven’t previously installed xclip simply run the following command in your terminal window:

sudo apt-get install xclip -y

Edit your BASH settings file using your favorite text editor.

nano ~/.bashrc

Then create an alias for pbcopy and pbpaste:

alias pbcopy=’xclip -selection clipboard’

alias pbpaste=’xclip -selection clipboard -o’

Close and save the file then just refresh your bash to import your new settings

source ~/.bashrc

Usage

pbcopy < /etc/resolv.conf

Intro to Webhooks — Discord

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Thu, 12 Dec 2019 08:59:43 +0000

Intro to Webhooks — Discord

Webhooks are a low-effort way to post messages to channels in Discord. They do not require a bot user or authentication to use.

Photo by Corinne Kutz on Unsplash

Discord’s built in Webhooks function as an easy way to get automated messages and data updates sent to a text channel in your server. Think of them as one of those fancy pneumatic tube things you used to love sending money into at a bank and watch disappear, but instead of never seeing your money again, you’re actually sending messages into Discord from another platform.

Open your Server Settings Webhook tab:

Click the purple button to create a new webhook!

Then you will get a new Webhook with the URL.

How to use Webhook to send message :

curl -X POST WEBHOOK_URL -H ‘content-type: application/json’ -d ‘{“content”: “Hello, World!”}’

Discord Developer Portal - API Docs for Bots and Developers

How to make a meme

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Thu, 21 Nov 2019 05:20:35 +0000

go to https://imgur.com

If you’re on social media, you already know what an internet meme is. Still, for the uninitiated, a meme is a funny picture that goes viral on the web. It comes in various forms, though most of them feature photos or illustrations emblazoned with witty text usually written with caps lock on. But what if you want to make your own meme? There are websites that will allow you to quickly customize your meme from a host of existing ones. All you need to do is to choose a image template, type in your desired text, and share away. However, you can also create a whole new meme from scratch and, fortunately, it’s pretty easy to do.

Jump to Meme Generator — Imgur is an American online image sharing community and image host founded by Alan Schaaf in 2009. Contents. 1 History.

The fastest and easiest way on the Internet to create your own memes!

A free dummy data generator and API mocking tool — mockaroo

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Wed, 06 Nov 2019 08:13:11 +0000

A free dummy data generator and API mocking tool — mockaroo

Get dummy data for your testing DB

Mockaroo

Mockaroo is website where you can generate the dummy data randomly. Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats per time. Mockaroo also have pricing plan for the ability of generate more rows per time.

Because Mockaroo generate random data, so if you want 10 000 rows of data you just click Download button ten times and it will generate ten files of 10 000 data randomly for you.

Using Map with @PathVariable

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Wed, 30 Oct 2019 10:13:27 +0000

Is that map populated with all path variable names and values?

Photo by David Martin on Unsplash

@PathVariable is a Spring annotation which indicates that a method parameter should be bound to a URI template variable. If the method parameter is Map then the map is populated with all path variable names and values.

It has the following optional elements:

name — name of the path variable to bind to
required — tells whether the path variable is required
value — alias for name

@GetMapping(value = "/book/{author}/{title}")
public void process3(@PathVariable Map<String, String> vals) {

   logger.info("{}: {}", vals.get("author"), vals.get("title"));

}

Doc : http://zetcode.com/spring/pathvariable/

Fixing GPG Keys missing public key in Ubuntu, Mint

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Thu, 24 Oct 2019 09:48:17 +0000

The following signatures couldn’t be verified because the public key is not available

Err :

W: GPG error: http://repository.spotify.com stable InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 4773BD5E130D1D45

SOLUTION

sudo apt-key adv — keyserver ha.pool.sks-keyservers.net — recv-keys

Ex :

sudo apt-key adv — keyserver ha.pool.sks-keyservers.net — recv-keys 4773BD5E130D1D45

Functional Interfaces In Java

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Thu, 24 Oct 2019 04:25:53 +0000

What to do with it?

https://www.journaldev.com

A functional interface is an interface that contains only one abstract method. They can have only one functionality to exhibit. From Java 8 onwards, lambda expressions can be used to represent the instance of a functional interface. A functional interface can have any number of default methods. Runnable , ActionListener , Comparable are some of the examples of functional interfaces.

Before Java 8, we had to create anonymous inner class objects or implement these interfaces.

Java 8 onwards, we can assign lambda expression to its functional interface object like this:

@FunctionalInterface Annotation

@FunctionalInterface annotation is used to ensure that the functional interface can’t have more than one abstract method. In case more than one abstract methods are present, the compiler flags an ‘Unexpected @FunctionalInterface annotation’ message. However, it is not mandatory to use this annotation.

READMORE : geeksforgeeks

@Override

public void run()

{

System.out.println("New thread created");

}

}).start();

}

}

Loading Maven dependencies from GitHub

ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ — Fri, 04 Oct 2019 09:08:57 +0000

jitpack.io — github.com

Now you can import a Java library from a GitHub repo using JitPack.

In your pom.xml:

First Add repository:



<repository>
    <id>jitpack.io</id>
    <url>https://jitpack.io</url>
</repository>

Second Add dependency:



<dependency>
    <groupId>com.github.User</groupId>
    <artifactId>Repo name</artifactId>
    <version>Release tag</version>
</dependency>

Note : for release tag

Before we can use release tag as a version in dependency, we have to create release tag first.



$ git tag -a 0.0.1-SNAPSHOT -m "commit message"
$ git push origin --tag

Example : I have a Repository : https://github.com/sovannarithcheav/artifact-demo.git, So the dependency should look like this :



<dependency>
 <groupId>com.github.sovannarithcheav</groupId>
 <artifactId>artifact-demo</artifactId>
 <version>0.0.1-SNAPSHOT</version>
</dependency>

It’s easy, right? 😜

DEV Community: Ｃｈｅａｖ Ｓｏｖａｎｎａｒｉｔｈ

Slack vs MS Teams > Message Searching

Why don’t MS Teams apply Truncation Search Algorithm?

Search

ILIKE condition in Oracle SQL

Using Case Sensitivity (alternative to **ILIKE)**

LIKE

ILIKE

How to use pbcopy on Ubuntu

this command line enables you to copy the standard input from terminal window to your clipboard enabling you to paste it to other applications.

how to configure pbcopy on ubuntu

Usage

Intro to Webhooks — Discord

Intro to Webhooks — Discord

Webhooks are a low-effort way to post messages to channels in Discord. They do not require a bot user or authentication to use.

READ MORE

How to make a meme

go to https://imgur.com

A free dummy data generator and API mocking tool — mockaroo

A free dummy data generator and API mocking tool — mockaroo

Get dummy data for your testing DB

Using Map with @PathVariable

Is that map populated with all path variable names and values?

Fixing GPG Keys missing public key in Ubuntu, Mint

The following signatures couldn’t be verified because the public key is not available

SOLUTION

Functional Interfaces In Java

What to do with it?

@FunctionalInterface Annotation

Loading Maven dependencies from GitHub

jitpack.io — github.com

DEV Community: ＣｈｅａｖＳｏｖａｎｎａｒｉｔｈ

Using Case Sensitivity (alternative to ILIKE)