Blog Posts | asprogramuoju

Latest

IT Vocabulary

2024-02-03

0 41

Course

IT

Define not used DB indexes in PostgreSQL

2024-02-03

0 46

Mano blog

How to know which DB indexes are not used? For PostgreSQL is simple, use the following query to find not used indexes. After analyze don't forget to remove those indexes. SELECT pg_size_pretty(pg_rela...

db postgresql

Reasons why you may choose to split your environment

2024-02-03

0 49

Mano blog

First, ask for yourself a questions: In multi-user environment, how exactly would you manage concurrent users? Will they take turns? Will they use terminal to log in? One client could potentially brin...

architecture infrastructure

CTE block will make your code clear and readable

2024-02-01

0 35

Mano blog

If you want to make your SQL readable and solve many performance questions first of all create CTE blocks. This simple and understandable solution solve for you many problems. But for better performan...

SQL db mysql oracle postgresql

Data modeling rules

2024-02-01

0 38

Mano blog

Objects (main part): All public relations, schemas, i.e. PostgreSQL has public schema and a postgres user, also public rights must be deleted. All xxx_log tables have to be put to "log" schema. All ad...

db postgresql

Apie Skyrelį

Tai kas naudinga ir aktualu.

Esu IT sferos specialistas, verslo sistemų kūrėjas, programuotojas (JAVA, PHP, Object Pascal ir kt.), duomenų bazių žinovas (PostgreSQL, Sybase, DB2 ir kt.), mokytojas bei mentorius, IT dizaineris.

Archyvai

Žymos

architecture db infrastructure IT mysql oracle postgresql SQL