اتصال به دیتابیس SQLite در برنامه‌های NextJS

npm install sqlite sqlite3

*
!.gitignore

import sqlite3 from 'sqlite3';
import { open } from 'sqlite';

let db;

export async function connectToSQLite() {
  if (!db) {
    db = await open({
      filename: './db/database.sqlite',
      driver: sqlite3.Database,
    });
  }
  return db;
}

export async function disconnectFromSQLite() {
  if (db) {
    await db.close();
    db = null;
  }
}

import { connectToSQLite, disconnectFromSQLite } from '@/lib/sqlite';

export default async function handler(req, res) {
  if (req.method === 'GET') {
    try {
      const db = await connectToSQLite();
      await db.get("SELECT 1");
      await disconnectFromSQLite();
      res.status(200).json({ message: 'Connected to SQLite successfully' });
    } catch (error) {
      res.status(500).json({ error: error.message });
    }
  } else {
    res.status(405).json({ error: 'Method Not Allowed' });
  }
}

import { useEffect, useState } from 'react';

export default function Home() {
  const [data, setData] = useState(null);
  const [error, setError] = useState(null);

  useEffect(() => {
    async function fetchData() {
      try {
        const res = await fetch('/api/sqlite');
        if (!res.ok) {
          throw new Error(`HTTP error! status: ${res.status}`);
        }
        const result = await res.json();
        setData(result);
      } catch (err) {
        setError(err);
      }
    }

    fetchData();
  }, []);

  return (
    <div>
      <h1>Database Connection Test</h1>
      {error ? (
        <p>Error: {error.message}</p>
      ) : data ? (
        <pre>{JSON.stringify(data, null, 2)}</pre>
      ) : (
        <p>Loading...</p>
      )}
    </div>
  );
}

{
    "disks": [
        {
            "name": "database",
            "mountTo": "db"
        }
    ]
}