WingNews logo WingNews GitHub [2]

michaelper22's comments

michaelper22 | 6 years ago | on: Your throat hurts, your brain hurts: the life of the audiobook star

In the US, in particular at least one NYC government agency, unionized "system analyst" jobs are common. They get a defined salary based on experience and level, an assigned eight hour shift with half-hour lunch break, and a clock that must be punched into on time. Another has kind and caring help desk people who nevertheless carefully watch the clock.

michaelper22 | 6 years ago | on: New In Postgres 12: Generated Columns

Here's one of my current use cases: We have a folder tree table in our (formerly nested sets, then closure table, now materialized path), and we cache a materialized version of the path with the folder names. There are some places in the app where you can look up a node by its full path, and this column should conceptually be unique. Obviously an unindexed VARCHAR(2048) is bad to filter on, but MySQL indexes can only cover the first 767 bytes (we used utf8mb4). So we have another column, PathHash CHAR(40) AS (SHA1(path)) VIRTUAL, and then a unique index on that.

michaelper22 | 6 years ago | on: SQL Window Functions

MySQL only as of 8.0, which also added CTEs, more JSON features, and index features relevant to indexing JSON.

michaelper22 | 6 years ago | on: Kaspersky in the Middle – what could possibly go wrong?

I was dealing with MySQL running on a Windows server box with McAfee Active Response running (MarService.exe). It has a feature for tracking files created/deleted, which is accomplished by hashing all new files, saving them to its own local DB, and presumably pushing them to the management server async. The app running on MySQL frequently creates many new tables and fills them as part of SOP, so the disk was constantly hammered by both MySQL and McAfee...

michaelper22 | 6 years ago | on: GitHub is down

AdoptOpenJDK builds are hosted there too; found out about the outage trying to download one.

michaelper22 | 6 years ago | on: I was wrong about spreadsheets (2017)

Notwithstanding the row length and column count limits, did you also give MySQL more memory? Setting InnoDB buffer pool size to 3 or 4 GB might help; its default is about 134 MB.

michaelper22 | 6 years ago | on: Ask HN: What does your development stack look like in your favorite language?

1. Install Windows (7/10 Pro 64-bit)

2. Install Java 8

3. Install Eclipse; configure eclipse.ini to use jvm.dll for launching and set max heap to not all my RAM

4. Install Tomcat; configure Eclipse to use Tomcat installation

5. Install MySQL 5.7

6. Install Toad for MySQL Freeware (no longer available; might break under MySQL 8.0 when the time comes to upgrade...)

6. Eclipse -> New Maven Project

michaelper22 | 7 years ago | on: On Internal Engineering Practices at Amazon

Morgan Stanley revealed at a recruiting event that they follow this practice. "You can definitely use Apache Spark! It's been reviewed by our Enterprise Architecture team; some APIs were removed, and we substituted 'Morganized' variants of others, which you won't find code/docs for on Github ;)"

Given the npm debacle, I could totally see even a small org running an internal Maven repo with approved versions of (popular, and especially obscure) libs.

michaelper22 | 7 years ago | on: A new class-action lawsuit takes aim at real estate agents and their 6% fee

I don't understand how this racket is allowed to operate. From my experience (three NYC apartments through realtors), the landlord's realtor provides pre-screening of "desirable" tenants for the landlord, showings, collecting paperwork from the prospect, and handing over the keys. None of this adds value from the (prospective) tenant's perspective, but the tenant must pay the fees (in all three cases, one month's rent).

michaelper22 | 7 years ago | on: Whitespace killed an enterprise app

My college, part of a larger university system, was in the first wave of campuses to switch from a hodgepodge of legacy stuff (CICS-based student info system, with other apps probably in classic ASP and ASP.Net, plus other vendor products) to PeopleSoft (Campus Solutions, HCM, Finance, etc.). The major complaints - from students, staff, and faculty alike - were about excessive pageload times and significantly more clicks to do simple things. They added huge sticky headers and layers-upon-layers of portals.

Perhaps the only people happy with the migration were the Oracle sales reps.

michaelper22 | 7 years ago | on: Moving from Go to PHP Again

> Can extend itself as it runs. For example Wordpress, running off of php files can download plugins to its own server (which are just more php files) to instantly extend itself. Without restarting or redeployment. (What other web platforms can do this?)

Java: Use a classloader to load a JAR and instantiate one of its classes: https://stackoverflow.com/questions/60764/how-should-i-load-...

.Net - use an AppDomain (or other methods): https://stackoverflow.com/questions/1137781/correct-way-to-l...

michaelper22 | 7 years ago | on: Roadmap to becoming a web developer in 2019

Nice to see relational DBs before NoSQL (learning the old and tried before the new). To follow that same pattern, SOAP should be earlier than REST. Taking a WSDL and running it through a client code generator is a fast and type-safe way to develop.
page 1
more