go-mysql-server
alasql
Our great sponsors
- Onboard AI - Learn any GitHub repo in 59 seconds
- InfluxDB - Collect and Analyze Billions of Data Points in Real Time
- SaaSHub - Software Alternatives and Reviews
go-mysql-server | alasql | |
---|---|---|
21 | 4 | |
1,256 | 6,757 | |
4.4% | 1.0% | |
0.0 | 8.8 | |
7 days ago | 6 days ago | |
Go | JavaScript | |
Apache License 2.0 | 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.
go-mysql-server
-
I created an in-memory SQL database called MemSQL as a learning project
Might be interested in https://github.com/dolthub/go-mysql-server, which also does this
-
Implementing the MySQL server protocol for fun and profit
https://github.com/dolthub/go-mysql-server
One item under "Scope of this project":
Provide a runnable server speaking the MySQL wire protocol, connected to data sources of your choice.
- MySQL-mimic - Python implementation of the MySQL server wire protocol.
- Parsing SQL
-
Litetree – SQLite with Branches
I just wanted to say thanks for https://github.com/dolthub/go-mysql-server
This is incredibly useful for anyone who wants to build their own DB or wrap another datasource so it's queryable via MySQL protocol.
-
Dolt Is Git for Data
a very cool project they also maintain is a MySQL server framework for arbitrary backends (in Go): https://github.com/dolthub/go-mysql-server
You can define a "virtual" table (schema, how to retrieve rows/columns) and then a MySQL client can connect and execute arbitrary queries on your table (which could just be an API or other source)
-
The world of PostgreSQL wire compatibility
Thanks for this write up! I've been really interested in postgres compatibility in the context of a tool I maintain (https://github.com/mergestat/mergestat) that uses SQLite. I've been looking for a way to expose the SQLite capabilities over a more commonly used wire-protocol like postgres (or mysql) so that existing BI and visualization tools can access the data.
This project is an interesting one: https://github.com/dolthub/go-mysql-server that provides a MySQL interface (wire and SQL) to arbitrary "backends" implemented in go.
It's really interesting how compatibility with existing protocols has become an important feature of new databases - there's so much existing tooling that already speaks postgres (or mysql), being able to leverage that is a huge advantage IMO
- calling Format() on a time struct in a golang program changes the default Location's timezone information in the rest of the program
- Let's write a compiler, part 5: A code generator
alasql
- Let's write a compiler, part 5: A code generator
-
Hosting SQLite databases on GitHub Pages (or any static file hoster)
For similar results, you can use SQL with IndexedDB running fully client-side: https://github.com/agershun/alasql
What are some alternatives?
vitess-sqlparser - simply SQL Parser for Go ( powered by vitess and TiDB )
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
sqlparse - A non-validating SQL parser module for Python
zetasql - ZetaSQL - Analyzer Framework for SQL
JSqlParser - JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
sqlite-parser - JavaScript implentation of SQLite 3 query parser
grammars-v4 - Grammars written for ANTLR v4; expectation that the grammars are free of actions.
sqlfuzz - Simple SQL table fuzzing
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
lakeFS - lakeFS - Data version control for your data lake | Git for data