spanspan

5 ms·

1.
by spanspan 3y ago
It does have joins
2.
by spanspan 3y ago
Fair. It’s “inspired by”, not a “clone”. Frankly, I don’t think these terms are that specific, that one couldn’t level the same point against “inspired by”.. in what sense is it inspired?
3.
by spanspan 3y ago
I began using python as a way to "mock" out the overall design; intending to re-implement it in rust. The main reasoning for using python: was the ability to focus on "high-level" concepts and speed of tinkering. This im
4.
by spanspan 3y ago
Re: ACID guarantees It doesn't have a notion of atomically batching multiple statements, i.e. transaction. But beyond that, it's a single file database, which can only have a single process (learndb instance) that is operating on
5.
by spanspan 3y ago
̶T̶h̶i̶s̶ ̶s̶t̶r̶i̶n̶g̶ ̶i̶s̶ ̶t̶h̶e̶ ̶g̶r̶a̶m̶m̶a̶r̶ ̶t̶h̶a̶t̶ ̶l̶a̶r̶k̶ ̶u̶s̶e̶s̶ ̶t̶o̶ ̶p̶a̶r̶s̶e̶ ̶t̶h̶e̶ ̶u̶s̶e̶r̶ ̶s̶u̶b̶m̶i̶t̶t̶e̶d̶ ̶s̶q̶l̶ ̶i̶n̶t̶o̶ ̶a̶n̶ ̶A̶S̶T̶.̶ ̶T̶h̶i̶s̶ ̶p̶a̶r̶s̶i̶n̶g̶ ̶i̶s̶ ̶f̶a̶r̶ ̶m̶o̶r̶e̶ ̶c̶o̶m̶p̶l̶e̶t̶e
6.
by spanspan 3y ago
Single file, embedded database with similar logical organization
7.
by spanspan 3y ago
It would be a fun exercise to implement something like TPC-C for learndb and see how this done.
8.
by spanspan 3y ago
Cool stuff. I had similar intuitions- Python allow me to focus on the high-level concepts. Albeit, there were times where I wished I had gone with a statically-typed + compiled language.
9.
by spanspan 3y ago
Most definitely. The b-tree implementation was the first motivation for starting the project. Especially, all the details around node rebalancing and splitting. And the fact that it was an on-disk structure, added another wrinkle to the thi
10.
Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python(github.com)
371 points by spanspan 3y ago|77 comments
11.
by spanspan 5y ago
This incomplete tutorial is about how to write a sqlite clone, with particular emphasis on how to implement the underlying b-tree: https://cstack.github.io/db_tutorial/
12.
by spanspan 5y ago
This is really cool. I recently attempted to build a toy database, and subsequently implemented my own b-tree ( https://github.com/spandanb/learndb-py ). I ended up running into a lot of these issues. I also did a write
13.
Show HN: Textwalker, a utility to incrementally parse (semi|un)structured text(github.com)
4 points by spanspan 5y ago|0 comments
14.
Show HN: Ascii_tree – A way to create beautiful ASCII trees(github.com)
79 points by spanspan 7y ago|23 comments
15.
What is Data Engineering(medium.com)
1 points by spanspan 10y ago|0 comments