oralce database flake

Oracle database on cloud

How to install SQL Developer in your nixos system

export NIXPKGS_ALLOW_UNFREE=1 
nix shell nixpkgs\#sqldeveloper --impure

This will throw the error

click on this previous button until match the version and download the

Pasted image 20241019131051.png

then added it the folder

nix-prefetch-url file:///home/vaisakh/Downloads/sqldeveloper-20.4.0.379.2205-no-jre.zip

Now download matching version of JDK - https://www.oracle.com/in/java/technologies/javase/javase8u211-later-archive-downloads.html
(google the correct file name, it can bring you to page you can download it from)

nix-prefetch-url file:///home/vaisakh/Downloads/jdk-8u381-linux-x64.tar.gz

download wallet with a password from Oracle Cloud DB website (video)
Open sqldeveloper
Click on green '+' button, on the popup, click on new database connect
give the name something like oracle cloud free tier db and
change connection from basic type to cloud wallet
then click on browse button
If everything went smoothly, "status: success" will appear at bottom
press save
press connect

Now you can run sql queries

xwayland {
  force_zero_scaling = true
}

Then set font size to 16

ref: https://www.thatjeffsmith.com/archive/2013/02/how-to-plug-vi-into-oracle-sql-developer/

❯ which vim 
/run/current-system/sw/bin/vim