-
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.Servlets.What does URL encoding mean? How can it be implemented in Java?
🧠 What is URL Encoding? ✅ URL encoding is the process of translating special characters in a URL into a format that can be safely transmitted over the Internet. In URLs: Only letters, digits, and a few special characters (-, … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlets.What does URL encoding mean? How can it be implemented in Java?
Java.Servlet.Explain the SingleThreadModel interface.
🧠 What is SingleThreadModel? ✅ SingleThreadModel is an interface that was introduced in early Servlet API versions (Servlet 2.0) to guarantee that: Only one thread can execute the servlet’s service() method at a time per servlet instance. 🎯 How It … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Explain the SingleThreadModel interface.
Java.Servlet.Can PrintWriter and ServletOutputStream be used simultaneously in a servlet?
❌ No, you cannot use both PrintWriter and ServletOutputStream simultaneously in a servlet for the same response. It is forbidden by the Servlet specification.Mixing them causes IllegalStateException. 🧠 Why? The response can either be character-based (PrintWriter) or byte-based (ServletOutputStream). Not … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Can PrintWriter and ServletOutputStream be used simultaneously in a servlet?
Java.Servlet.What is the difference between PrintWriter and ServletOutputStream?
Both are used to send data from your servlet back to the client as part of the HTTP response. But they are a little different: Feature PrintWriter ServletOutputStream Data type Character stream (text data) Byte stream (binary data) Best for … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the difference between PrintWriter and ServletOutputStream?
Java.Servlet.What is the difference between GET and POST?
🧠 Main Differences Between GET and POST Feature GET POST Where data is sent In the URL as query string (?key=value) In the HTTP request body Visibility Data is visible in the URL Data is hidden (not shown in URL) … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What is the difference between GET and POST?
Java.Servlet.What are the methods for sending data from the client to the server?
🧠 How Can a Client Send Data to the Server? There are several ways a client (like a browser or app) can send data to a server: 🎯 1. Using HTTP GET Parameters Data is sent in the URL as … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What are the methods for sending data from the client to the server?
Java.Servlets.Which HTTP method is not immutable?
🧠 First: What is an immutable HTTP method? In HTTP, a method is considered immutable (or safe) if: It does NOT change anything on the server. It’s supposed to be read-only (just retrieves data). ✅ Examples of immutable (safe) methods: … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlets.Which HTTP method is not immutable?
Java.Servlet.Should I worry about multithreaded safety when working with servlets?
The short answer is:👉 Yes, you absolutely should worry about thread safety when working with servlets. Let’s break this down very clearly: 🧠 Why? In a servlet container (like Tomcat, Jetty, etc.),only one instance of your servlet class is created … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Should I worry about multithreaded safety when working with servlets?
Java.Servlet.What are the main methods in the HttpServlet class?
🧠 Main Methods in HttpServlet Here’s the main methods grouped by their purpose: Purpose Method Description Core dispatching service(HttpServletRequest req, HttpServletResponse resp) Dispatches the HTTP request to doGet(), doPost(), etc., based on HTTP method Handle GET request doGet(HttpServletRequest req, HttpServletResponse … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.What are the main methods in the HttpServlet class?
Java.Servlet.Why is the HttpServlet class declared as abstract?
✅ Because it is designed to be extended, not used directly. HttpServlet provides basic HTTP-specific functionality: It implements the service() method to automatically dispatch requests based on the HTTP method (GET, POST, PUT, DELETE, etc.). But it does not know … Continue reading
Posted in Без рубрики
Comments Off on Java.Servlet.Why is the HttpServlet class declared as abstract?