Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
mozinator
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
mozinator
4y ago
This has been my experience too. Instead of going the logical replication route I tend to leverage the transactional outbox to achieve consistency in the application layer instead. So when I transact data into tables I immediately fetch the
2.
▲
by
mozinator
4y ago
Looked in the source of Materialize and it looks like this is exactly what they are doing. They are using Debezium + Kafka for receiving the WAL changes. And using send the processed WAL offsets back using a Kafka topic to Debezium + Postge
3.
▲
by
mozinator
4y ago
You can achieve consistency using a transactional outbox and "homegrown" solutions the following way. Make sure postgresql is configured with `synchronous_commit = remote_apply` * Create a postgresql logical replication slot which
4.
▲
by
mozinator
4y ago
What you are describing is having the data in elasticsearch in the same format as the data in postgresql. Which is easy. You could also for instance create a script and use a postgresql logical replication connection ( just like Debezium )
5.
▲
by
mozinator
4y ago
The poor man's version of Materialize that I implemented is the following: Step 1) Find all "paths" between tables * Use the postgres information schema to get all relations * Use npm library graph-cycles to see if there are
6.
▲
by
mozinator
6y ago
yes personal phone number. Had to do what it takes... To save the company I work for and all of our customers data. Which all is in Google Cloud!
7.
▲
by
mozinator
6y ago
That makes sense
8.
▲
by
mozinator
6y ago
obviously it was an accident
9.
▲
by
mozinator
6y ago
Exactly after my setIamPolicy API request to Google Cloud was the exact moment everything went down.
10.
▲
by
mozinator
6y ago
edit: added details edit: redacted my phone number edit: big mistake to add phone number edit: I think illic is right, probably not me edit: removed details
11.
▲
by
mozinator
9y ago
Nope, debit card is not allowed
12.
▲
by
mozinator
10y ago
How do jpeg.io's proprietery JPEG optimization algorithms perform compared to JPEG2000, webp or re-jpeg ?
13.
▲
A small fast lisp interpeter for a ESP8266 as alternative to lua on the nodemcu
(github.com)
4 points
by
mozinator
10y ago
|
0 comments
14.
▲
by
mozinator
12y ago
maybe automatically flagged because the word "bro"
15.
▲
by
mozinator
15y ago
There is a good documentary about it for Dutch speaking people http://beta.uitzendinggemist.nl/afleveringen/1094994
16.
▲
by
mozinator
15y ago
So that Microsoft can collect tax on Linux and that SUSE Linux will be the safe choice for people that dont want to be sued by Microsoft ? I dont trust it
17.
▲
Hackers: Wizards of the Electronic Age
(youtube.com)
1 points
by
mozinator
16y ago
|
0 comments
18.
▲
by
mozinator
16y ago
Taskjuggler supports durations http://www.taskjuggler.org/
19.
▲
by
mozinator
16y ago
How long does copyright apply on magazines ? If the magazines are older than xx amount of years they are in the public domain, right ?
20.
▲
by
mozinator
16y ago
You need quicktime.... FAIL!
21.
▲
by
mozinator
16y ago
I would rather have proper 64bit support for linux....