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

Release History

This version
History Node


Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
vcdb-0.1-py3-none-any.whl (9.3 kB) Copy SHA256 Checksum SHA256 3.4 Wheel Jul 1, 2016

Supported By

WebFaction WebFaction Technical Writing 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 Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting