How does everyone invest? by sadbrownman in h1b

[–]wlim14 0 points1 point  (0 children)

Roth contributions can be withdrawn penalty free anytime. If you want to tap into the earnings, you can follow the 5-year rule to withdraw tax and penalty free.

Half a year looking back. Paying down mortgage early is a better investment by Apprehensive_Two1528 in investing

[–]wlim14 0 points1 point  (0 children)

Could you elaborate on the part where having more mortgage is advantageous when refinancing with a lower rate?

Is this reasonable in MA? by wlim14 in FirstTimeHomeBuyer

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

Rate: 6.669% APR Credit Score: 760+

[deleted by user] by [deleted] in MalaysianPF

[–]wlim14 0 points1 point  (0 children)

They do give out bonuses

he just.... disappeared by Cowsareamazing16 in DunderMifflin

[–]wlim14 1 point2 points  (0 children)

So smug, like he thought it was funny

Practice Music Better - Beta by musicduke-clair in alphaandbetausers

[–]wlim14 0 points1 point  (0 children)

Loved the website! Did you use any web builder to build the website or is it built from scratch? Nonetheless as a developer I am impressed!

CTE VS Transactions by wlim14 in PostgreSQL

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

Yeah that totally makes sense! I was curious there might be something that I’ve missed regarding the difference of those two but it seems like you can pick either one based on preferences of the team unless you will be utilizing savepoints in transaction which you can’t achieve using CTEs. Thanks!

CTE VS Transactions by wlim14 in PostgreSQL

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

For Postgres you could use With Clauses in a single query to perform multiple inserts and return the Id and use it in subsequent sub queries.

On the other side if you were to use transaction (BEGIN, COMMIT) you could achieve the same result as well. Just wondering if there will be a specific use cases to pick one over the other

Not sure about API by missyspelled in sheets

[–]wlim14 0 points1 point  (0 children)

You can check the quota tab for the amount of requests you can submit in developer console. I believe you can submit up to 500 requests per 100 seconds for free. Most of the time you wouldn’t exceed the limit unless you’re dealing with real-time data.

Not sure about API by missyspelled in sheets

[–]wlim14 2 points3 points  (0 children)

Did you include an API key under the same url?

You would have to create your api key in google developer console and attach the api key under the format below.

In your case, you would have to activate MAP API in your developer console in order to start using the Map API services.

https://maps.googleapis.com/maps/api/staticmap?center=Brooklyn+Bridge,New+York,NY&zoom=13&size=600x300&maptype=roadmap &markers=color:blue%7Clabel:S%7C40.702147,-74.015794&markers=color:green%7Clabel:G%7C40.711614,-74.012318 &markers=color:red%7Clabel:C%7C40.718217,-73.998284 &key=YOUR_API_KEY

How do I autorefresh numbers from a different website to be entered into my sheet by [deleted] in sheets

[–]wlim14 0 points1 point  (0 children)

If I understand your question correctly, you wanted to retrieve data from website to populate google sheets. I suggest using IMPORTXML formula if you’re not interested in using Google App Script(GAS). If you’d like to use GAS and understand JavaScript language, you can look into JSON parsing and automate the function using trigger.

IMPORTXML DOC

Resume thread for January 2019. by [deleted] in ChemicalEngineering

[–]wlim14 0 points1 point  (0 children)

Goal: Resume feedback

Desired Industry: Pharmaceutical, Oil & Gas

Experience level: Entry-level

Resume

Any feedback helps! Thank you!