sophy

Python binding for sophia embedded database, v2.2.

• Written in Cython for speed and low-overhead

• Clean, memorable APIs

• Comprehensive support for Sophia’s features

• Supports Python 2 and 3.

• No 3rd-party dependencies besides Cython (for building).

About Sophia:

• Ordered key/value store

• Keys and values can be composed of multiple fieldsdata-types

• ACID transactions

• MVCC, optimistic, non-blocking concurrency with multiple readers and writers.

• Multiple databases per environment

• Multiple- and single-statement transactions across databases

• Prefix searches

• Automatic garbage collection and key expiration

• Hot backup

• Compression

• Multi-threaded compaction

• mmap support, direct I/O support

• APIs for variety of statistics on storage engine internals

• BSD licensed

Some ideas of where Sophia might be a good fit:

• Running on application servers, low-latency / high-throughput

• Time-series

• Analytics / Events / Logging

• Full-text search

• Secondary-index for external data-store

Limitations:

• Not tested on Windoze.

If you encounter any bugs in the library, please open an issue, including a description of the bug and any related traceback.

Contents:

• Installing
  • Installing with pip
  • Obtaining the source code
  • Running the tests
• Quick-start
  • Using Sophy
  • CRUD operations
  • Other dictionary methods
  • Range queries
  • Cursors
  • Transactions
  • Index types, multi-field keys and values
  • Configuring and Administering Sophia
  • Backups
• Sophy API
  • SophiaError
  • Environment
  • Database
  • Transaction
  • Schema Definition
  • Cursor
  • Settings

Indices and tables

• Index

• Module Index

• Search Page