31–40 of 80 posts
https://www.sqlite.org/lemon.html
You could probably use something like participle, but you'd have to translate the grammar.
How do you connect to it and actually use it? Does it behave like a SQL database? Row-based? Column-based? Good for analytical workloads? Document store? Redis/memcached database? What are it's strengths or weaknesses? Cool accomplishment in and of itself but hard for anyone here to really give you any criticism or feedback without understanding where it excels and how to work with it.
Earlier quoted context omitted.
yeah as a dev/non-go person don't know how it works either. I assume main.go is where it starts but then what... I see a commands maybe it works by CLI? idk either
You're a "dev," but don't seek out test folders/files for use case examples? Don't let your employer know...
Someone asked about resources and I ran into this while evaluating embedded db options for a golang project - it's a collection of db components implemented in golang: https://github.com/thomasjungblut/go-sstables
If folks would like to see more examples of databases built to teach oneself, they get shared on the /r/databasedevelopment subreddit not infrequently. Some recent ones: https://www.reddit.com/r/databasedevelopment/comments/1hyig8... https://www.reddit.com/r/databasedevelopment/comments/1ha5cc... https://www.reddit.com/r/databasedevelopment/comments/1dqgms... https://www.reddit.com/r/databasedevelopment/comments/1ix5…
If you are wanting proper SQL command support, you could copy the SQLite parser approach. Properly parsing all valid command texts is not a problem that I would find compelling unless I was being compensated for it. https://www.sqlite.org/lemon.html You could probably use something like participle, but you'd have to translate the grammar. https://github.com/alecthomas/participle
This looks like a good exploratory project! One thing I’d add to the readme is an example of how you’d use the database in an example application. From the docs, it’s clear that this isn’t a sql database (yet?), so it would be good to have an example to see how to use the database. It might also be nice to have a description of what happens when you insert or get a record, so others can learn from the code too. Or ca…
Learnt about B+ Trees, transactions, managing concurrent reads & data presistence
I didnt look into it yet but i already wanted to say - cuz of curiosity i build my own graph database in golang :) and i learned alot. so i absolutly understand why you did it and what experiences you probably made on the way :D congratz !
You might be interested in this golang db from mit’s database systems course: https://github.com/MIT-DB-Class/go-db-2024 https://dsg.csail.mit.edu/6.5830/
excellent, would love to hear more about resources you used while implementing