Conversation
Notices
-
Embed this notice
Sick Sun (sun@shitposter.world)'s status on Thursday, 01-Aug-2024 02:57:57 JST Sick Sun @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