cube2222 / octosql Goto Github PK
View Code? Open in Web Editor NEWOctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
License: Mozilla Public License 2.0
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
License: Mozilla Public License 2.0
Please add support for CouchDB :)
Thank you
Platform: Windows
example.json:
[{
"nameCache": null
}]
settings.yaml
dataSources:
- name: t
type: json
config:
path: "example.json"
arrayFormat: true
command
octosql "select * from t as tt" -c settings.yaml
result:
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0xf8 pc=0x51bce6]
goroutine 1 [running]:
github.com/cube2222/octosql.NormalizeType(0x0, 0x0, 0xc00009b988, 0x2)
/go/src/github.com/{{ORG_NAME}}/{{REPO_NAME}}/values.go:235 +0xbb6
github.com/cube2222/octosql/storage/json.(*RecordStream).Next(0xc0001064b0, 0xc000079e60, 0x9c9e20, 0xc0001064b0)
/go/src/github.com/{{ORG_NAME}}/{{REPO_NAME}}/storage/json/datasource.go:120 +0x32d
github.com/cube2222/octosql/app.(*App).RunPlan(0xc00009bd18, 0x9cf420, 0xc0000700b0, 0x9c4740, 0xc0000de460, 0x0, 0xc00009bd38)
/go/src/github.com/{{ORG_NAME}}/{{REPO_NAME}}/app/app.go:45 +0x1a3
main.glob..func1(0xd31520, 0xc000079aa0, 0x1, 0x3)
/go/src/github.com/{{ORG_NAME}}/{{REPO_NAME}}/cmd/octosql/main.go:94 +0x594
github.com/spf13/cobra.(*Command).execute(0xd31520, 0xc00006c0d0, 0x3, 0x3, 0xd31520, 0xc00006c0d0)
/go/pkg/mod/github.com/spf13/[email protected]/command.go:830 +0x2b5
github.com/spf13/cobra.(*Command).ExecuteC(0xd31520, 0xd36a90, 0x924ae8, 0x6)
/go/pkg/mod/github.com/spf13/[email protected]/command.go:914 +0x303
github.com/spf13/cobra.(*Command).Execute(...)
/go/pkg/mod/github.com/spf13/[email protected]/command.go:864
main.main()
/go/src/github.com/{{ORG_NAME}}/{{REPO_NAME}}/cmd/octosql/main.go:105 +0x157
This should probably be an extension of #26
Would be great to be able to connect over a bastion SSH host to the actual database.
Idea: The logical plan node should have a method getphysical and should, after calling on the root node, create a naive physical plan for the whole tree.
https://github.com/bradleyjkemp/memviz this with minor modifications to the code (inlining of pointers) works great.
Seeing how useful is to be able to query with SQL in Excel and similar spreadsheets it would be useful to bring this functionality into a CLI tooling.
Hi there,
Very interesting tools. Thank you in advance.
I see that MSSQL is not in the roadmap.
How could it be implemented? Adding a dedicated datastore would be enough?
I could eventually help in the process
Think about adding server mode where queries are supplied through http calls. Would also require adding nice statistics everywhere.
Would be very useful for production usage.
Watching configuration changes in git would be amazing.
Configuration hot reload.
This feature will be very helpful in generating sync-scripts that can allow you to compare different aspects or all of the schema where you can run that script to match the target schema. I've used a tool that did this (which was solid), but the licensing fees were absurd.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.