SimpleDB: A Basic RDBMS Built from Scratch • Hacker News Board

Re: SimpleDB: A Basic RDBMS Built from Scratch

#21

Post by hackthesystem » Tue, Feb 01, 2022, 4:58 AM UTC

java-man wrote: post #3

This is great! Could you please clarify the license for your code? Thanks!

Thanks! Just added the MIT license

Re: SimpleDB: A Basic RDBMS Built from Scratch

#22

Post by hackthesystem » Tue, Feb 01, 2022, 5:11 AM UTC

nstart wrote: post #18

A quick question about the MIT course this student followed[1]. Am I correct in assuming that the way to follow this course would be to take the lecture notes, the assigned reading material, and simply read it before then moving on to the assignments? Just wanted to make sure I'm not missing some video/other content before I take a look into this stuff. [1] https://ocw.mit.edu/courses/electrical-engineering-and-compu…

I think that is the recommended approach, but I just read the lecture notes and started working on the assignments. I tried to prioritize coding because it helps me retain knowledge better over time

Re: SimpleDB: A Basic RDBMS Built from Scratch

#23

Post by hackthesystem » Tue, Feb 01, 2022, 5:14 AM UTC

eatonphil wrote: post #4

Nice work! In my experience adding (basic) support for indexes shouldn't be too hard [0]. And good choice to support transactions up front. Adding that in later is pretty challenging. Mine doesn't support transactions and refactoring to support it would take a while. :( If HN-ers are interested in more database Internals content check out /r/databasedevelopment too. [0] https://notes.eatonphil.com/database-basics-ind…

Thanks! I do plan on adding indexes soon

Re: SimpleDB: A Basic RDBMS Built from Scratch

#24

Post by hackthesystem » Tue, Feb 01, 2022, 5:18 AM UTC

HappyJoy wrote: post #11

Hey, this is really great. Fun fact - there is another SimpleDB also written in Java [1]. The book (out of print I think) is a good read. [1] http://cs.bc.edu/~sciore/simpledb/

Thank you! I'll be sure to check out the book

Re: SimpleDB: A Basic RDBMS Built from Scratch

#25

Post by timmit » Tue, Feb 01, 2022, 5:40 AM UTC

Nice work.

The only one comment to add is

Amazon has an Amazon SimpleDB.

So different name might be before for your branding.

Re: SimpleDB: A Basic RDBMS Built from Scratch

#26

Post by [deleted] » Tue, Feb 01, 2022, 5:44 AM UTC

[deleted]

Re: SimpleDB: A Basic RDBMS Built from Scratch

#27

Post by t8y » Tue, Feb 01, 2022, 5:55 AM UTC

HappyJoy wrote: post #11

Hey, this is really great. Fun fact - there is another SimpleDB also written in Java [1]. The book (out of print I think) is a good read. [1] http://cs.bc.edu/~sciore/simpledb/

Is that book what this course is based on?

Re: SimpleDB: A Basic RDBMS Built from Scratch

#28

Post by ryanlpeterman » Tue, Feb 01, 2022, 5:59 AM UTC

I learned a lot from your post, thanks for writing!

Re: SimpleDB: A Basic RDBMS Built from Scratch

#29

Post by ddlutz » Tue, Feb 01, 2022, 6:03 AM UTC

HappyJoy wrote: post #11

Hey, this is really great. Fun fact - there is another SimpleDB also written in Java [1]. The book (out of print I think) is a good read. [1] http://cs.bc.edu/~sciore/simpledb/

I thought for sure that this post was about this simpledb.

Re: SimpleDB: A Basic RDBMS Built from Scratch

#30

Post by hackthesystem » Tue, Feb 01, 2022, 6:41 AM UTC

nivertech wrote: post #2

There is already Amazon SimpleDB database service[1] written in Erlang, but it's kind of deprecated in favor of Amazon DynamoDB. [1] https://aws.amazon.com/simpledb/

Ah yes, by the time I realized this it was too late to rename unfortunately. And very neat how Amazon SimpleDB is written in Erlang!