• 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?
      
      9 votes
    2. 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
    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's it take to make a secure, stable, and scalable site?

      I think I've identified an unfulfilled need in our current online environment, have an idea of an end-result that could flourish, and some possible ways to monetize without being a cancer on...

      I think I've identified an unfulfilled need in our current online environment, have an idea of an end-result that could flourish, and some possible ways to monetize without being a cancer on society.
      I have some experience with basic site-building, but this would be a very ambitious project for one person. It will probably take a long time before I get it going—if I get it going at all. I know some of what I need to start learning to make it work, but my mind doesn't know where to start when it comes to security, stability, or scalability.

      Security:
      This is probably my biggest concern. We hear all the time about data breaches, and this idea is—at its core—a kind of social media; by its nature we're dealing with PII.
      Where does everyone go wrong here, and how do I protect the information of potential users?
      All I've got is I know that storing passwords in plaintext is a bad idea, and to encrypt 'stuff' .

      Stability:
      I'm sure we've all experienced a site going down to a heavy load. Say I can get a site up, and things go well for a bit, and then somebody with a big twitter/instagram/youtube audience says something and a hoard of people come to check it out. A site going down when you try to check it out doesn't leave a positive impression. Can this sort of thing be prepared for, in the possibility such a thing ever happened?

      Scalability:
      If I can get a workable site running, I don't expect much of a userbase for a while, if ever. But if it does get large enough to attract hundreds of thousands, or a million+ returning users, it would be nice if I could have the architecture in place to handle that ahead of time, instead of playing catch-up later. What makes a site scalable, and is there any reason it can't be prepared for?

      I'd love to be able to pay some folk to help me, but I don't have the cash for that. The initial launch will have to be done by me alone, so I'm fully prepared to learn what I need to and take the long amount of time required (maybe next summer?) to get the minimum product going. Even if this ends up not being feasible to get going alone, I figure the worst case scenario is a lot of learning along the way.

      13 votes
    5. How do you plan or outline a program?

      I’m currently studying Python Object Oriented programming and got to a point where logic and syntax are the least of my problems. I always get to a stage where I’m completely lost between modules,...

      I’m currently studying Python Object Oriented programming and got to a point where logic and syntax are the least of my problems. I always get to a stage where I’m completely lost between modules, classes, objects and a sea of “selfs”.

      I’m not doing anything too complicated, just small projects for practice, but I think I would benefit from planning. My mental processes are highly disorganized (ADHD) and I need all the help I can get with that.

      I don’t need an automated tool (even though it might come in handy) -- sketching things out on paper is probably enough.

      I only know about UML, which seems fine. Can anyone recommend a tutorial about this and other tools?

      Edit to link my last attempt at following a tutorial:

      This is the last tutorial I tried to follow, a Pygame project from the book Python Crash Course 2ed. Following tutorials is frequently mostly typing, so what I achieved there is not a real representation of my abilities -- I would not be able to do something like that on my own. In fact, I failed to answer the latest exercises, which were basically smaller versions of this project.

      My problem is not with syntax and the basics of how OOP works, but rather with memory and organization of information.

      10 votes
    6. 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?

      8 votes
    7. Are there any good tools for "one-off" file encryption?

      Sorry if this is a silly question, but I keep running into situations where a small CLI or GUI tool that could be handed a single file and hand me back an encrypted version would be useful. I've...

      Sorry if this is a silly question, but I keep running into situations where a small CLI or GUI tool that could be handed a single file and hand me back an encrypted version would be useful. I've done some googling, but all I typically turn up is blogspam about random Windows-only tools that seem to be of dubious quality.

      Anyone know of a good tool for this type of thing?

      9 votes
    8. Looking for career switching advice from Film/Business to Software Engineering

      I have a few weeks left before I finish my MBA and I turn 26. I decided to spend the free time I have since my cancelled finance internship learning how to program. I enjoy it a lot and could...

      I have a few weeks left before I finish my MBA and I turn 26. I decided to spend the free time I have since my cancelled finance internship learning how to program. I enjoy it a lot and could easily see myself working as a Software Engineer. Prior to my MBA and the finance internships I did, I was a video editor and colorist with a film production bachelors.

      I started with App Academy's Introduction to Ruby I and II courses but I quickly realized that even if a boot camp would work out for me, that specific one would not work out due to geographic location. There is a Hack Reactor branch close to my parents house in Los Angeles, however I feel like if I choose to enroll in a boot camp I should learn as much as I can on my own first; doing it now seems like I would be subjecting myself to financial peril, especially in light of COVID-19.

      I am now taking the edX MIT 6.00.1 Introduction to Computer Science and Programming Using Python course. One of my friends gave me access to a udemy MTA Networking Fundamentals course and I was considering working through that alongside the MIT one. The MIT course only takes around 15 hours per week, so I need more classes/projects to help fill what is ideally a 50 hour work week in order for me to really grasp these concepts. I know at some point I have to begin to build projects, but I do not believe my fundamentals are quite there. If I'm wrong, I would love some pointers as to how to begin.

      If anyone is able, I would really appreciate some guidance in three main areas. First, is my timetable realistic? I have enough overhead and family help to last me to December before I start looking for work OR enroll in a boot camp, the latter of which would require some additional help. I feel that if I diligently study from now until then my family would be willing to help me out a little bit.

      Second, would a boot camp actually be worth it? I realize that a solid portfolio is the #1 thing that will get my foot in the door somewhere but I'm not sure if I would have one that is as fleshed out as I might need by December. Some alumni from my school went through Hack Reactor, but the amount of CS students currently working as SWE far outnumbers the two folks I have found so far that pivoted from Economics and Film Production into SWE. I see the boot camp as serving two purposes: demonstrating that I have what it takes to commit to something and see it through (similar to my two degrees, just for programming) and helping add a few items to my body of work. The financial obligation is a bit concerning, but if I truly was able to find a job at the end of it the ISA would feel worth it.

      Finally, how can my lesson plan be improved? I intend to finish this MITx course over the next six weeks (I'm working through week 2 right now). Is the MTA Networking Fundamentals course a good compliment? Are there other courses that might be better? I own the book Programming Principles and Practice using C++ by Bjarne Stroustrup and have read that it is a solid introduction to both C++ and programming fundamentals, similar to the MITx course. I intend on starting and finishing a Version Control with Git coursera class this coming week. What more could I add, are these the right things to focus on, and is this even a realistic endeavor for me?

      My interests are web development, app development, and data analytics. I feel each of these would be its own path, but if someone could help me narrow this list down to one that best suits my past experience, has complimentary skills, and seems like it would be a good fit it would be much appreciated.

      Any advice helps!

      15 votes
    9. 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?

      12 votes
    10. Build Concept: The Mobius Chair

      In the DC canon, The Mobius Chair is a time-space/dimensional vehicle operated by the New God Metron. It allows him to travel and observe the universe, but the one I'm making is nowhere near as...

      In the DC canon, The Mobius Chair is a time-space/dimensional vehicle operated by the New God Metron. It allows him to travel and observe the universe, but the one I'm making is nowhere near as functional.

      I've come into a recliner chair with a cupholder on each armrest, and I already had a split keyboard. My plan is to use the cupholders as a mount for both ends of the split keyboard, so that I could use the entire run of armrest and have my hands lay naturally on the keys. Goals are to minimize weird stretching and be able to comfortably type for long stretches of time, to put off stuff building this that I planned to work on this weekend, and to look super boss, though not necessarily in that order.

      If I want ultimate angulation and the best range of motion, I was thinking about something like a cupholder with a phone or a tablet mount, like this one, but if anyone has recommendations for what would be best to work with, or have done something like this before, I'm all ears.

      6 votes