Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

build SQL database from version control repository

Project Description

Vcdb scans a version control repository and builds an SQL database that can be queried. This simplifies monitoring version control activity and obtaining numbers from it.


Vcdb is available from and can be installed running:

$ pip install vcdb

The minimum supported Python version is 3.4.

The Subversion command line client svn must be installed and located in the command search path ($PATH resp. %PATH%).


To build a database for vcdb’s own repository run:

$ vcdb sqlite:////tmp/vcdb.db

Currently vcdb only supports Subversion. Because Github provides a Subversion interface for git repositories you can still analyze them using a call like the one above.

You can then query the database using e.g. the sqlite command line client, for example:

$ sqlite3 /tmp/vcdb.db "select count(1) from changes"

The data model is a work in progress, so their is no documentation yet. To see the SQL code used to create all available tables, columns and their relations, run:

$ sqlite3 /tmp/vcdb.db ".schema"

To see all available command line options, run:

$ vcdb --help

To see the current version number, run:

$ vcdb --version


Copyright (C) 2016 Thomas Aglassinger. Distributed under the GNU Lesser General Public License v3 or later (LGPLv3+).


v0.1, 2016-07-01

  • Initial public release.

Release History

This version
History Node


Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
(9.3 kB) Copy SHA256 Hash SHA256
Wheel 3.4 Jul 1, 2016

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Google Google Cloud Servers DreamHost DreamHost Log Hosting