void executeSqlStatement(final String sql, final GraphTraversalSource g) throws SQLException {
final GremlinSchema gremlinSchema = SqlSchemaGrabber.getSchema(g, SqlSchemaGrabber.ScanType.All);
final SqlConverter converter = new SqlConverter(gremlinSchema, g);
final SqlGremlinQueryResult sqlGremlinQueryResult = converter.executeSql(sql);
}Sql Gremlin
Provides a SQL interface to your TinkerPop enabled graph db
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Orientdb | 4,569 | 328 | 54 | 3 days ago | 209 | September 14, 2022 | 261 | apache-2.0 | Java | |
| OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries. | ||||||||||
| Graphjin | 2,638 | 2 | 5 days ago | 457 | September 20, 2022 | 16 | apache-2.0 | Go | ||
| GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks | ||||||||||
| Ipython Dashboard | 635 | 4 | 3 years ago | 6 | January 01, 2016 | 21 | gpl-2.0 | Python | ||
| A stand alone, light-weight web server for building, sharing graphs created in ipython. Build for data science, data analysis guys. Aiming at building an interactive visualization, collaborated dashboard, and real-time streaming graph. | ||||||||||
| Graphview | 519 | 4 years ago | 3 | August 29, 2018 | 12 | other | C# | |||
| GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to efficiently manage graphs. | ||||||||||
| Unipop | 186 | 1 | 5 years ago | 2 | October 09, 2017 | 40 | apache-2.0 | Java | ||
| Data Integration Graph | ||||||||||
| Awesome Hbase | 156 | 10 months ago | cc0-1.0 | |||||||
| A curated list of awesome HBase projects and resources. | ||||||||||
| Pgql Lang | 142 | 6 days ago | 2 | other | Java | |||||
| PGQL is an SQL-based query language for the Property Graph data model | ||||||||||
| Prosperity | 118 | 2 | 8 years ago | 11 | December 22, 2014 | 9 | mit | Ruby | ||
| The easiest way to graph data from your Rails models | ||||||||||
| Pgcodekeeper | 107 | 2 days ago | 13 | apache-2.0 | Java | |||||
| pgCodeKeeper is a PostgreSQL schema management tool | ||||||||||
| Graphquery | 104 | 3 | 4 | 4 years ago | June 03, 2021 | apache-2.0 | Go | |||
| GraphQuery is a query language and execution engine tied to any backend service. | ||||||||||
Alternatives To Sql GremlinSelect To Compare
Alternative Project Comparisons
Readme
SQL-Gremlin
Motivation
Many projects face the inevitable reporting/business intelligence requirement. This has motivated the creation of the SQL-Gremlin compiler.
Usage
To use this, build the module as a shadowJar (run package). From there you must collect the schema of your graph before you can enter sql statments. Basic usage is shown below:
The project is currently under rapid development and interfaces may change quickly with no notice.
Roadmap
Current priorities include:
-
Further SQL support
-
Increase testing
-
Enhancements to schema collection
Please refer to https://github.com/twilmes/sql-gremlin/issues for the most up to date list of outstanding issues.
Acknowledgements
Special thanks goes to the Apache TinkerPop and Apache Calcite teams. The depth and breadth of both of these projects is truly astounding. Also, thanks to Daniel Kuppitz. His work on SPARQL-Gremlin served as a model and inspiration for SQL-Gremlin.
Popular Graph Projects
Popular Sql Projects
Popular Computer Science Categories
Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Java
Graph
Sql
Edge
Gremlin