upscaledb 2.2.0 Mo 7. Mar 23:11:14 CET 2016
(C) Christoph Rupp, [email protected]; http://www.upscaledb.com
This is the README file of upscaledb.
Contents:
1. About
upscaledb is a database engine written in C/C++. It is fast, production-proven
and easy to use.
There are a few significant changes coming with this release:
1. A new query interface (uqi_select and uqi_select_range) with an SQL-ish
query language. The query engine can be extended through custom plugins,
which can also be loaded from an external library. You can therefore
run fast queries even when using the remote API or wrapper APIs like java,
.NET, Python or Erlang.
2. Records can now also be "typed", i.e. for uint32, uint64 and all other
currently supported types.
In addition there were a few (mostly minor) changes in the API and a bug fix.
CALL FOR ACTION:
I will upgrade some parts of the code to C++ 11 with the next releases,
starting with non-critical parts (i.e. unittests, tools). If your compiler
does not yet support C++11 then please tell me.
2. Changes
New Features
* Records are now typed, just like the keys
* A new query interface based on SQL-ish query statements
Bugfixes
* issue #71: fixed growing journal file (thanks, Hitoshi Yonemichi)
o issue #74: fixed ups_import for databases with record numbers (thanks, mjmckp)
* issue #71: fixed ARM compilation (thanks, MrApe)
Other Changes
* Added ups_at_exit cleanup function to release statically allocated
resources
* Removed UPS_PARTIAL and all related functionality
* Removed UPS_FLUSH_TXN_IMMEDIATELY - it was deprecated and not used
* UPS_DIRECT_ACCESS is now deprecated and only used internally
* ups_info, ups_dump and ups_export now work for UPS_TYPE_CUSTOM databases
* ups_cursor_get_record_size: size is now uint32_t* instead of uint64_t*
To see a list of all changes, look in the file ChangeLog.
3. Features
- Very fast sorted B+Tree with variable length keys
- Basic schema support for POD types (i.e. uint32, uint64, real32 etc)
- Very fast analytical functions
- Can run as an in-memory database
- Multiple databases in one file
- Record number databases ("auto-increment")
- Duplicate keys
- Logging and recovery
- Unlimited number of parallel Transactions
- Transparent AES encryption
- Transparent CRC32 verification
- Various compression codecs for journal, keys and records using
zlib, snappy, lzf
- Compression for uint32 keys
- Network access (remote databases) via TCP/Protocol Buffers
- Very fast bi-directional database cursors
- Configurable page size, cache size, key sizes etc
- Runs on Linux, Unices, Microsoft Windows and other architectures
- Uses memory mapped I/O for fast disk access (but falls back to read/write if
mmap is not available)
- Uses 64bit file pointers and supports huge files (>2 GB)
- Easy to use and well-documented
- Open source and released under APL 2.0 license
- Wrappers for C++, Java, .NET, Erlang, Python, Ada and others
4. Known Issues/Bugs
See https://github.com/cruppstahl/upscaledb/issues.
5. Compiling
5.1 Linux, MacOS and other Unix systems
To compile upscaledb, run ./configure, make, make install.
Run `./configure --help' for more options (i.e. static/dynamic library,
build with debugging symbols etc).
5.2 Microsoft Visual Studio
A Solution file is provided for Microsoft Visual C++ in the "win32" folder
for MSVC 2013.
All libraries can be downloaded precompiled from the upscaledb webpage.
To download Microsoft Visual Studio Express Edition for free, go to
http://msdn.microsoft.com/vstudio/express/visualc/default.aspx.
5.3 Dependencies
On Ubuntu, the following packages are required:
- libdb-dev (optional)
- protobuf-compiler
- libprotobuf-dev
- libgoogle-perftools-dev
- libboost-system-dev
- libboost-thread-dev
- libboost-dev
- (libuv needs to be installed from sources - see
https://github.com/joyent/libuv)
For Windows, precompiled dependencies are available here:
https://github.com/cruppstahl/upscaledb-alien
6. Testing and Example Code
Make automatically compiles several example programs in the directory
'samples'. To see upscaledb in action, just run 'samples/db1'
or any other sample. (or 'win32/out/samples/db1/db1.exe' on Windows platforms).
7. API Documentation
The header files in 'include/ups' have extensive comments. Also, a doxygen
script is available; run 'make doc' to start doxygen. The generated
documentation is also available on the upscaledb web page.
8. Porting upscaledb
Porting upscaledb shouldn't be too difficult. All operating
system dependend functions are declared in '1os/*.h' and defined
in '1os/os_win32.cc' or '1os/os_posix.cc'.
Other compiler- and OS-specific macros are in 'include/ups/types.h'.
Most likely, these are the only files which have to be touched. Also see item
9) for important macros.
9. Migrating files from older versions
Usually, upscaledb releases are backwards compatible. There are some exceptions,
though. In this case tools are provided to migrate the database. First, export
your existing database with ups_export linked against the old version.
(ups_export links statically and will NOT be confused if your system has a
newer version of upscaledb installed). Then use the newest version of
ups_import to import the data into a new database. You can find ups_export
and ups_import in the "tools" subdirectory.
Example (ups_export of 2.1.2 was renamed to ups_export-2.1.2 for clarity):
ups_export-2.1.2 input.db | ups_import --stdin output.db
10. Licensing
upscaledb is released under the GNU Public License (GPL) 3.0. See the
file COPYING for more information.
For commercial use licenses are available. Visit http://upscaledb.com
for more information.
11. Contact
Author of upscaledb is
Christoph Rupp
Paul-Preuss-Str. 63
80995 Muenchen/Germany
email: [email protected]
web: http://www.upscaledb.com
12. Other Copyrights
The Google Protocol Buffers ("protobuf") library is Copyright 2008, Google Inc.
It has the following license:
Copyright 2008, Google Inc.
All rights reserved.
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are
met:
* Redistributions of source code must retain the above copyright
notice, this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above
copyright notice, this list of conditions and the following disclaimer
in the documentation and/or other materials provided with the
distribution.
* Neither the name of Google Inc. nor the names of its
contributors may be used to endorse or promote products derived from
this software without specific prior written permission.
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 MERCHANTABILITY AND FITNESS FOR
A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
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 DAMAGE.
Code generated by the Protocol Buffer compiler is owned by the owner
of the input file used when generating it. This code is not
standalone and requires a support library to be linked with it. This
support library is itself covered by the above license.
The libuv library is part of the Node project: http://nodejs.org/
libuv may be distributed alone under Node's license:
Copyright Joyent, Inc. and other Node contributors. All rights reserved.
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to
deal in the Software without restriction, including without limitation the
rights to use, copy, modify, merge, publish, distribute, sublicense, and/or
sell copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in
all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS
IN THE SOFTWARE.