skysight-inc/HackerNews huggingface dataset:
> - Lost decimal places on a simple database round-trip.

This seems like a misunderstanding of the types that SQLite was able to store natively and which one was right for your use-case. While SQLite certainly has less options out of the box than a larger database has for types, this seems like it could happen in another database as well with a wrongly chosen type (ex. integer vs bigint in postgres).

> - Issues with accessing the DB from multiple threads.

How SQLite acts under multiple thread access is well documented[0]. You can even get closer to bigger systems by using WAL mode[1]. The fact that SQLite isn't the best for concurrent writes is also discussed in the page on when to use SQLite[2]:

> Many concurrent writers? → choose client/server

> If many threads and/or processes need to write the database at the same instant (and they cannot queue up and take turns) then it is best to select a database engine that supports that capability, which always means a client/server database engine.

> SQLite only supports one writer at a time per database file. But in most cases, a write transaction only takes milliseconds and so multiple writers can simply take turns. SQLite will handle more write concurrency that many people suspect. Nevertheless, client/server database systems, because they have a long-running server process at hand to coordinate access, can usually handle far more write concurrency than SQLite ever will.

A bit of a reach but I'm also willing to bet that the architectural pattern that you were using that required multiple threads to write to the DB at the same time might benefit from passing that responsibility to a single thread which could possibly employ some batching, which is normally one of the low hanging fruits of DB write performance tuning.

[0]: https://sqlite.org/lockingv3.html

[1]: https://sqlite.org/wal.html

[2]: https://www.sqlite.org/whentouse.html
This quote amused me:

> deep learning was inspired by the human brain, which is remarkably energy efficient

Yeah, sure, if you purely look at its' energy consumption in isolation and ignore all of the flights of fancy we engage in (such as, for example, this NN model) in order to maintain its' coherence.
We're talking about pre-flop actions. It's literally impossible to throw away quads pre-flop in hold-em. You may be thinking about a different form of poker.
As a casual user I prefer the walled garden that I get with iPhone.

Sure there are other apps but it’s just too much variety. What is out there is good and works.

Maybe I don’t know what I am missing because I never had it.
My personal experience (n == 1) study finds that a couple of Chromium GTF taken sublingually (ie sucked under the tongue) works instantly to improve my mood.

I never use picolinate.

Sublingual is so that it can cross the blood-brain barrier. I can use less Chromium that way to get the same improvement in mood.

My pet hypothesis is that it works by displacing Vanadium from the brain. Vanadium and Chromium are very similar chemically, and some studies suggest that Vanadium is elevated in manic-depressives. Particularly, I'm high in Vanadium because I live in Japan and eat a lot of whole fish and seaweed.

The main possible negative side-effect was that I needed more Manganese to balance the Chromium. That I worked out from developing mild dermatitis, that went away when I supplemented Manganese. [1]

None of the above is a recommendation - your mileage may vary etc. Everything you supplement has side-effects. Particularly, supplementing one bivalent metal can create a functional deficiency in another. In this case, I wanted to reduce the effects of Vanadium but I ended up reducing Manganese too. Anyway, people need to do their own research to see what works for them.

[0] https://www.ncbi.nlm.nih.gov/pubmed/6443582

[1] https://books.google.com/books?id=3UG9BQAAQBAJ&pg=PA45&lpg=P...
They hired people to build the desks. The labor cost probably puts them in the red, especiaplly b/c of the scale.
Al shares his experiences of transitioning from Google to a remote working role. A "data-lover", he stumbled into remote work but has since also fallen in love with working remotely. He surely would like to catch more casual coffees with his co-workers, though. Do read his story - it is fun, real, and, importantly, very helpful!
The point of the cryptocurrency was to decentralize Libra amongst several actors, such as Visa, Master Card, Paypal, etc

If done, Libra would have been the common interest of all those actors. That was the goal of the project.
You seem to be confused about what white supremacy is. It's a small subset of nationalism. There are many other types.

And white supremacy is more authoritarian than libertarian. And it's not conservative in the current political sense and it's populist.

I'm not sure what to make of that Twitter link except that there's a whole bunch of folk so embedded in their own political bubbles that they're incapable of communicating with anyone beyond.
The “radio royalty model” doesn’t pay singers but does pay writers. Also, it’s only for non on demand music. There is a similar model for programmatic internet streaming like Pandora that doesn’t apply where you get to choose your music like Spotify.

Even with that model, the government decides how much is paid and every song costs the same amount. Should studios be forced to license a movie that cost $120 million as one that costs $3 million.

Also, in that case should software developers be forced to sell their software at one government regulated price? Why stop there? Why shouldn’t we just let the government set all prices?
> Yes, now it's a few weeks wages. But prior to this round of hyperinflation they could have stored their wealth in bitcoin. Now it's probably too late. But i'm not referring to someone doing it now, storing your wealth somewhere will always have some cost associated with it. Wealth preservation is a step you take in anticipation of currency risk, not after its already done.

Perfect haha thus solving the problem once and for all. Except not solving any problem, and somehow even less efficiently.

Before the last few rounds of hyperinflation they could have just as well bought USD and been 70% better off. Yes if you cherry pick entry points in retrospect you can justify any position no matter how crazy. If these poor Venezuelans had only realized how valuable bitcoin was before it mattered you know? Or literally any other asset class that’s done well lately but hey don’t let me spoil the surprise.
I'm not sure exactly what the use case is but another awesome tool that's recently been making the rounds is datasette[0], it provides an easy to use data exploration point for SQLite databases. There's also a PyCon 2019 talk[1].

[0]: https://datasette.readthedocs.io/en/stable

[1]: https://www.youtube.com/watch?v=pTr1uLQTJNE
> Calibre is implemented for free in spare time in Python

Well it was Python. The number of C extensions means they can't go back without many hours of work and hundreds of thousands (or millions) of LOC cleaned and tested.

For instance, I recall a LZMA decompression C/Python script in the Calibre source. Python 3.3 added LZMA in the stdlib, but they're stuck maintaining their handrolled one.

I'm missing details. I learned quite a bit from that codebase awhile back.
Tangent: Why do we value dogs and cats more than pigs and cows?
It's ok. I have both a HoloLens 1 and a Magic Leap One [0]. The Magic Leap is kind of like HoloLens 1.5.

Unlike a sibling comment, I don't think it's a "borderline scam", but I do think the company is struggling to live up to their own hype. When it was released, it had a lot of problems. The latest OS update is much better. I first tried it around OS v0.17 and it was pretty shaky and crashed a lot. By v0.20, it was running much better, but that was like 6 months later. I think they felt pressured to release earlier than they should have.

I've been pretty busy at work with a mobile VR project, so haven't touched the Magic Leap in a while. Current OS version is 0.22. Curious to see how it's doing.

[0] I keep a full list of my hardware here: https://seanmcbeth.com/vr.html Ask me anything about anything on the list. The notes on the page are a little outdated, as I have now used all of the hardware I have (and have it all readily accessible on a shelf at work). Maybe I'll update the notes tomorrow.
How can something be flexible and durable? As someone who accidentally punched a hole through a hollow core door, I can definitely say I’d never consider placing expensive equipment on one.
Well if you made a relatively dangerous product but don’t release it to the public, that shouldn’t be a problem... right?
I wonder how they felt / were they really struggling / miserable or largely unaffected?
Could be a meter mixup
So it's like Tether?
Does this imply anything regarding the consumption of yeast? Specifically nutritional yeast which many vegans tend to eat.
How does this square with people climbing Mount Everest without oxygen? Acclimatization?
I have no direct observations on this topic myself but I remember receiving a newsletter a while ago that may be of interest [0]. The author says that about half of general market is for clients that "Whether or not they choose to explicitly acknowledge it, they look for an element of therapy or life coaching in their relationships with consultants they hire." but tech companies are a smaller proportion of the market and generally want a consultant to guide them philosophically.

An important distinction perhaps is the difference between consulting and being a contractor. If you're looking to go down the consulting path I recommend reading the other posts in that newsletter.

[0] https://artofgig.substack.com/p/elements-of-consulting-style
A monopoly on legal violence isn't about only the state legally being able to be violent, but it's also the state being able to outline who can legally become violent and in which circumstances. Which would include things like outlining that you can defend your home - so this isn't really an exception to the statement.

I don't find the phrase all that compelling. What is legal in a given place is based upon the strongest coalition of people that cares about that place. When speaking at this level of social organization its basically might makes right. A state with no police and no military has a monopoly on nothing.
So if Disney should not be allowed to sell their own product over the internet, does that mean that you also believe that software developers shouldn’t be allowed to sell their own content? Should no one be allowed to sell their own stuff over the internet?
> the whole point of using blockchain technology is it doesn’t matter who creates it, as long as the code does what it intend to do, there are no trust needed

That may have been the original point of blockchain, but control over money is still a pretty political issue. Accordingly, anyone who creates or transacts currency, regardless if done by fiat or mathematics, will necessarily wade into local political and social restrictions.

Bitcoin is impressive technology and definitely brought a nice jab to government monetary control, but it does not seem to be able to deliver a knock-out. No government will give up control over monetary policy without a fight. If governments can't control bitcoin directly, they'll do so indirectly (making them difficult to cash-out, blocking IPs, straight-up making it illegal).

It's yet another example of tech's beautifully orchestrated high-minded ideals, that come crashing down when they meet real power and reality.
In the beginning...1993 or so, before Altavista, everyone I knew doing web search came from TLA contractors where they had been long working on similar projects.
ok, how can i acquire this?
Uh, the English Channel is only 174m deep.
This is correct. Looks like they're proposing to share memory slabs across cgroups. But cgroups being a mechanism that's meant to partition groups of tasks for resource control, I don't know how wise it is to have them share memory slabs.
Charisma Neutrality
Oceanbase from Ant Financial Outstrips Oracle with 60,880,800 Tpmc in TPC-C
Funny. Knowing her history, my razor pointed toward a proven lack of scruples.
> As someone who accidentally punched a hole through a hollow core door, I can definitely say I’d never consider placing expensive equipment on one.

Why would you place expensive equipment on a door?
How to Fix the Situation Where I Cannot Delete a Message in Microsoft Outlook?
Detailed Guide to Create System Repair Disc in Windows 7, 8 and 10
>> Yeah, C++ has been working out great on the F-35.

The number of scary C and C++ architectures flying currently is quite troubling.

While DoD is coming to grips with the fact most aerospace primes take a 1990s approach to software development, other than mostly in research pockets, DoD is still not recognizing the impact of language choice. The late 90s push to embrace COTS threw a lot of baby out with the bathwater.

>> Competition is good and more choices for building avionics systems are welcome. I don't know of any DO-178C certified Rust implementations, but we need them.

One of the impediments to improvement actually is certification. Certification uses a lot of labor and paperwork-intensive proxies for code quality and configuration control that should be revisited in light of modern methods that can assure correctness-by-construction. I'm also not sure any major aerospace prime will generate demand pull for a certified Rust implementation without it being mandated in some fashion by a government regulator or customer (which I personally would not be opposed to).

>> Part of the issue is that high-integrity, hard real-time embedded systems are their own niche in terms of requirements. Java and C# are widely-used programming languages with hundreds of millions of lines of code deployed in business-critical production environments and yet both are unsuitable for avionics environments

Once running atop an RTOS of sufficient quality, what niche language features do you think would be required for avionics, given the widespread use of C and C++ there already? I can understand not wanting to run on garbage-collected runtimes like Java and C#, but once memory management has the determinism of something like Rust, what other functionality do you think is missing?
https://superuser.com/questions/601574/how-do-i-redirect-a-d...
I tend to agree, the biggest concern here is the goverment will create overly broad legislation with the only purpose of leveraging it against truly decentralized cryptocurrencies
You seem to have some kind of misconception about eugenics, the thing that everyone agrees to be unacceptable is "improving" mankind by forcing some people to not marry or to not have children. The thing talked about in that thread is voluntary modification of ones own dna. Deleting comments simply supporting this would be crazy.

HN is not a crowdsourced knowledge base like stackexchange or wikipedia, to expect high percentage of accuracy on all posts, it is place of conversations and having people with different viewpoints makes it more interesting. For the thermodynamics example did you post the correct version after researching? Or maybe you found it too late when conversation have already moved on? Unfortunately that's the way all conversations work in real world too, best arguments come after it.

I am not saying that hn voting is the perfect system, but it is way better than the system where moderators check if comments are true or "right wing BS" because then instead of discussions you'd get echo chamber of everyone agreeing with moderator, and it's not guaranteed that it will be left wing echo chamber you wish for.
Discussed about four weeks ago https://news.ycombinator.com/item?id=20908197
It always amuses me when people make that utterly irrational and illogical claim that gun manufacturers are responsible for what people do with the tool/machine called a gun/weapon/arms. Even if we just ignore the deeply evil motivation to take the means for people to protect themselves away; a gun is not responsible for the actions of a perpetrator any more than the manufacturer of knives, or a baseball bat, or a car, or even a toothbrush that is turned into a shiv.

If you want to find a real entity to blame, the only culpable person beyond the perpetrator is the government, politicians, and bureaucrats that conspire and plot to deprive people their fundamental and inherent rights in direct violation of the constitution. If you take over responsibility for keeping people safe, then you are also liable for your actions, ESPECIALLY when you’re breaking the law, the most fundamental core law.
There's a lot of money to make for the freight forwarding companies.

A lot of container owners charge you fully knowing that your product may get caught up in customs and they make their money on late fees.

As a user of this product, I think you probably get better visibility of where your contents are in the overall process and access to customs agents, which that in itself would help cut your overall costs down if you know that your items were categorized correctly on your customs forms, preventing the above from happening.

The founder talking about it at startup school. https://youtu.be/syoqjYLDs48?t=1169
I'd argue that feature set (transactions, ACID, etc) are a bigger differentiator because they drive/change application development -- this can have drastic effects on application features and complexity whether immediately or down the road.

I agree that the possible second biggest (if not the first) differentiator is size though -- despite the amount of choices out there, once you start narrowing down answering those questions, many options fall away very quickly.

I'd also add on that the only real way to scale a database is to shard. There are a bunch of tricks you can do to improve throughput and those are always welcome, and sometimes I'll see articles that proclaim "we just changed to a system with 256GB of RAM to fix our scaling problem!" -- but these improvements don't get past the basic premise that once your data does not fit on one computer/harddrive you need to start figuring out a way for multiple to coordinate. You need to shard, and you need to organize your data in such a way that it can shard, then you need to start worrying about data access patterns. There's a lot of space before something like this is necessary (you really do have to have a lot of data for it to not fit on one machine these days), but I think people don't see this chain coming fast/often enough.
Maybe I don’t know what I am missing because I never had it.

That applies to freedom too.
shifter karts are faster, but the one i modified for a project only did 60mph. you still needed to lean. you were probably still seeing a great deal of slip.

take a look at the steering on a pro kart - the wheels are deeply angled around the kingpin and dig into the ground.
Bull.

The NYT could make ad money without the tracking, because content relevant ads have always been more productive and the NYT knows their content.

They just want the data.
> I've been pretty busy at work with a mobile VR project, so haven't touched the Magic Leap in a while. ... Curious to see how it's doing.

Magic Leap has always raised a swath of significant red flags, but for me, one of those red flags is that the company is based in Florida. As Roger Stone famously said, "Florida is a sunny place for shady people". I'm pretty skeptical of any company or person based there that makes transformative claims.

I would love to be downvoted and proven wrong about this in comments below, so if you have good counter-examples, please share.
A Python package for creating Python packages
Our DBs are tiny for most users. We run s3 (minio rook ceph on k8s) locally so the network latency is a cluster latency.

I figure you could just throw hardware at it like you mentioned. Move them to nvme backed S3 if needed.

And our use case is only ever load, do a read or write, and then save. So they DBs aren’t open for very long.

And with S3 compression you could save on download time but pay a decompress cost.

This approach has its downsides don’t get me wrong but it scales nicely but forget running aggregates across the databases at least not for a real-time result.
It's worthless to me, but don't let that stop you.

If it turns a profit, keep it going until you can find a sucker willing to buy you out.

If you have fun running it and the operating costs are manageable, keep it running on the off chance that you find a way to monetize it.

And if it's fun and profitable, you've got it made.
Good point about bots, i am happy that hn has separate protection against them and other methods of self-upvoting.
Apple and Google are still dealing with merchant fees. So is PayPal for many transactions.

A PayPal style system might work, but it is only low-cost low-friction (the main appeal for crypto) for the transactions that occur completely within it's own ecosystem. And they don't call it a currency, so they dodge some issues there. Paypal also dodges issues of "being a bank" because funds equivalent to customer balances are actually held in real-world banks, so it's not in any way an independent currency. It doesn't "float" against anything. Libra's basket-of-currencies approach may be very stable, but automatically puts it in a very different class of financial instruments. They could abandon that and really stick to the paypal model though.

Even then, there are still many regulations for this that must be followed: It falls in a business class of "money transmitter" which requires a separate license in every state, as well as registration with the federal government. They also must follow laws like filing a CTR for transactions above $10,000, and SARs for suspicious activity. There's simply no getting around major regulations if you're providing any sort of financial services.
This would have the singular affect of forcing the entire cryptocurrency ecosystem into the black market, where it would thrive alive and well. Likely doing more harm than good in the process by fueling violent cartels to wreak havoc, as is still happening with the war on some drugs
Checkfront, a booking management system, got by on sqlite up until maybe 2 years ago - it was the solution for 5 or more years! These days it runs on postgres but it went very far without it.
> apparently the whole thing would be better off rewritten in a new form

It seems to me that this is basically describing Matrix [1]. Funnily enough, since its current transport is HTTP, it looks like by the time HTTP/3 becomes a thing, network hopping would be solved essentially for free.

[1]: https://matrix.org
emergency vehicles can use the rail tracks if they need to pass. them being there is actually an advantage for that because if the road was full of cars on all lanes, they could not pass either.

making pedestrians cross traffic after getting off the tram is indeed an issue. but there are various solutions. usually the tram is close to an intersection with traffic lights and crossings. you use those to get to the tram.

the alternative would be to have the trams run on the sides and the car traffic in the middle. but that doesn't work when the tram needs to get around the corner, because it can't turn with such a short radius.

there are tradeoffs.

i have lived in the suburbs and in a street like the article describes. that street is much more livable. for example i don't need to travel long distance to buy groceries. the next supermarket is usually within walking distance. other shops too, restaurants and anything else i might need. not so in the suburbs where the next mall is often kilometers away.