Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

LearnDB: Learn how to build a database

learndb.net

Post reply on HN
Print view View original

1–10 of 56 posts

Re: LearnDB: Learn how to build a database

#3

Post by johan_larson »

dominotw wrote: post #2

I realized how little i knew about how databases work until I watched this lecture series. https://www.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA Does anyone have DB internal book recommendation that inst' boring as hell.

You might try this collection of papers about DB technology.

http://www.redbook.io/

Fair warning: this is not for beginners. If you find the going too hard, start with a DB textbook.

Also, that site doesn't seem to include the papers themselves. But most of those papers are very famous, so if you search for the titles, you should find copies. Worst case, you might need to visit a university library.

Re: LearnDB: Learn how to build a database

#4

Post by rodw »

For complicated reasons I was involved in a successful project to develop an open-source, Oracle-SQL-compatible, transactional-integrity-preserving, extensible database designed for in-memory performance in Java. In the process of this development "suddenly" the reasons for a whole bunch of performance and syntax oddities in databases like Oracle and PostgreSQL became very clear.

I was shocked to learn that was 15 years ago when I looked up the link to share, but if you are interested in the topic of "how to implement a database" it may be worth a look.

For what it is worth it was listed (not by me) on the C2 Wiki on the "Programs to Read" Page, where it was described as "[A] database written in Java with good unit tests and ShortMethods." [1]

Both statements are true, for a complete working example of a production database (it supported a commercial product for at least 10 years) it is actually a pretty accessible and well documented code-base.

The project is called AxionDB and can be found at [2].

[1] http://wiki.c2.com/?ProgramsToRead [2] http://axion.tigris.org/source/browse/axion/

Re: LearnDB: Learn how to build a database

#6

Post by capkutay »

Mr_P wrote: post #5

How is this #2 on Hacker News? There's literally nothing here about how to actually build a database (yet?) Instead, there's just a key-value store implemented on top of a javascript hashmap and a filesystem.

This has to be a joke? This looks more like 'how to use a k-v store 101 for non programmers'

I don't want to put more content under a terrible post, but the best resource for this material Jennifer Widom's MOOC.

https://cs.stanford.edu/people/widom/DB-mooc.html

Re: LearnDB: Learn how to build a database

#8

Post by sethammons »

rodw wrote: post #4

For complicated reasons I was involved in a successful project to develop an open-source, Oracle-SQL-compatible, transactional-integrity-preserving, extensible database designed for in-memory performance in Java. In the process of this development "suddenly" the reasons for a whole bunch of performance and syntax oddities in databases like Oracle and PostgreSQL became very clear. I was shocked to learn that was 15 ye…

Could you provide some examples of oddities?

Re: LearnDB: Learn how to build a database

#9

Post by Denzel »

rodw wrote: post #4

For complicated reasons I was involved in a successful project to develop an open-source, Oracle-SQL-compatible, transactional-integrity-preserving, extensible database designed for in-memory performance in Java. In the process of this development "suddenly" the reasons for a whole bunch of performance and syntax oddities in databases like Oracle and PostgreSQL became very clear. I was shocked to learn that was 15 ye…

Do you have any more details on “the reasons” for the performance and syntax oddities?

Re: LearnDB: Learn how to build a database

#10

Post by dymk »

Why would a pedagogical project choose JavaScript of all languages?

Unless the project specifically needed to leverage features of the language, or a web browser, it's an incredibly poor choice for building anything with well maintained abstractions. Or anything at all ready, when the language is covered in warts.

I imagine the author hasn't yet discovered for themselves why it's a poor choice, given only a key-value store has been implemented (using JSON.stringify, no less)

Post reply on HN