4 ms·
I handrolled a very very basic SQL parser in my toy database hash-db https://GitHub.com/samsquire/hash-db https://GitHub.com/samsquire/hash-db It's distribute
by samsquire 4y ago
I handrolled a very very basic SQL parser in my toy database hash-db
https://GitHub.com/samsquire/hash-db https://GitHub.com/samsquire/hash-db
It's distributed dynamodb style keyvalue, SQL and Cypher graph database.
I feel if you want to get a project moving forward for something as large as a database, you can get something rudimentary working and extend the parser when you need those features.
SQL wise it supports Joins and where's and rudimentary full text search
It uses rockset's converged indexes for ease of query generation.
If you're interested in queries then you should read this blog post.
https://rockset.com/blog/converged-indexing-the-secret-sauce-behind-rocksets-fast-queries/ https://rockset.com/blog/converged-indexing-the-secret-sauce...
The database is partly multimodel with document storage and SQL and graph Cypher querying but I am yet to get all the models to be mutually queryable. The document storage is queryable by SQL but graphs aren't queryable by SQL or as a document.