Live data from Hacker News

Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

github.com

1–10 of 82 posts

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#2
Okay this seems like the perfect project to test out the various AI repo update solutions. Anyone want to do this for fun, you can have your own agenda, I'm just bored!

https://github.com/paul-gauthier/aider https://www.mentat.codes/ https://www.gitwit.dev/ https://www.second.dev/

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#4
This is fantastic, and seems like a great way for someone (me) to learn DS&A better. I can explain how a B+tree works, but if you asked me to code it, I’d freeze up.

I love databases and Python, so this was really interesting to walk through. Thanks for the post.

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#5
Thank you for sharing

My perspective is that writing this kind of system in a language such as Python is actually a great thing because for myself Python is more widely readable and approachable compared to C++ or C which is what databases are often programmed in. If someone wants to be serious they can port it to a low level language . As it stands it's educational and useful for studying.

I wrote a distributed pseudo multi model SQL/graph Cypher/Document and dyanmodb style database in Python https://GitHub.com/samsquire/hash-db for the same goal of learning how database engines could work in a distributed way.

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#6
post #4

This is fantastic, and seems like a great way for someone (me) to learn DS&A better. I can explain how a B+tree works, but if you asked me to code it, I’d freeze up. I love databases and Python, so this was really interesting to walk through. Thanks for the post.

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 thinking about the impl

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#7

Kudos, i bet that was a fun and rewarding experience. I know this was never meant to be fast, but could you produce some benchmarks for shits and giggles?

Off topic but do you know of any good resources/talks/blog posts that cover how to create useful benchmarks?

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#8

Thank you for sharing My perspective is that writing this kind of system in a language such as Python is actually a great thing because for myself Python is more widely readable and approachable compared to C++ or C which is what databases are often programmed in. If someone wants to be serious they can port it to a low level language . As it stands it's educational and useful for studying. I wrote a distributed pseu…

This is why you see a community of pure Java RDBMSs (Hypersonic, H2, Derby, etc), if you don't need the big iron scale it's easier to ship/use the database or even embed it in memory if needed.

Re: Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

#9

Kudos, i bet that was a fun and rewarding experience. I know this was never meant to be fast, but could you produce some benchmarks for shits and giggles?

Off topic but do you know of any good resources/talks/blog posts that cover how to create useful benchmarks?

Not OP, but Brendan Gregg has written a lot about performance and benchmarking.

* https://www.brendangregg.com/activebenchmarking.html

* https://www.brendangregg.com/blog/2018-06-30/benchmarking-ch...

Post reply on HN