HNHacker News
TopNewBestAskShowJobs

adamzochowski

651 karma · joined November 19, 2009

submissionscomments
adamzochowski··on Base64 Encoding, Explained
There is also base64URL , where the encoding uses different ascii characters that are url safe. I have seen some devs use BASE64URL but call it just base64, and that can lead to some problems for unaware.

https://datatracker.ietf.org/doc/html/rfc4648#section-5

adamzochowski··on We Built a Streaming SQL Engine
Isn't this what is done by some SQL engines with materialized views?

They update view data (counts and group by and sums) as the source table data changes. But not by rerunning the view, but smartly updating its contents based on the change that happened.

There are tons of limits in these views, as they have to provide stable results.

See ms sql documentation on limits of streamed/indexes sql views https://learn.microsoft.com/en-us/sql/relational-databases/v...

adamzochowski··on Overlooked reasons to still buy physical media
New players can stop supporting decrypting keys, locking out a disc.

Famously intel stopped supporting some encryption chip tech and bluray players for pc stopped working.

Finally, new disks too van stop supporting keys. This means that new disks could bad playback on old players.

So yeah. The tech supports broken behavior and encourages it.

adamzochowski··on We migrated to SQL. Our biggest learning? Don't use Prisma
> Weird pricing: PlanetScale prices you on row-reads and row-writes per month. What is weird is that row-reads is something that nobody controls. It is the SQL query planner which determines the query plan, which results in how many rows you’re reading internally. Remember that row-reads are not row returns. You can write a wrong query that returns 0 rows but can still do a full table scan of 1M rows and PlanetScale will charge you for it.

This is expected pricing. The pricing is based on the load on the db, not based on results.

Usually there are two ways working with this:

DB supports showing estimated query plan , which explains how query would be ran without running it. Allowing to capture any missing indexes or filtered indexes.

DB allows only querying against indexes (this is usually done by no-sql dbs which have flexibility to deny bad queries).

adamzochowski··on Please don’t theme our apps
I don't understand the issue?

The first screenshot (CSS Theming) shows an app that doesn't use standard background color (?offwhite?), but uses standard font color. Normally this works, as standard font color is something dark (?black?).

And the problem becomes when user opens the app in dark mode, the background color stays non standard (?offwhite?), but the font color stays standard, which in dark mode makes fonts bright (?white?).

The question is:

If developer is ignoring theming, why don't they hard code both background and foreground colors?

There is one solution : stop using off theme coloring

This is squarely for developer to fix.

But since they want Gnome/GTK to fix this, here are potential options:

- Gnome / GTK should implement that if someone wants to use non standard, off theme colors, then developer has to always define foreground and background color. --- not sure how feasible it this with nested frames

- Gnome / GTK should disable allowing changing colors to specific values, and only allow changing by rotating Hue (aka 5% rotation of Hue 'clockwise') and by changing saturating (aka 5% more grayscale) and by changing brightness/contrast in relation to paired color (aka: background 5% closer shade to font)

- Gnome / GTK should define more color pairs , kind of like bootstrap has primary/secondary/success/danger/warning/info/light/dark coloring for all components in a single theme

adamzochowski··on RustRover – A standalone Rust IDE
Sublime merge runs on linux. Why is it not a good git gui?
adamzochowski··on The Decomposition of Rotten Tomatoes
IMDB predates html and http protocols.

When IMDB was sold, it was seen as if wikipedia was sold to a private company. Amazon promised to leave IMDB mostly alone, and to provide data feeds / db backups for free. They are still available although new features of IMDb have not been migrated to the original datasets.

adamzochowski··on Goodreads is terrible for books – why can’t we all quit it?
For fantasy and sci fi there is nothing better than : Worlds Without End https://www.worldswithoutend.com/

The site tracks multiple literary awards: https://www.worldswithoutend.com/books.asp

The site tracks books by nominations and awards: https://www.worldswithoutend.com/lists_top_noms.asp

The site tracks top book recommendations by literary critics: https://www.worldswithoutend.com/lists.asp

And finally, most read books. https://www.worldswithoutend.com/lists_top_reads.asp (I hate that most sites don't allow me to sort not by rating, but by votes cast, or by review count)

adamzochowski··on VPS Benchmarking – Cloudfanatic, DigitalOcean, Linode, Vultr
Why not ovh's option called kimsufi or not Hetzner?
adamzochowski··on nic.funet.fi: Serving freely distributable files with FTP since 1990
FTP does FXP without either server knowing credentials of the other.

How does what you say "SSH" accomplish server to server transfer without exposing credentials of one server to another?

adamzochowski··on UnsuckJS: Progressively enhance HTML with lightweight JavaScript libraries
I don't think preact is part of the "progressive enhance html"

Progressive enhance HTML means whatever backend you use, it spits out html, and the HTML is rendered without Javascript. Preact fails this.

The libraries are meant to progressively enhance html by replacing or enhancing certain actions with small javascript. For example, with htmx, usually clicking on html link would load complete page, but with clever htmx directive, the link onclick will only load/replace what is needed.

Think of progressive enhance html as html first. As the page working even if javascript is disabled.

adamzochowski··on Evolution of the Scrollbar
When keyboard is not supported and I can't scroll by pagedown/space buttons.

When keyboard is not supported and I can't scroll to the bottom.

When I want to scroll to find something in a binary like fashion, scroll to the middle, decide if what I want is at upper half or bottom half, etc.

Not all people have scrollwheel to begin with

Scrollwheel is broken, as many overwrite OS behaviour, and generally slow even if you specify in settings to perform larger motion per scroll action

adamzochowski··on Show HN: FlingUp, a Reddit-like platform Ive been building for the last 2 years
I don't use mobile, so I can't comment on that, but I can compare to old.reddit (the classic good version).

Overall it is decent, but there is still plenty of work,

Here are my comments, ignore if you don't agree.

----

Content loading: Initial Page

old.reddit.com loads fast all content, without javascript. flingup.com instead is stuck on 5 blue bars bouncing because no actual content is loaded on first page. It is all loaded on some delay for some reason. Here is a thing: render content on backend, and if it is expensive, render it and cache it.

The only good thing is that flingup uses own subdomains, unlike reddit that uses other domains like redditmedia.com / redd.it / reditstatic.com . I hate companies that use alternative TLD because it is hard to discern if domain is real, or used by scammers.

Additionally, only 2 javascripts are needed to load flingup, and they are hosted from realm.flingup ... the other 4 seem to be some form of bloat. Basicaly, there is an iframe that loads something from realm.flingup on port 8443 and this iframe loads two javascripts. If these are so critical, why are they loaded through an iframe? why port 8443? why realm.flingup ? Sigh.

the good part, despite flingup being js based, it supports middle click / control click on links correctly, unlike plenty SPA. But not all items, can't middle click to see user profile, instead user has to normal click, which does some odd useless popup with an actual button to see user profile.

----

Content look: information density at 30%

old.reddit.com gives me 29 items I can see concurrently on my screen. Flingup only shows 9.

----

Content look: almost no comments loaded (25% of 40)

I will ignore the fact that most items are just links, not discussions. But lets use the top link "migrating from reddit" as example. It has some odd 40 comments, but only like 10 are loaded, because the remaining are hidden behind a series of 'there are 3 replies'.

Contrast this with old.reddit that will load 500 comments, up to ?8? levels deep (I counted up to 8, maybe more?) with a button to 'load more comments' either in a thread, or at bottom.

Paradoxically, my other complaint is no option to collapse uninterested thread, or to link to specific reply (aka permalink)

-----

Content: tooltips missing

I dislike the '2 days ago' as it doesn't say when. old.reddit provides actual time of a comment / post when user hovers over '2 days ago'. Flingup doesn't.

ps: fling sounds like a dating app.

Cheers

adamzochowski··on Hash Functions
There is a fourth category of hash functions: find similar items.

For English words, this is usually done with soundex / metaphone / doublemetaphone. Fun fact, soundex was developed over 100 years ago to help immigrants find their families in USA even if they didn't know how to spell their last name. Soundex is supported by most DBs.

For images, there are hashes like ahash/phash/dhash/whash/blockmeat/colormoment/colorhas/marrHildreth .

Most popular Audio hash is acoustid. There was also EchoPrint (with two incompatible versions), but once EchoNest was bought out by Spotify the public support and development into echoprint died. Some groups of people tried to keep echoprint alive but I am unaware if it is still used by anyone publicly.

adamzochowski··on Ask HN: Could Usenet get revived, to replace the soon to be unusable Reddit?
Unfortunately you can't do site:old.reddit.com , It is a tragedy as old version loads more comments and has better UI.
adamzochowski··on Show HN: I made a retro game archive for Polish games
This is missing Electrobody / Electroman

https://en.wikipedia.org/wiki/Electro_Man

https://www.youtube.com/watch?v=GosPJVggVmI

As per burmistrz for c64, I remember playing a differently looking version, all mostly black? Maybe v1? http://www.gamebase64.com/game.php?id=20415&d=36&h=0

adamzochowski··on Htmx 1.9.0 has been released
Constantly innovating can also be interpreted as 'having no standard'.

I had developed sites for 25 years. I still have a corporate site that was developed 20 years ago, and it returns more results, and is faster to render than most of new fangled SPA I seen deployed on servers 20x larger.

I do agree with you that SPA (react and its ilk) have cleaner benefit of composability of components, but I would posit that AJAX and component state/props has made for less reliable web. I often find myself in situation where SPAs crash mid way during concert or flight purchase - be it JS error, or network instability. Reloading the page doesn't get SPA to resume where it crashed, but often throws additional errors, saying I am already mid way in checkout (but I can't continue), or invalidating session (but still remembering that my other session was in process of buying a seat, so I can't reselect the seat I wanted. Finally, they are terrible for bookmarking or sharing.

So the composability of components, a benefit, came with a need for developer to be extra careful about failure modes, resuming states, bookmarking directly to specific content. Most developers are not careful, and the old html per page model forces different mentality for dealing with failures, and content availability.

adamzochowski··on Show HN: APIRank.dev – We crawled and ranked public APIs from the internet
This seems to lack tons of APIs , maybe instead of 'apirank' it should be called 'openapi dev rank'.

Apple Itunes : https://developer.apple.com/library/archive/documentation/Au...

last fm : https://www.last.fm/api

acoustid : https://acoustid.org/webservice

spotify : https://developer.spotify.com/documentation/web-api/

discogs : https://www.discogs.com/developers

deezer : https://developers.deezer.com/login?redirect=/api

music brainz : https://musicbrainz.org/doc/MusicBrainz_API

gracenote : https://developer.tmsapi.com/Sample_Code

---

Additionally, why not list API rate limits?

Or some lookups don't need any security, like querying Apple Itunes does not require anything except for being nice and rate limiting.

adamzochowski··on Ask HN: Are people still using Pascal?
Total Commander was in Delphi, but is now compiled with FPC. This is best file manager for windows. https://www.ghisler.com/

I believe Zoom Player too is a pascal beast. Before VLC became ubiquitous and playing all formats, Zoom Player was one of the top windows contenders. Since then Zoom Player grown to be also Zoom Commander, which is a player for meant for restaurants and venues, with ability to split video across multiple screens, with multiple overlays. https://www.inmatrix.com/

adamzochowski··on My daughter's school took over my personal Microsoft account
This doesn't work perfectly well if you are on multiple calls at the same time.

Desktop Teams allows you to join multiple calls at once, and switch between them is easy.

Web browser teams disconnects you from one meeting to join another. The only solution is to open multiple browser profiles, each for different call, and then manage the 'mute tab' manually. Additionally, web browser edition has something to detect if tab is active, and will downscale / delay video stream if tab is not active. This is extremely annoying when you have meeting active on one monitor, and want to double check what is being discussed on another.

Saying all this, web browser teams at least works. Desktop one stops working because as the whole discussion here points out, accounts get mixed up. I can't join team meetings anonymously because desktop edition thinks I have an account, but when I try to login it tells me my account doesn't have Teams enabled.

adamzochowski··on Binary to text encoding – state of the art and missed opportunities
Article doesn't mention yEnc, that is (or was?) very popular for binary attachments on usenet.

from wikipedia https://en.wikipedia.org/wiki/YEnc

> yEnc is a binary-to-text encoding scheme for transferring binary files in messages on Usenet or via e-mail. It reduces the overhead over previous US-ASCII-based encoding methods by using an 8-bit encoding method. yEnc's overhead is often (if each byte value appears approximately with the same frequency on average) as little as 1–2%, compared to 33–40% overhead for 6-bit encoding methods like uuencode and Base64.

adamzochowski··on AcousticBrainz: Making a hard decision to end the project (2022)
This is based on old Echonest scanner. Echonest was bought out by spotify. Echonest had same issue as AcousticBrains, their first scanner sucked and mid way had to ask people to rescan using a new version.

Echonest used to provide source code, but after being bought by spotify, they stopped updating their code, disabled fingerprint server, etc: https://github.com/spotify/echoprint-codegen

adamzochowski··on PRQL: a simple, powerful, pipelined SQL replacement
An optional value just means that the value is unknown.

For example, it is optional to enter the colour of the car I own. So my car colour is null. The database can't confirm if my car is Red or isn't Red, because it is an unknown value.

adamzochowski··on PRQL: a simple, powerful, pipelined SQL replacement
> SQL has many problems: > "from" should come first to help auto-complete;

Agreed

> null handling is complicated;

Mostly the issue is that null in dbs has different semantics than all programming languages. I wish programming languages used the db style of handling nulls. In dbs, null means that the value is unknown and can't be reasoned about. DB uses nulls in how people reason arguments: "Joe's age is unknown, Jane is 25 years old. Are they of same age? We can't say if their age are equal, or unequal, because we don't know."

> the syntax in general is weird.

I find syntax to be like any time switching a language. Python is weird to C++. Atleast with SQL, I find usage docs more understandable than many programming languages.

> Compatibility is a problem

This sounds like a complaint that two different programming languages are not providing same features. Or two operating systems have different UI toolkits (and different menu conventions, like where should the 'preferences' be under).

I wouldn't expect sqlite to be Oracle / MSSQL / PGSQL compatible.

adamzochowski··on Make your database tables smaller
1:1 mapping means that if one table has a row, so does the other.

How does this guarantee that the ID is in both tables?

adamzochowski··on Show HN: A new search engine UX I've been working on in my free time
I don't want to be tracked. The options are: swurl is ok with denying users access that it can't spy upon. I am ok with that. Or swurl builds code in a way to gracefully still work if a script doesn't get load. This would be good when google tag manager has a bug and no longer works, and for users who are behind proxy/dns pihole systems or other system settings that prevent them from being tracked.

And for your reference, i enabled googletagmanager in uMatrix, but it still got blocked by uBlock origin. I suspect even if i were to disable both uMatrix/uBlock origin extensions, then my pihole would still block it.

As per using caching proxies , use dns cname. So security conscious people / paranoid configurations know that the caching proxy is in your control and wont leak cookies from other domain accesses. So define something like pix-cdn.swurl.com or static.swurl.com .

adamzochowski··on Show HN: A new search engine UX I've been working on in my free time
I use gorhill's uMatrix (author of uBlock).

uMatrix is awesome as it disables any 3rd party domains and only loads content from main domain that author controls. it also allows blocking by content type. Like iframes.

I believe some blockers designed for telemetry blocking, like ghostery or privacy badger, will come with js shims. So they will block google tag manager, but will load a replacement JS to make sure the page doesn't behave in a broken way.

uMatrix is more general purpose and does't do shims. Saying this, website should detect telemetry didn't load, and either still work, or display error saying why it can't proceed.

adamzochowski··on Show HN: A new search engine UX I've been working on in my free time
Broken behaviour without google tag manager. I have disabled google tag manager, but javascript excepts it. It is generally recommended way to write javascript not to expect any spying/telemetry tooling to always be loaded.
adamzochowski··on The GIF Is on Its Deathbed
I wish mp4/av1 could be put as <img src= or <body background= or through css as background-image: url() . As it stands, to replace GIF one has to go through a hacky series of other tags/options.
adamzochowski··on JSX Mail: Ending All Your Problems When Creating Email Templates
Does render() also generate plaintext?
← PreviousPage 2 of 8Next →