A platform for describing, extracting, transforming, loading and serving open data.
Project description
Spinta is a command line tool and REST JSON API service for publishing and mapping data between different physical data models, JSON API and semantic data models. It supports a great deal of data schemes and formats.
Physical data Different Real time REST JSON
sources formats transformation API
+-----+
+--> | SQL | --------->|
+------+ | +-----+ |
| file | ---->| |
+------+ | +-----+ |
+--> | CSV | --------->|
+--------+ | +-----+ | +---------------+
| DB API | --->| | ------->| REST JSON API |
+--------+ | +------+ | +---------------+
| | JSON | -------->|
+----------+ | +------+ |
| REST API | -->| |
+----------+ | +-----+ |
+--> | XML | --------->|
+-----+
Purpose
Describe your data: You can automatically generate data structure description table (Manifest) from many different data sources.
Extract your data: Once you have your data structure in Manifest tables, you can extract data from multiple external data sources. Extracted data are validated and transformed using rules defined in Manifest table. Finally, data can be stored into internal database in order to provide fast and flexible access to data.
Transform your data: Data transformations are applied in real time, when reading data from source. This puts some limitations on transformation side, but allows data to be streamed in real time.
Publish your data: Once you have your data loaded into internal database, you can publish data using API. API is generated automatically using Manifest tables and provides extracted data in many different formats. For example if original data source was a CSV file, now you have a flexible API, that can talk JSON, RDF, SQL, CSV and other formats.
Features
Simple 15 column table format for describing data structures (you can use any spreadsheet software to manage metadata of your data)
Internal data storage with pluggable backends (PostgreSQL or Mongo)
Build-in async API server built on top of Starlette for data publishing
Simple web based data browser.
Convenient command-line interface
Public or restricted API access via OAuth protocol using build-in access management.
Simple DSL for querying, transforming and validating data.
Low memory consumption for data of any size
Support for many different data sources
Advanced data extraction even from dynamic API.
Compatible with DCAT and Frictionless Data Specifications.
Example
If you have an SQLite database:
$ sqlite3 sqlite.db <<EOF
CREATE TABLE COUNTRY (
NAME TEXT
);
EOFYou can get a limited API and simple web based data browser with a single command:
$ spinta run -r sql sqlite:///sqlite.dbThen you can generate metadata table (manifest) like this:
$ spinta inspect -r sql sqlite:///sqlite.db
d | r | b | m | property | type | ref | source | prepare | level | access | uri | title | description
dataset | | | | | | | | |
| sql | sql | | sqlite:///sqlite.db | | | | | |
| | | | | | | | |
| | | Country | | | COUNTRY | | | | | |
| | | | name | string | | NAME | | 3 | open | | |Generated data structure table can be saved into a CSV file:
$ spinta inspect -r sql sqlite:///sqlite.db -o manifest.csvMissing peaces in metadata can be filled using any Spreadsheet software.
Once you done editing metadata, you can test it via web based data browser or API:
$ spinta run --mode external manifest.csvOnce you are satisfied with metadata, you can generate a new metadata table for publishing, removing all traces of original data source:
$ spinta copy --no-source --access open manifest.csv manifest-public.csvNow you have matadata for publishing, but all things about original data source are gone. In order to publish data, you need to copy external data to internal data store. To do that, first you need to initialize internal data store:
$ spinta config add backend my_backend postgresql postgresql://localhost/db
$ spinta config add manifest my_manifest tabular manifest-public.csv
$ spinta migrateOnce internal database is initialized, you can push external data into it:
$ spinta push --access open manifest.csvAnd now you can publish data via full featured API with a web based data browser:
$ spinta runYou can access your data like this:
$ http :8000/dataset/sql/Country
HTTP/1.1 200 OK
content-type: application/json
{
"_data": [
{
"_type": "dataset/sql/Country",
"_id": "abdd1245-bbf9-4085-9366-f11c0f737c1d",
"_rev": "16dabe62-61e9-4549-a6bd-07cecfbc3508",
"_txn": "792a5029-63c9-4c07-995c-cbc063aaac2c",
"name": "Vilnius"
}
]
}
$ http :8000/dataset/sql/Country/abdd1245-bbf9-4085-9366-f11c0f737c1d
HTTP/1.1 200 OK
content-type: application/json
{
"_type": "dataset/sql/Country",
"_id": "abdd1245-bbf9-4085-9366-f11c0f737c1d",
"_rev": "16dabe62-61e9-4549-a6bd-07cecfbc3508",
"_txn": "792a5029-63c9-4c07-995c-cbc063aaac2c",
"name": "Vilnius"
}
$ http :8000/dataset/sql/Country/abdd1245-bbf9-4085-9366-f11c0f737c1d?select(name)
HTTP/1.1 200 OK
content-type: application/json
{
"name": "Vilnius"
}Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file spinta-0.1.69.tar.gz.
File metadata
- Download URL: spinta-0.1.69.tar.gz
- Upload date:
- Size: 374.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.4.2 CPython/3.10.6 Linux/5.15.146.1-microsoft-standard-WSL2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 12fa30ea0e474280a6dc14af3911ad68c6741fb26a41d7eb048c7e1a24a5ceb6 |
|
| MD5 | 645a662243e061afbc28cf153212920a |
|
| BLAKE2b-256 | 1c41d13d4774107707e0f7bce1c01decd41ac22e7bb02ab16e4deb88ed82ee3a |
File details
Details for the file spinta-0.1.69-py3-none-any.whl.
File metadata
- Download URL: spinta-0.1.69-py3-none-any.whl
- Upload date:
- Size: 535.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.4.2 CPython/3.10.6 Linux/5.15.146.1-microsoft-standard-WSL2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 1ca87578a173022a63b185a635c274b5b67516f320a113a24d5e759bcb610738 |
|
| MD5 | b52f63a19bfe350b9b044ccdf6f904a0 |
|
| BLAKE2b-256 | e5cb8ab49b5a0666d582aade94f1312ac249c110dcd35f51b21a2fc789ef77d8 |
