guillermo/sqlite-analyzer
guillermo
/
sqlite-analyzer
0
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Analyze a sqlite
1 Commit 1 Branch 0 Tags 36 KiB
JavaScript 100%
Go to file
Guillermo Bonet a7dd647da4 refs #5977 First commit 2023-07-10 07:53:34 +02:00
.gitignore refs #5977 First commit 2023-07-10 07:53:34 +02:00
README.md refs #5977 First commit 2023-07-10 07:53:34 +02:00
main.js refs #5977 First commit 2023-07-10 07:53:34 +02:00
package-lock.json refs #5977 First commit 2023-07-10 07:53:34 +02:00
package.json refs #5977 First commit 2023-07-10 07:53:34 +02:00

README.md

sqlite-analyzer

This code is a simple SQLite database analyzer that retrieves the names of all tables in a SQLite database file. It then iterates over each table and retrieves the count of columns for each table. If a table has more than 50000 columns, it logs the table name along with the column count to the console.

Requeriments

  • Git
  • Nodejs

Installation

Pull from repository.

$ git clone https://gitea.verdnatura.es/guillermo/sqlite-analyzer.git

Run this commands on project root directory to install Node dependencies.

$ npm install

Copy your database (example.db) into project folder with the name sqlite.db

How to run

Execute this command in project path.

$ node main

Built With