Skip to main content

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 familliar 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 data base is required.

``splicer`` enables:

* Analysts to create Datasets linking various
foreign tables together along with User Defined Functions written in python.
Once defind 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 advanatage of these various sources capabilities where
appropiate 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 the your worknig with a less
sophisticated source, like a 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


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.0.10.tar.gz (27.8 kB view details)

Uploaded Source

File details

Details for the file splicer-0.0.10.tar.gz.

File metadata

  • Download URL: splicer-0.0.10.tar.gz
  • Upload date:
  • Size: 27.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for splicer-0.0.10.tar.gz
Algorithm Hash digest
SHA256 a15aa957e32fa53cdce73246f8782960c2520b55b7ae6dd83578e5df4c0d83d1
MD5 11f86f79603350211943165c4a236940
BLAKE2b-256 cd7c033505601a55d6aa96d88f90bf88b60c3812c0d4f34a3ed894a0d7ab0646

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page