ctrl+R -> RegEdit -> enter Registry: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation Key: RealTimeIsUniversal Type: DWORD (32-bit) Value. Value: 1 Then restart PC
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,
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
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
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
Using Ankane: Dexter you can find missing indexes in your database. You will need to install HypoPG – PostgreSQL extension for hypothetical indexes too. After
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
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
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
If you were in trouble in access to WSL, firstly you need to setup WSL Linux firewall via UFW, or by default no firewall. Besides,
BARTULACODE 2024
