what is postgre and why does no one talk about pregre

@Felthry (if the first part is also a joke, sorry) PostgreSQL is a... powerful FOSS relational database, sometimes just called postgres. postgresql.org/

Follow

@myst (i'm kind of curious but i don't think we'd understand any details because This Stuff Is Complicated)

@myst (our idea of a database is an array of ordered bytes in memory)

@Felthry @myst It’s not so hard. Consider a database of User entities. Each User is a table. the rows are keys (userID, avatar, accountIsPrivate) and the columns are values associated with the keys (0123, “imageurl.png”, true). Sometimes the keys point to lists, or to IDs identifying other parts of the database. For example, a Comment entity might be a internal numeric ID and its text contents. The value of the comments key of a User might be a list of comment ID numbers.

@Felthry @kellerfuchs So if you have, say, a webapp, you're going to need to handle things like, say, people trying to do two conflicting operations at the same time - like making accounts with the same username. A way to handle this is talking to a networked database, like, in this case, PostgreSQL. It can handle things like what operations actually get to happen and ensure eventual consistency. Postgre's a relational database because the data is stored in tables with relationships to each other - the main alternative, I believe, is things like NoSQL with servers like MongoDB.

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!