-
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
Java.Collections.WeakHashMap uses WeakReferences. Why not create a SoftHashMap on SoftReferences?
✅ Difference Between WeakReference and SoftReference Feature WeakReference SoftReference GC behavior Collected as soon as no strong refs Collected only when memory is low Lifespan Short Longer (survives longer in memory) Use case Automatic cleanup Memory-sensitive cache So in theory: … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.WeakHashMap uses WeakReferences. Why not create a SoftHashMap on SoftReferences?
Java.Collections.Strong references, weak, soft, phantom
This is one of the most fundamental and fascinating topics in Java memory management. Let’s go through all 4 types of references in Java, how the Garbage Collector (GC) treats them, and when you’d use each one.
Posted in Без рубрики
Comments Off on Java.Collections.Strong references, weak, soft, phantom
Java.Collections.What is weak reference ?
In Java, a weak reference is a type of reference that does not prevent an object from being garbage collected. ✅ In plain terms: If an object is only weakly referenced (i.e., no strong references point to it), then the … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.What is weak reference ?
Java.Collections.What is the difference between HashMap and WeakHashMap? What is WeakHashMap used for?
Let’s talk about HashMap vs WeakHashMap, and why the second one is super useful in certain cases. 🔍 Main Difference Feature HashMap WeakHashMap Key reference type Strong references Weak references Garbage collection Keys are never GC’d if referenced Keys can … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.What is the difference between HashMap and WeakHashMap? What is WeakHashMap used for?
Java.Collections.What is the difference between HashMap and IdentityHashMap? What is IdentityHashMap used for?
Let’s get into the difference between HashMap and IdentityHashMap, and when to use this strange beast of a map. 🎯 TL;DR: ✅ HashMap compares keys using .equals()✅ IdentityHashMap compares keys using == (object reference equality) That’s the core difference — … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.What is the difference between HashMap and IdentityHashMap? What is IdentityHashMap used for?
Java.Collections.Why do we need HashMap if we have Hashtable?
🧓 First, a bit of history Hashtable is part of the original Java 1.0. HashMap was introduced in Java 1.2 as part of the new Collections Framework.
Posted in Без рубрики
Comments Off on Java.Collections.Why do we need HashMap if we have Hashtable?
Java.Collections.Stack is considered “obsolete”. What is recommended to replace it? Why?
in modern Java, the Stack class is generally considered obsolete or legacy. Let’s break it down 👇 🛑 Why Stack is considered obsolete 😬 Problems: It extends Vector, which is: A synchronized, thread-safe collection — unnecessary overhead for most use … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.Stack is considered “obsolete”. What is recommended to replace it? Why?
Java.Collections.What can PriorityQueue do?
The PriorityQueue in Java is a powerful tool for managing elements based on priority rather than insertion order — super useful in many real-world scenarios like scheduling, simulations, and pathfinding algorithms (like Dijkstra!).
Posted in Без рубрики
Comments Off on Java.Collections.What can PriorityQueue do?
Java.Collections.How to iterate through LinkedList elements in reverse order without using slow get(index)?
🔄 Reversely iterating over a LinkedList without using get(index) is a smart move — because get(i) on a LinkedList is O(n), and doing it in a loop would give you O(n²) total time 😱. ✅ Best way: Use DescendingIterator LinkedList … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.How to iterate through LinkedList elements in reverse order without using slow get(index)?
Java.Collections.Is LinkedList singly linked, doubly linked, or quadruple linked?
✅ Java’s LinkedList is Doubly Linked Each node in Java’s LinkedList contains: A reference to the next node A reference to the previous node A value So it’s a classic doubly linked list.
Posted in Без рубрики
Comments Off on Java.Collections.Is LinkedList singly linked, doubly linked, or quadruple linked?