DEV Community: zankyr

Git & tricks: plugins + tools

zankyr — Wed, 08 Feb 2023 14:16:13 +0000

// TODO place a beautiful and smart introduction here

IntelliJ
- Git
- .ignore
Lazygit

IntelliJ

Git

If I had to choose only one plugin to use, my choice would fall on this. It comes bundled with intellij,
even in the Community Edition, and I haven’t found a Git client yet that’s so simple and effective to use.
It’s free, but I’d also be willing to pay just for the merge/rebase conflict manager feature.

.ignore

Create ignore files for most of the tools/platforms (git, yarn, Docker, etc.) in an easy way.
Main features:

lots of templates for specific languages (Java, Node, etc.) or tools (JetBrains, Visual Studio Code, etc.)
syntax highlight
custom templates
etc.

Lazygit

If you don't want to learn git's commands (let's be honest, solving a merge conflict via command line is not so fun), and you have to work on different projects using different IDEs, maybe you'd like Lazygit. This is a Git UI for your terminal, so you don't have to work with different Git plugins each time you switch from IntelliJ to VS Code and viceversa.

Git & tricks: commands

zankyr — Thu, 17 Nov 2022 13:48:34 +0000

This is my collection of unconventional git commands. Here you won’t find basic commands like git log or git checkout, but more particular instructions that have come in handy during my daily work.

Empty commit
Restore file from another branch
Delete branches by filters.
Delete all local branches not matching the provided name(s)

Empty commit

If you want to make a commit even if you didn't modify any file, for example
to create a bookmark or checkpoint, just pass the --allow-empty option:

$ git commit --allow-empty -m 'Started working on PR'

Restore file from another branch

To restore a file using the version from another branch:

$ git restore --source develop -- /path/to/file/to/restore

where

--source develop is the source branch. This version will override the file in your current branch;
/path/to/file/to/restore is the path (absolute or relative) of the file to restore.

Delete branches by filters.

In the example, all the branches starting with "fix" will be removed:

$ git branch -D $(git branch --list 'fix-*')

Delete all local branches not matching the provided name(s)

In this example, all the branches different from master, main or develop will be deleted:

$ git for-each-ref --format '%(refname:short)' refs/heads \
| grep -v "master\|main\|develop" \
| xargs git branch -D

Create an Oracle database Docker image

zankyr — Mon, 23 Aug 2021 19:54:30 +0000

In this article, I will show how to run Oracle Database Express Edition using Docker.

Requirements

git
Docker
Oracle binaries (optional)

Why a post dedicated to Oracle?

On DockerHub you can find images for most of the common databases such as PostgreSQL or MariaDB. But when it comes to Oracle, all the good things come to an end.

Due to (I think) copyright reasons, Oracle doesn't provide images that can be pulled and run on a Docker instance.

But strangly, they provided an alternative solution.

Running Oracle Database in Docker

Oracle made available a suite of Docker build scripts that help set up many of its product offerings, including Oracle Database. You can find these scripts in a GitHub repository.

We'll deploy the version 18.4.0-xe because it is the only version that doesn't requires pre-downloaded binaries. For any other version, you'll need to download the required binaries as described below.

Note: All the step marked as (Optional) can be skipped for the version 18.4.0-xe, but are required for any other version.

(Optional) Download Oracle binaries

Go to Oracle Download page. and download the db version you require, for example oracle-database-xe-18c-1.0-1.x86_64.rpm

Clone Oracle Github project



$ git clone https://github.com/oracle/docker-images.git

(Optional) Copy the database binaries into the project folder



$ cp /path/to/file/oracle-database-xe-18c-1.0-1.x86_64.rpm /path/to/project/docker-images/OracleDatabase/SingleInstance/dockerfiles/18.4.0

Execute the installer. For the options description, see the command helper



$ cd docker-images/OracleDatabase/SingleInstance/dockerfiles
$ ./buildContainerImage.sh -v 18.4.0 -x

WARNING: the script can take up to 30 minutes before finishing

Check the image

List the docker images:



$ docker images

and check that there's an image tagged as oracle/database 18.4.0-xe

Pay attention to the size of the image: sometimes the installation does not complete completely but the script ends without reporting any problems. The image should be approximately 5.89GB in size

Run the container



$ docker run --name oracle \
    -d \
    -p 51521:1521 \
    -p 55500:5500 \
    -e ORACLE_PWD=mysecurepassword \
    -e ORACLE_CHARACTERSET=AL32UTF8 \
    oracle/database:18.4.0-xe

Where

--name: specifies the container name
-d: launch the container in detached mode
-p 51521:1521 and -p 55500:5500 map a host to a container port.
-e ORACLE_PWD=mysecurepassword and -e ORACLE_CHARACTERSET=AL32UTF8 set the environment variables. Here, ORACLE_PWD sets the administrative password, and ORACLE_CHARACTERSET sets the database’s character set.

You can check the container status via the docker run command, looking the STATUS field:



$ d ps
CONTAINER ID   IMAGE                       COMMAND                  CREATED              STATUS                                 PORTS                                                                                      NAMES
f7776a6dd664   oracle/database:18.4.0-xe   "/bin/sh -c 'exec $O…"   About a minute ago   Up About a minute (health: starting)   0.0.0.0:51521->1521/tcp, :::51521->1521/tcp, 0.0.0.0:55500->5500/tcp, :::55500->5500/tcp   oracle

In the example, the container is still starting (health: starting). Once the container is started, the status will change in healty.
Another way to check the container status is looking the container logs:



$ docker logs oracle
## Omitted for brevity
*******************
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: 2540b6bf28f7/XEPDB1
     Multitenant container database: 2540b6bf28f7
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################

Since every time you launch the container the database instance needs to be installed, the container takes several minutes before it is ready.

Connecting to the database

You can connect the database using any client you want. In the example I've used dbeaver:

Alternatively, create a bash session within the container, using the OS user oracle:



$ docker exec -it --user=oracle oracle bash

Set up the required Linux environment variables for Oracle Database:



bash-4.2# . oraenv
ORACLE_SID = [XE] ? 
The Oracle base remains unchanged with value /opt/oracle

Then access SQL*Plus as you would on any Oracle Database system:



bash-4.2# sqlplus sys@XEPDB1 as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Aug 23 19:49:33 2021

Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter password: 

Connected to:

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Version 18.4.0.0.0

SQL>

Coming next

Currently the database is working, but running the container requires a lot of time. In next posts I'll show how to improve starting time using different methods.

Sources

https://github.com/oracle/docker-images
https://blogs.oracle.com/oraclemagazine/deliver-oracle-database-18c-express-edition-in-containers

Make NTFS writable again (on OSX)

zankyr — Fri, 02 Jul 2021 16:08:24 +0000

Long story short: NTFS is a proprietary filesystem, owned by Microsoft. And thanks to this, all the NTFS formatted hard drives are read-only on a OSX OS.

Following you can find instructions on how to make NTFS writable again, depending on your operating system.

Ventura (13.0.1)
Monterey (12.2.1)
Mojave (10.14.6)
Yosemite (10.10) and El Capitain (10.11)
Useful links
Thanks to

Ventura (13.0.1)

Good news everyone!
It is now possible to re-enable the NTFS writing.

No more talk (really, the Italian "bando alla ciance" is way better).

Step 0: Homebrew should be installed.

Step 1: Update Xcode via Terminal:

$ xcode-select --install

Step 2: Install osxfuse via Homebrew

$ brew install --cask osxfuse

Step 3: Install NTFS-3G from Homebrew

brew tap gromgit/homebrew-fuse
brew install ntfs-3g-mac

Step 4: Change the mount location for your drive

First list all the mounted drives:

diskutil list

Take note of the name of the drive you want to make readable. In our example we'll use disk2s2:

Unmount the drive:

sudo diskutil unmount /dev/disk2s2

Create a new volume directory:

sudo mkdir /Volumes/NTFSDrive

Mount your drive to new newly created folder:

sudo /usr/local/sbin/mount_ntfs /dev/disk2s2 /Volumes/NTFSDrive

Open the drive:

open /Volumes/NTFSDrive/

Monterey (12.2.1)

Due to several security changes introduced in the previous versions (Big Sur or maybe Catalina), the operations described in this post no longer work.
I'll update this section as soon as I'll discover a working workaround.

Mojave (10.14.6)

Step 0: Homebrew should be installed.

Step 1: Update Xcode via Terminal:

$ xcode-select --install

Step 2: Disable the System Integrity Protection (SIP).
Reboot your Mac, and when the boot screen appears (the one with the Apple logo), press CMD+R, and go into recovery mode.
Once here, open the terminal from the menu' bar and execute the following command.

$ csrutil disable

If the operation is successful, reboot the machine.

Step 3: Install osxfuse via Homebrew

$ brew install --cask osxfuse

Reboot.

Step 4: Install ntfs-3g
The original Homebrew formulae has been disabled since it was not open-source software (you can find the entire motivation in the links at the end of the page).

You can use a fork made by an user:

brew install darelover/ntfs-3g/ntfs-3g

Guess what? Reboot again.

Step 5: Mount point
First, backup the original mount file:

$ sudo mv /sbin/mount_ntfs /sbin/mount_ntfs.orig

Now, create the new mount file:

sudo ln -s /usr/local/sbin/mount_ntfs /sbin/mount_ntfs

Note: /usr/local/sbin/mount_ntfs should be a symbolic link to the folder created by ntfs-3g. Usually its path should be /usr/local/Cellar/ntfs-3g/<version_number>/sbin

Step 6: Check
Attach your hard drive. If you're lucky, everything should be working fine.

But you can notice that in the Finder the files are not visible, you can see only folders (via Terminal you should see the entire filesystem correctly).

If you are unlucky, follow this step.
Using the Terminal, go in the ntfs-3g folder, make a backup of the mount_ntfs file and create a new one:

$ cd /usr/local/Cellar/ntfs-3g/<version_number>/sbin
$ sudo mv mount_ntfs mount_ntfs.orig
$ sudo nano mount_ntfs

Copy the following script in the new file you've just created:

#!/bin/bash
VOLUME_NAME="${@:$#}"
VOLUME_NAME=${VOLUME_NAME#/Volumes/}
USER_ID=501
GROUP_ID=20
TIMEOUT=20
if [ `/usr/bin/stat -f "%u" /dev/console` -eq 0 ]; then
        USERNAME=`/usr/bin/defaults read /Library/Preferences/com.apple.loginwindow | /usr/bin/grep autoLoginUser | /usr/bin/awk '{ print $3 }' | /usr/bin/sed 's/;//'`
        if [ "$USERNAME" = "" ]; then
                until [ `stat -f "%u" /dev/console` -ne 0 ] || [ $TIMEOUT -eq 0 ]; do
                        sleep 1
                        let TIMEOUT--
                done
                if [ $TIMEOUT -ne 0 ]; then
                        USER_ID=`/usr/bin/stat -f "%u" /dev/console`
                        GROUP_ID=`/usr/bin/stat -f "%g" /dev/console`
                fi
        else
                USER_ID=`/usr/bin/id -u $USERNAME`
                GROUP_ID=`/usr/bin/id -g $USERNAME`
        fi
else
        USER_ID=`/usr/bin/stat -f "%u" /dev/console`
        GROUP_ID=`/usr/bin/stat -f "%g" /dev/console`
fi

/usr/local/opt/ntfs-3g/bin/ntfs-3g \
         -o volname="${VOLUME_NAME}" \
         -o local \
         -o negative_vncache \
         -o auto_xattr \
         -o auto_cache \
         -o noatime \
         -o windows_names \
         -o user_xattr \
         -o inherit \
         -o uid=$USER_ID \
         -o gid=$GROUP_ID \
         -o allow_other \
         "$@" &> /var/log/mount-ntfs-3g.log

exit $?;

Save the file, save the world.

Change the file's permissions:

$ sudo chmod 555 mount_ntfs

Remove and then reconnect your disk, et-voila'!.

Yosemite (10.10) and El Capitain (10.11)

Step 0 - ONLY FOR EL CAPITAIN: Disable the System Integrity Protection (SIP).

Reboot your Mac, and when the boot screen appears (the one with the Apple logo), press CMD+R, and go into recovery mode.
Once here, open the terminal from the menù bar and execute the following command.

$ csrutil disable

If the operation is successful, reboot the machine.

Step 1: Install osxfuse

Download osxfuse and install it. Flag all the provided options when requested.
Once the installation is finished, reboot the machine.

Step 2: Install ntfs-3g

Download and install ntfs-3g. Unfortunately this application is no longer maintained, but this version is still enough for our purposes.
When asked, check the option nocaching.

On El Capitain an error message could be displayed at the end of the installation process. Just ignore it.

Reboot the system.

Step 3: Download and install fuse-wait.

Step 4: Attach your hard drive and check that the disk is writable.

Step 5 - ONLY FOR EL CAPITAIN: Re-enable the SIP
Repeat the step 1, but now execute this command:

$ csrutil enable

If the operation is successful, reboot the machine.

Useful links

Homebrew: https://brew.sh/
ntfs-3g original formulae: https://formulae.brew.sh/formula/ntfs-3g#default
Why ntfs-3g formulae has been disabled: https://github.com/Homebrew/homebrew-core/pull/64491

Thanks to

https://wpbeaches.com/how-to-write-to-windows-ntfs-usb-disk-drives-on-macos-macos-mojave-and-sierra/

https://gist.github.com/takeit/9fa83840f3b2065e204dc9d52cef3693

https://github.com/darelover/homebrew-ntfs-3g

https://github.com/osxfuse/osxfuse/issues/574

http://www.macbreaker.com/2014/06/how-to-enable-writing-to-ntfs-hard.html

https://techsviewer.com/how-to-write-ntfs-drives-on-macos-ventura/