• Breaking News

    Saturday, October 24, 2020

    Home Unlabelled Finally got my first job as a self taught developer! learn programming

    Finally got my first job as a self taught developer! learn programming

    October 24, 2020

    Finally got my first job as a self taught developer! learn programming

    Finally got my first job as a self taught developer!

    Posted: 23 Oct 2020 12:05 PM PDT

    I already made a similar post sharing an article I wrote about my experience, unfortunately it has been taken down automatically due to too many reports, I think it might have been due to the article being behind medium's paywall.

    Since I think I received a great response for it and I think it's a pity it's not available anymore on Reddit I want to share my favorite tips from the article hoping it can help my fellow redditors and to say thanks to theis community that helped me so much in my journey.

    My background is in chemical engineering (dropped out the final academic year due to not liking the major), I worked for one year in a technology company in an unrelated position when I decided that I wanted to learn programming and become a developer.

    I did not want to start university again due to bad experiences or join a bootcamp and spend thousands without being sure that it was the right path for me, so I moved back with my parents and started studying like I never did before in my life, when you are passionate about a subject the hours just fly by.

    After one year of dedication, missed opportunities due to covid and failed interviews, I finally aced the interview for a fantastic company that saw my dedication and passion.

    Harvard's Introduction to Computer Science

    CS50 is just great. If you started recently or you are intermediate you should definitely take this course, it teaches fundamentals that too often get ignored by self-taught students and It puts the emphasis on being independent and learning to do it on your own.

    It's definitely the thing that put me on the right track after months of not following a rigorous roadmap and not learning as much as I could. The staff is phenomenal and there is a free certificate if you complete every assignment and a final project of your choice.

    Projects are vital

    This is relevant for everyone, don't just stick to online courses or your lectures, reading about programming without actually doing it is as likely of making you a programmer as reading cookbooks without cooking is of making you a chef.

    The best way to avoid "tutorial hell" and actually become competent is putting everything you learn to good use with projects based on the material you are currently studying.

    They are also great to showcase on your resume if you have don't have much relevant experience, but you have to be the one to bring them up because in my experience recruiters don't really have the time to check your GitHub repo.

    Commit to something

    Another way to get stuck without making progress is trying to learn too many things at the same time without having a focus, or changing subject too often, learning the right thing is not as important as actually having a deep understanding of any topic, after you learn the first language or framework the second is drastically easier.

    That shouldn't stop you from trying different things, I was sure Artificial Intelligence would be my passion when I realized that training models is actually quite boring and sometimes frustrating, just be sure that you dedicate enough time to each endeavor.

    Don't wait too much before applying

    You will never feel ready for your first job because you probably aren't.
    Most companies, at least the good ones, hire juniors knowing well that they will lose them money for months before they are competent enough to bring profit, they are investing in you and committing to your improvement!

    Instead of waiting more ask a friend who is in the field or even people you don't know on social media but are willing to help if your portfolio and knowledge are at the level necessary to pass a technical interview.

    Networking is key if you don't have a brilliant resume

    Let's be honest, the job market is absolutely screwed, every posting on Linkedin has hundreds of candidates, some of them seniors or mid level applying for lower level positions, unless you just graduated from Cornell or MTI you will have to send hundreds of applications before receiving any answer.

    That's why networking is so important, use your social media like Reddit, Twitter, and Linkedin actively, participate in job fairs and conventions (physical or virtual), try meeting people that work in the sector you aspire to be in and ask them for advice, even a cold message on Linkedin can do wonders if you keep the interaction polite.

    I got at least a couple of interviews from messaging recruiters on Linkedin, and I actually found my current company because the founder saw my profile on AngelList, and liked it enough to message and ask me to send my resume, the fact that we had a personal interaction really helped me in passing the first selection stage.

    Prepare for the interview

    Like it or not algorithms, data structures, and Leetcode are the standard for many technical interviews, you can definitely find jobs that ask domain specific questions, but you can hardly afford to shrink your already small opportunities pool.

    Don't forget that your interviewers are people! Being able to communicate how you reason is more important than arriving immediately at the right solution, also be likable and confident in behavioral interviews and do your research, companies want people that are committed to working with them.

    Learn from your rejections

    You will get rejected, it's part of life. I failed really important interviews for positions that I cared a lot about, but every time I took it as a lesson to improve on my weaknesses.

    But also, don't take it too harshly, being deemed not ready for an opportunity doesn't mean you aren't good enough but that you have to keep looking for the right place and the right people that will be able to see your potential.

    Good luck to everyone, I hope you will be able to achieve your dream like I was able to.

    submitted by /u/Federico95ita
    [link] [comments]

    What language should I focus on as a new programmer?

    Posted: 23 Oct 2020 02:30 AM PDT

    I want to create an app, if there's a better term, pretend I used that, but I'm extremely new to programming. I spent about a week learning a little bit of python, and am now dabbling in JavaScript, which kind of requires learning a tiny amount of HTML.

    I was wondering if I'm on the right track, and if not, where should I be looking? Sorry about the dumb question, I'm just at a loss as to what I should be prioritizing.

    submitted by /u/spookymemecollector
    [link] [comments]

    Experienced Professionals: What is your approach for learning a language and its eco system while having a full time job in another tech?

    Posted: 23 Oct 2020 09:38 PM PDT

    There comes a time when either you want to change the tech stack reasons can be anything for example.

    1. You just got bored and don't feel satisfied with the niche s that provide job opportunities in your tech stack for example monotonous work.

    2. The region(geographical) you live in and work falls short of good tech managers and peers which hinders expansion of depth of knowledge(assuming you can't migrate).

    3. You want to switch because even after many years using same tech now its limitations are clearly visible to you and you find that in the long run it will not be benificial to continue.

    Learning a new tech, domain, programming language, framework etc. is totally different feat to achieve when one is working full time and can barely spent 1-2 hrs daily. And this creates kind of anxious mindset specially when you are learning to switch to another job(given very less time available).

    Considering points above, please suggest your methodology and practices. If your reasons and circumstances are specific or different please do mention them also.

    submitted by /u/u_d_b
    [link] [comments]

    I'm giving back - here's a free book on Python - keep learning during this pandemic!

    Posted: 23 Oct 2020 05:11 PM PDT

    I started writing "Slither into Python" a little over a year ago and I have recently completed it. I decided to release it online for free as a thank you to the programming community, in particular the Python community. Since release there has been over 64k readers, and I've received a tonne of really amazing feedback as well as some incredibly important constructive feedback which I have taken and used to improve the content. I know a lot of you out there are learning Python at the moment and I hope this resource can serve you well.

    If you have any questions, or feedback for me, then please let me know, my email is on the site!

    I know this is a difficult time for many of us but we can use it to our advantage! Many of us have a lot more free time now then we ever had before, so use this time to continue learning and really ramp up your skills!

    Check it out here: www.slitherintopython.com

    submitted by /u/BigTheory88
    [link] [comments]

    What have/did you find hardest about learning to code?

    Posted: 23 Oct 2020 05:51 AM PDT

    I'll start things off with a few things I have found challenging over the last four years.

    1. Understanding the landscape - It took me almost 4 years to develop a mental map of the different areas of employment, like embedded, web dev, data science, etc. Also, no one tells you that (at least in my country) 95% of entry-mid level jobs are for web development.

    2. Roadmapping domains - For example, I spent months fumbling with Ionic framework before even realising that I needed to learn Angular... before realising I needed to learn TypeScript... before realising I needed to learn JavaScript properly. I didn't start really making progress until I went back to basics and started building up to a modern stack.

    3. Most web dev tools don't explain the 'why' - After deciding to start from basics, I began making a To-do app with pure vanilla JS/HTML/CSS. The moment I started work on the 'deleteItem' function, I suddenly understood what jQuery was for.

    submitted by /u/well-its-done-now
    [link] [comments]

    BASH - I wrote a script that will randomly generate a year and return the top 10 movies of that year from Rotten Tomatoes. -- Looking for some help making it more efficient, and also want to make sure I'm not doing anything dumb

    Posted: 23 Oct 2020 02:42 PM PDT

    Basic info:
    We do a weekly 'random movie night' at my house where we pick a random year and watch one of the top movies of that year. I wanted a script that could do the "hard" work of randomly generating a year, and finding the movies on either imdb or RT.

    This uses curl grep and awk as a means to "scrape" rotten tomatoes top 100 lists and then clean it up. I'm not really sure if that's the best way to do that.

    I also wanted a wanted a way to add more results, if the top 10 movies aren't what you're looking for. I didn't know of a clever way to add more results, so what I did was essentially run grep again with a higher -m (max count). Feels like there's a better way to do this.

    Anyway, here's the script:

    #!/bin/bash # ~/MovieGenerator.sh # A small shell script using bash that will generate a random year, # then curl the Rotten Tomatoes website and present the top 10 movies of that random year and present it back # Created by /u/drpeppershaker 2020 # This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. # License info: http://creativecommons.org/licenses/by-sa/4.0/ # #This uses grep and awk because I don't know how to do it otherwise. I'm still learning... #Set variables clear LoadNum=10 #Display an *animated* pseudo-random number generator using jot for i in {1..100}; do rand_num=$(jot -r 1 1931 2020) echo RANDOM YEAR "$rand_num" sleep .01 clear done #Display the chosen psuedo-random number in a way that looks pleasant echo "*********************" echo "*" RANDOM YEAR: "$rand_num" "*" echo "*********************" sleep 2 ######################## # Curl rottentomatoes.com # Grep the relevant text from the website # awk to clean up the unnecessary information # awk regex is as folows: # <.*(;)|<(/.*|a|td).*>|^ * # this regex should remove all html tags (anything between "<" and ">" inclusive) -- # that was found in the grep results; as well as "&nbsp" which should leave us with readable output. # the second gsub removes the "--" that was added by the initial grep. ######################## echo ""; echo ""; curl -s https://www.rottentomatoes.com/top/bestofrt/?year="$rand_num" | grep "($rand_num)" -m $LoadNum -B 5 | awk '{gsub("<.*(;)|<(/.*|a|td).*>|^ *", ""); gsub("--","\n"); print }' ORS=" "; echo ""; echo "" # added a while loop in order to load more results, incase you want to view more than the 10 top movies # this is useful if you get a random year that is more recent, and you are likely to have seen most or all of the ones on the top ten # I don't know how to simply add more results without curl-ing Rotten Tomatoes again. Perhaps there's a better solution? while (( LoadNum < 100 )) do echo read -r -p "Load More if Available? [y/N] " response case "$response" in [yY][eE][sS]|[yY]) ((LoadNum=LoadNum+10)) clear echo "*********************" echo "*" RANDOM YEAR: "$rand_num" "*" echo "*********************" echo ""; echo ""; curl -s https://www.rottentomatoes.com/top/bestofrt/?year="$rand_num" | grep "($rand_num)" -m "$LoadNum" -B 5 | awk '{gsub("<.*(;)|<(/.*|a|td).*>|^ *", ""); gsub("--","\n"); print }' ORS=" "; echo ""; echo "" echo "If more are not loading, you've reached the end of the list" ;; *) break exit 0 ;; esac done # the maximum results from Rotten Tomatoes is the top 100 movies # if you attempt to load more than 100 results then the script will tell you that you've reached the end of the list and then end if [[ ! $LoadNum -lt 100 ]]; then echo echo "** You've reached the end of the list **" echo fi

    Please take a look

    submitted by /u/drpeppershaker
    [link] [comments]

    Graduated in non-CS field. Want to become a software engineer. Need advice.

    Posted: 23 Oct 2020 05:09 PM PDT

    Hello! Need some advice from those who may have gone through my position. I've been considering applying for a master's program in CS after I've completed the class requirements. I've been kinda iffy about bootcamps, because I'm not sure if it'll pay off. I've also looked into internships, but the problem is that I am not eligible due to not pursuing a bachelor's program anymore. If anyone has advice it would be greatly appreciated!

    submitted by /u/Alternative_376
    [link] [comments]

    Is it normal for a lack of a mathematics background to hold you back in programming?

    Posted: 23 Oct 2020 01:00 PM PDT

    Really getting stumped on some questions.

    submitted by /u/potentialstudent0102
    [link] [comments]

    How do I go about creating my own virtual assistant in Python?

    Posted: 23 Oct 2020 08:11 PM PDT

    After researching online, I came to the conclusion that I have no idea what I'm doing. After trying some tutorials, I kept coming into issues, like with pyaudio not working.

    How do I go about building my own virtual assistant in Python? Is there already developed software that I could piece together into a Virtual Assistant? Do I need machine learning to build a voice activated assistant, that is capable of following my instructions? Any suggestions or advice is welcome!

    submitted by /u/AquaStorm49
    [link] [comments]

    [JavaScript] What is the difference between naming a variable in reference to a function and naming the function directly

    Posted: 23 Oct 2020 12:57 PM PDT

    What is the difference between

    let a = function (x) {}

    and

    function a (x) {}

    What are the differences between these (if any)? They seem identical to me but I want to make sure before I start treating these as equals in my brain and regretting it later.

    submitted by /u/ManInBlack829
    [link] [comments]

    On learning front end web dev

    Posted: 23 Oct 2020 11:27 PM PDT

    Which of the following is to be the best way to learn front end to be job ready?

    Whatsdev's front end guide

    The front end portion of travers's web dev guide

    Or going on [The Odin Project](theodinproject.com), learning web dev 101, and then going towards the full stack js path

    It seems to me that whatsdev has a more longer approach, adding that learning CS50 and a bit of backend is necessary. This seems more bullet proof but I could use that time using The Odin Project.

    Traversy's guide explicitly tells you what you should learn in each component, but I'm just hoping it doesn't lack anything I should pick up. Plus, the order in which the skills are learned are a bit rearranged from whatsdev's guide.

    The Odin project is my "bite the bullet" choice, because it is proven job ready, but I'm afraid it too will lack a bit of content I may need to learn on the way.

    I would appreciate if you just skimmed through the videos to see the ramifications of what is to be learned and compared them to each other. Thanks.

    TLDR : What's the best way/main resource to learn front end?

    submitted by /u/priinze
    [link] [comments]

    Any good tutorials for learning to automate with Python?

    Posted: 23 Oct 2020 01:32 PM PDT

    If I want to learn how to, for example, create a script that opens up Chrome and logs into my email when I run it, how should I go about learning how to do this? Are there basic Python automation tutorials on YouTube? Thank you.

    submitted by /u/wetflapjack
    [link] [comments]

    My best project so far!

    Posted: 23 Oct 2020 12:31 PM PDT

    So, in school we just finished the book "The Outsiders" and I decided to create just a plain 'database' of the protagonist name and age. Also who is in each group (socs and greasers) and I added a "loading resource" effect in the terminal for fun. I didn't focus on the for l in resource: part so much. I used "l" as just an idle variable that doesn't do anything. This code in itself doesn't do much. I just thought it was cool so I did it. I don't know if I should show my teacher or not. )I haven't attended cs class yet, that's next year.) What's your thought? feel free to say anything you want.

    import time
    import sys

    protagonist_name = "Ponyboy 'Pony' Curtis"
    protagonist_age = 14
    Greasers = ["Ponyboy 'Pony' Curtis", "Darrel Curtis", "Sodapop Curtis", "Two-bit Matthews",
    "Johnny Cade", "Dallas Winston", "Steve Randle"]
    resource1 = "loading resource1/3"
    for l in resource1:
    sys.stdout.write(".")
    sys.stdout.flush()
    time.sleep(0.2)
    print(resource1)
    Socs = ["Robert 'Bob' Sheldon", "Cherry Valance", "Randy Adderson", "Marcia ... ", "Paul Holden",
    "David ... "]
    resource2 = "Loading resource 2/3"
    for l in resource2:
    sys.stdout.write(".")
    sys.stdout.flush()
    time.sleep(0.1)
    print(resource2)
    problem_in_novel = "The Socs and The greasers have gang wars and when one of the greasers, Johnny Cade, " \
    " kills one of the Socs in self defense, a gang/turf war breaks out." \
    " Pretty much the poor vs the rich." \
    " But both sides have their own problems."
    whole_story_round_up = "We take a walk through the life of Ponyboy Curtis and how he views things." \
    " About what happened to Pony and Johnny after the horrible events take place" \
    " in both of their lives."
    end = "Johnny dies. Dallas dies. Pony struggles in school but eventually regains his ability so learn." \
    " Greasers win the war."
    resource3 = "Loading resource 3/3"
    for l in resource3:
    sys.stdout.write(".")
    sys.stdout.flush()
    time.sleep(0.1)
    print(resource3)
    print("resources loaded successfully")
    print("")
    print("")
    print("It is the Greasers vs Socs.")
    print("end and plot1 and the_problem are not in any order. "
    "They are just there to be quickly summed up.")
    print("")
    call = input("call a plot of the story! (please type exactly these!)"
    " socs_members or greaser_members or end or plot1 or the_problem: "
    ""
    " ").lower()
    # In no specific order. This is just here to ask users if they want to know what's going on.
    if call in 'end':
    print(" ")
    print(end)
    elif call == 'plot1':
    print(" ")
    print(whole_story_round_up)
    elif call == 'the_problem':
    print(" ")
    print(problem_in_novel)
    print("")
    if call == 'socs_members':
    print(" ")
    print(Socs)
    elif call == 'greaser_members':
    print(" ")
    print(Greasers)
    print("")
    finale = input("Type any key and press enter to close the script!")
    if finale in 'x':
    exit()
    else:
    exit()

    ​

    (it doesn't show the indentation btw)

    (or print any of the story line, that's just there to be stored.)

    submitted by /u/Substantial-Ad5198
    [link] [comments]

    Go vs Swift: Which language is a better next step for a data/ml/distributed engineer?

    Posted: 23 Oct 2020 10:59 PM PDT

    Looking to learn one of these new languages, but cant decide which to choose. I know python, java, and some c/c++.

    I know about swift for tensorflow, but right now I don't see a reason to use it over python. Swift is said to be a near perfect language, theortically. But it's not as widespread as Go.

    submitted by /u/insanelylogical
    [link] [comments]

    Learning process- are my assumptions reasonable?

    Posted: 23 Oct 2020 06:56 PM PDT

    Hi all, I'm working to transition into a development career. I've gone through the basic questions like what languages I should learn, where I should start, etc., and have gotten a process down. I'm hoping that somebody who has done this before can let me know if I'm generally on the right track.

    Language: I'm starting with python. My impressions are: it's an easier language to start with, although the applications are somewhat limited because of its speed. I'm using this to learn the basics of cs and development, and plan to build a few applications in it before taking on C#. I get the impression that C# has a lot more versatility, especially when using .net. The assumption here is that python will get me started without spending all my time looking for semicolons and has some utility outside software development, while C# will ultimately be more useful.

    Environment: I'm starting on windows with Atom and git bash. I'm exploring Ubuntu on the side, but I'm most familiar with windows. I like Atom because it's a fairly simple editor but doesn't have a lot of frills to try and learn. I'm using git bash to practice with git and cli navigation. I know there is more to it, but I'm not terribly concerned with it right now.

    Projects: I've done a few little things, but haven't put them on Github because they're not terribly significant. A basic calculator, a hangman game, little things like that. I recently took a course in probability and statistics and recreated some of the models (Monty hall problem, basic monte Carlo simulation) in python. What I am putting on github is a random generated dungeon crawler that will use some of the data structures I'm learning and is a bit more involved than my previous projects. I'm not sure what to do next, that's something I'm still figuring out.

    Tutorials: I started the computer science track in codecademy in May, and made decent progress through that. I recently gained access to coursera, so I'm doing the python for everybody specialization for the certificates. Since I'm out of a job right now, I'm pushing pretty hard on that.

    As far as all the other stuff, I'm not sure where exactly to start. Everything I'm seeing is grow a network in LinkedIn, engage with Twitter, have a blog, have a github... I'm doing the github part. Not sure exactly how to do the rest. I'm open to suggestions!

    I'm interested to see what people have to say, I'm primarily looking for blind spots or bad assumptions in the process. I want to transition asap, but I know there are steps I need to take first. Thanks in advance for any constructive criticism!

    submitted by /u/rnandon
    [link] [comments]

    How to print a specific monthly calendar (including Mon Tue Wed... on top) without having to update the array from the first year when user inputs a specific year and that month ?

    Posted: 23 Oct 2020 10:34 PM PDT

    [perpetual calendar]

    submitted by /u/JacksonSteel
    [link] [comments]

    I just finished filming 12 hours of a coding tutorial using crossword puzzle construction as the goal. I hope it's a fun way to learn to code!

    Posted: 23 Oct 2020 06:42 PM PDT

    https://codingforcrosswords.com/ has the syllabus and links to the videos.

    submitted by /u/codingforcrosswords
    [link] [comments]

    Help with code for wallpaper engine

    Posted: 23 Oct 2020 10:27 PM PDT

    Hi I apologize in advance if this is against the rules. Let me preface by saying I have zero coding experience.

    I had just downloaded wallpaper engine and found myself delving deep into some wallpapers and had found some code which was graciously posted by the creator. I delved into the code and changed alot of variables to personalize the wallpaper. I was able to recreate something similar to the old school windows flying stars screensaver. I was wondering if anyone can show me how to make the stars fly sideways, or up and down. I was only able to adjust the z axis.

    Link to original code: https://codepen.io/hakimel/full/bzrZGo

    Link to my code: https://codepen.io/azandian/full/NWrdNYz

    Thanks

    submitted by /u/i_should_be_studying
    [link] [comments]

    Do you ever use different programming languages for one project ?

    Posted: 23 Oct 2020 10:18 PM PDT

    I am a complete newbie and just wondering.

    submitted by /u/bannedforeverything
    [link] [comments]

    How do i program my first project?

    Posted: 23 Oct 2020 10:14 PM PDT

    Just got started with coding, installed Visual code, picked my language (Python) and runned my first program "print ("Hello World")" and now, i'm planning to build my first project because someone said that instead of learning how to program, i should instead think of a topic i like to build or solve problems.

    What i had in my mind, is a word search puzzle, our prof likes giving us assignment about those. and it's such a pain in the ass because i especially suck at those.

    So now i have project in mind that i'll like to build, but now i'm thinking, "how the hell do i program that?!?" i'm a newbie at this, and i don't know any commands.

    So yeah i spent 30 minutes searching google and now i'm here.

    submitted by /u/Dreicoo
    [link] [comments]

    How does a test runner timeout and kill a test?

    Posted: 23 Oct 2020 10:10 PM PDT

    How does a test runner short-circuit a piece of code? For example I was using a bespoke browser test runner, it times out for an unresolved test and completely kills it (no catch blocks run etc), then it moves onto the next test. How does it do this?

    submitted by /u/UpOnCloud9
    [link] [comments]

    Help me fill some knowledge holes for an assignment

    Posted: 23 Oct 2020 10:00 PM PDT

    Hi, i was asked to make a web application for a school assignment, it's supposed to be able to make reservations for an event venue.

    The main limitations (and part of why i'm struggling with some bits) is that i was asked to NOT use any frameworks or libraries, just plain HTML, CSS, JS, PHP, AJAX, etc...

    I have almost everything in the Front-End part figured out, but i'm struggling to understand the Back-End...

    For data persistance i have to use client-side websql, which is some deprecated W3C standard that i have no idea how to use, and there is no way around it, this part I could maybe manage to do reading the documentation and watching some tutorials.

    The requeriments are as follows (I don't need help with everything):

    1- The user has to login to be able to create an event, event categories are: wedding, party, baptism, graduation, business meeting, family meeting, other.

    2- The user can choose the date and time of an event from a calendar HTML form.

    3- The user can input the names of the guests, as well as edit and remove them.

    4- The user can input the distribution of the tables, dance floor, music, bathroom, these elements are drag and drop, you drop them on an area and arrange how the event venue will be organized.

    5- Once the elements are organized, the user can assign the guests to each table, to a maximum of 8 per table (and choose a menu for each table).

    6- When the user hovers over a table, a tooltip with a list of the guests should appear (and be able to delete guests from said list)

    7- When the user logins, he should be able to look at past reservations, and if one is loaded, he should be able to modify it, here you will also show a XML document which you get from the server with all the information about the event.

    8- All the information about the event will be stored client-side with websql, you will also send that information in a XML file (with a DTD) to the server using AJAX.

    Note: the menu available will depend on the time of the event, (if morning then show breakfasts, if afternoon then show meals, if night then show dinners)

    The option that allows the user to see past events should load them dinamically (AJAX) and should display the drag and drop elements just how the user arranged them.

    This is all non-negotiable i have to do it exactly this way!

    Ok, i shared all the requeriments so you could see the whole scope of what i need to do. So, now the things i don't understand are:

    • HOW to generate the XML file with a DTD containing all the information about the event, and what's even the point of doing that and sending it to the server.
    • How to retrieve data from the database and display it via AJAX, but i guess i could figure this one out reading the websql documentation.
    • How to save the position of the drag&drop elements so i can load them if the user request a past reservation, my guess would be to save the value of the X and Y position of every element but i'm not sure where to fit this in my database schema.
    • What do i need the XML file for?, sorry if this is a really newbie question but i've never worked with this before, i usually use JSON, how do i even transform the data in my forms into XML and the XML file into HTML and why would i even do this if i could just retrieve it from the database instead? I'm confused the most by this.

    ​

    Before you say anything, yes I know websql is deprecated and it's awful, i usually wouldn't touch this stuff with a 10 meter pole but college gotta be college.

    I am planning to do the login and backend logic with PHP, since i can't use node which is what i would usually do. Since i'm using a client-side awful websql thingy the database logic will be handled by Javascript.

    I think i'm more confused about how the whole thing works together what is the XML for, how to connect everything... this is more of a design lack of knowledge on my part.

    If you're still here i thank you for your time, any help would be GREATLY appreciated since i have only the weekend to finish this. I will be around if you need more info.

    submitted by /u/astaro2435
    [link] [comments]

    Need help on running an install script for the popular reddit tool Cronnit on a fresh server

    Posted: 23 Oct 2020 09:42 PM PDT

    I'm not sure if this is the right sub for this but I thought I'd give it a try anyway. I need some help or preferably someone to walk me through how to host the reddit tool Cronnit myself for personal use? Should be straight forward for someone in this field of expertise. It's open source as well and already has a guide, I just can't seem to follow it lol. I'm fairly computer literate, already have Linux and have some experience but I can't seem to get my head around it.

    https://github.com/krisives/cronnit.us

    Any help would be much appreciated thanks

    submitted by /u/T_Immobilisation
    [link] [comments]

    [sql help with query] updating 2 columns from 2 joined tables

    Posted: 23 Oct 2020 12:36 PM PDT

    I am trying to update two columns:

    email from table usr_email

    full_name from table usr

    The tables are joined where usr.id = usr_email.usr_id.

    So this inner join select works:

     SELECT usr.full_name, usr_email.email FROM usr INNER JOIN usr_email ON usr.id=usr_email.usr_id WHERE usr.id = 123 AND usr.id = usr_email.usr_id;

    My question is how to fix my query so those two fields can be updated at once?

     UPDATE usr SET usr.full_name='Test New', usr_email.email='test@test.com' FROM usr_email INNER JOIN usr_email ON usr.id=usr_email.usr_id WHERE usr.id = 123 AND usr.id = usr_email.usr_id;
    submitted by /u/flfdev
    [link] [comments]
    Read more
    at

    No comments:

    Post a Comment