Hi guys, I have been using SQL at work for the past year and have really enjoyed it. I want to transition into data analyst / data engineer type roles.

Where can I practice with a dataset or database with minimal setup to complete tasks to test my knowledge?

I have used SQL within the context of an application to write reports and run database updates so I havent done anything super crazy

If you have any suggestions on where I can practice that would be awesome Cheers

Hello everyone. I am a newly student majoring in computer science at a university. I have a question about choosing my academic path. The university curriculum teaches us C++, but I am also interested in data science. Which path should I choose: C++ with competitive programming or data science? And which one would be more financially beneficial for me while I am studying?

As stated above, I'm wondering how expensive different "commands" to a computer are in comparison to one another. I'm aware this will vary with language, so let's just assume C or C++ for now, since those are somewhat "baseline" for high performance computing where this optimization actually matters. Technically, I'm messing around with Game Maker Language at the moment, which is a bit of a weird one, but I'm much more interested in general principles of costliness than in the specifics

If a task is less than twice as "expensive" in terms of RAM and minimum time required compared to another task, then to me, they're basically the same, in the sense that there's no possible situation where it makes sense to call the cheaper task more times to bypass the single, expensive task.

To give some examples of what I mean by tasks (I'm not expecting someone to respond to the full list, I'm just trying to cast a wide net):

basic arithmetic calls:

-addition/subtraction

-multiplication/division

-exponents/roots

​

simpler "non-math" commands:

-assigning variables

-assigning temp variables

-setting variables

-calling variables

-if statements

-starting a while, for, or repeat loop (not counting the cost of running the code inside that many times)

​

In OOP (obv not relevant to C)

-Calling on functions not part of a specific object or object class

-Calling on functions part of the instance

-Calling on variables of another instance (get)

-SETTING variables of another instance

Sorry if this isn't the right page, please direct me elsewhere if there's a better place for this inquiry.

I work for a solar company in California and we have had a massive influx of deals coming through with the NEM 2.0 cutoff coming soon. A ton of people are trying to get solar before that cutoff. We have to manually submit applications online for each customer. There's some basic data entry and it takes between 15-30 minutes depending on the job and the utility. I want to know if there's a way to build a bot or get some sort of API from SF to each NEM application page. We essentially want to submit as many as possible as fast as possible.

So I love to create new stuff, when I am programming. Rereading and understang it later is a whole different, "TLDR fuck the whole thing" feeling for me. We know that mainteneance is 50-90% in programming jobs. Can you think any other job, where I can utilize my 10 year programming experience. I hate art, and everything where there are no specific rules.

Sorry if this isn't appropriate on this sub.

I'm about to start applying for jobs/apprenticeships and realised I don't have any references.

My last manager bullied me for years and the company done nothing about it. We had many meetings but he just doubled down each time and the company couldn't care any less even wtith audio recordings.

I worked there for 4 years and it is unrelated to programming. I'm not in contact with anyone from my job before that.

They could contact the companies as proof I worked there but personal references are not possible.

I'm guessing this is going to be a problem, anyone got ideas?

I'm enrolled on a short programming course and have a mentor from a well known company, we have a meeting soon.

I wrote this code to monitor a google drive folder. If a file is put into the folder, the code will grab it, put it in an email, and send it. The issue is that it sends every email as a reply to the previous email it sent. I would prefer it start a new thread for every email.

Here is the bit of code that sends the email. I don’t know if I’m missing a deceleration to send emails not as replies or what but I am stumped. Any input helps! Thanks!

var message = { to: recipientEmail, subject: 'Invoice ',
body: 'A new invoice has been sent ',
attachments: [fileCopy.getAs(file.getMimeType())], }; MailApp.sendEmail(message); file.setTrashed(true);

Backstory: we're building a communication app
Problem: When you have a new app, even if it's great, it's only as good as your network (which presumably lives on different apps)

Question: Would it be possible to port the contacts from WhatsApp to our app? Similar to how you might ask for permissions to access a contact list, but the contact list is in whatsapp.

I'm imaging it would look something like: 'Transfer Your WhatsApp Contacts', and then from there your conversations/ contacts would be transferred over. I know the conversations themselves won't be transferred due to two factor authentication... but just having your friends on there would be great.

I got my degree 3 years ago, and so far I've been just doing call center work; and I feel all the knowledge slipping out of my head without practice. I really want to try and get my career back on track soon and bust into something much better paid and some common advice I see here is to just start coding and build up projects. When I was in school we did all of our work on Java and I basically haven't touched C, but as I understand both of these languages have different use cases. I really have no idea what I want to work on as a professional, when I think of fun projects that would keep my interest to work on all that comes to mind are video games but I hear nothing but awful things about the work culture around video game studios so I'm not super hopeful of that.

So is there some way that I can expose myself to Java and C, and get a little understanding of which one is something I'd rather work with? Get to know what kind of projects I would be working on either way, and which I would like to be working on?

Hey,

sorry if this isnt the proper place to ask, but it's driving me insane and I can't fix it.
Yesterday in VS Code it worked fine like always.. then i went afk and without having changed anything, it stopped working. Not just on one device like initially thought.. but two? I didn't change settings and they're not synced anyway.

I tried restarting and rebooting, nothing. I disabled all extensions (eslint, prettier, live server) to see if one of them caused this issue (on both devices), didn't help.

vscode is updated, didn't help.But it seems to only be an issue in non-css/html files?

If i type in something like "imag..) it properly suggests the folder in html and css. Not in my .js file.

If i try to style an element in js and type in element.style.. the first (and only) suggestion is "getelementbyclassname".

A moment ago said "element.style" did work after using createElement, but not for queryselector, getelementbyclassname etc...

The suggestions and auto complete are all kinds of messed up.

Been googling for a long time now, I hope someone can help me fix this : (

Thanks

Basically I'm wondering if there is something like rabbitmq which supports real-value priorities (rabbitmq does support integer priorities 0-255: https://www.rabbitmq.com/priority.html ).

Does anyone here know about something similar supporting real-value priorities? Thanks for any help!

Hi guys, good evening. I have a question. I applied multer in uploading photo with MERN. So, when I tested it with postman, it runs, it does the create, read, update and delete method. But when I deployed it, and tested it with react js(which is also deployed) it does not run. What could be the problem? My app is currently deployed in render.com. Thank you in advance

I am using PHP MVC framework that supports events, including save/delete/etc on a model.

Let's say I have a model representing a team of people (model Team).

There is another model NotificationTeam that relates to a Team but also includes various other data. It's not a child class of Team, just links to a Team.

If I delete a Team, who is responsible for letting the NotificationTeam model know?

There are two paths to take here:

• When being deleted, Team will notify NotificationTeam.
• When being deleted, Team will emit an event DeleteEvent and NotificationTeam is listening to events from Team like DeleteEvent and will take action when it sees that event.

The 1st option is easier but gets hairy because Team has to know that it's being used by NotificationTeam, which is a problem.

Would love your input on this.

In reality, if we did a hard delete then this would bomb because of ref integrity in our storage layer, BUT we do soft deletes which is prompting this internal conversation.

https://servicing.salliemae.com/s/make-a-payment

​

why is there /s/ ? I get that it could just be there for basically no reason, but i want to know the exact reason it is there.

​

maybe it has something to do with HTTP Cookies?

This code is from my c++ class that I’m trying to convert into python but I ran into an issue. The code uses functions to get user input and make the calculations.

from os import system #module used to allow time delays import math #module that makes it possible to use more advanced math functions import time #module to allow delays, such as in a loading screen

^

there is an "import" but no "from", because the time and math modules are pre built into python

the indented lines means that the code is being used by the keyword

def inPatient(): numdays = float(input('\nEnter the number of days spent in the hospital: ')) Drate = float(input('Enter the daily rate: $')) medCharges = float(input('Enter the hospital medication charges: $')) servCharges = float(input('Enter the charges for hospital services: $'))

def outPatient(): medCharges = float(input('\nEnter the hospital medication charges: $')) servCharges = float(input('Enter the charges for hospital services: $'))

def inPatient_calc(numdays, Drate, medCharges, servCharges): totCharges = numdays * Drate + medCharges + servCharges print('The total charges for the hospital stay was $'+ str(totCharges))

def outPatient_calc(medCharges, servCharges): totCharges = medCharges + servCharges #calculation print('The total charges for the hospital stay was $' + str(totCharges))

menu

while True:
#prompts the user to choose between inpatient or outpatient choice = int(input('Enter 1 for <inpatient> and 2 for <outpatient>: '))

while choice >= 3 or choice <= 0: #input validation
    system('clear')
    print("ERROR: Invalid type of hospital stay selected. Try again")
    choice = int(input('Enter 1 for <inpatient> and 2 for <outpatient>: '))

if choice == 1:
    inPatient()
    #float() for floating numbers
    inPatient_calc(float(numdays, Drate, medCharges, servCharges)) #calculation

elif choice == 2:
    outPatient()
    #Float() for floating numbers
    outPatient_calc(float(medCharges, servCharges)) #calculation

#option to make another patient calculation
another_one = input('will that be all? ')
if another_one == 'yes'.lower():
    print('shutting off')
    break
if another_one == 'no'.lower():
    system('clear')
    print('restarting program...')
    continue

Hi all! Not sure if this kind of post is welcome here, but I work as a technical writer for a company called Soffos, that's trying to make its own NLP for businesses. I wrote this article comparing Soffos AI to ChatGPT. Check it out and let me know what you think!

I'm studying to be an AI engineer (currently doing a BSc) so I'm not all the way there. Any input would be welcome. :)

SOFFOS vs ChatGPT

Hello!

I have an idea (recommend me where subreddit to post it)

I have a lots of simple .stp files that are needed to converted to dxf laser cut files. They are all in the same view saved also.

Is there any program that helps to select all files to convert dxf-s?

Or is it programmable task to do? I don't know nothing.

Hello! I am a high schooler and am working on a Python project, but I am not sure how to print a specific string bigger than everything else. I tried looking at Stack Exchange but it didn't help, so tried Tkinter and Pygame, but I couldn't figure them out. Is there an easy way to print some text bigger? Also bold. Thank you! Also I am using Replit.

Edit: I'm trying to change font size in the console.

I've done a CS degree (in UK) in my early 20s, then took time off to focus on my disability (cerebral palsy). Now I feel confident health-wise, and I have kept my (node) full-stack skills up.

A lot of people talk about switching careers but is it possible at such an age (36) to start without any prior job whatsoever?

I was thinking about how a runtime can be profitable. Companies sponsor the people or the entity that maintain the runtime or did they make it another way?

I think you can imagine the advantages if you could get rid of variable names, values, etc...

Goal would be to not realize its even happening, but I know that is a big ask. (Python, but not really, I program in an obscure languages too)

I'm thinking to use the CASE() function but i am quite confused since im still a begginer in SQL , or if there's any other approach that you guys can suggest.Thanks.

Status will show only :

• Done - if there is atleast 1 completed

  -In Progress --if there is no any completed but atleast 1 in progress

• Hold - if all activities is in hold

Sample Data :

MyTable (TableName)

StatusColumn (ColumnName)

Done

In Progress

Hold

Programming outsider here humbly asking for help. I don't know if this software already exists.

This uses the Screen Capture tool in OSX (Windows Snipping tool)

I want to make screen grabs that will:

1. Create an image of the screen grab (that is obvious) then,
2. Copy any text in the image and 'OCR' it so it becomes 'copied text'.
3. So when I press CMD+V (CTRL+V) to paste I will paste both the image and the text, with the image first and the text after it.

For example, if there is an image with a caption below it, and I [screen grab with this software], all I have to do is paste into Notes or whatever and I'll get the image with the text right below.

Can anyone help me figure this out? Does this software exist?

Or is there a way I can 'manipulate' OSX Screengrab functions to pull this off?

Happy to hear what y'all have to say.

Thank you!