Pstore is a high-performance, read-optimized database system. The core
is implemented as a shared library
libpstore that can be embedded in
There's also a CLI application
pstore that is used to manipulate and
inspect pstore files, and convert CSV files into pstore format.
The design of pstore is loosely based on C-Store which is another Open Source read-optimized database. The main idea is to store tabular data in column-order to improve read performance for special purpose workloads.
First, install dependencies:
$ yum install openssl-devel
$ apt-get install libssl-dev
Then install pstore:
$ make install
The command installs an executable
The first step is to create a database file. You can import a CSV file into a pstore database with the following command:
pstore import dataset.csv dataset.out
After that, you can use the
pstore cat command to look into the imported
pstore cat dataset.out
pstore import --append you can append more data into a pstore database:
pstore import --append moredata.csv dataset.out
When you have both Ruby 1.9 and Bundler, install Rubygem dependencies:
Then run the tests:
Pstore is distributed under the LGPL version 2.1 license.