VSCode addon
https://marketplace.visualstudio.com/items?itemName=Oracle.sql-developer

code --install-extension Oracle.sql-developer

Get Oracle SQL Developer package
http://www.oracle.com/technology/software/products/sql/index.html
https://www.oracle.com/database/sqldeveloper/technologies/download/

accept the licence
login
download "Oracle SQL Developer for other platforms"

Install

# download sqldeveloper-*-no-jre.zip archive
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-22.2.1.234.1810-no-jre.zip
https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-23.1.0.097.1607-no-jre.zip

# OPTIONAL: archive previous version
sudo mv  /opt/sqldeveloper{,.$(date -I)}

# extract
sudo unzip -q ~/Downloads/sqldeveloper-*-no-jre.zip -d /opt/

Configure JDK home / version

# find latest configuration file
SQL_DEVELOPER_COFIG=$(find ~/.sqldeveloper/*/product.conf | sort -V | tail -1)
#sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/default-java/|g' ${SQL_DEVELOPER_COFIG}
sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/java-1.17.0-openjdk-amd64/|g' ${SQL_DEVELOPER_COFIG}

Create starter

# Create desktop starter
cat <

<strong>Reduced memory usage</strong>
<code>
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf

Connect to MySQL server
https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer

sudo dpkg -i mysql-connector-java_8.0.26-1ubuntu21.04_all.deb 
# "Tools > Preferences > Database > Third Party JDBC Driver"
/usr/share/java/mysql-connector-java-8.0.26.jar

# DEP:
https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.dropbox.sh]

# create delayed start
# run this as user
sed -i 's|dropbox start -i|/usr/sbin/dropbox_start_dely|g' ~/.config/autostart/dropbox.desktop

# run this as root
cat < /usr/sbin/dropbox_start_dely

#!/bin/sh
sleep 120
ionice -c 3 dropbox start -i
EOF

chmod a+x /usr/sbin/dropbox_start_dely

Create account and get free Dropbox account with extra 250mb space
https://www.dropbox.com/referrals/NTQxNzA2OTU5

Enable folder share
http://www.dropbox.com/enable_shmodel

Links
http://wiki.ubuntuusers.de/Dropbox
http://www.getdropbox.com/download?plat=lnx.x86
http://www.maximumpc.com/article/features/15_things_you_have_know_about_dropbox

Install
https://gitlab.winehq.org/wine/wine/-/wikis/Debian-Ubuntu

sudo mkdir -pm755 /etc/apt/keyrings
sudo wget -NP /etc/apt/sources.list.d/ https://dl.winehq.org/wine-builds/ubuntu/dists/plucky/winehq-plucky.sources
sudo dpkg --add-architecture i386
wget -O - https://dl.winehq.org/wine-builds/winehq.key | sudo gpg --dearmor -o /etc/apt/keyrings/winehq-archive.key -
sudo apt update
sudo apt install --install-recommends winehq-staging

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.wine.sh]

winetricks

sudo apt-get install -y winetricks
#sudo winetricks --self-update

# winetricks BASH completion
wget https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks.bash-completion -O- | sudo tee /etc/bash_completion.d/winetricks
source /etc/bash_completion.d/winetricks

Downgrade to Wine 1.2.x (64 bit)

sudo apt-get remove wine1.4
cd /tmp
wget http://ie.archive.ubuntu.com/ubuntu/pool/universe/w/wine1.2/wine1.2_1.2.3-0ubuntu1_amd64.deb
wget http://ie.archive.ubuntu.com/ubuntu/pool/universe/n/nss-mdns/lib32nss-mdns_0.10-3.1ubuntu1_amd64.deb
sudo dpkg -i wine1.2_1.2.3-0ubuntu1_amd64.deb lib32nss-mdns_0.10-3.1ubuntu1_amd64.deb
wine --version

OPTIONAL: fake ie6 installation

wget kegel.com/wine/winetricks -P /tmp; sh /tmp/winetricks fakeie6

Snap package
https://snapcraft.io/wine-platform-6-stable

Debug

wine --version

Compile wine (deprected)

Instlal snap package
https://snapcraft.io/netbeans

sudo snap install netbeans --classic

Install binary
https://netbeans.apache.org/front/main/download/
https://www.apache.org/dyn/closer.lua/netbeans/netbeans/27/netbeans-27-bin.zip?action=download
[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.netbeans.sh]

# configure jdk
# echo netbeans_default_options="netbeans_default_options="--jdkhome" | sudo tee -a /opt/netbeans/etc/netbeans.conf
# Cannot find java. Please use the --jdkhome switch

Add git repository
https://www.youtube.com/watch?v=mzzAUEFS4vs
https://netbeans.org/kb/docs/ide/github_nb_screencast.html

OPTIONAL: install MySQL driver

sudo apt-get install libmysql-java

DEP: fix ubuntu locale settings for german

sed -i 's|en_US.UTF-8|de_DE.UTF-8|g' /etc/scim/global

DEP: disable compiz effects (Visual Effects (System > Preferences > Appearance > Visual Effects => none)

metacity --replace &

Fix bold fonts under Linux

sudo apt-get remove -y fonts-unfonts-core

Ansible role

git clone https://github.com/panticz/ansible.git /tmp/ansible
cd /tmp/ansible/
export ANSIBLE_ROLES_PATH=$(pwd)/roles
ansible-playbook -K /dev/stdin <
https://github.com/panticz/ansible/tree/master/roles/netbeans

<strong>Links</strong>
http://www.techytalk.info/netbeans-cannot-find-java-please-use-jdkhome-switch/ - HowTo (re)configure JAVA JDK
http://wiki.netbeans.org/NBPackagingPlan

# install
apt-get install -y apcupsd

# configure
sed -i 's|UPSCABLE smart|UPSCABLE usb|g' /etc/apcupsd/apcupsd.conf
sed -i 's|UPSTYPE apcsmart|UPSTYPE usb|g' /etc/apcupsd/apcupsd.conf
sed -i 's|DEVICE /dev/ttyS0|DEVICE|g' /etc/apcupsd/apcupsd.conf
sed -i 's|ISCONFIGURED=no|ISCONFIGURED=yes|g' /etc/default/apcupsd

# start apcupsd demon
service apcupsd start

# get status
apcaccess

# get run test
apctest

# monitor
tail -f /var/log/apcupsd.events

# OPTIONAL: configure /etc/apcupsd/apccontrol

Links
http://www.apcupsd.com/manual/manual.html
http://www.linuxcertif.com/man/8/apcaccess/

echo 'APT::Cache-Limit "50331648";' >> /etc/apt/apt.conf

# add debian sid repository
cat < /etc/apt/sources.list.d/sid.list
deb http://ftp.de.debian.org/debian sid main
EOF
sudo apt-get update -qq

apt-get install -y --force-yes syslinux


rm /etc/apt/sources.list.d/sid.list
sudo apt-get update -qq

# on i386
wget http://ftp.de.debian.org/debian/pool/main/s/syslinux/syslinux-common_4.01+dfsg-1_all.deb -P /tmp

# on amd64
wget http://ftp.de.debian.org/debian/pool/main/s/syslinux/syslinux_3.86+dfsg-1_amd64.deb  -P /tmp

wget http://ftp.de.debian.org/debian/pool/main/s/syslinux/syslinux-common_4.01+dfsg-1_all.deb -P /tmp
dpkg -i /tmp/syslinux*.deb 

sudo install-mbr /dev/sdb


http://packages.debian.org/sid/i386/syslinux/download

mount /dev/sdb1 /mnt/
mkdir -p /mnt/boot/syslinux
syslinux -f -d /boot/syslinux /dev/sdb1
umount /mnt

Links
http://syslinux.zytor.com/wiki/index.php/SYSLINUX#Linux
http://packages.debian.org/sid/i386/syslinux/download