651 karma · joined November 19, 2009
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...
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.
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).
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
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.
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)
How does what you say "SSH" accomplish server to server transfer without exposing credentials of one server to another?
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.
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
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
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.
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
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.
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.
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/
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.
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.
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
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.
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.
How does this guarantee that the ID is in both tables?
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 .
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.