[TiDBer Chat Session 37] The Blood and Tears History of Various Databases (Part 1), This Time Let's Just Have a Rant Session!

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【TiDBer 唠嗑茶话会 37】各种数据库的血泪史(之一),这期我们不聊别的,就来一次吐槽大会吧!

| username: Billmay表妹

This Topic:

The Blood and Tears History of Various Databases, Today We Want to Hear About the “Bizarre” Things You’ve Encountered~


Here, you can talk about everything you want to say but dare not, and vent all your frustrations~


Sometimes venting is to relax,

Letting out pent-up anger, grievances, and hostility is more beneficial for mental and physical health~

Some things, if not told to others, are feared to be misunderstood and not empathized with~

So let’s huddle together for warmth!

Origin of the Topic

This topic probably came from a casual chat in the group on Monday~

For example, reporting in PPT feels like a chicken talking to a duck~

image

For example, the time spent preparing the report is longer than the actual work time

image

For example, a casual remark can cause many colleagues to spend a lot of time and effort to complete~

And I’ve heard of even more bizarre things~

image

Want to hear, @DataXiaoHei

Event Rewards:

Participation Reward Points 50

Event Time

2022.09.02-2022.09.09

| username: xfworld | Original post link

From time to time, I see various articles praising PG, but after asking around my circle of friends, very few are using it… To this day, it remains quite niche.

Some time ago, I took over an overseas application, and the database was PG. I spent a month learning it… and found many pitfalls…

| username: Kongdom | Original post link

Is anyone still using Access databases?

| username: cs58_dba | Original post link

PG looks great in theory, but reality is harsh.

| username: xingzhenxiang | Original post link

The online environment of SQL Server is very intense, and it’s really difficult to find a way to handle issues with Always On.

| username: ShawnYan | Original post link

Removing “O”, what exactly was removed?

| username: Kongdom | Original post link

:wink: What a coincidence, we’re using it too~

| username: TiDBer_jYQINSnf | Original post link

A certain database vendor claimed their product is superior by saying TiDB loses data :pensive:, but they couldn’t provide any evidence, just saying it loses data. They also said TiDB is no longer viable and many companies are planning to abandon it :pensive:. Furthermore, they claimed TiDB is going to give up on the domestic market :relieved:. Hearing this makes me really angry, but since I don’t know the inside story, I can’t debunk the rumors :man_shrugging:.

| username: Billmay表妹 | Original post link

It’s okay, many people see TiDB as a competitor, which means they acknowledge us. We should be happy about that.

| username: TiDBer_jYQINSnf | Original post link

It might be like with smartphone manufacturers, where every phone is said to be better than Apple’s. :grin:

| username: db_user | Original post link

Deleting data in MongoDB and reclaiming disk space is quite problematic.

| username: ddhe9527 | Original post link

After switching from Oracle to MySQL, I realized that the Oracle database is very robust, while the MySQL database is like a fragile chicken; a few slow queries can max out the CPU.

| username: TiDBer_pFFcXLgY | Original post link

GP is not good to use in various ways.

| username: wuxiangdong | Original post link

Previously, I used proxy+db with MySQL. The proxy was written in Java, a tool called cat, for read-write separation, but the performance was not good. I switched to another proxy, and the QPS was acceptable.

| username: 张雨齐0720 | Original post link

I found a slow SQL, and it’s too late to add an index. I want to disable this SQL, but currently, there are basically no means to disable a specific SQL.
Migrating from Oracle to MySQL without downtime is too difficult.

| username: TiDBer-s | Original post link

Could you elaborate?

| username: 数据小黑 | Original post link

You know, it’s 2202, and we’re still needing people, resources, and downtime to upgrade our dozen MySQL instances. Sigh, want to hear something even more shocking? We have a PostgreSQL training that requires us to take six days off to attend. Do you know how many people I’ve cursed in my mind?

| username: Hacker007 | Original post link

I found that as a developer, I can’t integrate with you DBAs…

| username: Kongdom | Original post link

Development +1