My Jellyfin server now streams live TV without a tuner, and I finally stopped channel surfing
It only takes a few minutes to set this up
We haven't written up this one. XDA Developers has the full story — the link below goes straight to it.
More in Tech
Adding a foreign key to a big table without locking both of them
Foreign keys are the constraint people add late. The table already has a few million rows in it, someone notices that order_items.order_id can point at nothing, and the fix is one line.
Why SQLite refuses your ALTER TABLE, and the twelve-step rebuild it wants instead
Coming from Postgres, SQLite's ALTER TABLE feels broken. It is not. It is small on purpose, and the rules for what it refuses are consistent once you know them.
London property manager breach may have exposed bank details and lockbox codes
City Relay says intruders accessed its Metabase Cloud instance twice and extracted customer data
CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it
The standard advice is "always CREATE INDEX CONCURRENTLY in production". It is good advice and it is also a little lazy, because it skips over what the concurrent form costs and when you are paying…
One line stops a migration from taking down production. Almost nobody adds it.
Here is how a migration that does no work at all takes a table offline. ALTER TABLE orders ADD COLUMN note text; A nullable column, no default.
Samsung Galaxy Z Fold8 Gets Korea Sales Bump After iPhone Duo Reveal
Buying a foldable phone means weighing a premium price against thickness, weight, durability, and the value of a larger display.