skysight-inc/HackerNews huggingface dataset:
Counterpoint: I over-used SQLite because it was the first database I encountered and spent waaaay longer working around its shortcomings than I eventually spent porting to postgres.

Long version: I couldn't get bulk insert performance above absolutely miserable levels. I tried tricks like deleting and recreating indices but without luck. The perf tooling wasn't there to quickly figure out where the problem was (this was 10 years ago, not sure if things have improved) so I wound up building a version of SQLite with debug symbols and profiling it with a C profiler. The problem turned out to be a default setting that made spill-to-disk very aggressive and basically guaranteed that any workflow like mine would grind along with miserable slowness and no outward indication of what to do about it. I found an email thread where someone in effectively the same situation made some constructive suggestions and got turned away on the principle that even casual users ought to just know performance knobs like this one. Yikes. I am probably munging some of the details, but it made me angry enough to learn postgres and port my code over despite having a fix for my immediate problem.
Hate to sound heartless, but ... reading is still an option. So is making stuff. Hobbies. Hell, thinking. "Back when I was a kid" we didn't have our own telephones either - yet we didn't get suicidal about it.
> The limited type system and loose data validation always prevented me of using SQLite.

This.

"limited type system" is actually an exaggeration in my opinion. The "data types" seem to only serve documentation purposes. You can always store any value in any column regardless of the "data type"
Since you enjoy tinkering with linux have you considered trying Fedora Silverblue/NixOS/Guix or the like? It's quite a steep learning curve but almost guarentees that you're never left in a bad state of configuration.

I'm of a similar mindset and in my period of using Windows as a daily driver I concluded that neither Windows or Linux was that much more unstable but it is my tinkering that causes 99% of my own problems.
>I have no real methodology to assess the quality of any other brand

But then how did you assess the quality of Apple's chargers? Can the same methodology not be applied then to other brands as well?
I personally prefer

int x = (cond) ?
5 :
1;

Since the question mark applies to the condition and not the 5. This also highlights the 2 possiblities of the value in a more clear way. The two possible values are directly stacked with nothing in front of them.
Scientists Are Trying to Spot New Viruses Before They Cause Pandemics
To be more clear DTCC gets its collateral from the broker, ie Robinhood, not the actual clients. And the broker is not allowed to use client funds for collateral.

So the DTCC has to worry about Robinhood, and Robinhood has to worry about their clients.
Article about recent cancellation attempt on Pedro Domingos.

https://quillette.com/2021/01/27/beating-back-cancel-culture...
It's hard to understand from your post description whether you completed the in-depth customer development analysis or not. Did you manage to identify your market fit and test your hypothesis prior launching the first MVP? As a piece of advice, you may offer your product for testing / evaluation to the people you've initially interviewed for a lower fee or ask them to price the product.
Tangentially, my Amazon account had been compromised. The person hacking my account bought amazon vouchers (fortunately the attached debit card was empty as i always keep cards i use online empty until i actually buy stuff).

Four days in a row i was told by different customer support reps that the voucher will be cancelled in a few minutes (oddly enough i couldnt cancel it myself), and none actually did it all the while amazon tried charging my card and asking to update payment details. Since then, around 2 months ago, i stopped buying on amazon all together.

Oddly enough i usually get a notification when i login from a new device, but this time i didnt even tho the voucher was bought by someone in Panama (not sure if they used a real name or not but they sure weren't logging in from my device).
Creating read replicas has become easy with SQLite, thanks to Litestream (recently on HN: https://news.ycombinator.com/item?id=26103776).

What is really hard with SQLite is efficient concurrent updates. But you don't need them very often.
It's ridiculously tempting to try and use SQLite for everything.

It's so ridiculously useful and capable.
Amazon needs to separate out the ebay-style new/used peer-to-peer marketplace from the more trusted "Sold by Amazon" stuff.

Both marketplace types are useful (especially for books), but consumer goods need some kind of notice when you're buying from anyone other than Amazon.
1. You are naive about how this process works. SB35 has already led to thousands of new units of construction, including - finally - the construction of 2k units at what was formerly Vallco mall, despite lawsuits and general objections by Cupertino city council. That is only the beginning, because it was paired with reforms to the Regional Housing Needs Allocation process which has 10x'd the planned minimum requirement of new homes. Beverly Hills and Palo Alto are both quite upset about having to let people build homes or lose local control. Some more information here: https://www.sfweekly.com/news/bay-area-takes-step-toward-maj...

These changes take years to make their real impact felt, and the crisis is half a century in the making. The future is _more_ state pre-emption of zoning, not less.

The funny thing is: the ignorance of local voters to the larger systems at play lead to lots of recent decisions that will soon backfire. For example, San Mateo recently re-affirmed city-wide height limits which more or less guarantee that their RHNA requirements will require their planning department end single family zoning in large parts of the city; there's no place for them to shove apartment towers!

2. SB50 failed due to conservative state reps from SoCal, in particular LA. It had plenty of support with reps in NorCal, and in any case its mere existence disproves your point that there is no basis for states short-circuiting local control.

3. I'm not going to explain how delegation works to you in detail, since I assume you are intelligent enough to get it. There are many powers that are delegated to city governments which can be taken away if cities prove themselves incompetent at administering it. City departments go under conservatorship of the state all the time.

4. I'm not sure why you assume the legal remedy is a lawsuit. Changes to how federal mortgages are backed; removal of subsidy on home insurance which makes sprawl math workout (albeit in the short term); a shift away from federally mandated highway spending; changes to how housing assistance programs are managed and qualified for at the federal level could all manifest as land use changes in cities without explicitly being about zoning. There are probably individual bureaucrats at the DOT or FHWA who are deciding which expansions of 101 or 880 are worthwhile to fund and which aren't. Federal law could easily let them prioritize funding for BART instead.
That is not true.

Some dogs are famously picky eaters and will not touch the food even when hungry because they learned that their handler will then panic and provide better food. You might interpret that as the dog "choosing" not to eat. Of course it is just a learned response as with humans.

You can absolutely train a dog to not eat food, to "fast" if you will. Of course it wont starve itself to death probably, at some point survival instinct will kick in. This is the same with humans. Let's be honest. Most humans are barely able to keep their target weight, most are not able to fast for any extended period of time. They are still slaves to survival instincts. So much for the power of the free will.
JSON/XML quickly stop being alternatives as soon as you need any sort of index, a memory-mapped/on-disk data structure that doesn't have to be loaded into memory, transactional or even just incremental writes. ZIP is not even directly comparable.
What's so WTF about suggesting that a software protocol, that would be widely beneficial in most of the world, should have English documentation?

English is the closest thing we have to a common human language.
Nobody else has Apple's resources for supply management, nor are they as large a target for getting sued - Apple has the ability and incentive to sell safe products.
Your smart phone most likely has it already.
Show HN: My ultimate make file for Golang services
It's a one way road that you are joining. Nothing more complicated than that.
I don’t think you can delete comments once someone has replied to them.
If you're using sqlite, but for a static website, you might consider using duckdb. It's still evolving, but it has huge potential.

It's also an embedded single file database like sqlite, but stores data in columns. Duckdb to sqlite is like redshift to postgres.

Hopefully they will add compression for string columns, so that host your entire static site from a single file in a very efficient way.

https://duckdb.org/

https://youtu.be/PFUZlNQIndo
> the language designs are so similar that I could just as well imagine a world where Python is the web development lingua franca, and Ruby has all the machine learning libraries.

Well aside from the startling implication that Ruby is a web development “lingua Franca.”...the latter statement is reasonable, as it turns out language design isn’t actually that important here. But the former is pretty far off the mark. I mean, Ruby doesn’t even have first class functions and is very strongly smalltalkish in its OO purism, it has mutable strings a-la Perl. The async story is obviously quite different. Python has a much more complicated interpreter, which has contributed to it being more difficult to get even simple optimizations that are done in Ruby. They’re really only similar in the most superficial sense... in the same way that all current dynamic interpreted languages will do certain things similarly.
That’s a fair question, but I do a lot more than just listen to music. I jump on a call, I watch a YouTube video, I put on a basketball game or even the news. Those are all latency sensitive.
It all depends on how much/how complex data you have. SQLite is a database after all, you can query it with SQL and do lots of fancy stuff that might be hard to do with regular file formats like JSON or XML.

If you just need a config file or only have a small amount of data you can use XML/JSON files that you parse yourself. If you are going to have loads of data that needs some structure (for example messages in a messaging app) i would use SQLite.
The problem is that the marketing around this version states it’s a port, the classic — it’s very much not; it’s another game with the Lemmings IP slapped on it and DLC liberally sprinkled in. Frankly, such an enduring brand and IP deserves much better than the free-to-play nonsense that was received — $7 for just two hours of unlimited gameplay, such a bargain (?).

There’s very little about the original design that couldn’t have worked just fine for mobile, especially given the original was ported to mobile devices in the past. Maybe fixing release rates, making Lemmings stay spaced apart to make them easier to tap, the ability to zoom in and out, and a fast-forward function … so basically the PSP version with slight modifications!
NTP gets worse if you sync more than two devices across a broader network with other switched traffic, more into low 100s of µs. PTP does not degrade similarly and yes, most of PHYs made since middle of the last decade support it.
Which AI applications will flourish by 2030
Nice, I really like the clean design of Brisqi. Very neat and well put together. Can you sync using your own cloud (say Dropbox or Nextcloud)?
Almost no one write 3 and 4 star reviews out of spite.
Was this written recently?

Exclusive use of jQuery, not using browser drag and drop (manually edits element position), using JS to animate and fade/transition instead of CSS, etc.

Is localStorage the only modern/HTML5 concept being used?
Kind of, but it's not a continuum at all. Cyclists may use a surprising number of batteries (some configurations provide you with no less than five charging states to keep in mind, and that's before adding lights, and not counting the three coin cells also hidden in that configuration), but when you start using external power for propulsion, from a cyclist's perspective, puts it into an entirely different category: it's not a particularly easy bike, it's a very weak motorcycle. Obviously from a driver's perspective it's exactly reversed and cyclists will happily tap into powered drafting opportunities whenever they arise, but the category borders are what they are. Imagine showing up at a marathon start block wearing roller blades: good luck convincing anyone that you do and love the same thing, just having a slightly different taste in footwear.
> It's funny how many people still don't get that.

Or you could try explaining what you mean briefly, so maybe more people actually would get that.
Is 200kLOC really a lot? Lots of software nowadays has hundreds of megabytes of dependencies, and people seem to be fine with that. Not that I think having tons of dependencies is really a good thing, but for an application that needs a file format, SQLite is a very sensible dependency.

neither XML, JSON nor zip solve the problems SQLite does, though; if you use plain old files, you need to make sure any changes you make actually end up on the disk, consistently. This is not easy to do. It also solves any consistency issues that might stem from someone reading the data while you're writing it.

On top of being just better, having a relational model for your data gives you much more freedom to use said data; you'll be able to do things efficiently that might require restructuring your JSON or XML format. Personally, I love SQLite-based application formats because I can explore them with SQL, which is often much easier than trying to make sense of a custom JSON or XML schema.
Torrent sites have been doing invite trees for a long time. The oldest I personally remember was OiNK (2004).
You have no way of knowing that the overpriced stuff at the local garage is not fake either. I've had the Austrian consumer affairs department intervene on my behalf a number of times when local garages attempt to overprice on items that were either not required during the service or overpriced. I've had local plumbers try to charge double the price on certain items when they thought I wouldn't notice. Your rose colored glasses are quaint. Everybody is out to make a buck and I wouldn't put it past local shops to buy fake products and charge double for it. I'd rather my fake stuff at a decent price thankyou.
Uber Italy charged under anti-mafia laws
That’s silly, we get as much benefit from free trade as every other country. Let China or India do assembly at wages that would be below minimum wage here, and take those savings to get a bigger piece of the market, sell more iPhones, do more software and hardware design and create more developer jobs.
Their size and demonstrated product quality in other areas, plus this guy’s tear down: http://www.righto.com/2012/05/apple-iphone-charger-teardown-...
Any of them are going to be better for you than when there was only one option. Just get the cheap one to start.
It is nigh impossible to purchase computers and connect to the internet without the presence of middlemen and pre-made selections.

Who are you buying from? I get computers from Central Computer, which has five stores in Silicon Valley. They charge $30 extra to install Windows 10, $64 for Windows 10 Pro, and $0 for Linux.
From product innovation and design focused company into shareholders and politics first driven company. Closing the product ecosystem further, ignoring pro user needs, giving priority for dark pattern designs - dongle nightmare, giving access to user data to governments, censoring and creating barriers for OSS. I fully expect Apple to be the front-line operator in the new world envisioned by The Dirty Bunch Planners in Davos. And yes, Apple apologists like their toys and will love to be controlled in the name of ........insert politically correct, billionaire driven, tech-fetishist, pseudo-leftist, lgbt, blm, “woke”...agenda. And I don’t give a flying F. We, humanity as a whole, deserve what we get, and the psychopaths are here only because we are weak, lazy, naive and stupid.
Chinese phones sell well because they are cheap. Apple has never had but a fraction of the market but has always made most of the revenues and profits because they dominate high end phones.
I just switched the parchment paper approach myself. Unexpected bonus: I can wrap up the leftover pizza in the parchment.
No I'm not drawing any conclusions about Swedish education, I'm talking about KTH specificially. Are you replying to the wrong person?
Albert Einstein's Year of Miracles: Light Theory
I understand your point, but I believe it should be "trust but verify". Checks and balances are a normal part of any stable structure of governance, and they should always be there.

One thing that confounds me is how do taxes tend to increase as a percentage (and will it only end because of mathematical limitations like the laffer curve?)

https://en.wikipedia.org/wiki/Laffer_curve
I mostly use kanban boards in teams, so not having the option to sync with other people is a deal breaker for me.
Django is really bad (good?) at abstracting this kind of stuff away.

<ul>
{% for friend in user.friends.all %}
<li>{{ friend.name }}</li>
{% endfor %}
</ul>

The problem is that if you have 200 friends then it will make 200 queries. If you have 1,000,000 friends then, well, this will crash. The Django solution would be to fix-up your "user" queryset like:

user = User.objects.filter(pk=<pk>).prefetch_related("friends").first()

Pay the query cost just once.. instead of on every iteration of the loop!
What does it mean? (Free bashing a newb opportunity ;)
I wish they would sell the old games as-is on GOG. There are a couple of recentish commercial games that try to use a similar design: Sprits is the better one IMO and MouseCraft is also somewhat similar.

https://playism.com/product/spirits

https://www.spacesofplay.com/spirits

https://www.gog.com/game/mousecraft

There are also several open source clones:

https://osgameclones.com/

The one I've played (a while ago) is Pingus, which was good IIRC.

https://pingus.seul.org/
I'm mostly doing Golang/Typescript nowadays and worked with C# in the past, but F# looks really intriguing.

While I'm generally productive with Golang, I'm not really happy with the language itself. It's a bit too simplistic for my taste. F# on the other hand looks like pure elegance. The big question is how long it takes you to be really productive with it, say for a GraphQL/REST backend for some SPA. I'm also a bit worried about the small community.
I guess if things go wrong, you can always fallback on C#.
Any tips to get up to speed quickly?
My cat grew up sitting on my lap while I worked. He has learned, over the years, that when he wants me to stop and all else has failed, he merely has to jump on the keyboard. All kinds of things have happened from that action. Keeping good backups, scripts, and being able to restore from them in under an hour is important with a cat around.
It's quite doable, but it does have a tendency to require more tinkering than your average Linux desktop, and it does set some specific requirements in regards to hardware.

If you have some spare time and a spare laptop, I say go for it.
It is perceptible, but doesn't matter that much in practice. If you're able to achieve the overall latency of around 30ms, you'll be able to play just fine - your mind will quickly adjust to the latency, you just need to listen to your delayed output from the server and disable any local monitoring so you stay synchronized with others.
To be clear the parent post and mine were discussing self encrypting drives. Drives which handle the encryption and decryption on drive instead of relying on your CPU. This is what is insecure.

https://www.tomshardware.com/news/crucial-samsung-ssd-encryp...

https://ciso.uw.edu/2018/11/16/bitlocker-ineffective-on-self...

https://borncity.com/win/2018/11/06/ssd-vulnerability-breaks...

Self encrypting drives are have been insecure for years.
ZIP files are not a database: they are more like a directory hierarchy. But maybe all I need is named blobs: no query language parser, optimizer, indexing, etc.

SQLite positions itself as an improvement over ZIP for application file formats: https://www.sqlite.org/appfileformat.html . But minzip is so much smaller, easier to understand, debug and ship. So why use SQLite for an app if ZIP suffices?
That would take away an Aha! - moment which is what games fun. Fun factor is also the absolute hardest thing to create.
Although Turbo Vision and nCurses was great for the time, today’s TUI libraries are a different beast
> where a complex ternary is probably the best choice

Under what circumstances would that happen? I've never encountered a nested ternary that wouldn't be better replaced with readable code, so now I'm wondering what experiences I've been missing. :)
Sorry, what? The situation we're complaining about is more like this:

> Steve can't normally afford nice things, but he saves up to buy a nice coffee maker on Amazon, paying close to $100 and expecting to receive a product that will last decades. However, Steve receives a counterfeit product in the mail that breaks just a few days after the return window.

With most of these products, you're paying full price but getting an inferior product in return.
There is always DRBD as well. You can make replication a lower-layer problem. Not that it's without drawbacks.
Correction: if it doesn’t run Pytorch. No one really runs custom cuda code anymore. If you do, you’re an outlier.
Hmm, NextCloud always warns against sqlite (but it is the default in the Linux Server IO docker image. It would be very easy, and nice, if it turned out sqlite was fine. It makes backing up easier, and would clean up my docker-compose.yaml.
Solzhenitsyn's Testament (1974)
> Python and Ruby are really similar.

Yes they are, as seen in the _why's old project:

https://github.com/whymirror/unholy

> Compile Ruby to Python bytecode. And, in addition, translate that bytecode back to Python source code using Decompyle (included.)
Student says he was dismissed from UIUC over Covid-19 testing non-compliance
It's not really a suggestion when he is engaging in promotion. If his demands aren't met the promotion is going to stop.

And we all know the effect that will have on price.
This use case can be done much simpler; this is something I've been doing with PulseAudio on my phone for years.
Go ahead and use text files and then have fun with data corruption issues. We use CSV for sending commands to IoT devices and it's an issue. If this had been done with SQLite, then there were at least no data corruption issues. One could even use SQLite as a storage container for JSON if one whises to do so. They even have an extension that aids it with an useful set of functions:

https://www3.sqlite.org/json1.html
Why is sports commentary different? I love watching Twitch streams commenting real world events live.
If you put for example postgresql on equal footing, application and database in the same server (over unix sockets), then I guess 200 SQL statements is not a problem either for the timeline example.
Good point, I have a friend who was downsized at Yahoo in 2013 by being told he would have to start coming into Sunnyvale (Santa Clara?) from Santa Cruz. He dealt with it for about 6 weeks.