Sarajevo, Bosnia and Herzegovina

Category Archives: Web

Posts related to web design and programming web applications.

Quantum Key Distribution Network Simulator (web interface)

At the #ECOC2021 conference, we presented the web interface of the ETSI 014 #qkd network simulation module (#QKDNetSim). It is the initial version supporting the ESTI 014 standard. Subsequent versions will include routing, support for the ETSI 004 standard and additional functionalities.   Feel free to test it at www.open-qkd.eu .

Read more

Monitor live MySQL queries

Log to your mysql with mysql -u username -pPassword and execute: mysql> SHOW VARIABLES LIKE “general_log%”; +——————+—————————-+ | Variable_name | Value | +——————+—————————-+ | general_log | OFF | | general_log_file | /var/run/mysqld/mysqld.log | +——————+—————————-+ mysql> SET GLOBAL general_log = ‘ON’; Then in another terminal execute tail -f -n300 /var/run/mysqld/mysqld.log Then don’t forget to disable general_log […]

Categories: Web
Read more

Quick way to remove duplicates from MySQL database

DROP TABLE IF EXISTS tmp;create table tmp like mytable; ALTER TABLE tmp ADD UNIQUE INDEX(text1, text2, text3, text4, text5, text6); insert IGNORE into tmp select * from mytable; delete from mytable where id not in ( select id from tmp); DROP TABLE IF EXISTS tmp;

Read more