kad1r

select * from pg_indexes where tablename='your_table_name';

select tc.table_schema, tc.constraint_name, tc.table_name, kcu.column_name,ccu.table_schema as foreign_table_schema,ccu.table_name as foreign_table_name,ccu.column_name as foreign_column_name
from information_schema.table_constraints as tc
join information_schema.key_column_usage as kcu on tc.constraint_name = kcu.constraint_name and tc.table_schema = kcu.table_schema
join information_schema.constraint_column_usage as ccu on ccu.constraint_name = tc.constraint_name
where tc.constraint_type = 'foreign key' and tc.table_schema='your_db_schema' and tc.table_name='your_table_name';

kad1r

Stash

git stash
git stash save "your_stash_name"
git stash list
// Remove nth stash
git stash pop stash@{n}
// Apply nth stash
git stash apply stash@{n}
// If stash apply give an error like error: unknown switch `e' then use with quote

kad1r

AWS Configure

Open powershell and type aws configure

aws configure
enter access key
enter secret key
enter region
enter output format

kad1r

https://dev.to/pr0pm/run-postgresql-pgadmin-in-pods-using-podman-386o

podman pod create --name postgres_pgadmin -p 9876:80
podman run --pod=postgres_pgadmin -e '[email protected]' -e 'PGADMIN_DEFAULT_PASSWORD=yourpasswrod' --name pgadmin -d dpage/pgadmin4
podman run --pod=postgres_pgadmin -e POSTGRES_PASSWORD=password -e POSTGRES_USER=user --name db -d postgres
podman pod stats postgres_pgadmin
** 0.0.0.0:9876 or 127.0.0.1:9876 copy/paste this to your browser to configure pgadmin

podman pod pause postgres_pgadmin

kad1r

ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);

kad1r

root = true

# C# files
[*.cs]

#### Core EditorConfig Options ####

# Indentation and spacing
indent_size = 4
indent_style = space

kad1r

Here is the original link

Go to ~\AppData\Local\Docker\wsl\data and check the file size of ext4.vhdx. Right click the file and select "Copy as path". Apply these commands on cmd.

wsl --shutdown
diskpart

New cmd will open and

kad1r

See also:

• Free backend hosting
• https://free-for.dev/#/?id=dbaas

Service	Type	Storage	Limitations
Amazon DynamoDB	⚠️ Proprietary NoSQL	25 GB	⚠️ Payment method required
Amazon RDS	⚠️ Proprietary RDBMS		⚠️ Only free for 1 year
Azure SQL Database	MS SQL Server		⚠️ Only free for 1 year
👉 Clever Cloud	PostgreSQL, MySQL, MongoDB, Redis	256 MB (PostgreSQL)	Max 5 connections (PostgreSQL)

kad1r

Coding Standards

• C# Coding Standards
• Another C# Coding Standards
• DotNet Coding Standards
• Dotnet NopCommerce Coding Standards
• Wordpress Coding Standards
• Drupal Coding Standards
• Gnu Coding Standards
• Symfony Coding Standards

kad1r

npm outdated
npm update --save