Under the Hood: SQLite and JSONL Session Storage

Moment at 52:48 in Codex Essentials – AI Assisted Agentic Development Course by freeCodeCamp.org.

Codex Essentials – AI Assisted Agentic Development Course

Saved by Janno Nuyles.

Links to other pages

• Home
• 24
• Recent
• Vikis
• Creators
• Search

Discover other moments and creators

• Introduction
• Codex Essentials
• The AI Certifications Roadmap
• Study Recommendations & Passing Requirements
• Validity and Re-certification
• Accessing the Code Repository Codeex Fundamentals
• What is Codeex? Agentic Coding vs. Coding Harness
• Common Use Cases and Skills
• Understanding the Agentic Loop
• OpenAI GPT Model Families
• Deep Dive: Model Intelligence vs. Context Windows
• Installation Requirements (Node.js & WSL 2)
• Authentication: Subscription vs. API Keys
• Checking Login Status and Account Info
• Lab: Installing Codeex and "Hello World"
• Using API Keys for Production and Automation
• Setting Environment Variables for Keys
• Subscriptions vs. API Token Billing
• Managing the Context Window (400k Token Limits)
• Truncation and Hallucination Issues
• Commands: /clear and /compact
• Lab: Managing Context History
• Codeex Sessions, Threads, and Messages
• Session Commands: /new, /resume, /fork, and /rename
• Under the Hood: SQLite and JSONL Session Storage
• Tracking Usage with Custom Scripts
• Customizing the Status Line
• Project Guidance via agents.md
• Truncation Limits and Tracing
• Lab: Creating Project Guidelines
• Deep Dive: Plan Mode and Clarifying Questions
• Project Lab: Building a Wolfenstein 3D Clone
• Sandbox Security: Bubble Wrap and Seatbelt
• Approval Policies (Untrusted, Request, Never)
• OS-Specific Settings and Network Access
• Permission Overrides: Auto Mode vs. Full Access
• Creating and Troubleshooting Rules
• Global vs. Project Configuration (config.toml) API, SDKs, and Extensions
• Non-Interactive (Headless) Mode for CI/CD
• OpenAI Interaction Layers: REST API vs. SDKs
• Implementing the OpenAI Agents SDK
• Working with the Codeex SDK
• Using the Codeex Desktop Application
• Installing the VS Code Extension
• The Codeex App Server Protocol
• Automated Workflows with GitHub Actions
• Anatomy of Agent Skills
• Discovery, Activation, and Execution
• Skill Locations and Marketplace
• Lab: Image Generation Skills
• Project Lab: Building a Task Manager Skill
• Optimizing Cost with Model and Effort Selection
• Fast Mode for Inference
• Connecting MCP Tools (Roblox Example)
• Orchestrating Sub-Agents and Worker Teams

• Come on! Hit me! Conan O'Brien punched by Maria Menounos in the abs
• Anytime you say "algorithm" replace it with "audience"
• All Heartbeat features - No fluff
• Who did you fire? Senator drills Mark Zuckerberg, CEO of Facebook
• Heartbeat Payday #2 ❤️
• End of work from home #funny
• Egwene vs Ishamael - Wheel of Time
• Electric desk in action
• Graduation day
• Great Wall of China - Civ4
• Attack Death
• Almost monetized on YouTube
• 10-year anniversary of Freedom!
• Dragon flies in
• Elvis actor cast as Harkonnen Feyd-Rautha
• "Do you like to dance?" Aviendha asks
• All Heartbeat Photos features - No fluff
• And our son?
• The bureaucracy is expanding to meet the needs of the expanding bureaucracy
• See the color changes
• Drink a spicy margarita, make some bad decisions
• Dune: Part 2 - Riding the sandworm
• Use a lifeline - Call my parents
• Step outside the world's tallest building
• Everyone shooting at Wonder Woman
• Sexy squeeze through a narrow gap
• How do you make God laugh?
• "Fools!" said I "You do not know"