-
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.Serialization.What is “serialization”?
Serialization is the process of converting a Java object into a byte stream — so it can be: Saved to a file Sent over a network Stored in a database Transferred between JVMs Later, you can deserialize that byte stream … Continue reading
Posted in Без рубрики
Comments Off on Java.Serialization.What is “serialization”?
Java.Streams.Why do we need symbolic links ?
🧠 Why You Might Want a Symbolic Link 🔁 1. Reference a file from multiple places Let’s say you have: And you’re working in multiple projects that all need this config: Rather than copy config.json into each project (and update … Continue reading
Posted in Без рубрики
Comments Off on Java.Streams.Why do we need symbolic links ?
Java.Streams.What is a “symbolic link”?
A symbolic link is a special file that points to another file or directory. Think of it like a shortcut or alias. It doesn’t hold the actual data It just contains a reference (a path) to the real file or … Continue reading
Posted in Без рубрики
Comments Off on Java.Streams.What is a “symbolic link”?
Java.Streams.What is an “absolute path” and a “relative path”?
📘 What is a Path? A path is simply the location of a file or directory in the file system.
Posted in Без рубрики
Comments Off on Java.Streams.What is an “absolute path” and a “relative path”?
Java.Streams.Separators
Great one, Stanley! The path separator character in the file system depends on the operating system — and Java provides a portable way to handle this.
Posted in Без рубрики
Comments Off on Java.Streams.Separators
Java.Streams.Is it possible to redirect standard input/output streams?
Java allows you to redirect standard input, output, and error streams quite easily using the System class. It’s super useful for logging, testing, piping data between tools, and even simulating a console in GUI apps.
Posted in Без рубрики
Comments Off on Java.Streams.Is it possible to redirect standard input/output streams?
Java.Streams.Which classes support reading and writing streams in compressed format?
Great one, Stanley! 😎 In Java, working with compressed streams (like ZIP or GZIP) is well-supported — especially for reading/writing data on-the-fly in a compressed format. Here are the key classes you’ll want to know:
Posted in Без рубрики
Comments Off on Java.Streams.Which classes support reading and writing streams in compressed format?
Java.Streams.What file access modes does RandomAccessFile have?
📜 File Access Modes in RandomAccessFile 1. “r” — Read-only Read operations only. No writing allowed. File must exist, or you’ll get FileNotFoundException. 🔹 Use Case: Inspect a file without modifying it.
Posted in Без рубрики
Comments Off on Java.Streams.What file access modes does RandomAccessFile have?
Java.Streams.What do you know about RandomAccessFile?
📘 What is RandomAccessFile? It’s part of java.io. Supports both reading and writing. Allows you to move the file pointer to read/write anywhere (random access). Acts like a combination of DataInputStream + DataOutputStream + file pointer control.
Posted in Без рубрики
Comments Off on Java.Streams.What do you know about RandomAccessFile?
Java.Streams.How to select all elements of a certain directory by criterion (for example, with a certain extension)?
To select all files in a specific directory that match a certain criterion — like a file extension — you can use either: FileFilter or FilenameFilter (from java.io) Java 8 Stream API Java NIO DirectoryStream (from java.nio.file)
Posted in Без рубрики
Comments Off on Java.Streams.How to select all elements of a certain directory by criterion (for example, with a certain extension)?