33 lines
830 B
Markdown
33 lines
830 B
Markdown
# 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](https://git-scm.com/)
|
|
* [Nodejs](https://nodejs.org/) |