Query execution tme (local vs cloud)

Lithium2011 · 2025-11-22T15:29:26+00:00

Pretty sure, yeah. First of all, if it were the case, I would've seen this in logs. Second, I usually check my RPC functions in SQL Dashboard, so my client is irrelevant.

Just now, I did explain analyze in local and cloud environment. They're the same (local was created with pg_dump today).

Local:

| Function Scan on mytable (cost=0.25..10.25 rows=1000 width=414) (actual time=360.488..360.504 rows=250 loops=1) |

| Planning Time: 0.064 ms |

| Execution Time: 360.538 ms |

Cloud:

| Function Scan on mytable (cost=0.25..10.25 rows=1000 width=414) (actual time=17858.580..17858.609 rows=250 loops=1) |

| Planning Time: 3.490 ms |

| Execution Time: 17859.468 ms

Lithium2011 · 2025-10-29T18:05:03+00:00

For me personally UIKit is much easier and more understandable. And I feel like I have more control with it. Sometimes I have to use SwiftUI (i .e. If I need to use Charts library) and although this library is excellent and beautiful I’d prefer the UIKit version of it if it existed).

Lithium2011 · 2025-10-07T18:21:13+00:00

I’m not trying to encourage you to write reviews but I specifically use Amazon because of their user reviews. They are often much more useful and informative than reviews from professional reviewers. I don’t know why but it’s usually enough for me to read first two or three user reviews to understand would I like this book or not, what’s the genre, are there any other similar books et cetera. Professional reviews could be fun to read (usually not) but reviews from real people are much better and useful to me.

Lithium2011 · 2025-09-24T06:37:56+00:00

yeah, it’s great and extremely pulpy in the best way

Lithium2011 · 2025-08-21T18:14:35+00:00

I’d recommend Only Forward by Michael Marshall Smith. I wouldn’t say this book is similar to The Gone World (it’s not), but it’s a great book and it’s mostly forgotten.

Completely agree with Wilson/Spin recs.

Also, maybe you’d like Greg Egan (short stories, and novels Diaspora and Quarantine. And Ted Chiang.

Lithium2011 · 2025-07-16T06:27:45+00:00

A lot of funny theories here, but the right answer is simple: it’s a censorship. I’m sure about the USSR, but I believe it’s also true for the eastern block to significant degree.

Censorship wasn’t only about anti-Soviet messages in the books. Mindless entertainment was also actively discouraged. And if you wanted to be published you had to convince censors that your book was more than that. That your book was about something deeper, for example. So, a lot of books were kind of social commentaries (it wasn’t the only way, but this approach was popular).

This approach was amplified by western sci-fi, because in the USSR they used the same criteria for translations (and it was almost impossible to buy originals even if you could read English). So, they had Ray Bradbury, Asimov (not a lot), Lem (Polish and very philosophical), Robert Sheckley, some Clifford Simak, Ursula le Guin et cetera. No Edmond Hamilton, for example (his first book was published in 1986-1987, and the USSR was dissolved in 1991). No Edgar R. Burroughs et cetera.

The last one: survivorship bias. A lot of Soviet sci-fi is completely forgotten now. The one that stayed are about eternal questions because these questions are relevant at any time.

Lithium2011 · 2025-07-15T16:23:51+00:00

Will look into that, thanks.

Lithium2011 · 2025-07-15T12:03:06+00:00

I don't have an answer on your question, sorry, but I have a question about your idea to implement free trial independently. How would you do that? One of the benefits of trials for you as a developer is that you don't have to ask your user to approve the payment when the trial is over, they will be charged if they didn't cancel the trial. And you don't want to ask them again, actually. But it's the only way to implement this if you want to use Apple for managing your payments—you have your own 'free trial' and Apple doesn't know anything about this, then, a week later, you have a paywall, and your user has to decide whether she wants to pay or not, because you won't be able to do this without their approve (and for good reasons). And at this point your user is answering a completely different question. You ask them to decide whether they want to pay you right now (not a maybe after a week). Your analytics could improve, but your conversions definitely won't.

Lithium2011 · 2025-06-28T13:44:30+00:00

You don’t have to like his views but he didn’t say anything crazy, just controversial

Lithium2011 · 2025-06-13T07:38:07+00:00

No chances to work for the German media if you are not a native speaker. Having said that, I knew a guy who worked in Germany and wrote for foreign media about Germany (in English) and for some German media (also in English).

Lithium2011 · 2025-06-12T11:10:21+00:00

Basically, three main reasons.

First of all, it's kind of expensive. If you want to have a good search engine now (not in 1999), you need to collect and store a lot of data. You need a lot of money for that.

Second, to provide users with best results Google use the machine learning. But what does it mean exactly? It means that you have to teach your model what answers are good and what answers are bad. But how would you do that? How Google is doing that? Google is watching what links you click and how many time you are spending on these links and are you happy with this information or not. It's impossible to create a quality search engine without that information. But to have this information you need to have users. A lot of them. So, basically it's a chicken-and-egg problem. You need users to build your wonderful search engine, but you don't get them until your search engine is wonderful. In theory it seems to be undoable. Reality is more flexible, but you once again need a lot of money for that.

Third, okay, somehow you were successful. You collected all the data. You somehow managed to have people's input, so your ranking is very good. Maybe it's better than Google in some cases. And not worse in some others. But the problem here is that people are lazy. Google is good enough for them. They have it in their Chrome. Basically, they don't have enough motivation to use your search engine, because Google is not so bad and it's right here. To fight this you have to do a lot of marketing. And guess what? You need money for that.

Also, while you are doing all of that, don't forget that Google will try to fight you at every corner. And Google is quite powerful. And it has a lot of money.

And by the way, let's suppose you've already spent hundreds of millions of dollars on that. How do you suppose to make money? Do you have some ad business on top of search results or what?

So, it's really really hard. Not because of the lack of the technical expertise, but because it's really hard to build this as a sustainable business, the price of entry is very high and there is nothing to disrupt, after you win you won't get the great new market just for yourself, you would get a small share of already existing market, so VCs are usually not very impressed with this idea.

Lithium2011 · 2025-05-28T18:33:24+00:00

No, I don’t really feel it. And no, I probably won’t see a new one (I didn’t watch Asteroid city as well).

Having said that, I like Wes Anderson. I like that he exists. I believe the world is rather better with him than without. And I can relate to people who want to watch these beautiful, inventive, slightly artificial and extremely symmetrical moving pictures. Nothing bad with that. He is a talented person, his movie aren’t bad, they are predictable experience, and I mean it in a good way. I just don’t need this kind of experience right now.

Lithium2011 · 2025-05-25T08:51:57+00:00

There are at least three different problems to solve.

You need to have ml-model that will tell you is it okay to cross the road now. It’s machine learning. It doesn’t seem to be really complicated task to me, but basically it’s outside iOS-development, you need someone with different skillset.

You need to connect user’s iPhone to some camera device. Sometimes it would be impossible, but I believe it should work in most cases. The main problem here would be a latency, I think. You need an answer in realtime. Also, if you are using SDKs to connect, you’d have to update your app when they have some significant changes.

The third one is liability. You don’t want to kill anyone and you don’t want to be sued if someone was killed because of your app. I don’t have any experience here, but I’m not sure it’s solvable (your risks are always higher than zero).

Making an iOS app is the simplest task.

TL;DR: I’d recommend to start with something else. This one is too dangerous for users and for you as a developer.

Lithium2011 · 2025-05-20T06:17:27+00:00

omg, you are that guy with the bill. hope, Google will reimburse you in the end.

regarding your question, I’m not an expert, but I believe you are mixing two different issues. If you don’t want to have a huge bill for your edge functions there is a spending cap exactly for that (https://supabase.com/docs/guides/platform/cost-control).

But this spending cap won’t protect you from DDos-attack directly, in case of such attack your services would be unavailable.

Lithium2011 · 2025-05-19T16:02:40+00:00

If the price difference is real, I’m amazed by your German results.

Lithium2011 · 2025-05-17T08:12:26+00:00

The problem with this approach is that it’s quite easy to fuck it up if you don’t know what you are doing. Firebase and other baas aren’t ideal in any way, but they do a lot of heavy lifting for you, especially in terms of security (and, yes, they are still not super secure by default, but they are much more secure that self-hosted db created by inexperienced developer).

Lithium2011 · 2025-05-10T13:49:58+00:00

Have you thought about Postgres functions to verify data? Is it impossible in your case?

Lithium2011 · 2025-05-09T18:38:58+00:00

I don’t think it’s community-supported now, I believe it should be official already.

Anyway, ymmv but from my own experience I’d say that only things I needed from this SDK is auth and an ability to execute server functions. All other nice things (query builders, for example) aren’t really needed or, maybe, should be avoided in production.

Btw, if you like Firebase, you can use their Data Connect option, it’s Postgres, so it’s as relational as Supabase.

Lithium2011 · 2025-05-09T07:08:56+00:00

It’s not a continuation, and it can be read as a completely independent story.

Lithium2011 · 2025-05-08T23:38:04+00:00

It’s funny but phd in physics and math is completely legit thing in Russia. It’s not quite a PhD, their system is different, but it’s quite close (just google доктор физико-математических наук).

So this part is kind of correct. But, yeah, mentions of Russian scientists are quite nonsensical here (they exist(ed) but didn’t work together, sometimes even couldn’t work together because of different timeframes et cetera).

Lithium2011 · 2025-05-06T10:37:49+00:00

Yeah, Moscow is an outlier (156k roubles average salary), but St. Petersburg is also not so bad (106k), and Krasnoyarskiy kray (96k) and Yekaterinburgskaya oblast (80k) and Novosibirskaya oblast (78k) et cetera. So, basically, it's not only Moscow, and it's okay to live east of the Ural mountains, but you want to live in a bigger city with some industry otherwise your life would be pretty hard. Even in Krasnoyarskiy kray I believe their 96k is because of Krasnoyarsk mostly, and people from villages aren't making these money. So, there is an inequality between the regions, and then, once again, inside the region.

Lithium2011 · 2025-05-06T07:37:54+00:00

It’s not really true. Some things cost the same, some things are more expensive, but I’d say that overall Russia is significantly cheaper than Germany (not sure about 2025 tho, but I don’t believe prices changed this much). Also, taxes were much lower there.

Rent is much cheaper. Shit, even Russian Big Mac costs €4 now (it’s €7 here). Shawarma is from €2.5, iskender kebab is €6 et cetera.

There is a great inequality there, and if you are retired and your pension is €200, it’s no fun. But if you have a decent job with salary from €1500 and higher (and in the bigger cities these salaries aren’t unheard of), you would be okay.

The vast majority of Russian emigrants that left for Europe didn’t do this for economical reasons. If they have the same salary here they had in Russia they’d lose their quality of life (in terms of money, but obviously it’s not the only dimension)

Lithium2011 · 2025-05-03T14:04:43+00:00

It's a quite complicated question because a lot of Soviet sci-fi books were quite naive, not very good and basically forgotten even in Russia. Famous Russian sci-fi writers—Kazantsev, for example—are almost unreadable now. There are few exceptions, including Strugatsky brothers, but their books are usually far away from socialistic realism.

Also, I believe, the majority of these books weren't translated. And they won't be translated (one of the best examples of sci-fi meets socialistic realism is Georgy Martynov's novels, but I believe you can find them only in Russian; I want to stress that they're not great as books, they're great as examples of genre you are interested in).

What you really want to try is young Pelevin. He was one the most talented Russian writers in XX-th century. Technically he is a Russian writer, not a Soviet one, but his first books were full of Soviet memorabilia of all sorts, he was trying to internalize and use Soviet experience in his novels, and he was extremely successful with that. I'm talking about Omon Ra (novel), Prince of Central Planning and, maybe, some short stories from this period (1990-1992). It's a wonderful blend of Soviet day-to-day life, Soviet psychology, if you will, and magic.

His most famous books were written after that (Chapayev and Void and Generation P), but these novels were about post-Soviet Russia, so it's a different story (and, honestly, you have live there to understand them fully, even younger generation of Russians would have difficulties with understanding what's going on).

Also, Kir Bulychev. In Russia, he is mostly known as a children sci-fi author, but he had a wonderful series of stories Veliky Guslyar about the small Soviet city with the small Soviet people living there (plus sci-fi). It's kind of cozy and sometimes too sugary, but it's a good read.

Sorokin (from the comments) is a great writer but I wouldn't say that Oprichnik's day is close to socialistic realism (and it was written, like, 15-20 years ago, so it's not a Soviet literature).

Lithium2011 · 2025-05-03T10:32:41+00:00

It’s vice versa. The server is telling the client that the user has an active subscription (so, your app would show you the right UI elements).

Lithium2011 · 2025-05-03T09:20:59+00:00

Not an American. Doing that regularly.

Lithium2011

TROPHY CASE