830 B

Raw Permalink Blame History

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

Git
Nodejs