
Operator Ternary juga dikenal sebagai ekspresi kondisional merupakan sebuah operator yang mengevaluasi sesuatu berdasarkan sebuah kondisi `True` atau `False`. Operator ini mempermudah kita untuk mengetes kondisi hanya dalam satu baris yang menggantikan banyak baris kondisi `if-else` yang membuat kode semakin padat.

#### Contoh Penggunaan `Ternary Condition`

```javascript
kondisi ? ekpresiTrue : ekpresiFalse;
```

Selain ekspresi `False`, ekspresi ini juga akan dieksekusi ketika kondisi tersebut bernilai `null`, `Nan`, `0`, `""` (string kosong), dan `undefined`. Jadi setiap nilai yang bernilai seperti yang disebutkan sebelumnya atau selain `True` akan mengeksekusi ekspresi `False`.

Kita juga bisa membuat `conditional chains` atau seperti percabangan `if-else` dengan menggunakan `ternary condition` ini.

#### Contoh `Conditional Chains`

```javascript
kondisi1 ? ekspresi1 :
kondisi2 ? ekspresi2 :
kondisi3 ? ekspresi3 :
kondisi4 ? ekspresi4 :
. . .
```


Operator Ternary merupakan salah satu dari tiga sifat Operator yang digunakan untuk menentukan ekspresi berdasarkan suatu kondisi.

Ternary Operator


Database atau basis data adalah kumpulan data yang dikelola sedemikian rupa berdasarkan ketentuan tertentu yang saling berhubungan sehingga mudah dalam pengelolaannya. Database adalah susunan record data operasional lengkap dari suatu organisasi atau perusahaan, yang diorganisir dan disimpan secara terintegrasi dengan menggunakan metode tertentu dalam komputer sehingga mampu memenuhi informasi yang optimal yang dibutuhkan oleh para pengguna.

### Penyedia Aplikasi Desain Database

---

#### [DbDiagram.io](https://dbdiagram.io/)

**DbDiagram.io** merupakan salah satu aplikasi berbasis website dengan akses gratis yang dibuat untuk Developer dan Data Analyst.

Fitur yang diberikan dalam Free Plan:

- SQL Import & Export `[✓]`
- Up to 10 diagrams `[✓]`
- Public & Embedded diagrams `[✓]`
- Dark Mode (tweet to unlock) `[✓]`
- Export to PDF/PNG `[✓]`

**DbDiagram.io** memiliki dua _pricing plan_ yaitu Free Plan dengan `$0` forever dan Pro Plan dengan `$9` per month.

---

#### [Draw.io](https://draw.io/)

**Draw.io** atau Diagrams.net adalah sebuah aplikasi diagram online untuk membuat diagram alur atau dikenal dengan _flowchart_, _diagram process_, dsb. yang dapat digunakan secara `Full Free` melalui websitenya dan berbayar untuk aplikasi Atlassian seperti Confluence atau JIRA.

---

#### [Lucidchart](https://www.lucidchart.com/)

**Lucidchart** merupakan aplikasi berbasis cloud yang dapat digunakan untuk membuat _flowchart_, _process maps_, model UML, dsb.

Fitur yang diberikan dalam Free Plan:

- Price per month `[$0]`
- Editable documents `[3]`
- Professional templates `[100]`
- Collaboration `[Basic]`
- Integrations `[Basic]`
- Security `[✓]`

**Lucidchart** memiliki empat _pricing plan_ yaitu Free dengan `$0`, Individual mulai dari `$7.95`, Team mulai dari `$6.67` per user (3 user minimun), dan Enterprise dengan `custom pricing`.

---

#### [SQLDBM](https://sqldbm.com/)

**SQLDBM** atau SQL Database Modeler hanya mendukung MySQL dan MS SQL, aplikasi ini menggabungkan rules dan object database yang diperlukan seperti database keys, skema, indeks, column constraints dan relationship.

Fitur yang diberikan dalam Basic Plan:

- Forward Engineering `[✓]`
- Export to PNG `[✓]`
- Reverse Engineering `[✓]`
- MS SQL Server, PostgreSQL, MySQL `[✓]`
- Unlimited Projects & Revisions `[✓]`

**SQLDBM** memiliki tiga _pricing plan_ yaitu Basic dengan `$25` per month atau `$240` per year, Business dengan `$3000` untuk 3 licenses, dan Enterprise dengan `Contract price for custom licenses`.

---

#### [QuickDBD](https://www.quickdbd.com/)

**QuickDBD** atau Quick Database Diagram adalah tools ERD yang berbasis teks, dan dengan cepat menggambar diagram yang diperlukan. QuickDBD menyediakan export ke berbagai format seperti SQL, PDF, maupun word.

Fitur yang diberikan dalam Free Plan:

- Max diagrams `[1]`
- Max tables per diagram `[10]`
- Real-time collaboration `[✓]`
- Share diagrams publicly `[✓]`
- Export images `[✓]`
- Export SQL `[✓]`
- Export PDF/RTF `[✓]`

**QuickDBD** memiliki dua _pricing plan_ yaitu Basic dengan `$0`dan Pro dengan `$14` per month atau `$95` per year.

---


Menggunakan aplikasi desain database agar lebih mudah untuk membangun dan mengoptimalkan desain database.

Aplikasi yang digunakan untuk Mendesain Database


Git is an acronym for Global Information Tracker. Git is a software for tracking changes in any set of files, usually used for coordinating work among programmers collaboratively developing source code during software development. Its goals include speed, data integrity, and support for distributed, non-linear workflows.

#### GIT BASICS

---

Create empty Git repo in specified directory. Run with no arguments to initialize the current directory as a git repository

```bash
git init <directory>
```

---

Clone repo located at `<repo>` onto local machine. Original repo can be located on the local filesystem or on a remote machine via HTTP or SSH.

```bash
git clone <repo>
```

---

Define author name or email to be used for all commits in current repo. Devs commonly use --global flag to set config options for current user.

```bash
git config user.name <name>
```

```bash
git config user.email <email>
```

---

Commit the staged snapshot, but instead of launching a text editor, use `<message>` as the commit message.

```bash
git add <directory>
```

---

List which files are staged, unstaged, and untracked.

```bash
git status
```

---

Display the entire commit history using the default format. For customization see additional options.

```bash
git log
```

---

Show unstaged changes between your index and working directory.

```bash
git diff
```

---

#### UNDOING CHANGES

---

Create new commit that undoes all of the changes made in `<commit>`, then apply it to the current branch.

```bash
git revert <commit>
```

---

Remove `<file>` from the staging area, but leave the working directory unchanged. This unstages a file without overwriting any changes.

```bash
git reset <file>
```

---

Shows which files would be removed from working directory. Use the -f flag in place of the -n flag to execute the clean.

```bash
git clean -n
```

---

#### REWRITING GIT HISTORY

---

Replace the last commit with the staged changes and last commit combined. Use with nothing staged to edit the last commit’s message.

```bash
git commit --amend
```

---

Rebase the current branch onto `<base>`. `<base>` can be a commit ID, branch name, a tag, or a relative reference to HEAD.

```bash
git rebase <base>
```

---

Show a log of changes to the local repository’s HEAD. Add --relative-date flag to show date info or --all to show all refs.

```bash
git reflog
```

---

#### GIT BRANCHES

---

List all of the branches in your repo. Add a `<branch>` argument to create a new branch with the name `<branch>`.

```bash
git branch
```

---

Create and check out a new branch named `<branch>`. Drop the -b flag to checkout an existing branch.

```bash
git checkout -b <branch>
```

---

Merge `<branch>` into the current branch.

```bash
git merge <branch>
```

---

#### REMOTE REPOSITORIES

---

Create a new connection to a remote repo. After adding a remote, you can use `<name>` as a shortcut for `<url>` in other commands.

```bash
git remote add <name> <url>
```

---

Fetches a specific `<branch>`, from the repo. Leave off `<branch>` to fetch all remote refs.

```bash
git fetch <remote> <branch>
```

---

Fetch the specified remote’s copy of current branch and immediately merge it into the local copy.

```bash
git pull <remote>
```

---

Push the branch to `<remote>`, along with necessary commits and objects. Creates named branch in the remote repo if it doesn’t exist.

```bash
git push <remote> <branch>
```

---

### Additional Options+

#### GIT CONFIG

---

Define the author name to be used for all commits by the current user.

```bash
git config --global user.name <name>
```

---

Define the author email to be used for all commits by the current user.

```bash
git config --global user.email <email>
```

---

Create shortcut for a Git command. E.g. alias.glog “log --graph --oneline” will set ”git glog” equivalent to ”git log --graph --oneline.

```bash
git config --global alias. <alias-name> <git-command>
```

---

Set text editor used by commands for all users on the machine. `<editor>` arg should be the command that launches the desired editor (e.g., vi).

```bash
git config --system core.editor <editor>
```

---

Open the global configuration file in a text editor for manual editing.

```bash
git config --global --edit
```

---

#### GIT LOG

---

Limit number of commits by `<limit>`. E.g. ”git log -5” will limit to 5 commits.

```bash
git log -<limit>
```

---

Condense each commit to a single line.

```bash
git log --oneline
```

---

Display the full diff of each commit. --graph --oneline.

```bash
git log -p
```

---

Include which files were altered and the relative number of lines that were added or deleted from each of them.

```bash
git log --stat
```

---

Search for commits by a particular author.

```bash
git log --author=”<pattern>”
```

---

Search for commits with a commit message that matches `<pattern>`.

```bash
git log --grep=”<pattern>”
```

---

Show commits that occur between `<since>` and `<until>`. Args can be a commit ID, branch name, HEAD, or any other kind of revision reference.

```bash
git log <since>..<until>
```

---

Only display commits that have the specified file.

```bash
git log --follow <file>
```

---

--graph flag draws a text based graph of commits on left side of commit msgs. --decorate adds names of branches or tags of commits shown.

```bash
git log --graph --decorate
```

---

#### GIT DIFF

---

Show difference between working directory and last commit.

```bash
git diff HEAD
```

---

Show difference between staged changes and last commit.

```bash
git diff --cached
```

---

#### GIT RESET

---

Reset staging area to match most recent commit, but leave the working directory unchanged.

```bash
git reset
```

---

Reset staging area and working directory to match most recent commit and overwrites all changes in the working directory.

```bash
git reset --hard
```

---

Move the current branch tip backward to `<commit>`, reset the staging area to match, but leave the working directory alone.

```bash
git reset <commit>
```

---

Same as previous, but resets both the staging area & working directory to match. Deletes uncommitted changes, and all commits after `<commit>`.

```bash
git reset --hard <commit>
```

---

#### GIT REBASE

---

Interactively rebase current branch onto `<base>`. Launches editor to enter commands for how each commit will be transferred to the new base.

```bash
git rebase -i <base>
```

---

#### GIT PULL

---

Fetch the remote’s copy of current branch and rebases it into the local copy. Uses git rebase instead of merge to integrate the branches.

```bash
git pull --rebase <remote>
```

---

#### GIT PUSH

---

Forces the git push even if it results in a non-fast-forward merge. Do not use the --force flag unless you’re absolutely sure you know what you’re doing.

```bash
git push <remote> --force
```

---

Push all of your local branches to the specified remote.

```bash
git push <remote> --all
```

---

Tags aren’t automatically pushed when you push a branch or use the --all flag. The --tags flag sends all of your local tags to the remote repo.

```bash
git push <remote> --tags
```

---


Git cheat sheet that serves as a quick reference for basic Git commands to help you learn Git.

Articles3.

Ternary Operator

Operator Ternary merupakan salah satu dari tiga sifat Operator yang digunakan untuk menentukan ekspresi berdasarkan suatu kondisi.

August 28th, 2021

Aplikasi yang digunakan untuk Mendesain Database

Menggunakan aplikasi desain database agar lebih mudah untuk membangun dan mengoptimalkan desain database.

July 23rd, 2021

Git Cheat Sheet

Git cheat sheet that serves as a quick reference for basic Git commands to help you learn Git.

July 21st, 2021