Andrei Pechkurov’s Post

One more optimization for #QuestDB. varchar will soon replace STRING, making this a lot more storage efficient. This is the remaining step before adding #Arrow ADBC! #database #apachearrow #utf8 #varchar

Prioritizing readability, search-ability and feasibility of bulk-changes of a SQL pipeline code base is more important than just f-stringing/templating it to make it look pretty. Just a thought, what is your take on this? #dataengineering

Note to self re: hard-coded values in SQL scripts  **Maintainability**: Hard-coded values make scripts difficult to update and maintain. Having to change a value in multiple places increases the risk of errors. 🛠 **Reusability**: Scripts with hard-coded values are often single-use or can seem so to someone unfamiliar with them. Parameterized scripts can be reused across different projects and contexts, saving time and effort. ♻ **Clarity**: Code is easier to understand when it's free of hard-coded values. It’s clear what can be modified, making collaboration and debugging smoother. 🔍 #SQL #BestPractices

How avoid Divide by Zero error ? SELECT 1 / 0  SELECT 1 / NULLIF(0, 0) By using NULLIFF function we can avoid Divide by Zero error . This query replaces the denominator value with NULL whenever it’s zero, preventing the division by zero error. Explanation: To handle division by zero, we utilize the NULLIF() function. This function replaces the second argument with NULL if the first argument is equal to it. In our case, we replace the denominator with NULL if it is zero before performing the division operation. This prevents the division by zero error. #sql #sqldeveloper #sqldba

Also sql has become simpler (wayyyyy simpler) in Observable Framework, thanks to DuckDB. Here's a live example. Copy. Paste. Done. ```sql SELECT * FROM read_csv_auto('(csv url)'); ``` 🦆🦆🦆🦆🦆🦆

Day14 ||1934. Confirmation Rate 50 Days, 50 LeetCode SQL Problems Challenge #lSQLChallenges #SQLPractice #DataQueries #DatabaseSkills #SQLProblems #QueryMaster #LearnSQL #SQLQueryChallenges #SQLCoding #DatabaseChallenge #Day14

#100DaysOfCode Day 23 - Result: Focusing on testing/debugging the "Create" action a user can execute from the web-based interface, I have managed to fix a number of previously undetected issues with SQL syntax in server-generated queries. As of now a user is able to create new records which are then accessible within the database table named "Record".

#Day2 ✨of the #50day SQL Challenge on LeetCode ... 🚀 Find the names of the customer that are not referred by the customer with id= 2 Explanation: WHERE referee_id IS NULL: This condition selects customers who are not referred by anyone. OR referee_id != 2: This condition selects customers who are referred by someone other than the customer with id = 2. #SQLChallenge #SQL #50DayChallenge #LeetCode #CodingChallenge #ContinuousLearning

Write a #SQL code to print first 50 odd number and then first 50 even number. or I can put up a question on the #generate_series() function. When you have to generate a series of numbers without using any table then choose the generate_series() SQL function. SELECT (2*value-1) as odd_number FROM GENERATE_SERIES(1,50) generate_series syntax: GENERATE_SERIES(start_value, end_value, step_increment); #tsql #dataanalytics #advancesql #datahandling #testing #qualityengineering #learningandgrowing

🔥𝐄𝐅'𝐬 𝐪𝐮𝐞𝐫𝐲 𝐭𝐚𝐠𝐬 𝐟𝐞𝐚𝐭𝐮𝐫𝐞. ⚡ One problem with command execution logging is that it's sometimes difficult to correlate 𝐒𝐐𝐋 𝐪𝐮𝐞𝐫𝐢𝐞𝐬 𝐚𝐧𝐝 𝐋𝐈𝐍𝐐 𝐪𝐮𝐞𝐫𝐢𝐞𝐬: the SQL commands executed by EF can look very different from the 𝐋𝐈𝐍𝐐 𝐪𝐮𝐞𝐫𝐢𝐞𝐬 from which they were generated. To help with this difficulty, you may want to use 𝐄𝐅'𝐬 𝐪𝐮𝐞𝐫𝐲 𝐭𝐚𝐠𝐬 𝐟𝐞𝐚𝐭𝐮𝐫𝐞, which allows you to inject a small, identifying comment into the 𝐒𝐐𝐋 𝐪𝐮𝐞𝐫𝐲 #ef #sql #tag