• Activity
  • Votes
  • Comments
  • New
  • All activity
    1. Fortnightly Programming Q&A Thread

      General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads. Don't forget to format your code using the triple...

      General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

      Don't forget to format your code using the triple backticks or tildes:

      Here is my schema:
      
      ```sql
      CREATE TABLE article_to_warehouse (
        article_id   INTEGER
      , warehouse_id INTEGER
      )
      ;
      ```
      
      How do I add a `UNIQUE` constraint?
      
      6 votes
    2. What’s a mistake many people do not know they are making?

      Any answer in any scope is fair game: can be something very minor or something quite significant. It can be very domain-specific or very general. Also the goal of the thread isn’t to judge people...

      Any answer in any scope is fair game: can be something very minor or something quite significant. It can be very domain-specific or very general.

      Also the goal of the thread isn’t to judge people for their mistakes but more just highlight some common errors in hopes of bringing more awareness to them.

      30 votes
    3. What programming/technical projects have you been working on?

      This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's...

      This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

      14 votes
    4. What did you do this weekend?

      As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their weekend. Did you make any plans? Take a trip? Do nothing at...

      As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

      7 votes
    5. Much ado about title case

      I've noticed some people making a point of editing titles on articles to either impose or undo title case on articles. I dug around a bit and haven't been able to find any style guide suggestions...

      I've noticed some people making a point of editing titles on articles to either impose or undo title case on articles. I dug around a bit and haven't been able to find any style guide suggestions on the matter.

      Barring some kind of official stylistic standards being laid down, that I'd like to respectfully request that curator roles refrain from overruling a submitter's formatting choices without good reason.

      26 votes
    6. What did you do this week?

      As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do...

      As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

      8 votes
    7. Buying a house relatively soon, lay your advice on me!

      I'm in the market for a house, been looking pretty seriously for the past week or so. I've got two pre-approvals for mortgages, and I think I'll probably look for at least two more for fee...

      I'm in the market for a house, been looking pretty seriously for the past week or so. I've got two pre-approvals for mortgages, and I think I'll probably look for at least two more for fee comparison purposes. I have yet to actually see a house unfortunately, since every house we try to view gets sold that very same day :/ Hopefully the streak is broken, since we have an appointment with another house today!

      Anyway, who here has advice for (any part of the process of) buying a house? Things to look for when viewing a house, things to consider that the common person might not, tips for making offers, tips for not giving up because of the market, etc.

      I'll lead with some tidbits that I've gained from asking around friends and family that have already bought places recently.

      1. Apparently, sending a personal letter to the owners with the offer letter has gotten multiple people a house even when their offer wasn't the highest. For example, my sisters friend knew the owners had a cat, and has cats herself. So in the letter she wrote, she mentioned how happy her cats would be laying on the windows and running around in all the new space and such.... and she got it! The owners realtor was kinda pissed.

      2. Try to find out the reason the owners are moving out. My sister and her husbands realtor asked around, and they were able to close on their house because the owner needed a quick turnaround to get out as fast as possible. They got the house for 60K under asking price because they were able to sweeten the deal to suit the owner.

      3. Location is (generally) more important than furnishings. You can add or remove things from a house, but you can't move it once you buy it.

      4. Once you make an offer on a house and the owner accepts, make sure the contract includes the following two parts that are (apparently) very important:

        • House must appraise for at least the same value you've agreed to buy it at
        • Inspection must show no more than $buyer_defined_value dollars of necessary repairs, otherwise the deal should be re-negotiated or considered void.
      5. Always leave enough money in your savings account to pay for any extras (because there are always extras) after the house is yours. New furniture, carpets, smaller repairs, paint, etc. You don't want to drain your account for the house only to find out you can't do anything afterwards.

      I'm very excited (and exhausted already), but I want to make sure I'm as thorough as possible since I'll be spending the next several years of my life in it!

      Forgot to mention(Thanks @Thra11), this is the US East Coast.

      22 votes
    8. Anyone order a USB cable lately?

      OK, so this is kind of a weird question, but has anyone here ordered a USB cable recently, and if so, how long did it take to arrive? I ordered a 3 meter USB A male to USB A male cable on June...

      OK, so this is kind of a weird question, but has anyone here ordered a USB cable recently, and if so, how long did it take to arrive? I ordered a 3 meter USB A male to USB A male cable on June 27th from NewEgg, who have been fairly reliable in the past. I got an email later that day or the next saying the shipping label had been printed. So I thought, OK, it will go out in the next day or two. It still hasn’t shipped. After about 2 weeks of waiting, I ordered another one from B&H Photo. It also hasn’t arrived yet. I know there is a global chip shortage. Would that affect cabling too? It just seems odd that it’s taking so long to get a single USB cable. Anyone else experience this or am I just unlucky this month?

      12 votes
    9. Weekly coronavirus-related chat, questions, and minor updates - week of August 9

      This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the...

      This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

      8 votes
    10. Three experiences

      I'm 21 years old. I'm studying for a bachelor's degree at a very selective institution. I have a high-paying job lined up after I graduate in the spring. I'm physically active and in good health....

      I'm 21 years old. I'm studying for a bachelor's degree at a very selective institution. I have a high-paying job lined up after I graduate in the spring. I'm physically active and in good health. I see my friends and family regularly. I'm able to do most of my hobbies often, and I enjoy them. I've been in therapy for a long time for no specific reason and making little specific progress.

      I apologize if this is in the wrong section. I've been unable to stop writing for the past several hours and I must stop. This is where I feel it belongs the most.


      When I was 18, I noticed that I was going out of my way to make female friends, but not male friends. It may have been because I thought women were more attractive or likable, but my college dorm was mostly full of women, so maybe it was just statistics. In either case, my best friends were all men. We liked to do manly things, like drinking hard liquor, lifting heavy weights, and beating each other in wrestling matches. Over the next few years, I developed a very masculine, muscular body, which I took pride in both aesthetically and sexually. Women validated my physicality and spirit in speech and action. Acquaintances referred to me as a paragon of non-toxic masculinity.

      But I felt increasingly uncomfortable in male-dominated spaces, and I remember wishing that I could introduce myself as (she/her) rather than (he/him), even though that didn't really match who I was or how I felt. I enjoyed participating in activities that were full of women. I read Judith Butler and attended feminist lectures. I even took some classes at a women's college by way of a consortium. I did not cross-dress. I did not take hormones. I did not reject my identity as a man. I couldn't; I was and am decidedly male. I was reluctant to associate with men not because I felt disparate from the male psyche, but because I did not like men.

      The incongruity of my supposedly virtuous masculinity and my disdain for men is striking.


      When I was 19, I fell hopelessly in love with a girl at school. We discovered by chance that we very much enjoyed each other's company. We spent a great deal of time together. One evening she invited me to her bedroom to study. I had a lot of work. I painstakingly notated Hume for three hours. At midnight, as I stood in the doorway to leave, she asked me if I wanted to stay for the evening. Par for the course. I did, but I couldn't say it. I became extremely conscious of the over-neutrality of my facial expression. It turned into something approaching a pained grimace. My core contracted intensely and I spoke slowly: "I'd really like to, but I can't." I left.

      We saw each other the next day. I stayed over this time. We did not have sex, but I did kiss her.

      Another day passed. I invited her over this time. We tried to have sex. It didn't work.

      Some number of weeks passed. We saw each other occasionally. She'd lost interest in me. I was absolutely head over heels.

      Some number of months passed as we went home for the winter. I thought about her every single day. I struggled to sleep. I was listless and anxious.

      We reunited in February. She was taken with me. I'd stopped thinking about her constantly, just often. We spent more time together. She would brush up against me as we walked. She would speak to me with interest and excitement. We would dance at parties. We would look into each other's eyes and smile. My affection toward her grew beyond the realm of friendship again. Then a virus struck the Eastern Seaboard with a ferocity I'd never have expected within my lifetime. Our school announced its closure. We met the night before departing to say goodbye. I wanted desperately for her to stay with me forever. As she stood up to leave, I pulled her into an embrace and, my eyes tearing up and my voice nearly breaking, whispered, "I don't want you to go." She left.

      We texted over the next few months. We grew very close; closer than we'd been in person. My life was comprised of misery, separation, and apathy. I couldn't stand to be in my home any longer. I couldn't stand to be in my city any longer; I found it endlessly oppressive. I did not like being observed. I was always, always being observed. I wanted to be alone. I was never truly alone. I wanted to be with one person. I was never with her. I could not work. I could not sleep. I could not socialize. I could not breathe.

      The virus found its way to her. I was very concerned. She was fine. She could not smell. She was in good spirits. I escaped. I traveled to her. We met in a hotel. We spent several days together. I returned to my prison. I stepped foot inside and fell back into the crater I'd carved for myself.

      Some number of months passed. I had to see her again. I scrambled out of my crater and broke free of the cell. We met in another hotel. We spent several days together. We went on an adventure. I became lost within myself. I needed to be near her. I could barely speak to her. She wanted me to leave. She would not say it. I could see it. I could read it. I did read it. In the middle of the night, I felt an overpowering, overwhelming, push to GET OUT GET OUT GET OUT GET OUT GET OUT. It put the fear of God into my soul. I could not disobey, or I would die. I tried not to wake her. She heard me putting on my boots. She asked where I was going. I said that I needed to take a walk. I left as fast as my body allowed. I went out and forward. I had no destination; I just needed to depart immediately. I found a lake. It had a path nearby. The path continued into the woods, away from the water, windy and very dark. I walked along it for hours, hours, hours, hours, hours. The air was freezing. I was walking so vigorously that I had to take off my jacket. I could see the outlines of houses at some places along the path. The windows were dark. There were cars in the driveways. I intended to walk until I reached a town. I would look for a church, or a bar. Anywhere that would take me. It was cold again. I continued walking. There was no town. I continued walking. There was still no town. I continued walking. I saw lights in the distance. I continued walking. There was a lake. I approached. It was the lake I had found before. I halted and stood in place for ten minutes. I did not understand how this had happened or could happen. I sat down on a bench. I looked at the water. Across the lake, I saw a man walking alone. He took that path I had taken and disappeared into the darkness. I sat still for a very long time. Thoughts raced through my mind. I decided what I had to say to her. I went inside. A woman or man stood in the lobby. They took the elevator upstairs with me. I asked what floor. They gave some sort of answer. I pressed the button. We reached the floor I'd selected. They did not get out. I asked if this was their floor. They said no. I waited for the doors to close. We stood there in silence. The elevator brought us to our floor. I walked out. They followed me. They asked for a cigarette. I did not have any. I explained that I had to go to sleep. I walked quickly to my room. I entered. I closed the door behind me. I walked past the bed. She was awake. She asked how my walk was. I did not say anything. I could not look at her. I undressed and got into the bed. She made further conversation. I did not know what to say. She asked if I was feeling alright. I said that I was not. She asked why. My face tightened. My core tightened. I could not speak. I said, "My mind often takes me places." I paused for a long moment. "It gets anxious about people. Because I've been with you all this time, it's getting anxious about you." She said that that sounded like "normal social anxiety." I said, "No, it's..." I did not finish. I did not know how.

      We have not spoken in months. I think about her every day. At many moments I feel as though I have never wanted to see someone again more. At other moments I forget her completely, if only briefly. Then the loneliness comes back.

      Some weeks ago, I found myself in a distant place full of strangers. I made the acquaintance of a woman there. I liked her. She was older than me. She was very beautiful. She looked much younger than she really was. We drank wine and danced romantically at a party. Tango, waltz; whatever we could manage. She was the most attractive person there, and everyone knew it. She moved with a special mastery of her own body that I rarely saw in anyone. She was funny, and she could make really good drinks. Her friends commented on her beauty with pangs of jealousy. My heart fluttered when she entered the room, and I was drawn toward her. We spent more time together. People observed, but did not pry. She was confused or insecure about why I liked her. I offered kisses and flattery. The feeling was genuine; she had beauty beyond measure, and I felt remarkably comfortable in her presence. We had sex five times. We parted ways with a very heartfelt kiss. My mind returns now, uncontrollably, to two women.

      The incongruity of the deep affection I feel and my inability to express it is striking.


      TW. When I was 20, I lived far away from my friends. I spoke to my acquaintances cordially. Many of them looked up to me. I drank far too much alcohol. I saw a counselor. She spoke to me very candidly. I felt less alone.

      A girl down the hall, fresh out of high school, begged me to take her virginity. She was very intoxicated. I refused. She sat on my lap and kissed me. I froze. I thought of my woman from before. She put her hand on my crotch. I gently moved her off. She asked me again. I said no. I couldn't bear to have anyone witness this. I took her outside. We walked along the road, into the darkness. She asked if we could do it tomorrow instead, and I said no again. I explained that I could not sleep with her. She did not understand. We sat down on a bench. I was exasperated. She sat on my lap and kissed me again. She asked me to squeeze her ass. I resisted. She begged. I gave up for a moment and complied, and she tried to pull me in closer. I moved her off me and stood up. We walked back home. I made sure she went to her room. I turned to go to bed. I could hear her crying through her door.

      I felt that I had to leave that space. I could not. I lived there for six more months. I told no one. I avoided the girl down the hall. She and her friends always ate in the room near mine. It was hard for me to leave without being seen. I could say nothing. I pretended as though all was well with my other acquaintances. When I saw my friends, I did not tell them either. I distracted myself and moved on.

      The incongruity of my unbelievable narcissism and my pitifully diffident response to unconsensual sexual acts is striking.


      I'm 21 years old. Good or bad, all of that is behind me now. But it really isn't. I'm left with impressions in my mind that cannot be removed. I will never, ever forget these people; not by choice, but by imposition. I must accept this reality. In doing so I will allow myself to forget the worst parts, and so diminish the accursed reminders I presently face.

      If you read all of this, thank you.

      18 votes
    11. What have you been listening to this week?

      What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as...

      What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

      Feel free to give recs or discuss anything about each others' listening habits.

      You can make a chart if you use last.fm:

      http://www.tapmusic.net/lastfm/

      Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

      5 votes