Comments (4)
Hi @psychemedia
have you looked at https://github.com/frictionlessdata/datapackage-pipelines ?
If I understand your use case correctly, DPP could be used to do exactly what you want, with the following additions on top of the base library:
- A custom processor to open the current data package being streamed in R Studio
- A custom processor to open the current data package being streamed in a Jupiter Notebook
- Have a docker file that calls dpp with a pipeline spec, and takes a few env vars (path to the DP to open, open in R Studio or Jupyter, etc.)
We've love to see such a use case and even contributions of processors to do these things!
from tableschema-sql-py.
@pwalsh Not played with that, no... will take a look...
from tableschema-sql-py.
@pwalsh Actually, the datapackage isn't opened into Jupyter or RStudio environment directly. It's loaded into the database container, which is then linked to, and accessible from, the application environment(s).
That's why I posted to this repo...;-)
So the question more succinctly is: is there a simple, automated recipe for populating a MySQL or Postgres container with a datapackage so that someone who doesn't know how to set up a database can create a running containerised instance of a database containing the datapackage contents from a simple command?
from tableschema-sql-py.
Thanks! It's MOVED to https://github.com/frictionlessdata/implementations/issues/18
from tableschema-sql-py.
Related Issues (20)
- Update to jsontableschema-v0.7 HOT 1
- Fix readme on PyPi
- Data synchronisation? HOT 5
- Rebase on sqlalchemy.dialects.postgresql
- Fix readme on PyPi HOT 1
- Expose package version
- Resources have no "name"s HOT 1
- Support all Table Schema types
- Should support database engines other then postgresql HOT 1
- Should be able to save tables to MySQL HOT 2
- Mismatch in primary key types should not cause a failure on SQL writing HOT 2
- Postgres dialect incorrectly maps `array` types as text instead of JSONB
- Express mapping in an external JSON to reuse as standard reference HOT 1
- Package tableschema-sql for distribution via conda-forge HOT 5
- PostgreSQL requires a unique constraint for FK reference
- Pattern check uses 'like' which is not RE compatible
- Timezone offset ignored when loading into sqlite HOT 5
- Maintainer / Lead HOT 8
- Is the package still maintained?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tableschema-sql-py.