avg_dev

thanks,

here are a couple of links to the course:

https://smartphonehowto.com/gift/ - "Save time & help your loved ones" - for people who might want to introduce this course to someone they know

https://smartphonehowto.com/ - "Stay connected with family and friends" - for people who might want to take this course

i did take some issue with the way that point was phrased as well.

but, i took it a little more broadly than it was actually specified: people who are not great about communicating or make it hard for you to work with them at the outset will probably continue to be like that throughout the entirety of your working relationship.

i watch some videos on the Tested youtube channel, where the host is Adam Savage, who was one of the hosts/creators of the MythBusters tv show, and he often talks about this point, and how he learned it working with Jamie Hyneman early on in his career where they would take clients, and Jamie explained this principal.

i do think these are good habits. my favorite is the one about type #3 of tech debt. i wish i could push a button and impart this way of thinking to many of my old coworkers.

(and, there is some room for taste/interpretation/etc. i think the thing about copy-paste and "the third time it's in the code, encapsulate it, and deal with flag params later" is maybe true and maybe not true and may be context or team dependent. i know i have done this a few times and if i am trying to cover that func with tests, the complexity of the test goes up fast with the number of flags. and then sometimes i wonder it is even worth writing these tests when the logic is so dead simple.)

This linter tool checks a schema for those issues: https://www.npmjs.com/package/schemalint (it is linked from the doc itself, too). It is kind of handy.

i agree; but i use caps in my codebase, and lowercase when testing things out manually, just for ease of typing.

this is really nice. i am glad the author put it together. i didn't know the pg docs were 3200 pages long! i have been using it for a while and try to learn as i go. i really do like the docs. and i also like to read articles on various particular subjects as i find a need to.

i think the author might find it helpful to readers to add a note to https://challahscript.com/what_i_wish_someone_told_me_about_... that if someone is selecting for b alone, then an index on columns (b, a) would work fine. i think this is kind of implied when they talk about selecting on a alone, but maybe it wouldn't hurt to be extra explicit.

(i didn't spend much time on the json/jsonb part since i rarely use that stuff)

pretty informative. now i understand why people are often having issues with vacuum-related stuff. i like the diagrams too.

for my area code, some of the sysops have left commentary on the directory page that lists the numbers. also, i used to log in to many of them.

here is one nice site http://bbslist.textfiles.com/

i don't think i've done a bait and switch and generally don't actually know what you mean by saying that i have done so. my point in that sentence was simply that nothing is promised by life. society does have norms and people do have values. i never said that i don't understand (nor did i intend to imply or portray that i don't) why people would act in ways that are not to, or hurt, "the common good". it is clear why someone who doesn't feel like their life is comfortable when they are trying to better "the common good" would act against that same common good in order to get some peace or enjoyment out of their own existence.

yes, this. as others have pointed out: of course it is (understatedly) terrible that so many people who work various types of jobs cannot pay their bills. all that i see happening here is that the low income bar for being able to survive and live a decent life is getting higher and higher; it is not that there are not many others who also should be able to live a decent life.

(and yes, i do understand the difference between a lecturer and a professor, and i do understand about roommates, and i do understand about living in a cheaper cost-of-living area. i think these are all reasonable points. but i still think that it would be nice if someone could live a good life a distance from work that doesn't make their commute an absolute dread and still be able to afford basic things. yes, i believe everyone deserves this, no matter what type of work that they do. no, i don't think that's the direction we are currently headed.)

Of course you are correct, nobody is ever promised anything like the ability to fulfill their dreams or to live a decent quality of life. But maybe the universities could pay them a living wage for teaching six classes a week.

a beautiful post. it's really nice when we get posts like this here, just personally i find it very meaningful.

> But sometimes the employees there would give me the employee discount, I guess they realized I needed it.

that is such a heart-warming thing.

i would maybe argue the following point in the article:

> People whose work was not aimed at me in the slightest.

idk. i think that part of the point of being open is being open to possibilities. obviously no one can see the far-reaching consequences of their work when they set out to do it. but sometimes, people have hopes, i think, that their openness will create possibilities just like this article is describing.

> resources like w3schools,

i remember a long time back - maybe 15 years ago - i would occasionally read w3schools, and i had a coworker who would kind of turn up their nose at that site, they were kind of a snob about it. i knew enough then to realize it wasn't the best site for everything but out of insecurity after that person said that, i stopped reading it too. but it helped me, too. and i'm glad it helped you. i am starting to re-revise my opinion of that site.

this seems like a fantastic way to look back on a career where the author started as a prolific solo developer and later became an effective, fast, and contributing part of an effective development team. it was also just really fun to read, about the code reuse, the scrapping of ideas, the rewrites, etc.

while i have only ever worked at places that do some form of agile development, sometimes i think about things that are just foundational elements. to be pedantic, they definitely work. they just, on their own, do not provide any utility. just a means to facilitate things to be constructed later on in development.

in particular i think of Black Triangles https://rampantgames.com/blog/?p=7745 which has been discussed here previously.

> Or computing becoming a branch of advertising.

wow. such a succinct way of putting it. ugly too. and probably at least mostly truthful.

Very nice read. I remember reading the one she wrote first too. Quite moving.

it was a good read. but i also note the date on it is Dec. 2021. perhaps things have changed (i have no idea). i do think it is a risky business to change your car's interface with an update!

I believe I remember reading that for merging branches to the Postgres project, you need to update the docs too in order to pass code review. A nice way of doing it, I thought. Pg has some great docs that I have been reading for some years.

Just noting, the commenter you replied to said:

> use “bigint generated always as identity” instead of bigserial.

The commenter you are replying to was not saying anything about whether to use UUIDs or not; they just said "if you are going to use bigserial, you should use bigint generated always as identity instead".

also, you can view the original report here: https://www.goldmansachs.com/intelligence/pages/gs-research/...

"generative AI" seems to be covered from pages 3-24 inclusive.

you know, i think this skill can be learned. i used to definitely have very little ability to "bridge sensory modalities", but i've been studying music and performance as a hobby somewhat seriously for about 6 years now. and i now feel like i have much more of that ability than i did before. i probably had it as a kid, just as you were saying, but i am definitely well into adulthood now :)

(there is a radio program i listen to where the guy talks about the music he plays and the context and he explains many things in this sort of "bridging sensory modalities" sort of way. and i used to always think, "that is just some straight up nonsense that he is saying." but now, i often see what he is saying very literally...)

very fun article. What is a PHY?

you're giving your fellow programmers way too much credit. most people will never bother doing that.

That article links to the actual paper, the abstract of which is itself quite readable: https://dl.acm.org/doi/pdf/10.1145/3613904.3642596

> Q&A platforms have been crucial for the online help-seeking behav- ior of programmers. However, the recent popularity of ChatGPT is altering this trend. Despite this popularity, no comprehensive study has been conducted to evaluate the characteristics of ChatGPT’s an- swers to programming questions. To bridge the gap, we conducted the first in-depth analysis of ChatGPT answers to 517 programming questions on Stack Overflow and examined the correctness, consis- tency, comprehensiveness, and conciseness of ChatGPT answers. Furthermore, we conducted a large-scale linguistic analysis, as well as a user study, to understand the characteristics of ChatGPT an- swers from linguistic and human aspects. Our analysis shows that 52% of ChatGPT answers contain incorrect information and 77% are verbose. Nonetheless, our user study participants still preferred ChatGPT answers 35% of the time due to their comprehensiveness and well-articulated language style. However, they also overlooked the misinformation in the ChatGPT answers 39% of the time. This implies the need to counter misinformation in ChatGPT answers to programming questions and raise awareness of the risks associated with seemingly correct answers.

Interesting take.

I was having a discussion about databases and SQL with some coworkers and I want to get a chance to argue for using that as opposed to an ORM that generates some generic query functions. I feel like doing it the “hard and unintuitive” way will require more work and also allow for much finer-grained control and the ability to tweak queries and get into the details of indexes and execution plans, which can be important at some points. And there is no worrying about the quality or correctness of generated code.

At the same time I have been largely impressed with the thought that as developers we need a continuing and life-long lesson in empathy. Ask a non-daily computer user, maybe a senior citizen, to start making appointments and dealing with logistics online and see the result. And what if the person in question cannot afford a cell phone? Or a smart one with a web browser built in? Are we to leave such people behind? And what of accessibility? Of literacy or language fluency?

These issues are - to me - all tied up. There are no easy answers and as with all practical things there will be decisions and tradeoffs made.

But I think it is definitely worth thinking about.

Here is another article with different ideas on the subject: https://news.ycombinator.com/item?id=35589176

[deleted]

never heard of this before. I looked it up https://en.wikipedia.org/wiki/Token_bucket

I think this would be like a firewall or ingress thing that would drop packets that resulted in excess load before they make it to the application server.

> But in 9 years, that was the only time she did it while I was sleeping.

... that you know of