the world is a database now you can query it with SQL
Project description
Splicer [![Build Status](https://travis-ci.org/trivio/splicer.png)](https://travis-ci.org/trivio/splicer)
======================
``splicer`` makes the entire world look like a SQL database.
It is a python module for working with data from disparate sources
using commands to those familiar with SQL. It aims to make quick
one off queries and ETL scripts more declarative rather than procedural.
Inspired by projects like BigQuery, Postgres Foreign Data Wrappers
and Multicorn, except no database is required.
``splicer`` enables:
* Analysts to create Datasets linking various
foreign tables together along with User Defined Functions written in python.
Once defined, the datasets can be queried via SQL Select statements to create
new Views of the Data.
* Extension Developers to create extensions that make various data sources
REST endpoints, log files, NoSQL Servers, traditional Databases,
CSV Files to behave like tables.
``splicer`` will take advantage of these various sources' capabilities where
appropriate and will compensate for sources that lack basic
features.
For example if a database supports joins and you want to query
two tables within that database, ``splicer`` will have that system
perform the join for you. If however you're working with a less
sophisticated source, like plain files, ``splicer`` will perform the
operations for you locally.
Enough reading! [Try it out][1]
[1]: https://splicer.readthedocs.org/en/latest/install.html#installation "Installing Splicer"
======================
``splicer`` makes the entire world look like a SQL database.
It is a python module for working with data from disparate sources
using commands to those familiar with SQL. It aims to make quick
one off queries and ETL scripts more declarative rather than procedural.
Inspired by projects like BigQuery, Postgres Foreign Data Wrappers
and Multicorn, except no database is required.
``splicer`` enables:
* Analysts to create Datasets linking various
foreign tables together along with User Defined Functions written in python.
Once defined, the datasets can be queried via SQL Select statements to create
new Views of the Data.
* Extension Developers to create extensions that make various data sources
REST endpoints, log files, NoSQL Servers, traditional Databases,
CSV Files to behave like tables.
``splicer`` will take advantage of these various sources' capabilities where
appropriate and will compensate for sources that lack basic
features.
For example if a database supports joins and you want to query
two tables within that database, ``splicer`` will have that system
perform the join for you. If however you're working with a less
sophisticated source, like plain files, ``splicer`` will perform the
operations for you locally.
Enough reading! [Try it out][1]
[1]: https://splicer.readthedocs.org/en/latest/install.html#installation "Installing Splicer"
Project details
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
splicer-0.2.1.tar.gz
(36.4 kB
view details)
File details
Details for the file splicer-0.2.1.tar.gz
.
File metadata
- Download URL: splicer-0.2.1.tar.gz
- Upload date:
- Size: 36.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | a08870261af1b52d892b64f2b512dc4df690f093aaea8390b18df8e0c0c160b8 |
|
MD5 | 2f8eb2e21e17b025462249432fec33d5 |
|
BLAKE2b-256 | d688fa02e80958597b9430a61d229f536f2fa54828cb2ce41c4d9973c8c7ca33 |