Conversation
Notices
-
Embed this notice
Pissed Hippo (sun@shitposter.world)'s status on Thursday, 01-Aug-2024 02:57:57 JST Pissed Hippo
@volpeon @faoluin SAP database has the world's WORST design -
Embed this notice
Volpeon :drgn_verified: :drgn_smol: (volpeon@is-a.wyvern.rip)'s status on Thursday, 01-Aug-2024 02:58:00 JST Volpeon :drgn_verified: :drgn_smol:
@faoluin@chitter.xyz Oh my fucking god :neofox_googly_shocked:
-
Embed this notice
Softwarewolf (faoluin@chitter.xyz)'s status on Thursday, 01-Aug-2024 02:58:01 JST Softwarewolf
@volpeon I recently-ish ran into a fun problem with one component of SAP while doing some database development. They were using SAP to push some data down into a certain table. We had a foreign key constraint set up to use this table - because, you know, relational database. But we had to delete it because apparently what SAP does is just drop and recreate the table with the data every 24 hours - which means the table can't update if there's a foreign key constraint that's using it.
So, no relationships in your relational database, because SAP says fuck you.
-
Embed this notice
Softwarewolf (faoluin@chitter.xyz)'s status on Thursday, 01-Aug-2024 02:58:02 JST Softwarewolf
@volpeon SAP: Source of All Pain
-
Embed this notice
Volpeon :drgn_verified: :drgn_smol: (volpeon@is-a.wyvern.rip)'s status on Thursday, 01-Aug-2024 02:58:03 JST Volpeon :drgn_verified: :drgn_smol:
At least I understand now why our interface to SAP is generally slow as fuck: It uses RFC_READ_TABLE in a lot of places
-
Embed this notice
Volpeon :drgn_verified: :drgn_smol: (volpeon@is-a.wyvern.rip)'s status on Thursday, 01-Aug-2024 02:58:04 JST Volpeon :drgn_verified: :drgn_smol:
I said the new feature would be done by Monday (this week), but thanks to the power and versatility of SAP and my coworker's quality code, it took me until today
-
Embed this notice