ridhoperdana

CREATE INDEX trgm_idx_fts ON name USING GIN (ts);

ridhoperdana

query	use index	planning time	exec time
where name ilike '%Shandeigh%';	false	<=0.1ms	~300ms
where name ilike '%Shandeigh%';	true	~0.1ms	0.05ms < x < 0.1ms
where name ilike '%Shandeigh%' and created_at > '2022-07-01 08:41:14.515 +0700';	true	~0.1ms	0.05ms < x < 0.1ms
where ts @@ to_tsquery('Shandeigh');	false	<= 0.09ms	~700ms
where ts @@ to_tsquery('Shandeigh');	true	~0.1ms	~0.05ms
where ts @@ to_tsquery('Shandeigh') and created_at &gt; '2022-07-01 08:41:14.515 +0700';	true	~0.1ms	~0.05ms

ridhoperdana

insert into MOCK_DATA (name, created_at) values (?, ?);

ridhoperdana

create table MOCK_DATA (
	id SERIAL,
	name VARCHAR(100),
	created_at timestampz, 
	ts tsvector generated always as (to_tsvector('english'::regconfig, name)) stored
);

ridhoperdana

SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector @@ 'cat & rat'::tsquery;

ridhoperdana

SELECT name FROM mentors WHERE name LIKE '%ridho%';

ridhoperdana

id	name
1	anakin skywalker
2	ridho rhoma
3	gabriel martinelli
4	elkan baggot

ridhoperdana

#!/bin/bash

if [ "$1" == "" ]; then
    echo "Please define what branch you want to keep"
else
    eval git branch | grep -ve " $1$" | xargs git branch -D
fi

ridhoperdana

package main

import (
	"fmt"
)

func main() {
	names := []string{"John", "Doe"}

	for index, name := range names {

ridhoperdana

package main

import (
	"fmt"
)

func names()  {
	names := []string{"John", "Doe"}

	for index, name := range names {