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