skysight-inc/HackerNews huggingface dataset:
> I would guess that my biggest issue is not the details of the IAP, but rather marketing. I don't really do much of it outside the occasional tweet or social media comment. These blog posts are my primary marketing strategy.

Spot on. Makers think releasing the product is the end. It’s actually just the beginning. Now that your product is released, you will live and die by the sword of marketing.

As an indie developer, I made a month worth of sales in 3 days when a YouTuber mentioned my app. Not even a big YouTuber (few tens of thousands subscribers).
> I'm also posting this here because I assume many of your are professional web developers. I'm a learning hobbyist and wondering if there are any issues with the way I built the website.

I ran Lighthouse over the site. Excellent scores!

The one improvement I would suggest is to increase the contrast between your text and background. Currently the text is a little hard to read.

Have great fun coding!
> Try to avoid the bespoke features of psql in favor of generic SQL unless cornered by circumstances into doing so, methinks.

Why? To make migration to another database easier? I've never had the need to migrate any application away from postgres. I usually take full advantage of what the database can do.
Is OSM good at keeping up-to-date with commercial data? I always thought it wasn’t so good, but maybe I’m wrong
The industry does not distract from harm to shake the followers off the tail. Whoever comes next will have to bear huge costs getting over the insane regulatory requirements. The more politicians are involved in the process, the more secure are initial investments.
20 years ago LAMP (Linux, Apache, MySQL, PHP) stack ~is~ was the most common combo of the web
Oxide: Control plane data storage requirements
I don’t. How are new grads supposed to learn the ups and downs of different choices they make? Just being told they’re led astray in a blog post isn’t gonna work - it’ll backfire.

I used node as a new grad for things it wasn’t meant for and that’s how I learned what it is good at and what it isn’t.
It is like having Google's MusicML output a mp3 of saxophone music and then ask what proof is there that MusicML has not learned to play the saxophone?

In a certain context that is only judging the output, what is meant by "play the saxophone", the model has achieved.

In another context of what is normally meant, the idea the model has learned to play the saxophone is completely ridiculous and not something anyone would even try to defend.

In the context of LLMs and intelligence/reasoning, I think we are mostly talking about the later and not the former.

"Maybe you don't have to blow throw a physical tube to make saxophone sounds, you can just train on tons of output of saxophone sounds then it is basically the same thing"

The enter discussion is ridiculous.
To be honest, it sounds like it could be the friend in Austria who fell into a scam, and is thus left with cash flow problems.

Victims in these situations are pushed to beg money from their family and friends.
This should be titled "Just use Sqlite", you really rarely need anything more unless you're Google or Facebook.
1. With the recent developments at CockroachDB one may like to bundle it along with MSSQL and Oracle.

2. Like the author, I will like to understand "Why not MariaDB? (a free variant of MySql)".
I can think of two positive achievements: Pushing electric cars to the main stream (Tesla, he didn't found it, but I do believe he impacted its success dramatically) and pushing for space exploration (Space X). I find both important. Did I miss some other positive impact he's had?

I've never been a fan to be fair, and he surely didn't make it easier for me the last few years. But I think some of his potentially negative traits, incredible risk taking appetite and stubborness, propelled these two fields forward. Faster than they would have been if he wasn't around. Perhaps someone else would have done it with the same effects, I don't know.

I used to think there _must_ be method to the madness. But since the Twitter takeover and subsequent right wing transformation, I don't see it anymore. He seems way too smart to fall into a silly us-vs-them mentality. I refuse to believe he doesn't see "left" and "right" policies in a nuanced light. My only explanation is that he's going through some severe personal issues, and we're witnessing the symptoms in public. I don't like him, but I hope he can work through them and find happiness. Not just for his sake.
Good. The richest man in the world doesn't get to be above the law on account of being rich.

If you own a company, that comes with responsibility and if you shirk those responsibilities the law will come for you; as it should.
The difficulty is that the people who appear to "thrive on uncertainty" are actually thriving on collateral damage.
This actually used not be the case. About six years ago I was in San Francisco for work, and was surprised how inexpensive it was. Like, it wasn’t cheap, but I’d heard it talked up as basically the most expensive place in the world, and it was largely cheaper than Dublin.

Going back recently, it’s a _lot_ more expensive; home has gotten more expensive too, but not at the same rate.

(Some of this is due to the currency thing, of course; the dollar was about as weak as it ever got post-financial crisis in 2018.)
> Does it show clearly which data each app collects?

I think it would be very funny if it turns out Epic don't understand GDPR (data collection) and DSA (dark patterns), in much the same way they've already had a settlement for COPPA: https://web.archive.org/web/20221219211645/https://www.nbcne...

It's possible to win every battle, and still lose.
Na. The post is good.
Just use SQLite3.
You will with 99.99% chance never need more. Now what?
> There is absolutely no reason you can't make SQLite go all the way.

No reason you can't, but one you to consider if you should. If you're using libraries which make assumptions about your database layer, they may not like the sqlite model. Holding the writer mode for too long is something I experienced in write a few projects. For example paperless-ngx will block the web interface while batch importing documents, even though there's really no reason to do that.

It's less of an issue if you write all your own code and you explicitly target sqlite. But worth keeping in mind.
And in countries such as Germany you are legally required to be an employee if you only work for one company. The government will sue the company or if not reachable, they will sue the employee.

So deel.com is a usual choice.
Especially they shouldn't treat their customers like children.

Warn him of the possible fraud, let him sign some form of agreement but then send the money.
You are missing my point.

We do not leave in an ideal world. Saying something should happen does not translate to it being done.

Example, Bush vs Gore was decided by the courts, not by recount.

So if that election was stolen, we will never know.

In that case, your whole argument falls apart, there should have been a recount but that never happened.

In that case, if firmware altered enough votes it worked.

" Justice Antonin Scalia, convinced that all the manual recounts being performed in Florida's counties were illegitimate, urged his colleagues to grant the stay immediately.[1] On December 9, the five conservative justices on the Court granted the stay, with Scalia citing "irreparable harm" that could befall Bush, as the recounts would cast "a needless and unjustified cloud" over Bush's legitimacy. "

Now replace Bush with Trump, have a blatant steal, work a lawsuit up to supreme court, have supreme court decide the same way.
Yep, it's a huge improvement for complicated pipelines.

One thing to be aware of is "NOT MATERIALIZED". Here's what the docs say:

A useful property of WITH queries is that they are normally evaluated only once per execution of the parent query, even if they are referred to more than once by the parent query or sibling WITH queries. Thus, expensive calculations that are needed in multiple places can be placed within a WITH query to avoid redundant work. Another possible application is to prevent unwanted multiple evaluations of functions with side-effects. However, the other side of this coin is that the optimizer is not able to push restrictions from the parent query down into a multiply-referenced WITH query, since that might affect all uses of the WITH query's output when it should affect only one. The multiply-referenced WITH query will be evaluated as written, without suppression of rows that the parent query might discard afterwards. (But, as mentioned above, evaluation might stop early if the reference(s) to the query demand only a limited number of rows.)

However, if a WITH query is non-recursive and side-effect-free (that is, it is a SELECT containing no volatile functions) then it can be folded into the parent query, allowing joint optimization of the two query levels. By default, this happens if the parent query references the WITH query just once, but not if it references the WITH query more than once. You can override that decision by specifying MATERIALIZED to force separate calculation of the WITH query, or by specifying NOT MATERIALIZED to force it to be merged into the parent query. The latter choice risks duplicate computation of the WITH query, but it can still give a net savings if each usage of the WITH query needs only a small part of the WITH query's full output.
Why would we be? We’re gaming against Apple’s wishes.
Yes, but you know when that will happen.
Is Bill Gates a savior or a villain?
Also you are not taxed on that notional 29k, of course (this is one reason that companies often offer in excess of the statutory minimum paid leave etc; it’s essentially an un-taxable benefit). Given the choice between an extra week paid leave at your 100k a year job (notional value is ~2k) or a 2k raise, you’re probably better off taking the leave.
We seemed to be talking about trails. Maybe I misunderstood.
Hand-optimizing the sprite and billboard renderer for our GTA3 Dreamcast port
As a moral relativist, I'd go even farther: I derive my values from me. Or my own intuition.

Since I believe values to follow are arbitrary, it doesn't matter that much where they are derived from. Religion? Sure. Bodily pleasure? All right. Following the vibes? No problem. Civilization-sized or not, meh. No explanation needed.

It's only when I descend towards the practical life, and have to put on my hat of a good citizen, the choice and origin of values starts becoming relevant. There, I may say: I derive my values from my intuitions on co-operation.

But are my intuitions drawn from liberalism, or did they merely end up similar to liberalism? Having been part of a somewhat liberal society since birth, I can't give an answer one way or the ohther.
Author here.

This can be addressed with PG views. You create a view where deleted_at IS NULL and now you query the view instead. Furthermore, if the view is “updatable” (which is the case when it only has filters), you can also do updates and deletes directly against it, and it all just works. So as long as your ORM/query builder can work with views, you are good to go.

I understand many devs want to avoid moving more logic to the database (I also personally avoid stored procedures and similar) but views are quite declarative and simpler to manage than indexes.
But they all identify with the same hierarchical structure to some degree, at least if we're talking about a group like Roman Catholics, Sunni Muslims etc. It gets more complicated of course where e.g. Judaism is concerned, because that's more than just a religion.
> Rick Houlihan is currently at MongoDB.

Not according to the YT video.

AWS in 2018

I did not detect technical flaws in the article. I thought it was very good
It’s because PHP’s popularity is old and Postgres used to be mid. MySQL was faster and better than Postgres.

But Postgres slowly improved and then got better than MySQL while MySQL stagnated. The most basic bugs persisted, basic features never got added and consistency never seemed to be a point of improvement.
I'd rather suffer the Apple nanny state than the Google spyware empire. And the Google Material UI is eye-bleedingly terrible in its absolute blandness.

I just wish there was a serious third option.
The first part of the question is formed so weasely. "You acknowledge that you are expected to...".

Sure, I can acknowledge that GOOG is expecting me to do stuff, but other than me acknowledging the request, it's not asking me to fulfill its expectations (yet). Can you acknowledge me saying "Go fuck yourself" to your expectations?

Obviously the second part is less weasely...
To be fair they said "frontline application", not a transaction processor specifically. Also in cases where you can't lose stuff it's common to use reliable steam processing, so maybe they can reprocess old events into the system running sqlite. (This is extra general info about "important systems"; I don't know what OP is running)
Xapian: Open source search engine library
How can I find these people? Especially people who were fired or pushed out for example?
When people say "Just use SQLite. It's almost as good as Postgres and you won't need anything more" I'm trying to understand why I shouldn't just use Postgres. It's not like it's hard to install or has any significant overhead. Please enlighten me.
No. Even though I navigate with Osmand regularly, I must use Gmaps to find stores' existence, address, hours, phone number, url. Gmaps is the yellow pages. Osmand is a map.
And often no databases manager is the best solution.

Literally

If you are not storing much data no datase manager is th best
> They have been led astray.

They haven't though. What's wrong with using a tool even if it might be bad? Especially as a fresh user. It's how we learn. From both good and bad experiences.

> They need help.

Sadly it's not the fresh grad, but the "experienced" that only keep their old experiences that need help. Is this comment from 2010? MongoDB has improved. Maybe not to the point of being the best but definitely not unusable.
> If you, like me, are unchurched and don’t draw your values from a religion, then where do you get them from?

There's an even easier rebuttal: how does the believer choose which texts to obey and which to discard? Even if he blindly pledges himself to one particular translation of one particular text, how does he decide whether to eat bacon, kill homosexuals, or stone disobedient children?
Organic Maps is nice. On my phone (GrapheneOS Android), I use Organic Maps exclusively now, and haven't yet seen a need to install or use Google Maps on the phone.

(I still use the Google Maps Web site on my laptop, though, and like StreetView, satellite, and the texture-mapped aerial 3D imagery there.)
> The "SQLite is just a file" thing is actually an advantage.

It's more like besides the point. Everything in Linux is "just a file".
Depends on your workload, immutable tuples and vacuum can hurt a lot. (Although that got much better recently) Also the mad decisions about the query planner which you can't control. Often this doesn't matter, but it's worth being aware.
The ease with which Apple's rules may be circumvented is situation-specific, e.g. Facebook ran an ad campaign to protest against Apple enforcing privacy rules which (to my not legally trained eye) seem to have already been a legal requirement for app developers in several jurisdictions before Apple made it also a contractual obligation: https://news.law.fordham.edu/jcfl/2021/03/29/the-privacy-war...

So, for Meta, in this specific case, the law was easier to ignore than the developer agreement.
> ‘verbonden’

Co-op is the word you’re looking for. These co-ops went far beyond just healthcare after all. They owned bakeries, pharmacies, entertainment facilities for the workers, …
I can’t speak to the official decisions made by these camps/courses, but from my own experience as an undergrad, I was first introduce to MySQL, and the professors at my university did not teach using migration management tools for bringing a schema in a database up. You were either using a GUI to set up the tables, or running your own cobbled together sql files. For class assignments this was fine. Then I had a professor introduce mongo to me. I was floored by the idea of having my schema live along-side the application code! No more messing around in SQL GUIs! Then of course over time I realized you still need to maintain a schema over time and provide someway to “upgrade” data when your schema evolves, and keep your data consistent. Then I discovered the tools around migrating mongo data are not nearly as mature as the ones you’ll find for SQL databases.

I find mongo alright at producing a short-lived prototype of an application (e.g. school assignments), but the risk of it shipping to production for a long period is too risky for the “benefit”.
I tried systemd-nspawn which is similar but NixOS will complain about sandboxing if run from any kind of container layer. Fedora 40 works for me without any workarounds. It runs on a very recent 6.9x kernel with bcachefs and everything so at this point I’d rather just install nix on top of it.
Hi, the site looks nice.

It's not working as intended on firefox, though, when autoplay is disabled (this might be the default now, I'm not sure).

There is no way to know that the videos are videos, so the tips looks like a bunch of images. Clicking on them has no effect.

The only way to play a video seems to right-click on it, and select 'Play'.

You might want to add a 'play' button overlay on the videos thumbnail images, and/or show the controls by default...

Hope this helps,
Been waiting a rew decades now...
That is unbelievable to me. You always have the right to quit, and penalties are rare. The laws depend on the country you're in of course, but I've never heard of three months, and I've lived in Europe my whole life.

Would you mind sharing the country you were working in?
I don't have problems with that, we have effective controls. But the warehouse data requires context, and that's supplied via our metadata db. Once metadata starts having actual records associated with it you can't remove it, or you just end up storing junk.
Ah yes, the I don't have any other use case therefor all others are not good
uBO already runs on iOS. Orion is compatible with Firefox and Chrome extensions. The lack of extensions in mobile browsers is a sign of Mozilla's decay, not a sign of Apple being unnecessarily restrictive. They also don't care about you having extensions on Android; their most recent redesign left Android Firefox users without extensions for months.

Mozilla is an ad-supported company from every angle: Pocket, search deal, the ads built into Firefox. Why don't they get more of the blame for the current state of the browser ecosystem?
So what do you do when it turns out there are large groups of people who just can't socialize well in an environment like that where other groups are a majority?

Liberalism doesn't answer this nicely because of the belief that everyone is more or less fungible.
"Right to work" is an anti union provision and has nothing to do with being fired.

You might be thinking of "at will employment" - which is the case in 49 of 50 states.
I think you’re wrong there. Once the company is out of appeals (which should be soon for labour stuff), it will AIUI have a debt to the employee. The employee can then ask a court to enforce the debt, after which they can instruct a sheriff to seize goods (a sheriff in the Irish system is pretty different to a US one). However in practice most companies, unless they’re basically already dead, are going to pay a relatively small creditor, because they presumably need credit to operate normally.
The problem on such discussion that many Americans (I am not sure if you are but experience says yes you're) tend to use only straw man arguments (and that's why the reason they are ignored)
"When hiring employees means you’re hiring them effectively for life, it creates disincentives for hiring. "

In Germany it is not the case.

"The other thing is the employee obligations it creates. When I worked in Europ"
Europe is a big place and working law in the EU (and outside too!) is in the charge of national law. Where have you been living ?

In Germany you can talk to company to quit earlier because these quitting comworkers tend to be rather unproductive.
The Text Encoding Initiative (TEI)
Linux didn’t “do” anything to *BSD. Linux emerged at the same time there was a nasty lawsuit against BSD.
Your tendency may be that but the reality is my past companies want to ask me to contract for them after I leave, even 7 years later.

I uphold a certain quality of work and I expect my peers to do the same. Everyone makes mistakes but even mistakes can be modeled.
On the MySQL vs Postgres topic: We migrated for two reasons.

The first is that I consider everything remotely owned by Oracle as a business risk. Personal opinion and maybe too harsh, but Oracle licenses are made to be violated accidentially so you can be sued and put on the license hook once you're audited, try as you might.

But besides that, Postgres gives you more tools to keep your data consistent and the extension world can save a lot of dev-time with very good solutions.

For example, we're often exporting tenants at an SQL level and import somewhere else. This can turn out very weird if those are 12 year old on-prem tenants. MySQL in such a case has you turn of all foreign key validations and whatever happens happens. A lot of fun with every future DB migration is what happens. With Postgres, you just turn on deferred foreign key validation. That way it imports the dump, eventually complains and throws it all away. No migration issues in the future.

Or the overall tooling ecosystem around PostgreSQL just feels more mature and complete to me at least. HA (Patroni and such), Backups (pgbackrest, ...), pg_crypto, pg_partman and so on just offer a lot of very mature solutions to common operational and dev-issues.
This process is quite normal. The reason is two fold - first they want multiple people to interview the candidate before making a decision, one bad interview doesn't necessarily rule out a candidate. The second reason is the candidate experience. Some candidates feel humiliated if their interview is cut short and will harbor bad impression of the company for a long time. The company doesn't want that.
Just use fdroid. It's a nice app, great for hiking. Last time I used it (2 years ago), it seemed to be quite a battery drain, not sure they fixed it in the meantime.
Thanks, and thanks for sharing, I love the idea and will think about it. Even though my intuition says it would be more productive if I put more time into adding content and polish to the existing concept, and people openend the actual software to practise their muscle memory.

I won't make this for other software, because I don't have that level of expertise for anything else. I've spent years helping other blender users, this is why I feel confident to author the information in this particular case.
Why did my predecessor leave?

Helps to avoid DevHops companies were the tech debt rolled out to customers is sending the core team fleeing..
This is someone who’s worked for Twitter, which at least historically paid Big Tech(tm)-ish wages, for over a decade, and is in a pretty senior position.
If Postgres already had decent temporal table support (per SQL:2011 system time + application time "bitemporal" versioning) we never would have gone down the road of building XTDB. From the perspective of anyone building applications on top of SQL with complex reporting requirements in heavily regulated sectors (FS, Insurance, Healthcare etc.), "just use temporal tables" would be the ideal default choice. To get an idea of why, see https://docs.xtdb.com/tutorials/financial-usecase/time-in-fi...
Sorry but MySQL was not really “better” than Postgres.

I never understood back then why MySQL was the default choice for so many people.