🔥 Daily Digest: Apple’s AI Struggles with Code: Discover How to Leverage AI and Node.js for Your Projects

In partnership with

Daily Issue #75 | Subscribe to DS | Daily Sandbox Pro

• Penpot Plugins: Build custom tools with Penpot’s brand-new plugin system.

• Zoom Hack: A simple trick to lower your Zoom bandwidth.

• Fake Backend: Use IndexedDB to create a mock backend easily.

• JavaScript Challenge: Think you know JS? Prepare to be surprised!

• Apple Study: Spoiler alert: AI still struggles with coding.

• PostgreSQL & Express: Add a PostgreSQL database to your Express API with this guide.

• Node Toolbox Picks: 4 of the best new Node.js tools you need to try.

• Build Your Own Tools with Penpot’s New Plugin System

• A little trick to reduce Zoom bandwidth

• How to create fake back-end using IndexedDB

• Think You Know JavaScript? - Think again!

• Apple Study Says AI Can’t Code

More news here →

Unlock Windsurf Editor, by Codeium.

Introducing the Windsurf Editor, the first agentic IDE. All the features you know and love from Codeium’s extensions plus new capabilities such as Cascade that act as collaborative AI agents, combining the best of copilot and agent systems. This flow state of working with AI creates a step-change in AI capability that results in truly magical moments.

Download It Free Today

Adding a PostgreSQL Database to Your Express API

You’ve built a shiny RESTful API with Node.js and Express. It’s fast, efficient, and looks great on the surface. But behind the scenes, your data is living precariously in an in-memory array—a temporary cardboard box waiting to be wiped clean with the next server restart. Enter PostgreSQL, the hero your API deserves, ready to transform that box into a fortress of structured, persistent data.

Connecting Your API to Postgres

With a simple package called pg, you can turn your Express app into a data powerhouse. Imagine the relief of knowing your data won’t disappear the moment your server hiccups. Here’s a taste of what it looks like to connect your API to a PostgreSQL database:

const { Pool } = require('pg');
const pool = new Pool({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'marketplace',
    port: 5432
});

// Check the connection
pool.query('SELECT NOW()', (err, res) => {
    if (err) {
        console.error('Error connecting to the database', err);
    } else {
        console.log('Connected to the database at', res.rows[0].now);
    }
});

That’s the start of a beautiful relationship. Your API is now backed by a reliable database that won’t let your precious data vanish into the digital void.

Making Your API Persistent

Let’s say you’re tired of seeing your vendor data wiped every time you restart your app. Here’s how you can create a new vendor in style, with data that lives on forever:

app.post('/vendors', async (req, res) => {
    try {
        const { name, specialty } = req.body;
        const result = await pool.query(
            'INSERT INTO vendors (name, specialty) VALUES ($1, $2) RETURNING *',
            [name, specialty]
        );
        res.status(201).json(result.rows[0]);
    } catch (error) {
        console.error('Error creating vendor', error);
        res.status(500).send('Internal Server Error');
    }
});

Notice how we use SQL to insert data, with placeholders to prevent SQL injection. It’s simple, secure, and effective. And when you fetch vendors, it’s just as elegant:

app.get('/vendors', async (req, res) => {
    try {
        const result = await pool.query('SELECT * FROM vendors');
        res.json(result.rows);
    } catch (error) {
        console.error('Error fetching vendors', error);
        res.status(500).send('Internal Server Error');
    }
});

With Postgres, your API evolves from a basic demo to a full-fledged, production-ready system. You get persistent storage, relational data support, and the peace of mind that your data is secure and scalable. Want to learn how to set up the tables, structure your queries, and take full advantage of Postgres? This tutorial is just scratching the surface.

⭐️ For the complete tutorial, check out the full article here

More tutorials here →

Newsletter Recommendation

• laravel-resume-parser - Resume Parser/CV Parser for Laravel with AI-powered SharpAPI

• ws - Simple to use, blazing fast and thoroughly tested WebSocket client and server for Node.js

• node-redis - Redis Node.js client

• markdown-pdf - Node module that converts Markdown files to PDFs

More code libs here →

Midjourney

More AI prompts here →

📣 HELP SPREAD THE WORD

🚀 Spread the Code! Love what you read? Share the newsletter with your fellow devs - every recommendation helps power up the community.

💻 Sponsor the Dev Journey! Keep the bytes flowing and the newsletter growing by becoming a sponsor. Your support helps maintain this valuable resource.

💬 Tweet the Deets! Share the latest with your code crew - let’s make this viral, not just a bug!

If you have built anything that you’d like to share with the community, get with me on X @dailysandbox_ 😀