How dlt Loads Nested JSON into Tables in DuckDB
Learn how dlt normalizes nested JSON into parent and child tables in DuckDB using a simple students and courses example.
Deep Learning Nerds Academy
The ultimate Learning Platform for AI, Data Science, Data Analytics and Data Engineering.
Search posts, subjects and tutors
Popular subjects
What’s new?
Premium posts
Previous posts
Streamlit + DuckDB: Build Interactive Data Apps That Read and Write to a DuckDB Database
Build a simple Streamlit task tracker that reads from DuckDB, writes new rows, updates task status, and validates the result with SQL.
What Is AGENTS.md in Codex and Why Is It Needed?
Learn what AGENTS.md is in Codex, why project instructions matter, and how to use them to guide safer AI coding workflows.
When to Use replace, append, or merge in a dlt Pipeline
Learn when to use replace, append, or merge in a dlt pipeline with practical DuckDB examples and beginner-friendly explanations.
How to Build a RAG Chatbot with LangChain, Python, and FAISS
Build a beginner-friendly RAG chatbot with LangChain, Python, FAISS, and OpenAI by loading local text, creating embeddings, retrieving context, and answering questions from your own data.
How to Connect Codex App to Jira with MCP
Learn how to connect the Codex App to Jira with MCP using Atlassian's official Rovo MCP Server and the local mcp-remote proxy.
How to Add a Local Git Repository to the Codex App
Learn how to add a local Git repository to the Codex App, choose the right project folder, run your first task, and review changes safely.
