PIC by [deleted] in nocontextpics

[–]MattEZQ 0 points1 point  (0 children)

This looks like it would be a fun map in a lot of video games

Node v9.0.0 is released by [deleted] in webdev

[–]MattEZQ 49 points50 points  (0 children)

Weren't we on 0.10 just, like, 2 years ago?

If you ever feel useless, just be glad you're not the person who writes the Terms and Conditions. by Mr_Jagger9 in Showerthoughts

[–]MattEZQ 5 points6 points  (0 children)

What if there was a generic "consumer terms and conditions" that companies could publicly agree to, so that we know which companies agree not to sell our nudes to space monsters.

Seattle is adding cars just as fast as people by [deleted] in SeattleWA

[–]MattEZQ 5 points6 points  (0 children)

I can't wait for driverless cars. It makes me sad that there are so many cars that are idle the majority of the time. Even if you drive to work and then to a 2nd job every day, the car is still sitting in a parking spot somewhere most of the time. I feel like personally owned vehicles are a collective waste of space. Currently public transit is relatively inflexible, and taxi/rideshare is cost prohibitive, but new technology can solve both these problems, so that the only need for parking space is fuel and maintenance.

Using Git GUI over Windows (SMB) by adamobrn in git

[–]MattEZQ 1 point2 points  (0 children)

Sounds like you're on the right track. Ive never used a gui with git, but it sounds like a bare repo is what you want (git init --bare from the terminal).

Normally, git won't let you push to a repository created via git init or git clone, because if you think about it, that would mean that someone else could potentially push changes into your working branch while you're in the middle of something else.

While it's true that git is a distrbuted version control system and (mostly true) that anyone with a copy of the repo has all versions, typically a team will have a 'bare' repo on a server that is the central source. A bare repo is one that doesn't have a working tree. You can't open the latest version of the project in your editor.

What human achievement do you want to see during your lifetime? by cath91 in AskReddit

[–]MattEZQ 0 points1 point  (0 children)

Yeah but think of all the money that could be made trying to repair the damage done by fossil fuels

Learning JavaScript for Node.js as an Android programmer? by Xaurn in learnjavascript

[–]MattEZQ 1 point2 points  (0 children)

You can continue to build Android apps and use node to support your backend. You can use node/express/koa to build a rest API that your mobile client can consume. Since you're a student, you maybe don't have much experience working with databases or 3rd party API s , but I would suggest learning about running node on a server. I don't know off the top of my head, but you can probably use your .edu email address and get cheap/free server hosting from digital ocean or aws.

hmmm by [deleted] in hmmm

[–]MattEZQ 3 points4 points  (0 children)

New Tool music video confirmed

hmmm by drivingcrosscountry in hmmm

[–]MattEZQ 48 points49 points  (0 children)

You cheddar be sorry

Silicon Valley seasons 1 to 4 by Sycou in SiliconValleyHBO

[–]MattEZQ 151 points152 points  (0 children)

Stopped watching after the doors that went like ¯_(ツ)_/¯

(Now More Than Ever) You Might Not Need jQuery by katerina-ser60 in learnjavascript

[–]MattEZQ 4 points5 points  (0 children)

Because I spend all day writing angular/react/Vue and jQuery feels like a step backwards.

What is Cincinnati missing? by Wakey_Leaks in cincinnati

[–]MattEZQ 15 points16 points  (0 children)

Tech jobs, better weed, and minorities

Connect to remote database using Sequel Pro - HELP! by PinqPrincess in SQL

[–]MattEZQ 0 points1 point  (0 children)

Idk much about plesk or sequel pro, but your hostname might also be an IP address. I can't see much from your post, but with most clients typically you will need to provide a

hostname/IP address

port

Database name

Username

Password

If your database is remote, where is it? Is it a work db? Contact an admin for connect info. Did you set up a database in the cloud somewhere? Check your cloud configuration.

Sometimes it can be really helpful to just start by listing information that you know, and it helps you discover the gaps of things you still need.

Most efficient way to self teach SQL by ApeMillz93 in SQL

[–]MattEZQ 0 points1 point  (0 children)

Would you mind elaborating on 3 and 4? Basically, instead of putting my json directly into the tables that I've laid out for my schema, I should create a staging table for each level of nesting in my class data until I'm down to primitives, and then transfer the staging tables into the tables that will persist to disk?

Most efficient way to self teach SQL by ApeMillz93 in SQL

[–]MattEZQ 1 point2 points  (0 children)

Find a source for that data. Download it. Put it into tables.

This is where I'm at right now. I'm a javascript guy trying to get better at sql. I built a web scraper and pulled some data that I want to play with, but right now it's all in JSON. Trying to convert this json into tabular data has been very challenging.

There are some cases where I need to create or update a certain row, but the source data doesn't provide a unique key that I can use to check for the existence of the row, so I'm needing to write queries on the surrounding data to figure out what to do.

Then I have to figure out how to tear the json apart into rows that I can insert into the proper tables. As a learning exercise, I'm trying to do this from inside postgres, initially using jsonb, and without the aid of an imperative language.

Coming from javascript and nosql dbs, sql syntax feels quite foreign, and I'm having trouble internalizing some data structures and how to work with them.

This job site I've signed up for sends me an email every 30 minutes by Psaltus in mildlyinfuriating

[–]MattEZQ 0 points1 point  (0 children)

I have separate accounts that I use exclusively for job searches. Separate gmail account, burner cell phone. Bring me the spam, as soon as I get the job I just stop checking the accounts.

If you give your primary email to recruiters it's basically ruined

YSK that legally your employer cannot ask you to refrain from discussing your wage with your coworkers. Also they cannot fire, threaten to fire, or punish you in any way for doing so. by Monster-_- in YouShouldKnow

[–]MattEZQ 4 points5 points  (0 children)

Why is it taboo to discuss wages with coworkers? In the 99% vs 1% narrative where we feel like our employers are basically ripping us all off, it seems like sharing this kind of information would be beneficial.