Hacker News Reader

scompon What Is Dbt and Why Are Companies Using It?

I recently applied for a job in a data warehousing team that was using this. The way they were using it replace their transformation stage from legacy tools like SSIS,DataStage and Informatica, It was certainly impressive and looked great to work with. I can see dbt becoming a lot more common moving forwards.

scompon Flu has disappeared worldwide during the Covid pandemic

I had the worst cold of my life in July last year (could of been the flu, it was a struggle to walk from the lounge room to the bedroom), got tested thinking 100% I had COVID (partner was a COVID nurse, seemed likely I would get it). Got a negative result.

scompon Facebook approves alcohol, vaping and gambling ads targeting 13-17 year olds

Never said there wasn't...

scompon Facebook approves alcohol, vaping and gambling ads targeting 13-17 year olds

When watching TV during a football (Aussie rules football not soccer) game I see probably 15-20 gambling ads and so would the 0-17 year olds watching. There is also an ad with Matthew McConaughey drinking whiskey, although im not sure if that's during prime time or late hours. Never seen a smoking or vaping ad though.

scompon Breaking RAR5 and 7Zip Passwords

Is this just an ad for their 'recovery' software?

scompon Google’s copying of the Java SE API was fair use [pdf]

What about Microsoft J# or Microsoft J++? A directly relatable example.

scompon Z3 – ZFS to S3 Backup/Restore Tool

Yeah I got excited to see a thread about z3 then I realized.

scompon Millions of websites offline after fire at French cloud services firm

OVH Definitely hosts a lot of seedboxes.

scompon ClickHouse as an alternative to Elasticsearch for log storage and analysis

I work for a company that uses it as a mission critical product. It provides the search in our SAAS. I'd say it mysteriously fails 3-4 times a year. But no one wants to invest or encourage anyone to look at it proactively or even re-actively. We've had JVM issues and indexers spiral out of control using 99%CPU only to stop at random hours later. It's definitely a product to learn before it fails.

scompon Ask HN: Advice for finding an entry-level remote job?

Side question sorry, what happened to the side business after the PE firm acquired it?

scompon LEGO Group banned user for buying bricks from official store and BrickLink

Cockatoo was a huge pain the ass to get anything delivered to.

scompon SQL queries don't start with SELECT

To be honest I don't think the article highlights very well where this applies. I am a SQL Developer with SQL Server right now and in the past using Teradata I vaguely remember an aliased column could be referenced in the where clause if you didn't use the AS keyword.

scompon Windows X86-64 System Call Table

200ms on Firefox clicking show all.

scompon Adblocking: How about Nah?

You may not use the CCTV in stores but I can assure you it is using you.

Source: I set up this tracking for a retailer.

scompon Salesforce is buying Tableau for $15.7B

big expensive Oracle-ish databases

Don't forget Teradata.

I found the same thing with MicroStrategy. I spent a lot of time reverse engineering what I could from MicroStrategy jars to expose additional functions in their plugin interface (which is so incomplete it shouldn't be advertised). But the reality is its 20+ year old system with front end updates, can only put so many band aids on it.

I think the only thing keeping MicroStategy alive is its cube functionality and the businesses who have invested to much into it.

scompon Show HN: Turn an Excel file into a web application

I don't know if a BI Developer with a web skillset would solve this problem. I worked as a BI Developer and was solely hired because I had mucked around with the COGNOS and its API's and written a few analytics based web apps. The reality was that the rest of the team didn't want to support anything outside COGNOS/MicroStrategy nor did the project managers foresee web apps as a solution to any problem.

scompon Professor gave us dire warning that CS is going to be the next Art History major

Sounds similar to my situation. I try and put it down to programmers like programming to justify why the devs here take the most complex route rather then the cheapest/fastest/reliable route.

scompon My Salary Progression in Tech

Was it hard to get into a COBOL role? I am interested in moving that way, was driven to Coldfusion under the excitement of working on challenging code. Naturally the next progression is COBOL.

scompon My Salary Progression in Tech

Sounds sort of inline with me (Melbourne):

2014/2015 - 23 - $50K - $70K | Fraud Analyst using C#/Python/SQL

2016/2017 - 25 - $90K | Teradata/SQL Developer

2018 - 26 - $70K | SQL Developer and Coldfusion/Java

I switched companies in 2018 to be a little closer to home which resulted in a substantial paycut.

I feel your struggle with savings, buying a house in Melbourne is definitely not easy.

I couldn't care less about salary if I could work remote.

scompon Data science is different now

I think DS has been abused by some people as an umbrella to not produce qualify code, yet they somehow they put themselves in higher regards in the value chain.

Hit the nail on the head here. I worked in an DevOPs/ETL team across from the data science team, all they did was write SELECT * FROM sales and complain Teradata was slow and when they got the result set they'd use "R" to SUM the column and display it with GGPLOT.

scompon Quora User Data Compromised

Do you have any more info on running your own mail server? I looked at doing so but was promptly steered away because of blacklisting, servers that allow it and redundancy.