5 ms·
Cool, I got inspired by this system too -- the aspw library and examples made it extremely easy to get started. I happen to have a lot of non-relational yet tab
by Erwin 12y ago
Cool, I got inspired by this system too -- the aspw library and examples made it extremely easy to get started. I happen to have a lot of non-relational yet tabular data sitting around and the interface to read it is Python. It took a short time before I could join up several of my proprietary databases to do queries on them.
One thing I am planning on doing is to let the user mix in just about any data source: any list of objects with properties/values can be used really. So you can take your database (in proprietary format) and join it up with a text file (quite a useful thing for me). But you could also mix in an API call (again done using your identity). I've been thinking about how many REST APIs suport a subset of SQL via letting you seletct what fields to output, how to order things etc. -- if you instead allow the user to process it via SQL/sqlite you will allow the user quite powerful remixing/aggregation facilities.