I felt this in my teeth.
Lemme lean into this a little harder: JIRA is what companies buy when they should have invested in manager training five years ago.
@mhoye very curious about this because I can’t tell if you mean jira in particular or bug tracking systems in general.

@bsmedberg Every project needs issue trackers, but describing Jira as an issue tracker is like describing McDonald's as a restaurant. It's a organizational culture and language least-common-denominator normalization tool whose endpoint happens to resemble an issue tracker.

A well-functioning issue tracker is a core part of making an org visible and legible to itself; adopting a tool that forces every part of an org to speak the same operational language is the lowest-trust path to that goal.

@mhoye @bsmedberg #PostgreSQL doesn't use any bug tracker. There's only a mailing list.
Seems to work pretty well in the last 26 years.
@sjstoelting that's interesting. On the other hand, what works for one org may not work for others. I'm not defending Jira, it's a pile of trash. But, email for issue tracking / project management is (to me) as bad as Jira 😦
@oliver @sjstoelting But how do you manage priorities, manage bug state (proposal, in progress, verify, complete, etc), etc? Just replying to an issue helps keep track everything about the issue, but not within its ecosystem. Curious how you do that per release. There’s got to be another doc keeping track of it, no?

@oliver @sjstoelting This reminds me a conversation I had 20 years ago with a certain VP that hated DBs with a passion. A really, deep hatred I might add. He suggested storing data in plists (property lists) and index them separately. I wish I was joking, but sure as heck I’m not. That pushed me to write one of the first SQLite wrappers in Objetive-C in early 2002.

The man is brilliant, trust me, but this serious suggestion threw me for a loop.

True story.

@titociuro @oliver PostgreSQL has an extension for this: hstore
https://www.postgresql.org/docs/current/hstore.html

Developing failures that other people had already solved is stupid.

F.18. hstore — hstore key/value datatype

F.18. hstore — hstore key/value datatype # F.18.1. hstore External Representation F.18.2. hstore Operators and Functions F.18.3. Indexes F.18.4. Examples F.18.5. …

PostgreSQL Documentation
@sjstoelting @oliver Geez… is there *anything* Postgres doesn’t have?! 🤣 When will it make Cappuccinos? 😉

@titociuro @oliver A bit more fun facts:
The first .net provider hasn't been M$ SQL Server, it's been PostgreSQL.

And there is a foreign data wrapper to read from and write to Sqlite: https://github.com/pgspider/sqlite_fdw

GitHub - pgspider/sqlite_fdw: SQLite Foreign Data Wrapper for PostgreSQL

SQLite Foreign Data Wrapper for PostgreSQL. Contribute to pgspider/sqlite_fdw development by creating an account on GitHub.

GitHub

@titociuro @oliver It's very well documented. PostgreSQL has a thing called CommitFest https://wiki.postgresql.org/wiki/CommitFest_Checklist?ref=timescale-blog

A list of previous and coming CommitFests can be found here: https://wiki.postgresql.org/wiki/CommitFest_Checklist?ref=timescale-blog

This is for new features. Bug fixes are done on email lists.

CommitFest Checklist - PostgreSQL wiki

@sjstoelting @oliver Amazing. Such detail! My hat off to you, team.

@titociuro @oliver @sjstoelting There is no such thing, as far as I'm aware. People work on something, or they don't.

Companies might prioritize this internally, and have people work on this, using their internal tools. Which may or may not end up in upstream.

@ascherbaum @oliver @sjstoelting Right, but what if there some dependencies? That is, some prior work that needs to be completed before another task can happen? Just trying to understand how something as massive as Postgres can be managed via email/mailing list alone. Fascinating!
@titociuro @oliver @sjstoelting Done you dive into a long discussion on -hackers!