Node Functions on EdgeOne Pages - MySQL

Node Functions allow you to run code in a Node Runtime without managing servers. With its capabilities, you can easily develop and deploy full-stack applications connecting to MySQL databases on Pages.

./node-functions/db.js

import mysql from 'mysql2/promise';

...

export const onRequestGet = async (context) => {
  // Add database query logic here
  const result = await executeQuery('SELECT * FROM user LIMIT 100');

  return new Response(JSON.stringify({
    success: result.success,
    data: result.success ? result.data : null,
    error: result.success ? null : result.error,
    thisis: 'get'
  }), {
    status: result.success ? 200 : 500,
    headers: { 'Content-Type': 'application/json' }
  });
};