Ubuntu no Ethernet connection after suspend Controller I226-V
21 March 2025
Today, after whole night suspend of my PC at the moring i wake up it. And it occur that i have no ethernet connection. After
Category: Programming
Windows Use UTC Time
28 October 2024
ctrl+R -> RegEdit -> enter Registry: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation Key: RealTimeIsUniversal Type: DWORD (32-bit) Value. Value: 1 Then restart PC
Missing foreign keys finder
21 October 2023
Sometimes when you need to import big bunch of data you may need to consider setting a flag: SET session_replication_role = 'replica'; However, this import,
Postgre change ownership of whole database to the role/user (including tables, functions, and views)
24 June 2023
If you need to transfer ownership of whole database (in postgress) you need to alter all tables, sequnces, views, and materialized views separately. Below is
Rider support MAUI .NET
12 January 2023
If want to create .NET application with MAUI uusing Rider. you don’t need to install Visual Studio. All you need is run this commands dotnet
Check which process using socket
10 January 2023
If you want to check which porcess accessing to the some url/port Use this: netstat -a -n -o | findstr "8080" Replace 8080 with port
The automatic indexer for Postgres
8 January 2023
Using Ankane: Dexter you can find missing indexes in your database. You will need to install HypoPG – PostgreSQL extension for hypothetical indexes too. After
Usefull PostgreSQL commands
4 October 2022
Source : https://gist.github.com/rgreenjr/3637525 — show running queries (pre 9.2) SELECT procpid, age(clock_timestamp(), query_start), usename, current_query FROM pg_stat_activity WHERE current_query != '<IDLE>' AND current_query NOT ILIKE
Refresh AutoIncrement value in PostgreSQL
20 September 2022
Sometimes on import data to database, you have issue with not updated autoincement keys? Use this, to generate scripts for update all tables to their
Crop images by transparent
12 September 2022
I was looking for script which allows crop iamges by their transparency. Python comes with help. You only need to instal PIL librarry pip install