skysight-inc/HackerNews huggingface dataset:
If you want less middlemen on the web, you are probably not in favor of advertising. Price tags only involve a middle man of the payment processor. Advertisement involves ALL of the advertisers on the platform.
It's not what it looks like. Selecting either timestamp or timestamptz gives you a string representation in the database's configured local time zone, which your backend's Postgres driver will convert to whatever date representation (like `Date` in NodeJS). But timestamp leaves the time zone out of the string. Your Postgres driver probably assumes UTC in that case, which is a problem if your database is set to PST.

First off, it's regrettable that Postgres drivers are parsing strings at all. That opens this can of worms.

Secondly, the DB locale setting is weird. It's advisable to always set your Postgres config to UTC locale to eliminate this nonsense, but that's not the default. So if your database is on PST, at least timestamptz will output strings that tell your code the correct time zone.

PST database:

select now() as timestamptz; -- 2022-11-09T14:41:12.110-08

select now() as timestamp; -- 2022-11-09T14:41:12.110

UTC database:

select now() as timestamptz; -- 2022-11-09T22:41:12.110Z, "Z" means UTC

select now() as timestamp; -- 2022-11-09T22:41:12.110

This isn't clearly explained in the official docs, btw. I think the only thing saving a lot of users is how AWS, GCP, etc all set their Postgres instances to UTC by default. Which makes this even more of a landmine if you ever use a DB not configured this way.

Another moral of the story is, every string representation of a datetime has a time zone, so it's better to be explicit about it. Something like "2022-11-09T14:41:12.110" is ambiguous. Put the "+00" or the "Z" if you mean UTC. Unix timestamps, on the other hand, are simply defined as a duration of time that has passed since the epoch and have no concept of time zone (don't even call them UTC).

tl;dr Just say no to `timestamp`
I really hope this guy has his "trade secrets" set up on some sort of dead man's switch. It would be a tragedy to lose this knowledge with him.
Maybe it's just me but search results for that were very helpful in my case. Official documentation, stack overflow questions, an informative blog about cte gotchas, all within the top half of results.
I'm not particularly impressed by it.

It's made worse by the fact that it's usually the only way of navigating confluence, as any non-trivial confluence eventually turns into a nightmare maze of abandoned stale pages, dead links and half-baked attempts at restructuring it where the person enthusiastically pushing for the restructuring effort sort of gave up a third through because it turned out to be a lot more work than it seemed.

I've seen this time and time again in both big and small organizations that use confluence. Makes me feel there is a fundamental design problem with the product.
In this case everyone involved, over and over again. There's widespread agreement they're scum.
You can try digging into modern 5G stacks. Search for VNF/CNF, be wary of the fact that it is a much deeper industry acronym-wise (heck, we have 4 and 5 letter acronyms that are not jokes), and hang on to your hat...
Shouldn't the government be responsible for paying repairs to vehicles that have sustained damages due to potholes? Or do they just take people's taxes for no return?
What this has also shown is that most people (literally almost everyone) are better off relying on the traditional financial system.
mtgox was bigger too. There are other reasons for a crypto winter like high interest rates and a newly credible us central bank.
Rest of the world is not bigger when it comes to non residential real estate: private equity, venture, tech, finance.
Beyond the nuisance factor, there is literally nothing helpful I can do. I turned the alerts off. Knowledge of something does not mean we can control it - kidnapping, earthquake.
Having bought Eth at I dunno, $150, it's funny watching people panic or gloat about price swings from $1k, or $2k, or $7k.

Whatever, maybe I'll be wiped out tomorrow. Or maybe it'll be $10k in a year or two. Let's ride it and see.
"If they wanted you, they got in touch."

you make it sound like a prestigious elite club. it was a scam, and it should be called out as such.

also again i personally know two people that received stingy offers from them
Yes and?

Apple invested in ARM and worked with ARM/Acorn on what would become ARM6, in the early 90s. The newton uses it (specifically the ARM610), it is a commercial failure, later models use updated ARM CPUs to which AFAIK Apple didn't contribute (DEC's StrongARM, and ARM's ARM710).

<15 years pass>

Apple starts working on bespoke designs again around the time they start working on the iPhone, or possibly after they realise it's succeeding.

That doesn't mean they stopped using ARM in the meantime (they certainly didn't).

The iPod's SoC was not even designed internally (it was contracted out to PortalPlayer, later generations were provided by Samsung). 15 times and the revolution of Jobs' return (and his immediate killing of the Newton) is a long time for an internal team of silicon designers.
Nope. I just don’t have the time. Would you say you are being patronizing and are making assumptions?
95% of hit usage is fairly easy, yeah. But that other 5% can be extremely difficult.
Such a policy would mean that the consequences of a risk going wrong vastly outweigh the benefits of success.

That would incentivize extremely risk-averse decisions by business leaders and lead to society-wide stagnation. The result would be far more suffering overall.
(After typing this, it occurred to me to check if Emacs has a mode that supports this. And, sure enough, it does! http://www.bobnewell.net/filez/poetry.el)
Congrats! I’ve recently started the journey towards more decentralization and kagi seems to be the next logical fit. So far I’ve self hosted backups with s3 replication and next cloud over tailscale has been amazing but I’m still trying to figure out social media.

How does the workflow look like for sharing an album of pics with friends and family (who are on traditional social media platforms)?
You're cute. In the end of the day this entire shenanigan is a game of musical chairs and as every chair is taken out, you should be more anxious to sit down quickly before the music stops. The actual details hardly matter, this is a game played only by investors, and money is slowly draining. Nobody is inserting new chairs into your musical game, only new participants with their own chairs. Unlike musical chairs, you can leave right now.
Give it a try! The worst thing that can happen is that you destroy something that wasn't working anyway, and you learn something nee

But more likely than not you will manage to wrangle it back together somehow :)

Good luck!
Konst for Rust: Const equivalents of std functions, comparison, and parsing
Zucc's net worth is down more than $100B? Should he lose an arm too?
Record-replay doesnt even work when running the same scenario 2 minutes later half the time - never mind in 2 months' time.

I tend to find in most apps that unless you directly change the front end templates to give elements you interact with better identifiers and then deliberately use those identifiers your browser tests will always end up an unreliable sucky mess.
> There will always be those especially in the younger generations that want something better than the current system.

Sure, this isn't it though.
Bitcoin down 77% in a year.
git add .

We have had multiple security incidents because some developer left a credential file inside the local git clone (no, not all tooling supports out-of-tree stored credentials). Blind 'git add .' is the first thing I teach my developers not to do.
Tons of people got into Bitcoin when it was over 20K. That's part of what pushed it so high last year.
You'd be surprised exactly how much functionality is written in vanilla C and pushed down the stack to raw packet handling. There is hardware acceleration in NICs, but voice is actually a tiny, almost insignificant amount of the workloads involved in some parts of the world.

Think hyperscaler-style SDN, but largely on-premises.
You can set as the default search engine with a Safari extension
I don't think you can call yourself "using git" if you're not comfortable with such simple concepts. Pointing a branch to a specified ref is one of the most basic operations you can reason about when using git!

I'm perfectly aware that many people don't think when using git at all and instead merely copy'n'paste memorized commands hoping that they'll do what they want to accomplish, but this is something you should move past when you want to stop calling yourself a "junior developer". This is one of the most important and helpful tools in your field of work, you can either take advantage of it or suffer.
In a word, no. I’ve spent a lot of time on SEO over the past couple years, and inbound links still matter a lot to search rankings and traffic. This is clear evidence that PageRank still matters.

From a more macro perspective, I’ll believe Google is failing when a competitor starts eating their lunch. What I see right now are a bunch of would-be competitors who want to eat their lunch, including this company. The blog post is probably best understood as aspirational rather than descriptive.

As a user of search, Google results are frustrating at times, but is that because “pagerank is over?” Or because it’s an incredibly hard problem they’re working on? Google does not have to be objectively perfect to keep succeeding, they just need to be better than other search engines.
Because they only allow 50 searches per month in their free tier. You can check how the UI looks using the "Example search results" area in the home page.
Yeah the reason is that Richard Nixon cancelled Project Rover, which had long since demonstrated that a safe and reliable nuclear engine was totally feasible
If you don't add metadata to the README so I can still just open with any editor, I'm all for it.
Hey, in crypto not all is a scam. Some are a proper pyramid scheme, others outright betrayal, and few are just stupid or for fun (:
Talking about containers: is there an easy way to run “system” containers? This is, containers that run systemd and everything else you would expect to be running on a normal Linux OS. I rely heavily on VMs to simulate cloud environments, but I would love to use lightweight containers instead. Also, these “system” containers should be able to run containers inside them as well (docker in docker?).

I saw something on github the other day that may work (can’t remember the name, something about “box”), but it wasn’t available for Macos.
Changing the meaning of the check is a security issue
We would know enough, except people tend to reject the philosophers and prophets who impart ancient knowledge in ways too mysterious to accept as truth.
I feel like I've seen stories about this sort of thing happening a few times at least; almost invariably the newly [re]discovered animal is very similar to another species that was already known to be alive, so while still a significant discovery it lacks some punch. In this case the presumed-extinct animal is quite similar to C. electilis, which was known to be around in the modern era but apparently is poorly documented (the article says living specimens of C. electilis are undocumented so they could only compare the shells.) These are the only two known living members of the genus and both are rare, so it seems like a fairly significant discovery to me. Not really a case of "animals previously thought to be one species are now reclassified as two", like many other species discoveries seem to be.

I think situations like the Coelacanth, where the rediscovered animal is unlike any other already known to be alive, are quite rare. Although even in that case, the Coelacanth was a revelation to science but probably not the fishermen that caught it.
but you're trading $100 worth of Crypto A into $100 worth of USDT or whatever other 'stablecoin' ostensibly backed dollar for dollar with USD, thus there are no gains but you still ostensibly have 'converted' Crypto A to the closest thing you can convert it to that isn't actual USD.

That's the purpose. If you sell a crypto for USD you may get taxed. If you convert it to equal amounts of a different crypto there are no gains and no tax.
For anybody interested in why this comment says "cosine similarity _or_ dot product", its because the vectors in word embedding models are typically scaled to unit length.

If cos(theta) := A.B / (|A|^2 * |B|^2)

And A and B are normalised, then the denominator is 1, and the RHS is equal to the dot product.
Are we in a recession ?
https://archive.ph/CxJqM
Bravo. These pass the “sniff test” and that’s impressive
Game recognizes game.
It turns out that chanting "this is good for Bitcoin" doesn't actually make that true.
The author says the killer feature is:

> Playwright "records" your steps and even gives you a running Python script you can just directly use (or extract parts from). I'm serious about the running part- I can literally record a few steps and I will have a script I can then run with zero changes.

Does Selenium have that ?
Seems like..embeddable Github Pages? Maybe only on your project readme (or elsewhere, can't really tell)?
It would be better to analyze what is broken about the current platforms before thinking about the ideal one. Current platforms are broken because they're centralized and motivated by profit. This means the mechanics of the platforms are designed to maximize profits at the expense of everything else. So the ideal platform must be a non-profit. If the new platform is still a business that must make money for its shareholders then it will inevitably end up in the same place as Twitter, Facebook, and Instagram full of political grifters and scam artists.

Elon keeps saying that his goal is to make Twitter the source of truthful information but it's pretty obvious that the biggest cheerleaders on Twitter are not interested in truth, they're mostly interested in increasing their clout among the Twitterati. I guess that's another thing every good social media platform should try to avoid, constant navel gazing and meta-analysis of the platform itself because the goal should be to help people discover useful information instead of gaining followers and clout by meta-analysis of what is happening on the platform itself.
Yah, I think this falls under the category of a bad business decision that was easier to make because it was reactionary and not preventative.
iOS 16.1.1 includes fixes for two libxml vulnerabilities
Small Changes, Big Results
GitHub Next here!

Kyle Daigle's "Building with :heart:" session[1] in just under an hour is going to show this off, and we'll be getting people into the thing as quickly as possible! No long waitlist here.

https://githubuniverse.com/events/detail/virtual-schedule/a0...
Weeble wobbles but they don't fall down.
Github blocks = Notion style blocks and Jupyter notebook style code execution in your GH repository text files
How funny that timing is. It showcases P5 which has absolutely awful bundle sizes because the code is written in a way that tree shaking (unused code removal) isn’t possible. It attaches everything to the p5.prototype.

This took a site I have from loading 200kb to 1.1mb. It also includes browser polyfills that haven’t been needed for years. Unacceptable.

I hope that P5 can get some attention as a result of Blocks to refactor it to solve this.

https://github.com/processing/p5.js/issues/5740#issuecomment...
There's a certain segment of people with a smug self superiority that think because they earn six figures in places like Seattle or San Francisco that the simple forklift driver in bumfuck, WI has even less chance of buying a home than they have.

They couldn't be more wrong.

While the forklift driver is slowly saving 10k a year for a 150k house, the SF bro is saving 50k a year for a similar house for $1M. Guess who gets to the target first.
We are, a recession is usually called in retrospect after some quarters, we are definitely in the beginning of a recession.
First of: It has been some time since I last installed Docker. It actually was on Ubuntu and a properly current version was not in the distro repositories, so I had to add a new repository and it installed plenty of extra dependencies. It's not hard, but also not really pleasant.

It also seems like Docker is now able to run rootless as well, so my nitpicks are actually more minor than I originally thought. It's still not daemonless, but it would work for my use case still I think.
From reports I've heard floating around, Alameda was making >$1M per day doing their good ol' prop trading. If that's true (and that's a big if) then all SBF had to do was simply stick to the playbook. Do you prop trading on the side, help customers transact crypto via FTX.

How do you even mess it up this badly?
That's no really relevant to Google or Kagi.

YT Premium is a reaction to the infeasibility of subsidizing the extreme cost of hosting video streaming with ads alone. The scale of ads needed to cover hours of streaming video vs. ads to cover search results are magnitudes in difference, and people are more willing to pay to make those streaming ads disappear.

Even so, with a paid option, the vast majority of YT users still use Youtube w/o the Premium subscription.
Not when your infrastructure includes your data store, though. Or if it includes such things as your application endpoint. You may want to stand up the new endpoints and then drain over traffic, as an example. Not take an outage for a deployment.
Not really, FTX was barely in the top 10 for spot, though better in futures. Plus there are DEX and AMM.
We have Eric S Raymond to thank for corrupting the meaning of "Hacker" to include himself.
> The experiment that is Bitcoin shows that people do not need to rely on a monetary system where a cabal of rich and powerful individuals can arbitrarily modify the money supply without any regard to all the participants in that monetary system.

I don't get it. How does this description fail to encompass the likes of SBF, CZ, or Do Kwon? And while they didn't modify the money supply (although UDT kinda did), their actions had a strong impact on the value of money. So anyone holding coins in their own wallets still got screwed by their actions.
Just a PSA for any FTX users out there: please make sure you get details of your balances, deposits, withdrawals and trade history whilst the site is still up.

You can download it as a CSV - I'd also take screenshots to be on the safe side.

Save yourself a potential headache when you come to do your taxes down the line.
Sellers like Mercate Group are a solid reason why the Apple/Amazon agreement took place. Look at the seller feedback - I’m not sure I understand why they’re still allowed to list product for smartphones/electronics.

https://www.amazon.com/sp?ie=UTF8&seller=A389ML6MNB3VQK&asin...
This is the landing page which explains how the app will work. We created this in the meantime while the app is being built.
What about browser extensions?

I had a neighbor who gave his computer to another neighbor. I found dozens of browser tabs that had inevitably introduced malware. His addiction was innocent enough: he wanted online deals, coupon codes, and discounts. The browser extensions promised the world and delivered spyware, adware, malware.
git add .
git commit -m ""

Are like the first 2 got commands anyone tends to learn after git init or clone
The problem with MBS was always the zero-sum nature of the alchemy. They took 100 low-quality loans in, and returned 10 high-quality loans, 30 ok-ish loans, and 60 dog-shit loans. No harm no foul, until the dog-shit tranches were marketed as ok-ish, and alchemists believed they we're really creating gold.
In this case, where do the liabilities come from?

Edit: nvm I guess this thread is about FTX's original business model
This indicates that the value was propped up by market manipulation. I have no problem with a crash like this, as I have no exposure to centralized * exchanges.

I also don't have illusions about price action. I don't invest into crypto to make a quick buck. I invest because I fundamentally oppose traditional finance.
I had similar issues with a different VPN/Proxy at an earlier role. I solved with https://github.com/sakai135/wsl-vpnkit and trusting the root certificate of the proxy on the rancher desktop WSL2 vm (Assuming you're on Windows as I was).

Docker desktop pays for itself by solving these issues though IMO (I wasn't able to get a licence at the old role however)
They just hire people from other places, cheaper labor, I know at least 4 southamericans who worked for them in the past, 100% remote, same talent as an US dev, and 1/4 of the cost
>There are plenty of studies that show that having a "purpose" and working after it is correlated with higher happiness or well being. "Purpose" is vague enough, so to make things worse I am going to conflate it with "life meaning", "calling" or "personal values".

Some subjective sense being correlated with blah blah blah doesn't mean any such thing objectively exists. It doesn't. You have no purpose. Nobody designed you. You're free.
Yeah, someone posting above literally said that their AR/VR teams were left pretty much unscathed. In fairness these teams might also be a lot smaller and more "optimised" in desired structure as they're younger than the rest of the company.
> That it will splinter into many nuclear armed states.

Definitely a serious cause for concern, but not uncharted territory. Remember this already happened to the Soviet Union, and ultimately things were arranged so only one nation inherited those nukes. It may happen like that again.
We already had it in the early years with Facebook, before Zuckerberg added news and the ability to communicate with strangers.
I second this. However I'd like to note that in the later chapters, Cal Newport does develop the concept of 'mission' which has some overlap with the concept of purpose but is defined more constructively.
> The experiment that is Bitcoin shows that people do not need to rely on a monetary system where a cabal of rich and powerful individuals can arbitrarily modify the money supply without any regard to all the participants in that monetary system.

Is this really true, given that the largest currency pair of Bitcoin is with USDT, which is alleged to have been arbitrarily created at whim to pump up the price of Bitcoin?
I get it its a joke and all but do people not realize that in crypto just like everywhere else only the people who dont know what they are doing lose money.

No one whos seriously is into crypto and has looked at the markets sober, didn't see this coming.
Sure most didn't know about FTX or what exactly would trigger it but it was very very clear this crash is going to happen.
Its also very very clear it isn't over yet BTC/ETH are at -72% from ATH while -85% would be the "norm".
Past does not predict the future but still gives a pretty good idea of what is to come.
> Insinuating other users you converse with online are bots is kind of a bad faith claim that derails political discussion

This almost passed the Turing Test, but you can tell it's a bot because The Guidelines were never mentioned.