Sorry! Can work on adding basic auth

idk to what extent the claim is true, but off the top of my head Britain's GCHQ discovered public key cryptography but for some reason kept it under wraps and made no use of it after WWII. It was only found out years after it was rediscovered by American researchers.

The apartments are lovely, but the service charges are eye-watering, ranging from around £6,000 per year for a two-bedroom, to £14,400 for the more expensive ones:

https://themodernhouse.com/sales-list/thomas-more-house-ii

https://themodernhouse.com/sales-list/Lauderdale-Tower-II

https://themodernhouse.com/sales-list/willoughby-house

https://themodernhouse.com/sales-list/ben-jonson-house-iii

And all are sold on that weird UK feudal relic, leaseholds, so you're just buying for a certain number of years - a couple of the ones above only have ~80 years remaining.

I built a complete working application (errortexts.com) using an AI tool, so I have a little insight on this.

At first, the product I was using (lovable.dev) seemed to me exactly as you described. I gave it a basic app outline and hit run, and it produced something that superficially looked right but did nothing.

So I asked some other people for advice, and they said you have to hold its hand and go step by step. So I did.

I told it, give me a landing page that matches [product description], but implement nothing else. Then, ok, let's set up auth - add a sign in and sign up dialog. Then, ok, let's create a user account page. Bit by bit.

It succeeded wildly. I was able to build the whole thing in 3 days. I'm not capable of that on my own, it would have taken me 3 weeks. Sometimes the AI got stuck and I had to manually go in and accomplish what I wanted. It took over 100 steps to complete the product, and probably around 10-20 times I had to revert its changes and give it more specific instructions. I had to check its work at every iteration, just like with a junior developer.

But it worked. And it's going to get better. Would I use this for "something important"? Depends how you define that. I used it to build a working product. Would I start letting it modify an existing mature codebase willy-nilly? No, probably not. Would I let it write cryptographic logic or trust that it wrote bulletproof code from a security standpoint in a sensitive context? No.

But for a simple application, it was an incredibly powerful tool. Especially for something that didn't even exist just 2 years ago. Give this a decade and it's going to change all our careers even more than it already has.

I visited China in 2014 and I have literally wondered out loud this morning whether air pollution has improved since then. I am gald to hear the answer is yes!

Does sqlite cache pages in memory?

If not, how can it be faster?

Is it the IPC overhead of Postgres?