|
for fucks sake another afternoon wasted trying to work out what is configured wrong only to find that its actually that visual studio has actually just poo poo all over its temp files and lost the ability to load debug symbols again edit: turns out it was the project settings fffffffuck Powerful Two-Hander fucked around with this message at 16:31 on Sep 6, 2016 |
# ? Sep 6, 2016 15:20 |
|
|
# ? May 25, 2024 15:19 |
|
what if someone wrote a program using only SQL queries?
|
# ? Sep 6, 2016 17:52 |
|
now I've unfucked my solution..... is there a web graphing library that isn't a total pain to use? the default .net mvc one is simple but looks disgusting and chart.js has the usual godawful configuration settings and lovely documentation all javascript libraries seem to love....though it does at least work.
|
# ? Sep 6, 2016 18:06 |
|
Spent a month refactoring shitcode before I could do what I was supposed to do. But then it was easy. Architect basically said "do it you gotta do it this isn't maintainable". Whoa.
|
# ? Sep 6, 2016 18:11 |
|
HoboMan posted:what if someone wrote a program using only SQL queries? I've seen it, and had to rewrite it. Something like 20k lines of bash and stored procs that took an hour to run, replaced with 500 lines of scala that took 10 secs. I'm pretty sure that I posted about it in this thread if you want more details
|
# ? Sep 6, 2016 18:23 |
|
HoboMan posted:what if someone wrote a program using only SQL queries? I've seen dynamic sql "programs" that basically are stored procedures that write their own sql and it had all kinds of weird poo poo. Debugging it was horrible and it was pretty much impossible to maintain because no one really knew how it worked. It had like 40-50 stored procs and several of those were 1000+ lines. Granted, a lot of that was just giant blocks of setting up variables and select params, but it hurts my brain just thinking about it again (that was financial sector stuff, btw)
|
# ? Sep 6, 2016 18:25 |
|
yeah i asked because basically our dba did this. i don't really blame them though, they're a fukkin' dba of course they're gonna want to use sql. i blame the madman who decided to have the dba make "software".
|
# ? Sep 6, 2016 18:53 |
|
Finster Dexter posted:I've seen dynamic sql "programs" that basically are stored procedures that write their own sql and it had all kinds of weird poo poo. Debugging it was horrible and it was pretty much impossible to maintain because no one really knew how it worked. It had like 40-50 stored procs and several of those were 1000+ lines. Granted, a lot of that was just giant blocks of setting up variables and select params, but it hurts my brain just thinking about it again I've done this but only for one specific proc one where it was the 'easiest' way to pivot data from n columns per row to 3 columns of n rows. or it was on whateve sql server version we had. i have heard that there is a team at work that have written an xml import process in sql. unsurprisingly it fucks up all the time
|
# ? Sep 6, 2016 19:26 |
|
Powerful Two-Hander posted:i have heard that there is a team at work that have written an xml import process in sql. unsurprisingly it fucks up all the time hopefully they managed to wrap the whole thing in a transaction and can rollback when it fucks up
|
# ? Sep 6, 2016 19:34 |
|
YeOldeButchere posted:hopefully they managed to wrap the whole thing in a transaction and can rollback when it fucks up code:
|
# ? Sep 6, 2016 19:36 |
|
YeOldeButchere posted:hopefully they managed to wrap the whole thing in a transaction and can rollback when it fucks up ha ha ha, wrong. they insert the data anyway and crash the dependent processes
|
# ? Sep 6, 2016 19:48 |
|
of course it does, why would i expect anything else from a sql db
|
# ? Sep 6, 2016 19:54 |
|
i added transactions to our calling-a-dozen-stored-procedures-for-one-operation poo poo to be in our next release this poo poo is ten years old
|
# ? Sep 6, 2016 19:55 |
|
lol I was assigned to remove the transactions from our calling a dozen stored procedures for one operation poo poo because they don't know what row level locking is
|
# ? Sep 6, 2016 20:04 |
|
suppose for a minute that you're concerned about the performance of pthreads on Windows. "this poo poo's too slow," you think, "probably because it's just an emulation of POSIX threading on Windows threading primitives" how insane do you need to be to then decide "well I guess I'm gonna make a #define cross-compiling library that exposes all the pthreads interfaces on Unix but reimplements them using Windows threading primitives on Windows" like is there a way that this isn't literally just reimplementing exactly the same thing as already exists and you don't like
|
# ? Sep 6, 2016 20:07 |
|
LordSaturn posted:suppose for a minute that you're concerned about the performance of pthreads on Windows. "this poo poo's too slow," you think, "probably because it's just an emulation of POSIX threading on Windows threading primitives" yeah but yours is going to be better, because you wrote it.
|
# ? Sep 6, 2016 20:11 |
|
Finster Dexter posted:I've seen dynamic sql "programs" that basically are stored procedures that write their own sql and it had all kinds of weird poo poo. Debugging it was horrible and it was pretty much impossible to maintain because no one really knew how it worked. It had like 40-50 stored procs and several of those were 1000+ lines. Granted, a lot of that was just giant blocks of setting up variables and select params, but it hurts my brain just thinking about it again dynamic sql is an untyped abomination that belongs exclusively in one-off queries and should never ever touch production in any way, shape or form but don't tar all of sql code with the same brush. often enough you can gain a ton of safety, encapsulation and/or performance by moving some of your logic from application code to triggers, sprocs and views.
|
# ? Sep 6, 2016 20:25 |
|
GameCube posted:yeah but yours is going to be worse, because you wrote it.
|
# ? Sep 6, 2016 20:39 |
|
NihilCredo posted:dynamic sql is an untyped abomination that belongs exclusively in one-off queries and should never ever touch production in any way, shape or form I'm writing dynamic SQL right now at work. It just inserts it as a sproc though so that a human can check it and fill in the bits which require specialised logic.
|
# ? Sep 6, 2016 20:45 |
|
everybody else is an idiot, and i am the best programmer ever. only 3 days into my first job out of school, i could tell that the codebase was a huge piece of crap, and it'd be better if we just started over. i can't believe nobody else ever thought to do that, but i guess that's what makes me the best.
|
# ? Sep 6, 2016 20:51 |
|
in unironic terrible programmer news: someone on my team insisted this morning that any multi-byte characters in our utf-8 encoded xml files should be escaped, in case someone opens the files with the wrong editor and fucks them up. i argued that in the year 2016, that is not something we should be concerned about. which of us is the idiot? turn your monitor upside down to find out. answer: ˙sᴉɥʇ ƃuᴉpɐǝɹ ɹoɟ 'noʎ oslɐ puɐ 'sn ɟo ɥʇoq
|
# ? Sep 6, 2016 20:54 |
|
wouldn't that make a multi-byte characters not display correctly in editors that support utf-8? if so lol
|
# ? Sep 6, 2016 21:02 |
|
Luigi Thirty posted:lol I was assigned to remove the transactions from our calling a dozen stored procedures for one operation poo poo because they don't know what row level locking is simple solution: SET TRANSACTION ISOLATION LEVEL: READ UNCOMMITED always be reading dirty
|
# ? Sep 6, 2016 21:03 |
|
python best languagecode:
|
# ? Sep 6, 2016 21:36 |
|
Barnyard Protein posted:wouldn't that make a multi-byte characters not display correctly in editors that support utf-8? if so lol instead of pre:<fart>Pokémon</fart> pre:<fart>Pok\u00e9mon</fart>
|
# ? Sep 6, 2016 21:38 |
|
Flat Daddy posted:python best language lol up until the last line i was all like "drat that's pretty cool"
|
# ? Sep 6, 2016 21:59 |
|
LordSaturn posted:suppose for a minute that you're concerned about the performance of pthreads on Windows. "this poo poo's too slow," you think, "probably because it's just an emulation of POSIX threading on Windows threading primitives" you just fire up linux on windows and have fast native pthreads
|
# ? Sep 6, 2016 22:10 |
|
I'm mad I can't find anyone to sell me a compact flash card for my apple 2
|
# ? Sep 6, 2016 22:15 |
Flat Daddy posted:python best language I get why this happens, but wow that is surprising behavior
|
|
# ? Sep 6, 2016 22:30 |
|
VikingofRock posted:I get why this happens, but wow that is surprising behavior do tell
|
# ? Sep 6, 2016 22:31 |
|
gonadic io posted:do tell in case you're serious: python's behavior is that all data is passed by reference at all times, but immutable types will make a new instance when you attempt to set them integers are immutable so [x] * y makes a list of y distinct copies of integer x lists are mutable so [a, b, c...] * y makes a list of y copies of a reference to [a, b, c...] then when you subscript the mutable list and its mutable list child to set one immutable member, the correct operation is that the child list should replace the member with a newly-constructed immutable member. it just so happens that ALL the child lists are mutable references to the same data EDIT: I bet I'm wrong about some of the details, like I know l1 = l2; l1 = [] will not delete l2. please pedant the poo poo out of my terrible post
|
# ? Sep 6, 2016 22:40 |
|
Luigi Thirty posted:I'm mad I can't find anyone to sell me a compact flash card for my apple 2 text me
|
# ? Sep 6, 2016 22:45 |
|
Luigi Thirty posted:I'm mad I can't find anyone to sell me a compact flash card for my apple 2 are the CFFA cards really that hard to find now? you could always use a Floppy Emu instead have you seen the dude who's making new TransWarp GS cards? he bought one, sent it to a reverse engineering co in China to get Garber files of the PCB (only $75/layer!) and is now making new cards so people can have a super zoomy IIgs
|
# ? Sep 6, 2016 22:57 |
gonadic io posted:do tell Short version: the list multiplication operator effectively copies by reference for "mutable" types (such as lists), and by value for immutable types (such as ints). So the outer list is just five references to the same inner list. Longer version: Don't think of python as having reference or value semantics, think of it as being more like pointer assignment. So when you say l1 = [1, 2, 3], think of l1 as now "pointing" at [1, 2, 3]. If you then say l2 = l1, l2 will "point" at that same list. If you then say l1 = [], l1 now "points" at an empty list, but l2 is still pointing at the original [1, 2, 3] list. If you then say l2 = l1 again that original list will get garbage collected since nothing is pointing at it. Now l1 and l2 are both pointing at the same empty list. If we say l1.append(0), that modifies the list being pointed at, so now both l1 and l2 will be pointing at a [0] list. This is only for "mutable" types though. For "immutable" types everything is just copied. Or at least that's how I understand it.
|
|
# ? Sep 6, 2016 23:42 |
|
VikingofRock posted:Longer version: Don't think of python as having reference or value semantics, ok VikingofRock posted:think of it as being more like pointer assignment wait, how's that different from having reference semantics? i mean, unless you specifically mean c++ style references that are themselves just immutable pointers, but i don't think that's what "reference" usually means in the general case
|
# ? Sep 6, 2016 23:49 |
|
eschaton posted:are the CFFA cards really that hard to find now? you could always use a Floppy Emu instead oh no, i haven't. nice i could just buy a floppy emu yeah
|
# ? Sep 7, 2016 00:05 |
YeOldeButchere posted:ok I was thinking of it more in the C++ way. If this is how Java does it, than ignore that statement.
|
|
# ? Sep 7, 2016 00:14 |
|
wow both of you really overcomplicated your explanations by trying to introduce a non-existent distinction between immutable and mutable types. the reason all the ints don't change isnt because python is magically making new ints, it's that you're not even trying to modify the ints. you're only modifying the lists. python doesn't have any special concept of immutable types; the only reason things like tuples are immutable is because they don't implement any methods that modify them. Soricidus fucked around with this message at 00:34 on Sep 7, 2016 |
# ? Sep 7, 2016 00:32 |
IS PYTHON BAD? [Y/n]
|
|
# ? Sep 7, 2016 01:51 |
|
|
# ? May 25, 2024 15:19 |
|
y
|
# ? Sep 7, 2016 01:55 |