wynalazkowo - eksperymenty małe i duże

Year 2020 – summary

Year 2020 – summary

This year was very bad for me. Lots of fear, uncertainty, overhours, rush. From the work perspective: participtaing in two dead-ends project rare oportunity of work with so called professionals from international companies (many of them with more than 10 years of IT experience):

SmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant

SmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant

After installation of HomeAssistant on RaspberryPI Zero using this tutorial: https://www.home-assistant.io/hassio/installation using Virtual appliance, I have installed following Addons: „SSH&Terminal” „Samba share” Afterwards I needed to create my own Addon as it was shown in this Addon for MariaDB: https://github.com/home-assistant/hassio-addons/tree/master/mariadb Following this tutorial : https://developers.home-assistant.io/docs/add-ons/tutorial/ I have created my own Addon for ActianZen. The clueWięcej oSmartHome – how to add ActianZenDB as Addon and your main database in HomeAssistant[…]

Pi hole – blokowanie reklam w Twoim domu.

Pi hole – blokowanie reklam w Twoim domu.

A to kolejny wpis mojego męża: Zacznijmy od tego – czym jest pi hole? Pi hole to prywatny DNS z opcją filtrowania adresów kojarzonych z reklamami. Po co to komu w czasach AdBlocka? Otóż adblock nie jest niestety doskonały – po pierwsze jest wykrywany przez różne strony, które potem serwują nam żebrozasłonę z tekstem “przecieżWięcej oPi hole – blokowanie reklam w Twoim domu.[…]

Omnitracker -extraction of attachments

Omnitracker -extraction of attachments

Here is magic query to extract all attachments from Omnitracker and their physical storage. select request, ‚path_to_your_attachments\’+substring(filename_on_disk,1,2)+’\’+ substring(filename_on_disk,3,2)+’\’+ substring(filename_on_disk,5,2)+’\’+filename_on_disk+’.’+ substring(orig_name,len(orig_name)-2,3) as fileOnDisk, orig_name from ( SELECT [id], CONVERT(varchar(MAX),CONVERT(VARBINARY(8),id),2) as filename_on_disk ,[request] ,[orig_name] FROM [Attachment] where request in (617674,760232,…))a requests_id can be retrieved from this query: select request from UserFields1 where f19_titel=”your title of Incident/RFC/Problem”

RaspberryPI – project for „Baltic Robo Battles” – impressions after the contest

RaspberryPI – project for „Baltic Robo Battles” – impressions after the contest

This contest took part almost one month ago so it is the highest time to write down my impressions. This time it was online event. We watched all of the streamings on Friday, Saturday and Sunday, starting from 25th of September. We watched set of very interesting presentations from SKALP society and very amusing andWięcej oRaspberryPI – project for „Baltic Robo Battles” – impressions after the contest[…]