Spare Cores (SC) Crawler database schemas
Spare Cores, a Python-based open-source ecosystem, provides a comprehensive and standardized inventory, along with performance evaluations of available compute resources across public cloud and server providers. The project providers different components to interact with the database schemas defined here:
- Run the SC Crawler, to compile your own database: https://github.com/SpareCores/sc-crawler
- Use the SC Data package to easily grab a copy of the database: https://github.com/SpareCores/sc-data
- Fire up an API using the SC Keeper package on the top of the database: https://github.com/SpareCores/sc-keeper
Diagram
Open the interactive diagram and version history on dbdocs.io.
Tables
| Table | Description |
|---|---|
benchmark | Benchmark scenario definitions. |
benchmark_score | Results of running Benchmark scenarios on Servers or managed Databases. |
compliance_framework | List of Compliance Frameworks, such as HIPAA or SOC 2 Type 1. |
country | Country and continent mapping. |
database | Managed database SKUs. |
database_price | Managed database SKU prices per Region. |
database_storage | Managed database storage products. |
database_storage_price | Managed database storage prices in each Region. |
ipv4_price | Price of an IPv4 address in each Region. |
region | Regions of Vendors. |
server | Server types. |
server_description | Variable length, plain English descriptions of Server hardware specs, performance, cost-efficiency, and workflow fit. |
server_price | Server type prices per Region and Allocation method. |
storage | Flexible storage options that can be attached to a Server. |
storage_price | Flexible Storage prices in each Region. |
traffic_price | Extra Traffic prices in each Region. |
vendor | Compute resource vendors, such as cloud and server providers. |
vendor_compliance_link | List of known Compliance Frameworks paired with vendors. |
zone | Availability zones of Regions. |