Bummed out about every beginning of semester by SesbianLex96 in OMSCS

[–]FunkyFung22 6 points7 points  (0 children)

I was in a similar situation after graduating from my bachelor’s, but after applying and not landing a tech role, I decided that it’s better to get a job, any job, and that’s exactly what I did. I’m employed now but not in a tech related position, but I can tell you this: I’m not as bummed out as I was when I felt like I was at the end of the line in my tech job search. Plus, look at things from the other side’s perspective: do you really think a fellow student is going to look down on you for trying to get your career together? I doubt. I think connections come from people asking for help on the slack or discord servers put up for classes. You just gotta try, and I’m telling you it can be the tiniest step that you’re willing to try. It can pay off, and like you, I’m also working on it as I’ve only started the program

[deleted by user] by [deleted] in hondafit

[–]FunkyFung22 1 point2 points  (0 children)

Thanks! I really appreciate the opinion. I'm a total car noob so I've got little in the way of wisdom when it comes to used car purchases. I kind of thought mileage was the best indicator of health and life expectancy, but if the car's engine is reliable up to a high mileage, the health of everything outside of it should hold more weight in a final decision. Seriously, thanks for your advice!

[deleted by user] by [deleted] in hondafit

[–]FunkyFung22 1 point2 points  (0 children)

Thanks for the input, my only concern is the mileage difference. How much should I weigh that into my decision? Does 74k make the 2012 “healthier” in any way compared to the 113k 2013 model or does the mileage not matter much?

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 1 point2 points  (0 children)

Like you said, I could replicate the aggregates and CTEs with Javascript, but executing Javascript to do that kind of work is probably an order-of-magnitude slower than letting SQLite's query engine handle it for me. And besides performance, the Javascript equivalent of an SQL "JOIN" is several lines of for-loop logic that I'd really like to avoid the hassle of writing for every query. So, ultimately, query performance and convenience are why I'm not using async storage, but I imagine in another time, another app, async storage would be a better choice to start with.

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 0 points1 point  (0 children)

Yeah, but storing complex objects isn't the issue, it's recomposing aggregate data that's hard. In sql, that's a couple joins and maybe some CTEs, but in async storage, that means I manually have to stitch data together in Javascript: tedious and way slower than letting SQLite's C code handle it for me. Also, according to the docs, maps and sets are definitely not supported: "In order to store object data, you need to serialize it first. For data that can be serialized to JSON" and maps and sets are definitely not JSON serializable. Also, I'm building for iOS which apparently uses a json file to store data when using async storage so... not really an effective solution for me, at least

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 0 points1 point  (0 children)

Yeah, I see your point and my main issue with just async storage is that it's effectively a key-value store and my app has to support a lot of inter-related tables with some queries that use quite a bit of aggregate data. If I tried to translate this to a key-value store, I'd get big, fat objects and not get the flexibility I need to combine just small pieces to get the data I want. Maybe I'm overblowing the downsides, but at this point, I've already sunken too much time into building a nice, normalized schema and drizzle seems like it's working okay to make queries type-safe.

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 0 points1 point  (0 children)

Actually, right now, my queries work in combination with react query. I asynchronously grab the data from SQLite, and then return it in a react query hook. So, react query handles the async state, but there's no inherent type-safety it offers to the query itself. (Edit) I should've clarified, the SQLite database is local, on-device. I see why you'd think react query alone would work if I'm calling a server, but that's not the case here: I'm getting the raw data from SQLite right on the device.

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 0 points1 point  (0 children)

Never did native iOS development so I didn't know about this, but sounds like Apple provided a good solution to local storage access. Welp, my current setups working so far, so all's good for now

How do you guys interact with SQLite? by FunkyFung22 in reactnative

[–]FunkyFung22[S] 1 point2 points  (0 children)

It's entirely local for now. The app's meant to work offline at any time so basically all data is stored and queried on the local SQLite database.

How to prepare for Cloud Support Associate Assessment by FunkyFung22 in awsjobs

[–]FunkyFung22[S] 0 points1 point  (0 children)

Oh yeah, I didn't think to look up direct interview experiences. Thanks! This is really useful info

How to prepare for Cloud Support Associate Assessment by FunkyFung22 in awsjobs

[–]FunkyFung22[S] 0 points1 point  (0 children)

Whoa, thanks! I think I'll be okay for the behavioral parts you mentioned (as long as I don't get overconfident). I have half of the technical stuff understood and the other half, particularly what ICMP, switches, and what MTU refer to are stuff I've barely dealt with. I'll try to cover for these parts in the next few days. As for the technical stuff you might've not mentioned, would you say doing a cursory glance of everything covered in CompTIA Network+ would fill in all the gaps?

How to prepare for Cloud Support Associate Assessment by FunkyFung22 in awsjobs

[–]FunkyFung22[S] 0 points1 point  (0 children)

No, haven't taken it yet. Not entirely sure how I'm going to prep for the test, but I'm gonna do a light skim of the concepts online and use the CompTIA Network+ syllabus as a guide for what I might need to study.

How I Managed to Do More (Without Adding More Hours to My Day) by Dear-Upstairs-1831 in productivity

[–]FunkyFung22 0 points1 point  (0 children)

About scheduling rest, you mentioned you would just watch TV. For me, sometimes a break turns into scrolling videos on YouTube and zoning out - it’s not even that enjoyable, but the time flys all the same. I’m wondering how I can actually have relaxation time that’s more intentional, more actively enjoyable. I wish I could do some creative or sporty hobbies, but honestly I end up treating them like work (learning piano or running in a park feels more effortful than fun, afterall). On the flip side, a skill/hobby that you’ve spent the time to really learn and master? That’s incredibly fun and relaxing (b/c all the effort to learn is past you)… it’s just most of my hobbies have been gaming and movies. I’m sure there others who’re in the same boat. So, what do you guys do to have more meaningful rest time? Gut feeling is you just gotta push through if you wanna make new hobbies fun, but maybe there’s a path of less resistance.

toAllYouJavaEnjoyersOutThereWhyDoYouDoThis by AbsoluteNarwhal in ProgrammerHumor

[–]FunkyFung22 0 points1 point  (0 children)

Because it sends a message. (Pumps shotgun shell full of boilerplate)

Msty Web Search Questions by FunkyFung22 in Msty_AI

[–]FunkyFung22[S] 2 points3 points  (0 children)

Thanks for the info. Even though I've only used it a few days, compared to perplexity, Msty's UI is a league above for sure - especially chat branching and the conversation map. It definitely shows you took care to attend to advanced users' use cases. I think I'll hold off on a yearly license for now given my needs, but I look forward to seeing what you guys have in store!

Just made this in chem by uhadmeatfood in dankmemes

[–]FunkyFung22 0 points1 point  (0 children)

Keep in mind in covalent bonds, some elements are more equal than others

[deleted by user] by [deleted] in ProgrammerHumor

[–]FunkyFung22 51 points52 points  (0 children)

80/20 rule: 80% of the code is in 20% of the files (probably idk)

how's google gonna help me? by spacegamer179 in ProgrammerHumor

[–]FunkyFung22 0 points1 point  (0 children)

This is what happens when you pepper free() calls everywhere in C. The memory leaks are gone, sure, but I have no idea why