Wednesday, October 30, 2024

Facturador Sunat SEE SFS (Linux)

 

 

/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
 

Friday, October 25, 2024

Audacious Skins

 Winamp skins for Linux

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

Tuesday, October 22, 2024

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 Online

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

 

 References:

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

Friday, September 20, 2024

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

 


Thursday, September 19, 2024

Video edition issues

 Merge Video and Audio

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

Friday, August 16, 2024

Sunarp consulta partida

 

Obtener numero de partida

https://www.sunarp.gob.pe/bus-personas-juridicas.asp


Consulta partida

https://conoce-aqui.sunarp.gob.pe/conoce-aqui/inicio

Inspect/canvas/copy/Image DATA-URL (to get the page image)

PostgreSQL json fields

select name->'es_PE',* from product_template where name->>'es_PE' like '%MEGACI%'   References: [1] https:/...