pcblues

13 ms·

181.
by pcblues 4y ago
It depends on the use of the database. Where there is intense transactional writes (e.g. case management system, etc.) the CTE approach can easily get locked up, especially if the write queries do a lot of their own lookups. I have come fro
182.
by pcblues 4y ago
Removing CTEs from your codebase by replacing them with the creation of a temp table and then using separate queries with as few joins as possible to populate it will give you low-locking performance hundreds of times better nearly every ti
183.
by pcblues 4y ago
I wonder how many in the crowd are reacting to being labelled antitrans and transphobic unfairly. It's definitely what I see the comedians reacting to.
184.
by pcblues 4y ago
I still think the "Going to Mars" plans are a stepping stone to mining the asteroids. The old book "Future Cities" from 1979 that I read as a kid (I'm 49 and I assume Musk and the other current billionaires did too)
185.
by pcblues 4y ago
"Eating your own shit is never healthy in the long run." However, putting someone else's shit in your butt seems to work wonders. Maybe we just need to replace the internet's AI queue with a stack?
186.
by pcblues 4y ago
Steam could alleviate the new account requirement by having a "cheat" counter. If you do more than, say, five actions that look like a cheat, then a real person on their side looks at the problem. Or, have a cheat counter that wai
187.
by pcblues 4y ago
You nailed it! Language is different in different parts of an organisation or life. A programmer says 'or' to a lay person. A lay person thinks 'xor'.
188.
by pcblues 4y ago
I think this is key to maintainability. Provably maintainable does not equal maintainable in the real world. Unfortunate? For some. When I wrote software in company X I wrote code simply with old idioms so that anyone could understand, step
189.
by pcblues 4y ago
I learned about this sneaking a science stats subject into my arts degree. Fascinating.
190.
by pcblues 4y ago
( Edit: Sorry, not meant to threadjack, I just thought it answered a question that might come next along the line for the poster or others. The answer to the poster's question is "It's withdrawal" Peace and love to you a
191.
by pcblues 4y ago
I'm ok with this. People shouldn't steal prestige by stealing words from other practices. It dilutes the ability to identify quality and truth.
192.
by pcblues 4y ago
Could I be right to say idemslopency is another excuse for a lack of practical and useful experience that gets jobs done? I'm olde.
193.
by pcblues 4y ago
Like any Sandra Bullock movie, I can't tell if I have witnessed the funniest or most achingly sad thing I have ever seen. I like both.
194.
by pcblues 4y ago
I would also try to find a way that didn't involve programming. Less bugs.
195.
by pcblues 4y ago
I love this so much. I know what I should do, and yet my conscience will make my final decision more expensive for the company I work for. Should I be fired for that?
196.
by pcblues 4y ago
"you cannot do everything related to data in SQL. In some cases, you need a traditional programming language to work with the data" Them's fighting words :) But point taken regarding the benefit of modern language tools appli
197.
by pcblues 4y ago
They failed to mention (in either the best or worst column, YMMV) alt.binaries.tasteless and alt.swedish.chef.bork.bork.bork Well, I could have finished uni a lot quicker without knowing about them.
198.
by pcblues 4y ago
I can't (but I will) tell you how much Scorched Earth rocked in the early 1990's at uni. It was a winnable game for people who sucked at xpilot :) Thanks for the mammaries people ;)
199.
by pcblues 4y ago
I dabble in image recognition. I could understand the signage on the back of the truck looked like an overhead sign much further away. This is the sort of whoops, sorry accidents ML will make. I'd still like to see a deaths by people d
200.
by pcblues 5y ago
That's clever and awesome, in the true spirit of hacking.
201.
by pcblues 5y ago
I had a big zip file of all my HPAVC files in one place from the early nineties. Fast-forward to about 2005 when I was working in corp and I needed a Win32 Disassembler for a particular task and I knew where it was. As soon as the still-com
202.
by pcblues 5y ago
I guess my point was that if you are trying to achieve results in a language paradigm that isn't the one the language was designed for, the learning curve is _really_ steep, and to use the declarative features of any language still req
203.
by pcblues 5y ago
Easy if you have an APL keyboard :) (Hint, it's on the 8) https://www.dyalog.com/uploads/images/Business/products/us_r...
204.
by pcblues 5y ago
I have been developing software that includes SQL for twenty years, and watched my own mental progress from misunderstanding to understanding. I found the biggest initial problem is that I used to imagine SQL queries as an imperative langua
205.
by pcblues 6y ago
I play a game called human resource machine. You succeed by implementing algorithms and then try to optimise them for space and time. It reminds me of what I like about programming.
206.
by pcblues 7y ago
Also add another couple of years to efficiently debug with the new tools and environment :)
207.
by pcblues 7y ago
I can type quickly so if i am not sure of the particular precedence rules or syntactic sugar I dont bother because it is quicker to correctly write something a little more verbose than it is to remember a cute language trick that the poor m
208.
by pcblues 7y ago
https://en.wikipedia.org/wiki/Computer_Power_and_Human_Reaso... My favourite cautionary tale of the programming industry. His concerns in 1976 of programmers spiralling into ever deepening efforts to solve their self-m
209.
by pcblues 8y ago
I minimise the impact of unexpected context switches by keeping a running log what I am doing or should do next in a document for each project. It might seem like a waste of time but I can safely mentally let the whole current context go wh
210.
by pcblues 8y ago
For the sake if the original owners I hope he wasn't paid per hour.

More ›