Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
adamzochowski
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
11 ms
·
61.
▲
by
adamzochowski
4y ago
The world says "leading news story" and therefore "burying the lead". Lede is an american thing. Parent could have been a british or canadian neighbour with their british colourful spelling.
62.
▲
by
adamzochowski
4y ago
Miami Vice had two memorable tunes, miami vice title song, and the crocket's theme (more nostalgic like feel). Both were made by Jan Hammer. If you want to see cool stuff, checkout his "beyond Mind's Eye", one of the ear
63.
▲
by
adamzochowski
4y ago
There was a proxy, proxomitron in early 2000s, that allowed you to change the html/js as it went through the proxy. people used it for adblocking and removing page annoyances, like removing sounds / animated gifs / etc. Here
64.
▲
by
adamzochowski
4y ago
because scraping and indexing the site is hard. because getting first response on super slow speeds doesn't accomplish anything because many js devs write buggy code that renders in their browser etc
65.
▲
by
adamzochowski
5y ago
Not OP, but this often is used when I am brought onto a new project against old code base, where no one from original developers is around. I am then given four things: - here is binary that is currently running - here is source code previ
66.
▲
by
adamzochowski
5y ago
One of my favourite auth is the NTLM/SSPI which came out of the the windows NTLM world. Users don't even see they are being asked to be authenticated, they are either logged in, or told they don't have access. Works great in
67.
▲
by
adamzochowski
5y ago
The goal is to avoid password sharing. if 20 people have root password, and server supports root login, then you can't know which of the 20 people had their machines compromised. if 20 people each have to sudo, then you can trace which
68.
▲
by
adamzochowski
5y ago
But they are not. Empty string means "we know this is empty", Null means "We don't know". For example, I have a second name. Some people don't have second names. And some records we might not even know if such
69.
▲
by
adamzochowski
5y ago
There are bad scrapers out there. Plenty of common problems: - Denial of Service by queries - they hit search pages with complex or slow queries, diving to 1000th page of results . This kills the db. - Denial of Service by parallelization -
70.
▲
by
adamzochowski
5y ago
Does this mean that other languages that are gendered also will be fixed? Currently Polish Twitter displays both variations in a single text because it doesn't know which variation to use. For example I see: "Nie wysłałeś/aś
71.
▲
by
adamzochowski
5y ago
Yeah, plenty of people edit files like xml or json in text editors.
72.
▲
by
adamzochowski
6y ago
The backwards compatibility is for physical keyboards. So that a keyboard with just one alt can still trigger polish letters. I don't know how other OSes allow for users to trigger "right-alt" when the keyboard has only one a
73.
▲
by
adamzochowski
6y ago
There is also a whole slew of issues with Polish characters. Polish keyboard setup relies on "right-alt" and a letter to get it's diacritics variation. Ie: 'ą' is 'right-alt'+a Windows for backwards compa
74.
▲
by
adamzochowski
6y ago
Opus at sample rate of 48khz, still only encodes frequencies up to 20khz of listening range (think of opus as having 40khz sampling rate). This is same as audio CDs, which although are in 44khz sampling rate, have a red book recommendation
75.
▲
by
adamzochowski
6y ago
snap has problems that exist for years. It will upgrade a running application without telling the user. Then it will remount all folders in use by the running application in read only mode. As such, your chromium will start misbehaving, cra
76.
▲
by
adamzochowski
6y ago
Some SQL Servers, like MS-SQL have been slowly going into banning order by a number / constant expression, and flagging column numbers as error prone constructs. https://www.sql-server-performance.com/error408/
77.
▲
by
adamzochowski
6y ago
Sigh, In all other programming languages the code has to be along the lines of: if ((jane.car.colour == james.car.colour) and (jane.car.colour != null ) and ( null != james.car.colour)): pr
78.
▲
by
adamzochowski
7y ago
An easy way to think about database nulls is how you would answer a question in real life about unknowns. I have a friend James, and another friend Jane. I don't know their ages. Are they of the same age? Or Jane has a car. James has a
79.
▲
by
adamzochowski
7y ago
FYI: Paranoid adblockers / privacy protectors will block iframe to remote domains. For example: uMatrix by gorhill (same author as uBlock Origin) does this.
80.
▲
by
adamzochowski
7y ago
I think OP's point was that for starting developer PHP is super easy. - edit a text file with any text editor (notepad?) - copy file onto a server (ftp? scp? git push? -- most servers will process php) - access it through url in browse
81.
▲
by
adamzochowski
7y ago
> Otherwise it does not matter how many columns you select, because you will have to read all the columns for every row anyway. It does matter. An index can actually contain a cache of values for some columns. This is done with INCLUDE s
82.
▲
by
adamzochowski
7y ago
The people who say "No Scaling" mean that they want to use screen to fit more things. It is not state of mind about past pixels, but about how much stuff you can fit on the screen. how many lines of code. How many sidebars in your
83.
▲
by
adamzochowski
7y ago
The made up story sound similar to Hertz losing 32 million while hiring Accenture to do internal API rewrite in 2 years. https://www.theregister.co.uk/2019/04/23/hertz_accenture_law...
84.
▲
by
adamzochowski
7y ago
As an application developer I want for my users a consistent experience, irrelevant of OS or distribution. I understand that. But, as a user I want for my experience consistent on my os, irrelevant of that different apps are written by diff
85.
▲
by
adamzochowski
7y ago
There are two solutions to this: 1) use offset colours, like specifying to move 10% in Hue off the theme colour. 2) specify all foreground + background colours and admit that this is special and won't conform to any user or distro them
86.
▲
by
adamzochowski
7y ago
For me I get adblock blocking the series of redirects: Step 1: Engadget is doing a 307 redirect to : ttps://guce.engadget.com/consent?brandType=nonEu&gcrumb=_____&lang=en-US&done=https%3A%2F%2Fwww.engadget.com%2F2
87.
▲
by
adamzochowski
7y ago
User CAL is only cheap if you only deal with small amount of users (internal app). Please note a user is not SQL User account, but represents actual individual person. If you have a webserver (with one db user) but a thousand of visitors, t
88.
▲
by
adamzochowski
7y ago
Google released very own Chrome Extension specifically to block domains that you find to always provide bad results. You can use that to permanently block pinterest, and any forum/stack exchange clones, etc. https://chrome.g
89.
▲
by
adamzochowski
8y ago
Javascript rendered pages load JS which then in turn calls some rest API to get data and use that to render contents. Web scraper stops scraping the html, but calls and scrapes the rest api endpoint.
90.
▲
by
adamzochowski
8y ago
pg_dump provides return codes just like any other executable. Zero means no error, and treat non-zero value as an error.
More ›