Luca Liu

Software

SQL Window Functions: A Quick Review With Examples | HackerNoon

Introduction Window functions are a powerful feature in SQL used to perform calculations across a set of rows related to the current row. Unlike aggregate functions, window functions do not group rows into a single output; they return a result for each row while maintaining the context of the dataset. In this article, we’ll explore some commonly used SQL window functions (ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD(), and LAG()) with examples. Sample Table: Sales Data We’ll

Read More »

Obsidian Guide: How to Create the Daily Note Every Day – Even If You Don’t Open It | HackerNoon

Problem The Daily Note plugin is a fundamental feature in Obsidian, essential for many users who track their daily tasks, thoughts, and progress. In the Daily Notes settings, there’s an option to Open daily note on startup, which ensures that a new daily note is created whenever you open Obsidian in the morning. However, there’s a catch: if you leave Obsidian open overnight and don’t close it, you’ll notice that when you open your computer

Read More »

How to read and write JSON files in Python | HackerNoon

Python provides built-in support for working with JSON files through the `json` module. We will discuss how to use Python to read, write, and manipulate JSON files. To read a JSON file in Python, you can follow these steps: Import the ` json` module and open a new file using Python’s `open()` function. To write data to aJSON file, use the ‘writer’ function to write the data to the file.

Read More »