Code, Query, Ship, and Learn | A Malaysian Data Engineer's Blog

Code, Query, Ship, and Learn

Sign in Subscribe

Latest — 05 Apr 2026

Getting Started with Oracle FreeSQL at FreeSQL.com

Overview Oracle FreeSQL at FreeSQL.com is a free, browser‑based environment for learning, practicing, and prototyping SQL and PL/SQL on a real Oracle Database instance without installing any software. It runs entirely in the browser, giving users an always‑free personal schema and a safe sandbox to write,

More issues

Cheapest legit 2 vCPU / 4 GB-class VPS

Here’s a ranked overview of the cheapest legit 2 vCPU / 4 GB-class VPS options that are practical from Malaysia, with the cheapest first and a focus on Malaysia/Singapore–friendly providers. TL;DR – cheapest picks * Cheapest overall (and low latency): Oracle Cloud Always Free – Ampere A1 (Singapore) – configure 2

Free Tiers for Popular LLM Providers (2026) and How to Get Them

Executive Summary This report compares the free tiers of several widely used large language model (LLM) and inference platforms as of early 2026 and provides step‑by‑step guidance on how to activate and use each one for development and experimentation. It focuses on Google AI Studio (Gemini API), OpenRouter,

AI Empowers Developers to Create Stunning Websites

1. AI-Powered Extensions in Visual Studio Code VS Code’s extensibility makes it a prime platform for AI-driven coding tools. Here are key extensions and workflows to enhance productivity: GitHub Copilot * What it does: This AI pair programmer, powered by OpenAI’s Codex, suggests code completions in real time. It

Running Kafka in a Docker Container for SQL SERVER source and sink

Running Kafka in a Docker Container Apache Kafka is a powerful distributed streaming platform widely used for building real-time data pipelines and event-driven applications. Running Kafka in a Docker container simplifies setup, ensures consistency across environments, and makes it easier to scale and manage. In this article, we'll

Scrapy python to scrap a website to a word document script example

import scrapy from scrapy.linkextractors import LinkExtractor from scrapy.spiders import CrawlSpider, Rule from bs4 import BeautifulSoup from docx import Document import logging from scrapy.spidermiddlewares.httperror import HttpError from twisted.internet.error import DNSLookupError, TCPTimedOutError from docx.shared import Pt, RGBColor from docx.enum.text import WD_PARAGRAPH_ALIGNMENT

Optimizing Performance: Understanding How SQL Server Uses Indexes Based on Row Count and Server Resources

Introduction: In the dynamic world of database management, the efficiency of SQL Server relies heavily on the judicious use of indexes. Indexing is a powerful mechanism that facilitates faster data retrieval by organizing and structuring the data in a way that accelerates query performance. However, the way SQL Server utilizes

Exploring the Hallucinations of Generative AI: Unveiling the Creative Frontier

Introduction Generative AI has rapidly advanced in recent years, pushing the boundaries of what machines can create. As these systems delve into the realm of creativity, a fascinating phenomenon has emerged – hallucinations of generative AI. These hallucinations are not in the traditional sense, as experienced by humans under the influence

Path of a beginner to Kafka on docker for windows from A-Z for SQL Server

Follow the learning process of a beginner from you tube. Install wsl2 in windows add feature and linux from app store https://www.youtube.com/watch?v=n-J9438Mv-s Install docker desktop https://www.youtube.com/watch?v=AgZwJnBe2OE Install terminal app from windows app store and linux integration in docker