personal tech blog

Ahmed Morsi

654 posts 69 categories

Categories

Posts

Nuitka: The Professional Way To Compile Python May 3, 2025 Build Your OWN AI Agent That Can SEE And SPEAK With Ease Mar 24, 2025 uv: The Ultra-Fast Python Package Manager Mar 22, 2025 This one tool forever changed how I use Docker Mar 14, 2025 I replaced my entire tech stack with Postgres... Mar 14, 2025 My Business Card Runs Linux Nov 4, 2023 ZRAM - compressed block device in RAM Nov 1, 2023 UNBRICKING a RADXA ZERO with UART Oct 31, 2023 Make Algorithm much FASTER Oct 31, 2023 ChatGPT as Decompiler Oct 28, 2023 Decompiling ARM raw binary with Ghidra Oct 28, 2023 Ultra low latency Oct 28, 2023 Hacking Firmware Oct 27, 2023 Vacuum Robot Security Oct 21, 2023 PCB Motor Oct 19, 2023 Intro to Hardware Reversing: Finding a UART and getting a shell Oct 18, 2023 Thorium Fuel Cycle Oct 15, 2023 Yet Another Benchmark Script Oct 13, 2023 Analog computing Oct 13, 2023 why are switch statements so HECKIN fast? Oct 8, 2023 Watching Neural Networks Learn Sep 23, 2023 Neural Networks Explained from Scratch using Python Sep 19, 2023 Llama2.mojo : The Fastest Llama2 Inference ever on CPU Sep 15, 2023 The World's Best Open Source LLM Model Released Sep 10, 2023 Bun is disrupting JavaScript land Sep 10, 2023 Remove telegram groups Mar 8, 2023 Alternatives to C & C++ for Embedded Systems Mar 6, 2023 How to use VS Code from ANYWHERE Feb 27, 2023 Hands-on Hacking Kubernetes and Ways to Prevent It Feb 7, 2023 Stop Writing Dead Programs by Jack Rusher Feb 7, 2023 Experimenting with Buses and Three-State Logic Feb 6, 2023 Upgrade Your SSH Key to Ed25519 Feb 5, 2023 dwitter - 140 Characters of JavaScript Feb 1, 2023 Only 1% Need Microservices Jan 30, 2023 Mere Linux Jan 24, 2023 Run Linux or other Operating Systems in your browser Jan 24, 2023 Build a minimal Linux with only Busybox Jan 24, 2023 any.run - run malwares and virus in a sandbox Jan 19, 2023 BAREMETAL RUST Raspberry Pi - no operating system Jan 19, 2023 This Is How Rust Stops Memory Leaks Jan 19, 2023 Writing Code That Runs FAST on a GPU Jan 19, 2023 Rust's Journey to Async/Await Jan 17, 2023 Creating a Chat Server with async Rust and Tokio Jan 17, 2023 Rust at speed — building a fast concurrent database Jan 17, 2023 Linux Performance Observability Tools Jan 16, 2023 Writing a compiler with LLVM Jan 16, 2023 The Future of eBPF in Cloud Native Jan 11, 2023 Kubernetes kube-proxy Modes: iptables and ipvs, Deep Dive Jan 11, 2023 Cilium - eBPF - Liberating Kubernetes From Kube-proxy and Iptables Jan 9, 2023 pulumi - Universal Infrastructure as Code Jan 9, 2023 webinstall.dev the best installer for common apps for linux and windows Jan 7, 2023 Building a Web server in Bash Jan 7, 2023 Rust Before Main Jan 7, 2023 VSCode In The Cloud - Setup a Remote Dev Environment Jan 3, 2023 Build and Run Containers with Podman and Systemd Jan 3, 2023 On Javascript Performance - JustJs Jan 3, 2023 WPE WebKit: HTML5 User Interfaces for Embedded Devices Jan 1, 2023 Demystifying Python’s Internals Dec 26, 2022 How we are making Python 3.11 faster Dec 26, 2022 Hello eBPF! Goodbye Sidecars? Dec 26, 2022 Coding Complex App Logic, Visually Dec 26, 2022 How to clean node_modules Nov 20, 2022 An AST Operating JavaScript Nov 3, 2022 Codebase Tour Of An Advanced React / Next.js Project Oct 30, 2022 CSS Frameworks Oct 24, 2022 Svelte.js vs Malina.js Oct 14, 2022 Exploring Stackblitz's WebContainer Oct 13, 2022 How does CodeSandbox work? Oct 13, 2022 Mantine UI Oct 12, 2022 Airbnb’s Trip to Linaria Oct 12, 2022 WebAssembly and Containers Oct 11, 2022 Step CI - API Testing and Monitoring made simple Oct 10, 2022 Neon - Electrify your Node with the power of Rust! Oct 10, 2022 Edge Tech Stack for 2025 Oct 10, 2022 Use Zero API In SvelteKit Oct 10, 2022 Building vite-plugin-svelte-inspector Oct 8, 2022 UnoCSS - An all-in-one atomic CSS engine! Oct 7, 2022 Why I Switched From NPM/Yarn to PNPM Oct 2, 2022 NextJS to Astro Oct 1, 2022 A closer look at SurrealDB Sep 22, 2022 Call Postgres functions from JavaScript with RPC Sep 17, 2022 Using PostgreSQL functions to call an API Sep 15, 2022 Count Millions of Rows Fast with Materialized Views Sep 15, 2022 GraphQL APIs for Postgres with pg_graphql Sep 14, 2022 SvelteKit and Supabase Tutorial with Authentication Sep 11, 2022 Implement Authorization using Row Level Security with Supabase Sep 11, 2022 pg_graphql: A GraphQL extension for PostgreSQL Sep 11, 2022 Supabase React Tutorial Sep 10, 2022 Exa A modern replacement for ls. Sep 6, 2022 Working with GraphiQL 2 Sep 6, 2022 Figma Design to Live Website with Locofy.ai Sep 3, 2022 Hasura Authorization Sep 1, 2022 MDX Editor Aug 3, 2022 Data & Business Intelligence terms every analyst should know May 13, 2022

Showing 94 of 654 posts

Count Millions of Rows Fast with Materialized Views

September 15, 2022

web developmentsoftware engineeringsoftware architecturedatabasevideospostgres

Written by

Ahmed Morsi

Software engineer and tech geek. I write about Linux, DevOps, web development, and whatever shiny tool caught my attention this week.

GitHub LinkedIn CodePen Email