News for hackers. Stuff that matters.

A comment on Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python. Parent comment

Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by devman0 on Sunday August 13, 2023 @05:47PM (#37114862)
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.
[ Parent | on HN ]
Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by fuzztester on Sunday August 13, 2023 @06:08PM (#37115047)
Yes. It's an interesting area, irrespective of implementation language.

I had tried out one or two Java-based RDBMSes back in the day, via programs written in Java, for fun.

I think one was HSQLDB.

https://en.m.wikipedia.org/wiki/HSQLDB

There was also another interesting one called PointBase, which was developed by Bruce Scott, an Oracle founder, and others.

https://en.m.wikipedia.org/wiki/PointBase

[ Parent | on HN ]
Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by gabereiser on Sunday August 13, 2023 @09:29PM (#37116429)
H2 is pretty great and fully supports JSONB and the like [1]. Full java-only RDBMS.

[1]: https://www.h2database.com/html/main.html

[ Parent | on HN ]
Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by p2detar on Monday August 14, 2023 @03:55AM (#37118530)
H2 is pretty solid. I used to ship a product with it as a default database. Customers could optionally use MySQL, MSSQL or Oracle, but for small businesses H2 was more than enough.
[ Parent | on HN ]
Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by fuzztester on Monday August 14, 2023 @01:27PM (#37123824)
Thanks, sounds worth checking out.
[ Parent | on HN ]
Re:Show HN: I wrote a RDBMS (SQLite clone) from scratch in p... by lopatin on Monday August 14, 2023 @08:33AM (#37120299)
H2 has quite heavy use in production too. For example Apache Ignite uses it as the core of it's distributed SQL engine. Ignite takes a distributed SQL query and splits it up into single node queries, which are executed on each node by H2, and then Ignite merges the results back.
[ Parent | on HN ]