skysight-inc/HackerNews huggingface dataset:
What should I tell them exactly? That the size of the US Army will be exactly the same no matter what currency America uses? I think they already know that.
There are underlying algorithms and data structures in databases (b-tree, indexing, WAL etc.) and then there are application level data structures and algorithms, like the schema and how you use it in your app.

So if we see data and algorithms disconnected, we're just thinking about different architectural layers.
Wars would not be any easier to finance in a Bitcoin economy. America had no trouble going to war under the gold standard - and frankly organized and structured debt just makes it easier still. Remember the vast majority of US debt is held domestically by Americans. All that is to say [citation needed].
In "most cases"? I take it by most cases it means, non enterprise applications with no load and basic use-cases? I can't think of a single application for SQLite at any company I've ever worked for, perhaps my first job for a small e-commerce company. Every database I work with has hundreds of GBs of data at the minimum and has to be highly available (i.e. tolerate any DB server dying with zero downtime) and in most cases, extremely low latency. I.e. respond to hundreds or usual thousands of requests per second with a response time ranging from 100ms to 1ms. Recently most of the databases I'm working with are responding to 10000+ requests per second at an average request time of less than 1ms.

Sure, for embedded databases with not much data and a single user, use SQLite, but for actual serious applications it's a toy.
> as in each unit of currency has no ID

If you mean physical units of currency that is no longer the case, most notes have serial numbers. In principle quite a lot of tracing can be done.
> Apparently deep discussion is something they now want to discourage.

That might be true, but a more benign explanation is incompetence.
I currently run email on ~10 domains using one $5/month digital ocean droplet running Mail In A Box. Adding a new domain is as simple as pointing nameservers to my server and creating a user with an email address on that domain (which can be done with curl using a simple one-liner api call, or manually through the admin interface) MIAB handles provisioning ssl certs, mta-sts, dane tsla, verifying we're not blacklisted at spamhaus, configuring roundcube and everything else. My domains get ~5k incoming messages a day. Maintenance litterally involves sshing into the server and running apt update/upgrade once a week or so and could easily be done as a cron job.
I wrote a full multitenancy row level security system in 3 short Python functions in Django. Simple, complete, compatible with Django's architecture. All the other multitenancy solutions I researched were complex and fiddly and heavyweight and required all sorts of considerations and caveats to implement and run.
I really like SQLite but I also like postgres because it supports more complex data types. Sure you can do the same in SQLite by destructuring the data over multiple tables but it's just not as easy or straightforward.

This is why developing with MongoDB is so fast and easy in the beginning. You just go, store shit like you structure your data in code which makes the mapping extremely easy in most cases.
Oh good we've met our monthly quota for wildly exaggerating the capabilities of SQLite.
Sorry, not practical. Intercepting debris requires FAR more delta-v than you may expect. Changing the plane of your orbit is so expensive you just don't do it. Its cheaper to just launch a new satellite in a different plane. For example, to intercept hubble from the ISS (or vice-versa) you are looking at a velocity change of a bit over 3000m/sec. Compare that to delta-v of just over 9000 m/sec to reach the ISS from the surface of earth.

Lets say you are in a really, really close orbit to your target and you only need to spend delta-v of 100m/sec to intercept . If you only use 90% of the fuel you'd need to perfectly match orbits then you are still going to impact your target at 10m/sec. Thats 36 km/h, which is a very violent collision. You aren't going to just grab your target on the way past.
Compiling it yourself from source is quite easy, you can find instruction here: https://www.sqlite.org/howtocompile.html

Here is an article from Julia Evans explaining it: https://jvns.ca/blog/2019/10/28/sqlite-is-really-easy-to-com...

Or if you are familiar with Docker, you can use a more recent Debian in a container and install sqlite inside it.
Story of Kiko as a YC Startup
it's important to note that the author of SQLite wasn't "competing" with RDMS engines -- it's competing with flat file access.

To that goal, I think it's wildly successful, instead of writing files I almost always reach for SQLite first.

When systems share a database, I, like you, reach straight for postgresql. Most people reach for mysql, which I do not prefer.
But you don't mind the current state of affairs where everyone is being ingested with sugar and caffeine? Are those not drugs?

Office productivity is directly corrolated to the coffe machine. The moment that breaks down everything stops. Coincidence, or are we all addicted to a drug?
It's (functionally, not cost-wise) an entry level device for people with some money to splurge to fiddle with; your comment already starts with "I'm a musician", so this one is probably not for you.
I am pretty sure that something can go wrong with a bad (partial or missing) rule of 5.
I mostly agree with all of this - but the US government is already a fairly big user of o3b. Oneweb, in terms of what their terminals will look like, the slightly higher orbit, and the fact that they'll only be selling to enterprise/carrier/government users and ignoring the consumer end user, is already somewhat similar in business plan to o3b. I wouldn't be surprised at all if they make a serious effort to capture a good portion of US gov business from SES.

It is also highly possible that oneweb may sell the equivalent of a geostationary SCPC 1:1 transponder lease, or an o3b dedicated-capacity circuit, which might not be something that would be technically feasible with starlink. If you're coming from an environment of geostationary looking at $1200 per Mbps per month, anything looks good by comparison.
Any one ported the "Github Theme Default" to vim?? I really liked the Default One.
I can't realistically automate the brain manipulation of millions of people taking mushrooms in a short period of time from the comfort of my evil lair.
Except for some people it'll take a couple of months to learn the dance, and they could also apply for jobs at a company that would pay you $200K and $50K in bonuses.

I would apply at the other job.
I’d love to see the code if you can share.
This is great. And I don't even like swimming pools much!
Study finds mushrooms are the safest recreational drug https://www.theguardian.com/society/2017/may/23/study-halluc...

Britain, drug harm score https://www.economist.com/img/b/600/916/90/sites/default/fil...
I went with an Uno Synth, it's a bit larger but in the same price range and target audience as the Volca line and it has a lot more functionality.
It's neither a strength (there are definitely tons of things to do) but nor is it much of a weakness because the development is quite active pretty much all the time (just look at the commit history, PR merge rate or whatever).

The main problem with 3.2.0 is that, due to our commitment to ABI compatibility for even-numbered releases, we really want to cram as many new APIs into it as possible and this keeps pushing it further and further away. If nothing catastrophic happens, it should finally be released this autumn, whether we manage to finish all the planned features (see https://trac.wxwidgets.org/wiki/Roadmap) or not, but in the meanwhile you really shouldn't hesitate to use 3.1.x, the only unstable part of it is the ABI (_not_ API).

Nice chess GUI, BTW! (although I admit that I spend what little time I have for chess exclusively on Lichess nowadays).
> Octatrack

Depending on your musical tastes and tolerance for UI complexity, you may be better served by other Elektron devices as your first purchase. The Octatrack is very powerful but pretty complex to wrap your head around.

Personally I’d go for the Analog Rytm mk2, especially if you like drum-based electronic music... it sounds fantastic, is a great analog drum machine but each track can also be used as a synth or sampler track, which makes it much more than just a drum machine, you can really quickly make great sounding full tracks on it. It also has a really fun interface with far fewer button combos to remember etc. than the Octatrack.

Of course, it doesn’t matter too much because once you buy one you’ll eventually end up buying them all ;) I agree that Elektron are making some of the most fun and exciting music gear out there, I love all their stuff. Quite a strong tracker influence to their sequencer which I like too!
I would be fine with a static analyser doing the last one (giving up in doubt), considering that install scripts are a smaller subset of all possible shell scripts.

Such a static analyser would have two interesting aspects: on the end user side, the one mentioned of outputting the touched paths, and also doubling as being a linter for the script developer.
I've deployed Bitbucket and Postgres as a docker stack under the same subvolume and done snapshots on that. As long as you have WAL enabled in Postgres there shouldn't be an issue, and I've restored multiple times without problems.
Sure, in isolation, that's all true. However, in isolation, the cost of doing nothing is zero. In a pandemic where 70% of America will catch a disease somewhere between 0.3% and 1% fatal, the cost of doing nothing is dramatically higher than zero. In fact, it's dramatically higher than a vaccine that just randomly kills 1 in 1,000,000 people - which this one strictly does not.

My point is that yes, an investigation should be carried out, but stopping the trial obviously - trivially - does more harm than good due to the extenuating circumstances of the global pandemic.
Hey Europe, can you please define first what AI is?

Otherwise we go the same route like with terrorism (every muslim with a knife running around is a terrorist-attack, but if not muslin "just" a psychologically unstable person)
CMS would be low writes assuming no tracking or authentication audit trails or maybe buffered copies of all those.
You can pay 1$ for a BTC transfer, so outrageous.
The fraudsters setup premium numbers with some other telephony provider, possibly in another country. Then they use those numbers to receive 2FA (two factor auth) passwords (either SMS or read aloud in calls). Because the defrauded party's servers called those premium numbers through Twilio, the defrauded party has to pay Twilio.

AFAIK there's no easy way to always, securely detect premium numbers. The fraudster can setup a forward from a normal number to a premium one anyway. So checking number prefix is useless. One could listen for the "After the beep, this call will be billed at X c/min" recording that premium numbers in honest countries have. The fraudsters manage to find less honest premium number providers that skip these.

This is a well enough known issue that Twilio has a page about it: https://www.twilio.com/learn/voice-and-video/toll-fraud
If you have access to the application machine, you will likely have access to DB credentials, no?

Actually if anyone has some more to add to this discussion, I would be interested to hear, in case I am missing something. I am currently using an SQLite database for a small internal Django app.
I have a fairly high degree of confidence that however they're doing the contention/time-slicing right now (very much a secret), they'll keep pace on satellite network density with the number of terminals active in a given geographical area.

Even if Starlink was only 20Mbps down and 4Mbps up, and you could do those sorts of speeds any time in the day, it would still be amazingly better for the consumer tier price ($95-140/mo) compared to a hughesnet or viasat type product.
Well, the examples are simplified to present the concept of outlining. In the first example calc_X and OUTLINED_FUNCTION_0 are functions and not basic blocks, thus they are not guaranteed to placed in that order, but I agree, if they were consecutives blocks the last call should have ben removed.

To give more details on the LLVM optimization pipeline there are only two passes which run after the Machine Outliner for ARM before code emission (ConstantIslands and LowOverheadLoops) because they are dependent upon block layout and size.
> but for actual serious applications it's a toy

I tend to disagree. As do a lot of others [1].

[1]: https://www.sqlite.org/famous.html
We haven't seen the worst about company towns because they were regulated away. Do we have to get there before same thing happens with AI, like it did with so many things like: healthcare, products being toxic, people literally dying?

By the way, what about military uses? Counterintelligence? Anything goes?
1ms write latency means max 1000 writes per second. That seems low for a "medium sized app".
Setting up Webamp with the visualizer is sadly not any easier. If you’re still interested, come join our Discord https://Webamp.org/chat and we can help you figure it out. This example would be a good start: https://github.com/captbaritone/webamp/blob/master/examples/...
I recently-ish upgraded an app's (Slippi) wxWidgets base to 3.1.4, which led me into a somewhat deep dive of wxWidgets since the Dolphin build it was forked from had an "Externals" version that was somewhat of a custom setup. Needless to say I have a renewed appreciation for the amount of work that went into (and still goes into) wxWidgets. It's just absurd how well it covers the "big 3" desktop environments.

I think it probably gets a bad rep when compared to "modern" UI development frameworks, however this thing is still trucking along all these years later. I'm not sure I'll need to touch 3.1.5, but it's just really cool to see it still being worked on.

I think the biggest thing the project needs though though is... documentation. Or maybe it has it, but needs some serious SEO work to make it better accessible? So much of my time was spent trying to figure out what specific feature flags meant, whether they were still valid, and so on. I've done Cocoa development for years, so I'm used to outdated/old documentation, but with wxWidgets it just felt... harder to find the right stuff. Maybe because the userbase is smaller in comparison?
Ugh a dynamically typed SQL database, no thanks. I always find I have to build quite a bit of a "data layer" on top of SQLite for example when using it in mobile apps.

Also you have to build some basic stuff yourself like Enum or JSON support. It's not hard but honestly I would feel much better using PostgreSQL in those situations.
Always fun to see this sort of comment under an article about using the right tool for the job.
GiveWell is literally a priority queue of charities. The moment AMF starts getting diminishing returns, it'll drop down the list. If some other organization figures out an even cheaper way of saving lives, it'll overtake AMF on the list.

It's a simple and obvious system. I'd say the only two things to potentially quibble about is whether or not one likes their sorting function, and the lag time between resorting.
Definitely agree. I've had the opportunity to visit and work in Australia (Melbourne in particular, love that city). Everyone is so much friendlier than in the USA.

No one understands the weird cultural shit we (USA) have around guns / healthcare.

The big cities in Australia have lots of cultures melting together, great food, even better coffee, and decent transit. What more could you want?
Where did I say anything about caffeine and its acceptability?

Don’t read things into my comments that aren’t there.
Writing an operating system is not all that hard–thousands of undergraduates do so yearly. What's hard is coming up with UNIX and implementing it as something that others can use.
That doesn't seem very different to a client-server setup. If your DB is on a different server and your app is compromised the attacker has similar access to the DB as if it was on the same disk.
That is just awesome, I go into bitcoin in 2011 or 2012 (in top few hundred users on bitcoin-otc back when price was $4 a pop) and had loads of ideas for services (+ accepted bitcoin for years for webhosting) but listened to all negative comments about crypto and spend most of them over years (have a descent stash left) and hence now not a billionaire just a millionaire, but yeh moral of story is not to listen to overly critical nerds who are overly negative about every subject (often just to be edgy/cynical) and just do it!
The study was from the early 2000s, if I remember correctly. And yeah, things have changed since then. Back then, and to me the numbers made sense, the conclusion was: not enough launches of smaller payloads into low orbit to make it profitable. And reusability isn't feasible for larger payloads or higher orbits (not sure how much and high SpaceX launches stuff with reusable rockets).

I would love to see SpaceX financials, without them all we are left with is advertised launch costs, Musks Tweets, money raised and financials from the competition. That is like calculating airline costs and profitability based on Spirits quarterly figures and Ryan Airs special offerings between Dublin and some provincial German airport.
The core kernel is pretty much all C, but extensions and drivers are C++, yes.
> I use Gitea(Github clone) locally with SQLite running on ZFS where I can take atomic snapshots of both the SQLite database and git repositories.

ZFS snapshots may not result in a consistent databases backup of sqlite. You should use VACUUM INTO and then do a snapshot or use the sqlite Backup API.

See my other comment: https://www.sqlite.org/backup.html

Essentially, while you have a proper atomic snapshot of changes on disk the in flight transactions won't be there and you will be on the mercy of having a sucessful recovery from the journal/wal if you have that.
I think a lot of people are frustrated about how so many idolize him to the point where anything he is involved in is immune to criticism.
Did they actually have another choice though? Or perhaps all other business sectors are choked and on life support?
Definitely, however it's also disingenuous to say that we have no idea what the long term consequences of shrooms are just because there hasn't been a formal study recently. There's tons of people doing it regularly - for millennia actually, studies from the before-times and a large incentive by the mainstream anti-drug folks to dramatize any adverse consequences.

Should there be studies? Sure. Are we pretty sure it's safe? Yep. Safe enough to legalize? Oh most definitely. Certainly until proven otherwise.
NHS Covid-19 App Draining Battery Since Monday?
I got a notification on Monday on my iPhone telling me how the Covid-19 app had changed or something, but since then it seems that my battery, and my wife's battery are running out super quick.

I had a look at the battery stats, and apparently the exposure notifications had used 22% of my battery since the last charge.

The last app update I can see what 23rd March, and supposedly the latest update was blocked (https://www.bbc.co.uk/news/technology-56713017) - I wonder if the 23rd March update was waiting to turn something on in the next update, but being blocked the notification is making it go a bit crazy?

Has anyone else noticed this?

The only other thing I can think, is that the PiHole is blocking something, but I can't see anything obvious.
What if I pay with 100 Euro bank note and get back "tainted" 50 Euro note and then pay in bar? Bank notes are not just collected and sent back to bank.
Effective altruists would generally be open to the idea that political reforms might theoretically be the best way to spend money in some cases.

But in the case of despotic or otherwise terrible leaders, the problem is that it's unclear what to do to stop them even if you have control over a large military, let alone if your only resources are a relatively small amount of money and the time of a relatively small group of people.

It remains an unsolved problem how to evaluate causes like political advocacy that have very long-term or very uncertain effects. Combine that with the rancor and division that talking about contemporary politics causes and its no wonder EA as a movement chooses to eschew political advocacy for the most part. I guess the overall sentiment is that the money some people donate to feed the Democratic or Republican party machines could probably be spent better.

That said, I've have seen (relatively) small EA grants given to organizations advocating and acting to improve governments in undeveloped countries. For example, the first one I came across was this: https://www.givewell.org/research/incubation-grants/innovati...
It's not really dynamically typed in the sense that there isn't a schema.
I've expanded about what I think about this in the neighboring comments. I'd like to ask this though. When you feel that a thread is going off-topic, to the detriment of the forum, please post a comment pointing that out. Others might disagree with you, or they might see your point. What I find really problematic is when a discussion that I care about is flagged without any input. I perceive it as spiteful, because usually it's me having a controversial opinion, and I'm more likely to be spiteful in turn, though of course I try not to be. I don't mind people questioning the quality of my contribution. I actually welcome it, because I care. Just don't reject it off-hand.
Popular culture is full of historical myths, another popular one is about cruelties of Holy Inquisition. Inquisition is painted ("The Name of the Rose" by Umberto Eco and others) as some sadistic group of catholic priests who were chasing innocent woman, torture them and then burn.

The truth is that Inquisition aim was exactly opposite: to stop chasing and burning innocent woman (and man) by all kind of petty lords and civil "courts" who used witchcraft accusation to get rid of opponents. This was done in the name of Catholic Church so Rome decided to do something about this and stop that practice by introduction of pretty modern standards of court proceedings - this way Inquisition was born.

Inquisition was punishing heavily those who gave false testimony and that cut number of witchcraft cases significantly.

In addition the punishment for heresy was rarely death penalty (about 1,5% of cases), which is less than 5 thousand executions during several centuries of Inquisition activity. Typical punishment was fasting, scourging or pilgrimage.

Coming back to Umberto Eco writing, he described in "The Name of the Rose" Dominican friar Bernard Gui as some bloody, mindless, cruel madman, medieval version of Doctor Mengele. While the truth was exactly the opposite - he was a decent and educated man.

Obviously historical research and facts are much less interesting than Eco pop writing, but we live in the pop age and believe in the pop "truths" so this is not a big surprise.
as a die-hard vim user, what feature of vscode would shatter my world?
I think the file system is the best database we have to date, and it's what I use for the "base" data store in my most recent applications.

However, for querying, SQLite makes a nice caching layer.
In cases where depression is caused by whackadoodle brain chemistry, this might actually be a completely reasonable answer.
lol This reminded me about that comment about Heroku marketing email.
Wikipedia tells me that

> Uisce beatha, literally "water of life", is the name for whiskey in Irish. It is derived from the Old Irish uisce ("water") and bethu ("life").

In France, many liquors used to be simply called "eau de vie". They now tend to each have their own name (origin and/or brand), but most people would still understand that you're not looking for water if you ask for some eau de vie.