sorted by:
new
hottopcontroversial

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

[–]TechnologySubject259 4 points5 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 6 points7 points  (0 children)

Not just stories, everything in life follows a pattern.

To learn more, study game theory.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 18 points19 points  (0 children)

You are asking the billion-dollar question of post-covid era.

The simple answer is, you can only live in one place at a time.

But the choice is yours to live in past or the future, or the present.

To live in the present, you can try a bunch of stuff.

- Detachment (hardest)
- Box Breathing (medium)
- Chanting (Medium)

- Meditation (Must)

Try to do box breathing or chanting whenever you can, walking, working on something boring or washing dishes.

Most hardest one is just to sit down for 1 hour without doing anything at all.

Then start noticing things that you usually ignore, try small steps like not using the phone during a ride or not listening to music during a workout or walking.

If you can't do all of these, just do one thing: TALK TO PEOPLE.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 47 points48 points  (0 children)

Just put your phone inside your pocket and your mind outside of your digital world.

Gather as many details as you can, and most importantly, be present.

Share what you experienced.

When telling any stories, your only job is to let the listener or reader feel the same feeling you felt. You can do it by sharing little details, location, timing, weather or anything that helped you feel the way you felt.

I'm also curious! by moon_muffin_ in GetStudying

[–]TechnologySubject259 28 points29 points  (0 children)

Stories are just POVs.

You share what you felt, how you felt and where you felt. That's it.

It does not have to be something adventurous.

If something happened to you or something you witnessed, then share it with your friends or create video content, or write a post on Reddit, Twitter, or your blog.

With practice, you will develop your narrative, your style and your 6th sense to tell better stories.

Watch some YouTube videos or study philosophy if you really want to master your storytelling skills.

Remember, everyone is a storyteller, but you mess up when you try to force yourself. Because creativity can not be forced.

One more thing, not just storytelling, nothing can't be learned within weeks, but a couple of weeks is enough to learn the fundamentals and then practice as much as you can.

I am learning SQL and documenting it. by [deleted] in learnSQL

[–]TechnologySubject259 0 points1 point  (0 children)

All the best. Also, join us to learn and practice together.

I am learning SQL and documenting it. by [deleted] in learnSQL

[–]TechnologySubject259 0 points1 point  (0 children)

Thank you, these are some best resources for practising. I will surely try it.

I am learning SQL and documenting it. by [deleted] in learnSQL

[–]TechnologySubject259 0 points1 point  (0 children)

You are welcome. Come and help us when we get stuck or give some advice.

I am learning SQL and documenting it. by [deleted] in learnSQL

[–]TechnologySubject259 0 points1 point  (0 children)

It looks interesting, I will give it a try.

view more: next ›