PostgreSQL json fields

select name->'es_PE',* from product_template where name->>'es_PE' like '%MEGACI%'

 

References:

[1] https://popsql.com/learn-sql/postgresql/how-to-query-a-json-column-in-postgresql

Ubuntu VGA Resolutions

 

References:

[1] https://pendrivelinux.com/vga-boot-modes-to-set-screen-resolution/

 

Ubuntu add user easily

 

 

$sudo adduser pharmaquipa

$sudo usermod -aG sudo pharmaquipa #add to sudo group

References

[1] https://www.digitalocean.com/community/tutorials/how-to-create-a-new-sudo-enabled-user-on-ubuntu

[2] https://phoenixnap.com/kb/how-to-create-sudo-user-on-ubuntu

Facturador Sunat SFS (Linux)

 

 

/usr/lib/jvm/java-8-openjdk-amd64/bin/java -jar ./facturadorApp-2.1.jar server prod.yaml

References:

[1] SFS(Sistema Facturador SUNAT) https://orientacion.sunat.gob.pe/6790-07-descarga-del-facturador

[2] Make temp certificate for test https://llama.pe/facturador-sunat-see-sfs-certificado-digital
 

Audacious Skins

 Winamp skins for Linux

https://lunduke.substack.com/p/miss-winamp-try-audacious-the-winamp

Notes run odoo 16 venv

Using previous virtual environment (~python 3.10)

pip install --upgrade pip
 

pip install lxml==5.1.0

pip3 install Werkzeug==2.0.2

pip install pyOpenSSL

pip3 install docutils
 

pip3 install num2words
 

 Trying on python3.8 by empy virtual environment

python3.8 -m pip install virtualenv

python3.8 -m virtualenv test  

source test/bin/activate     
 

sudo apt install python3.8-dev 

 

pip install -r requirements.txt
 

python3 odoo-bin --http-port=1616 -d enter02

 

Update pgadmin

pgadmin4 on web by python

$sudo mkdir /var/lib/pgadmin
$sudo mkdir /var/log/pgadmin
$sudo chown $USER /var/lib/pgadmin
$sudo chown $USER /var/log/pgadmin
$python3 -m venv pgadmin4
$source pgadmin4/bin/activate
(pgadmin4) $ pip install pgadmin4
(pgadmin4) $ pgadmin4

Change port, by default is 5050 but if you want to change(on the venv):

$PGADMIN_INT_PORT=6060 pgadmin4/bin/pgadmin4
 

Change the credentials(on the venv):

$pgadmin4/bin/pgadmin4-cli add-user email@gmail.com password


 

Remove credentials:

$ls /var/lib/pgadmin/storage
 

Enable remote access to pgadmin4

$vi pgadmin4/lib/python3.10/site-packages/pgadmin4/config.py
 

[1] https://www.digitalocean.com/community/tutorials/how-to-install-configure-pgadmin4-server-mode

 

References:

[1] https://www.pgadmin.org/download/pgadmin-4-python

[2] https://gcore.com/learning/how-to-install-pgadmin4-on-ubuntu/

AI Dog identifiers

 Online

[1] https://www.nyckel.com/pretrained-classifiers/dog-breed-identifier/

PostgreSQL command tools

 

Database size

select pg_size_pretty( pg_database_size('dbname') );


Tables order by size

select
  table_name,
  pg_size_pretty(pg_total_relation_size(quote_ident(table_name))),
  pg_total_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 3 desc;

References:

https://stackoverflow.com/questions/21738408/postgresql-list-and-order-tables-by-size

 

Video edition issues

 Merge Video and Audio

ffmpeg -i video.mp4 -i audio.mp3 -c:v copy -c:a aac output.mp4

Android by VMWare on Linux

VMWare paremeters

• bios.forceSetupOnce = "TRUE"
  
• bios.bootDelay = "xxxx"

Resources

[1] Android images http://www.osboxes.org/android-x86/

References
[1] https://kb.vmware.com/s/article/1004129
[2] http://siliseed.com/2013/08/instalar-android-en-una-maquina-virtual-windows.html
[3] https://android.stackexchange.com/questions/141700/how-to-fix-android-x86-install-on-vmware
[4] https://android.stackexchange.com/questions/144535/android-x86-marshmallow-not-booting-on-virtualbox-and-vmware-workstation