Skip to content
Documentation
Data Size Method

Data Size SQL Method

The dataSize method allows you to retrieve information about the size of your SQL data file. You can use this method to determine the file size in different units (bytes, kilobytes, megabytes, and gigabytes).

Syntax

db.dataSize(dataname)
  .then((result) => {
    if (result.acknowledged) {
      const sizeInfo = result.results;
      console.log("Size in bytes:", sizeInfo.bytes);
      console.log("Size in kilobytes:", sizeInfo.kilobytes);
      console.log("Size in megabytes:", sizeInfo.megabytes);
      console.log("Size in gigabytes:", sizeInfo.gigabytes);
    } else {
      console.error("Error:", result.errorMessage);
    }
  })
  .catch((error) => {
    console.error('An error occurred:', error); // Catch any unexpected errors
  });

Parameters

  • dataname: The name of your SQL database.

Example

Suppose you have a SQL database named your_database.db. To retrieve the size information for this database, you can use the dataSize method as follows:

const dataname = 'your_database.db'; // Specify the name of your database
 
db.dataSize(dataname)
  .then((result) => {
    if (result.acknowledged) {
      const sizeInfo = result.results;
      console.log("Size in bytes:", sizeInfo.bytes);
      console.log("Size in kilobytes:", sizeInfo.kilobytes);
      console.log("Size in megabytes:", sizeInfo.megabytes);
      console.log("Size in gigabytes:", sizeInfo.gigabytes);
    } else {
      console.error("Error:", result.errorMessage);
    }
  })
  .catch((error) => {
    console.error('An error occurred:', error); // Catch any unexpected errors
  });

Feel free to adapt this example to your specific use case! 😊


VERSE.DB. Powered by JEDI Studio.