tiny-redis
SQLToy
tiny-redis | SQLToy | |
---|---|---|
1 | 5 | |
9 | 122 | |
- | - | |
1.8 | 0.0 | |
almost 3 years ago | over 1 year ago | |
Go | JavaScript | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
tiny-redis
-
Show HN: SQLToy – a tiny relational database for learning SQL via code
I made a key value store: https://github.com/tinfoil-knight/tiny-redis (easy to build compared to a SQL db) and really enjoyed the process.
Making a SQL db is on my list and your wiki seems like a great place to start.
But, I also wanted to know what books/articles/implementations did you refer to create your own?
SQLToy
- Shouldn't FROM come before SELECT in SQL?
-
SQL: The difference between WHERE and HAVING
You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy
-
Show HN: SQLToy – a tiny relational database for learning SQL via code
I am a Javascript developer and I've used SQL for years but it's always been a bit of a black box. I recently learned about the SQL order of operations and the relational model and it kind of blew my mind. In the process of digesting this information I wrote my own database in Javascript which I think might help others in my same situation. The result is SQLToy.
It is a SQL database written in Javascript. It's under 500 lines of code (including comments) and has zero dependencies.
The purpose of SQLToy is not to use it as a database but to learn SQL. Instead of doing this from the "outside-in" by learning the query language you do it "inside-out" by going through the implementation of the most common SQL operators. Instead of just learning what the operators do, you also learn how they do it which (hopefully!) should lead to a much deeper level of understanding.
A detailed wiki walks through the code of 15 different SQL operations including SELECT, WHERE, JOINs, GROUP BY, Aggregate Functions COUNT, AVG, MAX, MIN to name a few.
The wiki can be found here: https://github.com/weinberg/SQLToy/wiki
Feedback appreciated!
- Show HN: SQLToy – my zero-dependency SQL database in
What are some alternatives?
godis - A Golang implemented Redis Server and Cluster. Go 语言实现的 Redis 服务器和分布式集群
FunSQL.jl - Julia library for compositional construction of SQL queries
rueidis - A fast Golang Redis client that supports Client Side Caching, Auto Pipelining, Generics OM, RedisJSON, RedisBloom, RediSearch, etc. [Moved to: https://github.com/redis/rueidis]
rueidis - A fast Golang Redis client that supports Client Side Caching, Auto Pipelining, Generics OM, RedisJSON, RedisBloom, RediSearch, etc.
redix - a very simple pure key => value storage system that speaks Redis protocol with Postgres as storage engine and more