|5 days ago||5 days ago|
|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.
I created an in-memory SQL database called MemSQL as a learning project
3 projects | /r/golang | 30 Mar 2023
Might be interested in https://github.com/dolthub/go-mysql-server, which also does this
Implementing the MySQL server protocol for fun and profit
2 projects | news.ycombinator.com | 22 Dec 2022
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.
4 projects | /r/Python | 31 Oct 2022
7 projects | news.ycombinator.com | 22 Aug 2022
Litetree – SQLite with Branches
3 projects | news.ycombinator.com | 22 Jul 2022
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
5 projects | news.ycombinator.com | 23 Jun 2022
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)5 projects | news.ycombinator.com | 23 Jun 2022
The world of PostgreSQL wire compatibility
3 projects | news.ycombinator.com | 10 Feb 2022
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
4 projects | /r/programming | 3 Sep 2021
Let's write a compiler, part 5: A code generator
14 projects | news.ycombinator.com | 19 Aug 2021
Llama: Add Grammar-Based Sampling
7 projects | news.ycombinator.com | 21 Jul 2023
This grammar "library" was cited as an example of what the format could look like:.
There is everything from assembly and C++ to glsl and scripting languages, arithmetic, games, and other weird formats.
Structured Output from LLMs (Without Reprompting!)
5 projects | news.ycombinator.com | 16 Jul 2023
> Which brings me to the other approach: steering the LLM's output __as it is generating tokens__
A relevant PR:
The plan is to support arbitrary grammar files to constrain tokens as they are generated, like the ones here:
2 projects | /r/SQL | 25 Jun 2023
Have a look at jooq - I know this has been used to rewrite SQL from one dialect to another, so it MUST be capable of collating code activity metrics. Look here. Otherwise, you might want to look into writing your own parser. ANTLR has a T-SQL dialect parser script here.
How should I prepare for AI-driven changes in the industry as a Software Engineering Manager
2 projects | /r/ExperiencedDevs | 3 May 2023
Find a Perl grammar file for ANTLR, like https://github.com/antlr/grammars-v4/tree/master/perl Save the grammar file as Perl.g4 in your project. Now, you can create the Kotlin program: import org.antlr.v4.runtime.* import org.antlr.v4.runtime.tree.ParseTree import java.io.File
DELD: An experimental HTTP-Client
4 projects | /r/java | 26 Mar 2023
Antlr is another option. You could generate a parser using the JSON antlr grammar.
lang.g4: ANTLR4 Grammar for different programming languages
2 projects | /r/programming | 5 Feb 2023
SQLite Internals: How the Most Used Database Works
4 projects | news.ycombinator.com | 19 Dec 2022
> ...than it would be to learn the exact syntax and quirks and possibly bugs of someone else's implementation...
Yup. Also, having deep knowledge of the language is required.
SQLite's grammar is neat. Creating a compatible parser would make a fun project. Here's a pretty good example: https://github.com/bkiers/sqlite-parser (Actual ANTLR 4 grammar: https://github.com/bkiers/sqlite-parser/blob/master/src/main... )
Postgres, which tries to be compliant with the latest standards, however...
SQL-2016 is a beast. Not to mention all the dialects.
I'm updating my personal (soon to be FOSS) grammar from ANTLR 3 LL(k) to ANTLR 4 ALL().
I've long had a working knowledge of SQL-92, with some SQL-1999 (eg common table expressions).
But the new structures and extensions are a bit overwhelming.
Fortunately, ANTLR project has ~dozen FOSS grammars to learn from. https://github.com/antlr/grammars-v4/tree/master/sql
They mostly mechanically translate BNFs to LL(k) with some ALL(). Meaning few take advantage of left-recursion. https://github.com/antlr/antlr4/blob/master/doc/left-recursi...
Honestly, I struggled to understand these grammars. Plus, not being conversant with the SQL-2016 was a huge impediment. Just finding a succinct corbis of test cases was a huge hurdle for me.
Fortunately, the H2 Database project is a great resource. https://github.com/h2database/h2database/tree/master/h2/src/...
Now for the exciting conclusion...
My ANTLR grammar which passes all of H2's tests looks nothing like any of the official or product specific BNFs.
Further, I found discrepancy between the product specific BNFs and their implementations.
So a lot of trial & error is required for a "real world" parser. Which would explain why the professional SQL parsing tools charge money.
I still think creating a parser for SQLite is a great project.
.NET-compatible scripting languages for users to write their own scripts to query/manipulate objects/properties in the app
9 projects | /r/csharp | 6 Aug 2022
You can find C# grammar files already defined online: https://github.com/antlr/grammars-v4/tree/master/csharp
I Built a Ruby Parser
2 projects | news.ycombinator.com | 7 Jun 2022
Creating custom formatter for Java
3 projects | /r/javahelp | 15 May 2022
Initially, I was thinking about learning ANT and using it, but I see that they provided grammars for: java8 and java9 https://github.com/antlr/grammars-v4/tree/master/java
What are some alternatives?
vitess-sqlparser - simply SQL Parser for Go ( powered by vitess and TiDB )
ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.
tree-sitter-sql - SQL grammar for tree-sitter
tree-sitter-sql - SQL syntax highlighting for tree-sitter
rewrite - Automated mass refactoring of source code.
zetasql - ZetaSQL - Analyzer Framework for SQL
sbt-antlr4 - Antlr4 plugin for sbt 1.1+ and 0.13.x
Presto - The official home of the Presto distributed SQL query engine for big data
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement