lvogel

9 ms·

1.
by lvogel 1y ago
That's just my age showing, I guess. For me, all 2.5D shooters are DOOMlikes. I was actually first thinking about calling it a Quake-like since IMHO that is much more well known for its multiplayer, but then I never got around to imple
2.
by lvogel 1y ago
Love that you liked it! Your project was the inspiration and showed me the insanity was actually feasible :D
3.
by lvogel 1y ago
Yea, I actually thought of the viability of SQL for games while working on DOOMQL. It's just so easy to express a lot of game logic in SQL queries. As an avid OSRS player I was thinking about doing a simple MUD/MMO next. Thanks
4.
by lvogel 1y ago
If you want to take a look at the source code, here's the repo! https://github.com/cedardb/DOOMQL
5.
Building a DOOM-like multiplayer shooter in pure SQL(cedardb.com)
255 points by lvogel 1y ago|39 comments
6.
Tailored Code Generation for Every Database Query(cedardb.com)
1 points by lvogel 1y ago|0 comments
7.
by lvogel 2y ago
The version is just an atomic integer assigned to that btree node which is monotonically increasing. Each writer increases the version when it releases the lock IF it has modified the node. Wraparounds are only a theoretical issue. There wo
8.
To B or not to B: B-Trees with Optimistic Lock Coupling(cedardb.com)
2 points by lvogel 2y ago|0 comments
9.
Why German Strings Are Everywhere(cedardb.com)
35 points by lvogel 2y ago|4 comments
10.
by lvogel 2y ago
Tell me about it... Was just too expensive compared to flash. But the tech was definitely awesome and I hope it'll come back in one way or another. When designing CedarDB, we recently had multiple instances where we thought: "If
11.
by lvogel 2y ago
> Ultimately, a reliable non-volatile write cache, sized for your workload is the answer. Author here, I agree! It's quite sad that we need such an involved solution to offset the inherent complexity of the flash medium (latency spi
12.
by lvogel 2y ago
Yes, the way it is currently implemented, the build side has to fit into RAM. There is no inherent reason we couldn't also spool to disk, but we haven't implemented that yet.
13.
by lvogel 2y ago
Depends on your use case. Redis is a key-value store that is optimized for simpler workloads and is designed as a caching layer. Umbra, on the other hand, is a full fledged, ACID compliant relational database systems with all bells and whis
14.
by lvogel 2y ago
Yes, we do use io_uring
15.
by lvogel 4y ago
all VLDB papers are also completely open access. You can find e.g. last year's papers here: http://vldb.org/pvldb/volumes/15 .
16.
Mosaic: A Budget-Conscious Storage Engine for Relational Database Systems [pdf](vldb.org)
2 points by lvogel 6y ago|0 comments