Fork me on GitHub
#sql
<
2018-11-28
>
scriptor18:11:26

are there any sql databases that provide java libraries for easily working with the write-ahead log?

scriptor18:11:10

seems like for most you’d have to use JNI or drop down to C/C++/Rust etc.

kulminaator19:11:27

you mean something else than postgres means with it's WAL log ? 🙂

scriptor19:11:52

nope, just the ability to read from the WAL

kulminaator20:11:51

🙂 why would you want to get your fingers in there

kulminaator21:11:13

there is the test decoder in postgres which may or may be something that you look for https://www.enterprisedb.com/docs/en/10/pg/logicaldecoding-example.html , but it's really hard to guess your usecase 🙂

scriptor21:11:55

the use case is to stream events out of the database based on the transaction log

scriptor21:11:19

could probably do something with triggers, but right now I’m just exploring the options

scriptor21:11:09

the decoder thing is interesting, might be able to rig something up with pg_recvlogical