如何用Node.js连接已有SQLite数据库？Discord Bot跨文件连接求助

Hey there! I’ve set up exactly this kind of stack before—Node.js + SQLite for a Discord bot—so let’s walk through both of your questions clearly.

First, you’ll need a Node.js SQLite library. The two most popular options are:

• sqlite3: The core callback-based library (works well, but requires handling callbacks or promisifying it)
• sqlite: A promise-based wrapper around sqlite3 (uses async/await, which is cleaner for modern code)

Step 1: Install the library #

Choose one and run the install command:

# For promise-based (recommended)
npm install sqlite sqlite3

# Or for callback-based only
npm install sqlite3

Step 2: Write the connection code #

Promise-based example (async/await):

const sqlite3 = require('sqlite3').verbose();
const { open } = require('sqlite');

async function connectToDB() {
  try {
    // Replace './your-database.db' with the actual path to your existing SQLite file
    const db = await open({
      filename: './your-database.db',
      driver: sqlite3.Database
    });
    console.log('Successfully connected to your existing SQLite database!');
    return db;
  } catch (err) {
    console.error('Failed to connect to database:', err);
    throw err; // Let the caller handle the error (e.g., crash the bot if critical)
  }
}

// Call the function to initialize the connection
connectToDB();

Callback-based example:

const sqlite3 = require('sqlite3').verbose();

// Open the existing database file
const db = new sqlite3.Database('./your-database.db', (err) => {
  if (err) {
    console.error(err.message);
    return;
  }
  console.log('Connected to your existing SQLite database.');
});

// Note: For long-running apps like Discord bots, you don't need to close the connection manually
// The connection stays open until the bot shuts down

The key here is to avoid creating a new database connection in every command file—this causes unnecessary overhead and can lead to database locks. Instead, create a shared database module that exports a single, reusable connection instance.

Step 1: Create a dedicated database module #

Make a file named database.js in your project root:

// database.js
const sqlite3 = require('sqlite3').verbose();
const { open } = require('sqlite');

// We'll store the single connection instance here
let dbInstance;

// Function to get the connection (creates it only once)
async function getDB() {
  if (!dbInstance) {
    dbInstance = await open({
      filename: './your-database.db',
      driver: sqlite3.Database
    });
    console.log('Database connection initialized and ready to use!');
  }
  return dbInstance;
}

// Export the function so other files can access the connection
module.exports = { getDB };

Step 2: Initialize the connection when your bot starts #

In your main bot file (e.g., index.js), initialize the database connection before loading your commands to ensure it’s ready when commands run:

// index.js (your main Discord bot file)
const { Client, GatewayIntentBits } = require('discord.js');
const { getDB } = require('./database');

const client = new Client({ intents: [GatewayIntentBits.Guilds] });

client.on('ready', async () => {
  console.log(`Logged in as ${client.user.tag}!`);
  
  // Initialize the database connection first
  await getDB();
  
  // Now load your commands (adjust this to match your command loader setup)
  await loadCommands();
});

// ... rest of your bot code (login, event handlers, etc.)

Step 3: Use the connection in your command files #

In any command file (e.g., commands/addUser.js), import the getDB function and use it to access the shared connection:

// commands/addUser.js
const { SlashCommandBuilder } = require('discord.js');
const { getDB } = require('../database');

module.exports = {
  data: new SlashCommandBuilder()
    .setName('adduser')
    .setDescription('Add a user to the database')
    .addUserOption(option => 
      option.setName('user')
        .setDescription('The user to add')
        .setRequired(true)
    ),
  async execute(interaction) {
    // Get the shared database connection
    const db = await getDB();
    const user = interaction.options.getUser('user');
    
    try {
      // Example: Insert the user into a 'users' table (adjust to your schema)
      await db.run(
        'INSERT INTO users (discord_id, username) VALUES (?, ?)',
        [user.id, user.username]
      );
      await interaction.reply(`Successfully added ${user.tag} to the database!`);
    } catch (err) {
      console.error('Error adding user to database:', err);
      await interaction.reply('Oops! Something went wrong while adding the user.');
    }
  },
};

Quick Notes: #

• Never create a new sqlite3.Database() instance in each command—this will spawn multiple connections and cause issues.
• The getDB() function uses a singleton pattern, so it only creates one connection and reuses it every time it’s called.
• For long-running apps like Discord bots, you don’t need to close the connection manually—it stays open until the bot shuts down.

内容的提问来源于stack exchange，提问作者Frostyman