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! 😊