Skip to content

darless/sqlite-analyze

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

sqlite-analyze
==============

Analyze a SQLite database. 

To Run
======

./sqlite-analyze basic test-db/test.db
Table           : # of entries
--------------------------------------
table1          : 5536
table2          : 5536
table3          : 5536
--------------------------------------

./sqlite-analyze detail test-db/test.db
Parsing table table1
Parsing table table2
Parsing table table3

DB Size: 441.34 KB

Table           : # entries        Size             Entry Size       Percent         
-------------------------------------------------------------------------------------
table2          : 5536             87.04 KB         15.0 B           19.72 %         
table3          : 5536             149.5 KB         27.0 B           33.87 %         
table1          : 5536             206.85 KB        37.0 B           46.87 %



Future
======
- Generate DB with random data by reading its schema

NO WARRANTY
======
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
LIMITED TO, THE IMPLIED WARRANTIES OF NONINFRINGEMENT, MERCHANTIBILITY
AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE LIABLE FOR SPECIAL, EXEMPLARY,
OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF
THE POSSIBILITY OF SUCH DAMAGES.



About

Analyze a SQLite database.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages