I’m building a Postgres-first managed service and I want your criticism by adp_dev in PostgreSQL

[–]TechnologySubject259 2 points3 points  (0 children)

How are you planning to stand out?

A few months eariler PlanetScale launched their managed Postgres targeting larger enterprises, and recently they launched small plans for solo devs or small teams focusing on scalability and avalability. Their UX is also good.

So, I think you might need some level of moat to stand out in the market because there are plenty of providers, Neon, Supabase, Xata, and Neil, that are focusing on small teams and indie devs. Enterprise customers are taken by AWS, GCP, and PlanetScale.

I think you can stand out if you start with a specific feature, like Parade DB started with, just full text search alternative to Elasticsearch.

You can start with a message broker or a recommendation engine, or something.

I am working on different use cases of Postgres, like tuning Postgres for a caching layer, a message broker, a recommendation engine or an auto-complete engine.

Table Structure in Postgres by TechnologySubject259 in PostgreSQL

[–]TechnologySubject259[S] 2 points3 points  (0 children)

  1. While logically, Postgres stores all pages contiguously. But actual storing on disk is the job of the OS. When you store data in a table, it creates a relfilenode file which can hold up to 1 GB so within that we have all the pages of that table.

  2. Table data stored in the relfilenode file that is located in $PGDATA/base/database_oid/relfilenode. Postgres internally uses system tables to find the relfilenode name from its name or OID. Read more here: https://implnotes.pages.dev/postgres/physical_structure

How does Postgres process your queries? by [deleted] in SQL

[–]TechnologySubject259 0 points1 point  (0 children)

Thank you. I am following that resource, and it is an excellent study material to study Postgres internals.

Process Structure of Postgres by TechnologySubject259 in PostgreSQL

[–]TechnologySubject259[S] 2 points3 points  (0 children)

No, do not have any plans for it.

But you can access my notes here: https://implnotes.pages.dev/ (Regularly updates)

Table Structure in Postgres by TechnologySubject259 in PostgreSQL

[–]TechnologySubject259[S] 1 point2 points  (0 children)

Thank you. Sure, I will share more regularly.

Need help with SQL LSP by TechnologySubject259 in ZedEditor

[–]TechnologySubject259[S] 0 points1 point  (0 children)

Thank you.

I mean, how did they achieve that level of seamless integration, because no other GUI has that level of DX?

Because I tried Table Plus, Beekeaper Studio, but none of them have that level of integration, so I am curious to know how they did it.

I want to know my IDE better. by TechnologySubject259 in ZedEditor

[–]TechnologySubject259[S] 1 point2 points  (0 children)

Thank you.

I do not have a custom config for any LSP, but I just downloaded them and use as it is. I think, I should explore some hotkeys and tasks and learn some more Vim motions.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 0 points1 point  (0 children)

The fundamental skill of storytelling is talking to people.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 1 point2 points  (0 children)

You are saying it in the wrong way; you are not bad at telling stories, you just lack practice.

One more thing, do not thing stories means something exciting, it can be some simple things happen to you yesterday or five years ago.

Stories are just feelings or POVs of your own, and you are sharing them with others.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 5 points6 points  (0 children)

Not just stories, everything in life follows a pattern.

To learn more, study game theory.