-
MY PROJECTS
-
Recent Posts
- SQL.How can you compare two nullable values safely, and how does IS DISTINCT FROM differ from <>?
- SQL.How are NULL values ordered by ORDER BY, how do defaults differ between databases, and how can you control their placement?
- SQL.How does NULL propagate through arithmetic expressions, and how can COALESCE and NULLIF help handle missing values and division by zero?
- SQL.How does NULL affect join conditions, and why can filtering the right-hand table in WHERE remove unmatched rows from a LEFT JOIN?
- SQL.How do GROUP BY and DISTINCT treat NULL values, even though NULL = NULL evaluates to UNKNOWN?
- SQL.How do aggregate functions handle NULL, and what is the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column)?
- SQL.How does NULL affect IN and NOT IN, and why can NOT EXISTS be a safer choice when a subquery returns nullable values?
- SQL.How do WHERE, HAVING, and CHECK constraints treat conditions that evaluate to UNKNOWN?
- SQL.Why do column = NULL and column <> NULL not work as expected, and when should you use IS NULL and IS NOT NULL?
- SQL.What is SQL’s three-valued logic (TRUE, FALSE, UNKNOWN), and how do AND, OR, and NOT behave with UNKNOWN?
- ChromeDevTools.Watch all failed requests
- SQL.What are domain types (or constraints on data types), and how do they help enforce data correctness?
- SQL.How does SQL handle comparisons between different data types (for example, string vs number), and why is this dangerous?
- SQL.What is the difference between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ, and which one should be used for business events?
- SQL.How do numeric types like INTEGER, BIGINT, DECIMAL, and FLOAT differ in terms of precision and use cases?
- SQL.What problems can arise from implicit type casting in SQL, and how can it affect indexes?
- SQL.How does NULL differ from 0, an empty string, or FALSE in SQL?
- SQL.What is the difference between CHAR, VARCHAR, and TEXT, and when would you choose each?
- SQL.What is MVCC ?
- SQL.What is AutoVacuum Postgres ?
Categories
- Aptana
- Azure
- C#
- DataSnap
- DBExpress
- Delphi
- Delphi и сети
- Delphi. Язык программирования
- ExtJS
- FastReport
- FireDAC
- FireMonkey
- GIT
- ICS
- IDE
- IIS
- Indy
- InnoSetup
- javascript
- jQuery
- JSON
- LiveBindings
- MSHTML
- MySQL
- PHP
- REST
- Ribbons
- SMS
- SQL инструкции
- SVN
- TRichView
- UniGui
- WebBroker
- WinAPI
- Windows
- Алгоритмы
- Без рубрики
- Деревья
- Ищу ответ
- Компонентостроение
- Мои компоненты
- Начальный уровень
- Обработка исключений
- Парсинг
- Потоки(Threads)
- Регулярные выражения
- Тестирование приложений
Author Archives: Stanislav_Panteleev
Reading.CleanArchitecture.Components.Reusable.Cohesion.Decouple.Principles
The question is – how to create components ? There are 3 basic principles. Summary Table Principle Focus Key Question Addressed REP Reusability & Release Can this component be reused and released independently? CCP Cohesion Do classes that change together … Continue reading
Posted in Без рубрики
Comments Off on Reading.CleanArchitecture.Components.Reusable.Cohesion.Decouple.Principles
Reading.CleanArchitecture.SOLID
1. Single Responsibility Principle (SRP) Definition: A class should have only one reason to change. Meaning: Each class should only have one responsibility or functionality. This makes the system easier to maintain and understand. Example: Bad: A Report class that … Continue reading
Posted in Без рубрики
Comments Off on Reading.CleanArchitecture.SOLID
Algo.Java.DecreasingRemainder2
https://leetcode.com/problems/lemonade-change/description/
Posted in Без рубрики
Comments Off on Algo.Java.DecreasingRemainder2
Algo.Java.DecreasingRemainder
2224. Minimum Number of Operations to Convert Time
Posted in Без рубрики
Comments Off on Algo.Java.DecreasingRemainder
TechInterview.CQRS.EventSourcing. StabilityPatterns
Command Query Responsibility Segregation EventSourcing Eventual Consistency (if one database instance updated, other ones should too, there is a listener pattern under hood) Stability patterns circuit breaker Retry pattern Also there is stability based on pos metrics, like health for … Continue reading
Posted in Без рубрики
Comments Off on TechInterview.CQRS.EventSourcing. StabilityPatterns
TechInterview.DomainDrivenDesign.Tips
DDD is one o architect patterns Ubiquituis language Ubiquitous Language is a core concept in Domain-Driven Design (DDD) that emphasizes the creation of a common language between all stakeholders involved in a project, such as domain experts, developers, and end-users. BoundedContext … Continue reading
Posted in Без рубрики
Comments Off on TechInterview.DomainDrivenDesign.Tips
Reading.CleanArchitecture.DependencyInversion
The Dependency Inversion Principle (DIP) states that high level modules should not depend on low level modules; both should depend on abstractions. Abstractions should not depend on details. Details should depend upon abstractions. flow without dependency inversion, main call high level … Continue reading
Posted in Без рубрики
Comments Off on Reading.CleanArchitecture.DependencyInversion
Reading.CleanArchitecture.Thoughts
What does this history lesson on paradigms have to do with architecture?Everything. We use polymorphism as the mechanism to cross architecturalboundaries; we use functional programming to impose discipline on the location ofand access to data; and we use structured programming … Continue reading
Posted in Без рубрики
Comments Off on Reading.CleanArchitecture.Thoughts
Algo.Java.PascalTriangle.ExampleOfDynamicProgramming
example
Posted in Без рубрики
Comments Off on Algo.Java.PascalTriangle.ExampleOfDynamicProgramming