Browsing Tag
database
180 posts
Mastering Postgres Window Functions for Data Analysis in Supabase
Postgres window functions are a powerful SQL feature that lets you perform calculations across rows related to the…
Deploying Vanity URLs for Oracle APEX on OCI
How to deploy an Oracle APEX instance publicly through a custom URL domain using Oracle Cloud (OCI) load…
Bat-KV: Lightweight Key-Value Store for Windows Batch
Bat-KV: An Ultra-Lightweight Database for Windows Batch (.bat) Windows batch scripting is notoriously tricky, especially when it comes…
Beyond Functional: Writing Professional and Performant SQL Queries
Structured Query Language (SQL) is one of the most widely used languages for interacting with databases, yet even…
# Vector Digitizing vs. Raster Graphics: Why Quality Matters in Embroidery
What Are Raster Graphics? Raster graphics are images made up of tiny squares called pixels. Each pixel carries…
Mobile development best practices
Introduction Today, mobile applications are at the forefront of user engagement, brand presence, and business growth. With the…
🛠️ Was tired of duct-taping APIs and breaking ETL pipelines… RavenDB just dropped an AI Agent Creator inside the database. Finally feels like AI that won’t collapse on me.
RavenDB Launches the First Database-Native AI Agent Creator: The Missing Piece for Secure, Integrated AI Om Shree ・…
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle When working with Oracle databases, developers and DBAs often…
A Guide to Database Normalization & Denormalization (With Visual Examples and Practical Use Cases)
Table of Contents Introduction to Normalization First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF)…
How to Design a PostgreSQL Schema Visually (Step-by-Step)
1. What is a Schema? In PostgreSQL, a schema is just a folder inside your database where you…
