skysight-inc/HackerNews huggingface dataset:
We've been using SQLite as our principal data store for 6 years. Our application services potentially hundreds of simultaneous users at once, each pushing 1-15 megabytes of business state to/from disk 1-2 times per second.

We have not had a single incident involving performance or data integrity issues throughout this time. The trick to this success is as follows:

- Use a single SqliteConnection instance per physical database file and share it responsibly within your application. I have seen some incorrect comments in this thread already regarding the best way to extract performance from SQLite using multiple connections. SQLite (by default for most distributions) is built with serialized mode enabled, so it would be very counterproductive to throw a Parallel.ForEach against one of these.

- Use WAL. Make sure you copy all 3 files if you are grabbing a snapshot of a running system, or moving databases around after an unclean shutdown.

- Batch operations if feasible. Leverage application-level primitives for this. Investigate techniques like LMAX Disruptor and other fancy ring-buffer-like abstractions if you are worried about millions of things per second on a single machine. You can insert many orders of magnitude faster if you have an array of contiguous items you want to put to disk.

- Just snapshot the whole VM if you need a backup. This is dead simple. We've never had a snapshot that wouldn't restore to a perfectly-functional application, and we test it all the time. This is a huge advantage of going all-in with SQLite. One app, one machine, one snapshot, etc...
> There's a lot more. You shouldn't be able to downvote replies to your post.

You're not allowed to do that anyway. You can only upvote direct replies to a comment of yours.
He should stick to songwriting...
Moral of the story is, he didn't find one.

It's impressive how transparent he was. But maybe he did not use the current-month's favourite javascript metatranscompiler
I don't know if that was meant to be sarcasm, or some sort of slam dunk argument, or what?
Why? An atomic filesystem snapshot is very similar to power loss. Since WAL is required to handle that scenario, it's just as important when backing up through snapshots.
Golly. I wonder how Republicans would respond the next time they're in power?
As I said, what are they actually doing to achieve this?
Rents pretty much always reflect the "real market". There can be speculation on property but there is no speculative gain to be made on renting and the demand for rental properties reflects the actual demand for housing.

Obviously when more people want to rent than there are properties available rents go up.

This is why rent caps do not solve problems. They ignore and do not address the cause of high rents and they may make things worse by reducing supply and making tenants stay put.

And as you say not everyone can live in the most desirable areas, which will always be pricey.
That might be harder/more expensive if it was decommissioned because of reactor/propulsion/other critical systems in the back.
Works beautifully on iPhone
Windows 10 is still using the CP/M unit labeling scheme.
A Bayesian Framework for Online Social Network Sampling
I'm "that guy" who, if I see a stackoverflow question that has code (i.e. variable names and comments) written in non-English (making me work twice as hard to make it work), I passive-aggressively post an (otherwise correct) answer in Greek code (i.e. my own native language).

I know it's a dick move, but I stand by it. :p
Yup, same in my country. I was able to buy a home recently, but my method of accumulating capital enough is just about mission impossible for normal peeps. It is really unfair. Government regulation and control of housing prices is the solution.
This is a catastrophe and very disappointing.

Here is a little personal anecdote: I used to live in the center of Berlin Mitte when I was a student, had rented a Penthouse apartment for 450 Euro/mo incl. additional costs (but without water, gas, electricity). It was affordable. Then a Bavarian multimillionaire bought the house from the original owners. I was already abroad most of the time, so I didn't experience the loud works his people conducted to get old renters out. However, he did cut off my telephone cable, something the phone technician realized when I returned and was able to fix.

Later he threatened to build a balcony - "and this might take a long time" - unless I agree to pay a higher rent. The classic ugly move. I negotiated with him for a while and in the end the raise was not so bad. However, I realized that I have to get out anyway - he wouldn't stop until I'd have left, you cannot fight a landlord with evil intentions in the long run even if you're a member of renter protection like I was. So I left Berlin and never returned, not even for a visit. I never asked but would estimate the same apartment at around 1600 EUR/mo today, with an ever increasing tendency.

Now I live in another country, ten years have passed, and the same happens in the city I live in. Rents are rising continuously, I've already seen people photographing the houses in our street, several of them are being totally renovated, new apartments are always "luxury apartments" as if any local could afford these (it's a poor country, ca. 800 EUR average income), and an agent from Sotheby's Real Estate rang my doorbell recently to ask if I'm the owner of my apartment.

You cannot escape this trend unless you want to live jobless on the countryside. I'd buy an apartment like most of my colleagues if I had the money, but it would mean having liabilities for the next 20 years and I only have time-limited contracts in Academia.

It's frustrating to know there is a real risk I'll have to spend my later years in the most ugly suburbs and slums of an otherwise beautiful town, even though I have a rather decent salary in local terms, while most of these houses with unaffordable "luxury apartments" are bought by foreign investors. By the way, many of the new apartments are empty, apparently only serve as investments.
> Please no suburban sprawl while Berlin still has such low density compared to other cities

A city should be worth it to live in and provide enjoyment for the citizens, not be a glorified chicken coop for people.
Yes, case fatality rate is 1.8% but infection fatality rate is quite a bit below 0.5% (the exact number is unknown since no one in the US is doing random testing properly). Bubonic plague infection fatality rate was 50-70%, so over 100x larger.
Ask HN: I am a coder and I am thinking of buying Dell XPS 13. What do you think?
I am planning to buy Dell XPS 13 (9305) and run Ubuntu on it. It's mostly for coding. Is it good? Would you recommend it? Is screen big enough?

I've been using Dell Inspiron 7559 for the last 4 years and I've loved it.
Well in recent months the Tesla Giga Berlin factory has shown just how fast construction can take place if the people in power actually want it to happen. Building new housing units in the city slows the increase in value of existing real estate, which is why property owners are not rushing to allow the construction of new structures. Lobbyism is a powerful force in real estate.
The problem is that in the countries with democratic systems, these can be easily exploited if you find a % of demographic that would accept handouts in exchange for votes and target them using Facebook etc. they'll happily vote to get free money.
One of my biggest annoyances with Terraform is how you cannot start out by creating your state remotely - you have to run it first with local state and then move it to a remote backend on a subsequent run.
Versions of the same comments could be made even today. It's a great company with a bright future, and their own cut of the pie is guaranteed, but there are excellent exchanges outside US
Why? So that investment or people will move eastwards?

What about the thriving culture which exists in Berlin, and which is supported by low rent prices.
Show HN: ASO by 2Stable – App Store Optimization Tool for Mac
In my experience SQLite is fine for single process concurrency (just push everything onto a worker thread). However multiprocess concurrency support is very primitive even with WAL support enabled.

Internally SQLite relies on file locks to mediate access and this seems to necessitate very coarse locking (lots of table locks).

Comparatively the client server model of other databases like PostgreSQL seems to allow better coordination between writes and much finer grained (row level) locking.
It's like joining a game of Monopoly after a few rounds have already been played.
I didn’t know my father’s suicide and my subsequent depression was caused by governments, politicians, or general existence in the modern capitalist world. Thanks for giving me this deep insight.
One of the things I enjoy about these is the difference between the cat and the dogs. The dogs are in general very declarative, although sometimes unsure about what is going on or what they want.

The cat on the other hand is only interested in itself and its family member (ie. doesn't care about what's going on outside); but it also seems to change its mind constantly. It might ask for one thing, then seem to think about it and change its mind to something else and change the buttons it is pressing.

But processing the data from them is really hard. Obviously they know a lot of these words, but its when they combine them in interesting ways that you begin to wonder how deep their understanding and ability to express goes. For example Bunny might combine her meager word-set to express something that makes you wonder if what she's trying to say is more than the sum of her words, and if whether she understands it at that level.
I used ansible for AWS a few years ago - it's terrible. Not by design, just that most of the modules are buggy and incomplete.
Yes, I was instantly reminded of the time I implemented the core functionality of the 'time' command in shellscript, only to find out about it months later.
yes, the physical currency does. but as soon as its in a bank, thats lost.

moreover we are assuming that cash is ID at entry and exit, which its not, unless someone suspects something.
Heh. Ironically they were more witch huntings and killings outside Iberia than inside. Ask the protestants.

Also, read about Salamanca's School on humanism:

https://en.wikipedia.org/wiki/Salamanca_school
I thought it was more "Federal law has already decided this and the state can't be more restrictive than the Federal law"
And a job in these cities usually pays the rent. Unless, of course, you work blue collar at smaller companies. Or are a long time resident. Then it sucks.

That being said, I'd say the situation sucks especially for older folks not owning their apartments. The generally higher educated post 1980 generation has it comparatively good.

I just take issue with such general blatant statements, things are never that simple.
The difference between a Yelp review and a government social score is the Yelp score doesn't determine whether you're eligible for loans, jobs, education and so on.

> Europe will struggle to compete in the future

I'd say it already does, but not because it addresses valid issues through regulation or introduces excess regulation for invalid use cases.

One reason it does is regulatory capture, stifling competition to already established companies. It shares this aspect with the US.

Another is a cultural difference with the US, Japan or China in terms of general ambition/entrepreneurship. The European dream for most seems to be "get big enough so I can cash out", not "let's take over the world".

Yet another is that Europe, while being unified in many respects, still is a loose federation of a bunch of different cultures and languages, making it more work to appeal to and serve everyone in the internal single market.
Wouldn't it be more appropriate to limit (ban?) the tracking of people, instead of focusing on use of AI to data-mine the collected information? And how do we even define AI?
Wild plants growing around in a city, the horror!
The black death cut GDP in Europe by about 50%, and it took maybe 100 years to recover. I hope COVID will be less severe for the economy than that.
That is simply not the case anymore. Neither are the sale prices low anymore. You will now pay same m2 price as in West-est west, like at the border with Switzerland.
If the .wal file is not backed up, then any information in it will not be backed up. Depending on the settings for the WAL, this can be quite a lot. You would need to do something like the VACUUM INTO trick described above if you want to safely backup the sqlite database from a live filesystem, because there is a risk of the WAL and database being out of sync. I’m not sure that SQLite, good though it is, can get around the WAL being taken at a different time to the rest of the database.

The problem here isn’t the .wal file, but doing backups from a moving filesystem. The solution is to use snapshots. ZFS supports snapshots natively, and Linux’s device mapper supports snapshots of any block device. [0]

[0] https://www.kernel.org/doc/html/latest/admin-guide/device-ma...
AirBnB is part of the problem btw. There are at least 4 fulltime AirBnB flats on my building floor (that I'm aware of). I'm assuming it's AirBnB because there's a very high "fluctuation" of new people in those flats (few days to 2 or 3 weeks). Imagine if all those AirBnBs would be available for longterm renting ;)
Calling a country's M2 money stock "market cap" is exactly the kind of category error I expect in the crypto space.
Correct. Unfortunately, the Mietpreisbremse is not as "automatic", because there is no fine tied to it. This means the landlord will not reduce your rent unless you do something about it. It also brings a lower reduction than the Mietendeckel.

Unfortunately, many rent contracts had a "shadow rent" clause - a higher rent they'd have to pay retroactively if the Mietpreisbremse was repealed. A lot of people are about to get a really big invoice they have to pay within 2 weeks.

Fortunately, the Mietpreisbremse is retroactive back to April 2020, so you can start the process now and get a refund later.

Your action plan should be the following:

1. Use a Mietpreisbremse calculator to check how much you are paying

2. Contact your landlord, either alone or with the help of a tenants' union (Mieterverein)

3. If that fails, use a lawyer, or a service like Wenigermiete. If it get this far, the resolution will generally take around a year. This is the average resolution time.

I have worked directly with Wenigermiete. They explained the situation to me just last week, but they expected the court to resolve the case in July, perhaps even later.
AFAIK it's even worse than that. The field types can trigger lossy transformation of the input data, but aren't enforced.

https://www.sqlite.org/datatype3.html#type_affinity
This is great. I also want affordable housing for everyone, but capping rents does not deal with the core problem: There's not enough supply. I am baffled how some people do not understand this.

Also, for many people in Germany buying e.g. a single apartment is an investment for their later retirement. It's not all big and evil real estate companies.
For JSON support, there seems to be an extension:

https://www.sqlite.org/json1.html

Haven't used it, was just wondering if there's something as I found myself quite happy with JSON support in mysql/aurora.
If it is the solution, why doesn't it work wherever they have tried?
Housing in all winner-take-all cities are fucked. Here's hoping remote work can start to really spread things around with intentional communities trying to bring specific types of people together.
You are correct and what I had in mind was the required recovery. I do trust recovery but performing it can be very time consuming.
How do you think those two stack up against each other?

Not trying to start language wars here, of course, I'm just interested because I find Nim one of those languages that I'd like to try but don't have a project/use case to try on.
Stunning footage shows two bubble rings colliding in Balearic Islands, Spain
A free diver captured the moment when two bubble rings collided, dissolving into each other to form one larger circle.
higher rent can only lead to 10 euro pretzels and 50 euro pizzas. and then it all collapses and starts all over again.
It shouldn't be overly painful. There were already laws in place restricting the price of rent. It's just a few months ago nearly everyone got a rent decrease. Mines was about 150 euros. With this decision it may be possible that the landlords ask for back rent that they didn't charge because of this law. And our rents go back to what they were. I considered my rent pretty cheap in the first place so I am not overly concerned about the rent hike. I am going to be annoyed about paying back rent in a lump sum for something that really wasn't anything to do with me.
You'd want to be clear on how much of that was caused by the setting in which they took psychedelics before making a pronouncement.
But also for the ops, as it means securing one place instead of two.
It's the jobs that support the locals that don't pay enough. While the skilled workers might be able to afford the local rent, other residents progressively get pushed out.
You mean "federal law trumps state law"?
There is JSON support, yeah.

But while you need to do everything with a JSON1 extension for managing the json ( https://www.sqlite.org/json1.html ).

Postgress has build-in v8 javascript functions to manage this ( as stated before). Which makes it much more useable.

There's a good library for .net that handles postgress documents, which has an insane amount of usefull functions ( https://martendb.io/documentation/documents/ ). I think halve of those wouldn't be possible on another database.
Typically you normalize both to a non-accented format, which is what you index...
a lot of us have this as nightmare scenario.

- long term we really should move to an industry wide due process system with legislation for compensation and other parameters. once there is some more structure there can also be insurances or similar ways to prevent something like this to ruin a company.

- there maybe is a market for more intermediaries that bundle twilio and messagebird or similar providers and have an official strong communication channel to the providers to resolve issues and provide failover
They wont be ever again once either voterID is banned or undocumented citizens are allowed to vote
Brave has also disabled FLoC:

https://brave.com/why-brave-disables-floc/
Abortion is a complex moral issue and if you think it isn’t, you haven’t researched the topic well enough.

Ditto for the other issues mentioned in your comment. The lines you’ve used (“control of their bodies, Jim Crow”) are indications that you get your information from propagandistic sources.
The following is anecdotal, but many people report more vivid dreams after recreational use of LSD.
Fundraising with Discount Cards, Creative Fundraising
also like https://www.resemble.ai I remember using that one awhile ago and thinking this should all be open source
Yup. I use it for most cross-platform apps as a default.

Quick prototyping with Python and wx would be my typical use-case.
Add the USA to that list.

Housing needs to not be an investment.
Mietpreisbremse for Berlin wasn't renewed, so there is now no upper limit on Miete except the federal 20% every 3 years. (I think)
Equisafe launches Equisafe Markets, a revolution for private equity markets
Deaths per population, not per infected case is about 0.2% in the US. The black death killed about 50% of Europe's population.
There was a good talk at Hashiconf a few years back, can't find a link now.

I can't say that this is the "right" way to do it, but it scales OK for our org (100+ engineers, 200+ services per environment, many third party and in-house providers). A single team owns the codebase, though all backend engineers expected to write and maintain their own infra code. Some highlights:

* Monorepo with ~ 700 terraform modules, > 1000 terraform workspaces
* CI/CD tooling to work out the graph of workspaces that need to be executed for a given change using merkle tree/fingerprinting, and build dynamic plan/apply pipelines for a given PR
* Strict requirements about master being up to date, and serialised merges managed by a bot, with continuous deployment (i.e apply) on merge
* Templated code/PR generation for common tasks
* Tooling for state moves, lock management etc
* Daily full application of all workspaces with alerting on state drift (e.g externally updated resources)

As an org, we average about 20 infrastructure changes per day through this system.

A few tips:

* Find the right level of abstraction for breaking larger workspaces down into smaller ones. This should be determined by things like rate of change, security requirements, team ownership, and in some cases whether you have a flaky provider that you want to isolate. Size of state should also be a consideration - if a workspace takes 2 minutes to plan, it's too big
* If you start to use lots of remote states, wrap all remote states into a module with a sane interface to make consumption easier. You can also embed rules in this like "workspace X cannot consume from state Y" (e.g because of circular dependencies or security considerations)
* Never embed a provider within a module (I think this is enforced in newer TF versions)
* Terraform is a hammer that will can tackle most nails, but for several problems there are more appropriate tools
I'm sure their customers will completely understand, pay the higher costs without complaint, and not at all go and find alternative suppliers.
The only problem with atomic filesystem snapshots is the time required to perform recovery which can be avoided. The recovery process is of course reliable.
It's a Great News Thanks for Sharing.

https://www.upsers.mobi/
We need to change the message from "don't take drugs" to "if you choose to take drugs, take them responsibly".

Start with low doses, don't mix (alcohol,benzo,opiates), and remember that unless taken therapeutically, drugs should be an occasional party thing and not an escapism for life.

It's also totally fine to not do drugs. I'm going sober (except a beer or two) for an indefinite period of time, just because that's what I feel like.

Maybe I'll go on a mushroom trip for new years eve, who knows, but drugs shouldn't define your life.
It is like saying refugees are part of the problem, because they are taking flats from the market. People who rent Airbnb also have a right to be in Berlin.

And this policy is pushing more flats from normal market into airbnbs.
neeva? maybe brave search in a few months?
I have $2.7 million that must be paid back to you immediately or else I will be sent back to jail, please wire me a $2,500 deposit so I can initiate the transfer as soon as possible!
> (e.g., in the trolley problem, what happens if you save the 3 people over the 1 person, but one of those 3 people ends up becoming (or is) a dictator who orchestrates a genocide.)

Presumably by this logic, you'd have no opinion on whether a midwife should save a newborn baby's life, as it's unknowable whether the baby will one day orchestrate a genocide?
Canada to grant residency to 90k students and workers fighting coronavirus
So, the bavarian investor who upgraded his property is the bad guy here? While you spend your time abroad, blocking an apartment in Berlin's city center?
Sure, low rents from decades ago are nice, but there has to be an equilibrium. Houses depreciate and if the rent is too low there won't be any money left to pay for upkeep. Unless of course, the bavarian millionaire has to take a loss and pay for that out of his own pocket, because eat the rich.
is it really a benefit? seems to me like it inevitably leads to optimizing for earning money rather than helping people, leading to a lack of focus on solving problems which affect people but aren't profitable to solve (focusing more on a perspective of scientific research rather than art)
That's why we have charity evaluators like GiveWell. https://www.givewell.org/