Egregoros

Signal feed

Ignas Kiela

@ignaloidas@not.acu.lt

I do in fact exist

I'm an information sponge, so if you have some question that you think I might have an answer to, feel free to ask! Even if I won't have it off my head, I know how to look up things fast.

Posts

Latest notes

@sun@shitposter.world @feld@friedcheese.us ok, I understand it with oracle because of it's toxic licensing

But like, I've rewritten a whole bunch of stored procedures - e.g. from postgres to mssql and then back to postgres after some changes while it lived in mssql. Was fine.

And yes, if you put all of it in stored procedures, you're gonna have a bad time migrating (guess why oracle wants you to use them so much), but as I said, you should have either small ones for consistency, or large ones for large transformations/analytics. The first case is easy to rewrite because small, the second case is a pain either way because the alternative is just having all of the sql in some script or whatever and you're gonna have to rewrite it either way.