Pratik Gajjar
LightNews LightNews
banner
pratikgajjar.in
Pratik Gajjar
@pratikgajjar.in
43 followers 220 following 19 posts
I love everything backend engineering 🧑‍💻 - 🕸️ backend.how

Engineering Team @yougotfam | @daiict 👨‍🎓| Personal opinions
Posts Replies Media Videos
pratikgajjar.in
What about server side cursor to fetch subsequent rows vs keyset/cursor pagination? www.postgresql.org/docs/current... this should be faster at cost of memory
41.7. Cursors
41.7. Cursors # 41.7.1. Declaring Cursor Variables 41.7.2. Opening Cursors 41.7.3. Using Cursors 41.7.4. Looping through a Cursor's Result Rather than …
www.postgresql.org
May 27, 2025 at 7:27 AM
pratikgajjar.in
Why not alias git=jj ?
May 26, 2025 at 6:58 AM
pratikgajjar.in
What are your thoughts on XMPP vs websocket for chat use case ?
May 18, 2025 at 9:28 AM
pratikgajjar.in
It should've been 7-3, Referee + Big miss. One needs to be 10x better than Madrid to win league.
May 11, 2025 at 10:36 PM
pratikgajjar.in
Pakistan based terrorists attacked once 9/11 at USA, India for past 10yr more than 10 incidents has happened. They just don't f ing stop and actively take action against terrorism. How long one would stay silent, keep up with shit ?
May 10, 2025 at 8:12 AM
pratikgajjar.in
backend.how
Home
Pratik's blog for thoughtful articles on engineering, tech trends, and other insightful topics.
backend.how
May 9, 2025 at 5:05 PM
pratikgajjar.in
😥
May 6, 2025 at 7:54 PM
pratikgajjar.in
Can it be configured on premise instance? With anthropic & gemni api keys ?
March 18, 2025 at 12:32 AM
pratikgajjar.in
Checkout backend.how
Everything Engineering
Pratik's blog for thoughtful articles on engineering, tech trends, and other insightful topics.
backend.how
March 17, 2025 at 9:59 PM
pratikgajjar.in
www.shayon.dev/post/2024/19...

github.com/pgflo/pg_flo
Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
pg_easy_replicate is a CLI orchestrator tool that makes the process of setting up and managing logical replication between PostgreSQL databases a breeze.
www.shayon.dev
March 12, 2025 at 8:08 PM
pratikgajjar.in
Working on problems close to this. Here are the ref that I found helpful.

Integrity
1. sirupsen.com/napkin/probl...
- github.com/datafold/dat...
- www.usenix.org/conference/s...

Replication
- github.com/PeerDB-io/pe...
- PG Man page subscription and publication
- PG Source code & Dbz
Using checksums to verify syncing 100M database records
sirupsen.com
March 12, 2025 at 8:01 PM
pratikgajjar.in
Too expensive
March 5, 2025 at 7:01 AM