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
Software Developer, Programming, Web resources and entertaiment. Desarrollo de software, programación, recursos web y entretenimiento.
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
References:
[1] https://pendrivelinux.com/vga-boot-modes-to-set-screen-resolution/
$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
/usr/lib/jvm/java-8-openjdk-amd64/bin/java -jar ./facturadorApp-2.1.jar server prod.yaml
References:
[1] Make temp certificate for test https://llama.pe/facturador-sunat-see-sfs-certificado-digital
Winamp skins for Linux
https://lunduke.substack.com/p/miss-winamp-try-audacious-the-winamp
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
pgadmin4 Online
[1] https://www.pgadmin.org/download/pgadmin-4-python
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:
https://gcore.com/learning/how-to-install-pgadmin4-on-ubuntu/
Database 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
Merge Video and Audio
ffmpeg -i video.mp4 -i audio.mp3 -c:v copy -c:a aac output.mp4
select name->'es_PE',* from product_template where name->>'es_PE' like '%MEGACI%' References: [1] https:/...