Sql

Published on
September 2, 2025
Lag Function: Access data in a previous row in the same result set without having to join the table to itself.
databases window-functions sql postgres
How to use the SQL LAG window function to compare current and previous row values, with practical query and table output.
Published on
August 10, 2025
How Do I Clone a Remote PostgreSQL Database to Another Remote Database?
postgres sql databases devops cloud question guide
Step-by-step guide to cloning tables or data from one remote PostgreSQL database to another using pg_dump and psql.
Published on
August 9, 2025
How Do I Dump and Restore a Remote PostgreSQL Database to a Local Database?
postgres sql databases devops cloud question guide
Step-by-step guide to dumping a remote PostgreSQL database or schema and restoring it to a local database using pg_dump and pg_restore.
Published on
June 12, 2020
Project: Royal Stock Exchange(RSE) - How to Scale Our System to Millions? - Part 4
project sql redis elasticsearch
10,000 ft overview on how we plan to scale to our first 1,000,000 concurrent users
Published on
June 11, 2020
Project: Royal Stock Exchange(RSE) - First "Demo-able" Work - Part 3
project flutter .NET sql
Basic functionality of a stock exchange including Carousel Ticker, Line & Candlestick Charts, Portfolio page/screen & more.
Published on
June 1, 2020
Project: Royal Stock Exchange(RSE) - Seeding Stock Market data in SQL - Part 2
project sql sql-server
Seeding database records for our clients, understanding our records data types, and validating/designing relationships between resources.
Published on
May 20, 2020
Project: Royal Stock Exchange(RSE). Building a Full Stack Stock Exchange - Part 1
project flutter .NET sql entity-framework
Build a stock exchange with .NET, Entity Framework, Flutter, Azure & more. Write backend code in C# & frontend using Flutter
Published on
July 22, 2015
Mastering PostgreSQL: Beyond Basic SQL
databases sql postgresql
Learn how PostgreSQL extends standard SQL with advanced features, reliability, and open-source flexibility. This guide covers practical commands, differences from generic SQL, and tips for effective database work.