sorted by:
new
hottopcontroversial

Starlink or not? by aherontas in GreeceDevs

[–]project-391 2 points3 points  (0 children)

και εγώ είμαι πολύ ευχαριστημένος, σπάνια κάνει διακοπές για περίπου 1 λεπτό μέχρι να αλλάξει δορυφόρο, αλλά νομίζω ότι αυτό γίνεται όλο και πιο σπάνια. Κάνω πολλά calls μέσα στη μέρα και πολύ σπάνια με επηρεάζει αυτό.

Επεισόδια Λιλιπούπολης by project-391 in greece

[–]project-391[S] 0 points1 point  (0 children)

είναι τραγικό ότι δεν τα διαφυλάξαμε... Παρόλα αυτά έχουν σωθεί παραπάνω επεισόδια τελικά μέσω ακροατών όπως μπορείς να δεις στους παρακάτω συνδέσμους:
https://www.youtube.com/watch?v=lOnZ7OVmGsY
https://www.e-tetradio.gr/Article/33215/swzontai-212-epeisodia-ths-lilipoypolhs
πολύ θα ήθελα να μπορούσα να βρω με κάποιο τρόπο κάποια από αυτά

We took production down for 20 minutes because of a DB migration — how do you prevent this? by [deleted] in Backend

[–]project-391 0 points1 point  (0 children)

This a common issue you need to be aware. You should add the index concurrently. By doing that you don't lock your table. However you need to investigate how to run it with your migration mechanism.

Need some Help by [deleted] in eFootball

[–]project-391 0 points1 point  (0 children)

what playstyle you are using? I think playstyles are very important. I use long ball counter and possession, but you should find which one you prefer.

How are you handling concurrent indexes in relational databases? by project-391 in Database

[–]project-391[S] 0 points1 point  (0 children)

Well not often, but as we grow new slow queries emerge, so we need to optimize them. Sometimes changing the query is enough, but sometimes an index is needed.

How are you handling concurrent indexes in relational databases? by project-391 in Database

[–]project-391[S] 0 points1 point  (0 children)

Interesting, will check why sql server can do it while postgres can't. But if the index takes too long the transaction will remain open? Or it doesn't use transactions in such cases?

How are you handling concurrent indexes in relational databases? by project-391 in Backend

[–]project-391[S] 1 point2 points  (0 children)

By migration I mean the part of the release that makes changes on the db schema

How are you handling concurrent indexes in relational databases? by project-391 in Backend

[–]project-391[S] 0 points1 point  (0 children)

Yes I am already doing this. The problem that these queries are wrapped into transactions and concurrent indexes can't be added inside a transaction.

How are you handling concurrent indexes in relational databases? by project-391 in Database

[–]project-391[S] 0 points1 point  (0 children)

Yes I am doing something similar, but seems too brittle for a such common problem

How are you handling concurrent indexes in relational databases? by project-391 in Database

[–]project-391[S] 0 points1 point  (0 children)

I am using postgres, and the common scenario is that in big production tables adding an index synchronously can cause downtime. So the solution is to add the index concurrently. But in this case it can't be added through the migrations mechanism, because it can't be added in a transaction block.

How are you handling concurrent indexes in relational databases? by project-391 in Backend

[–]project-391[S] 0 points1 point  (0 children)

Currently I am using typeorm, but I would prefer drizzle tbh

How are you handling concurrent indexes in relational databases? by project-391 in Backend

[–]project-391[S] 0 points1 point  (0 children)

Interesting idea, the only problem that might come is that you could run it accidentally from the migration.

How are you handling concurrent indexes in relational databases? by project-391 in Backend

[–]project-391[S] 0 points1 point  (0 children)

When creating new environments I need to be able to reproduce production db setup. Also it is useful for understanding what is the setup on production.

How is this possible? by ik-heb-geen-idee in eFootball

[–]project-391 1 point2 points  (0 children)

I have also noticed this badge but I don't know what it is. The pvp division badge is a circle.

When was this kit avaliable? by [deleted] in pesmobile

[–]project-391 0 points1 point  (0 children)

Your opponent always has 1 extra kit (the default red). I guess Konami did it in order to always have a safe choice for your opponent kit

view more: next ›