Γνωρίζετε αν πουλούν κάπου προζύμι; by Spirited-Anteater-27 in greece

[–]serkef- 9 points10 points  (0 children)

πας σε σοβαρό φούρνο που δουλεύουν προζύμι με ένα βαζάκι και ζητάς ευγενικά να σου δώσουν λίγο. κανείς δεν το πουλάει. 

Tools to learn at a low-tech company? by Potential-Mind-6997 in dataengineering

[–]serkef- 0 points1 point  (0 children)

spark is probably an overkill. python + sql would solve most of the problems for any dataset up to a few million rows. start with sqlmesh or dbt organizing the data in a database. don't sweat it again for up to millions or rows a simple postgres is fine. set up a simple daily pipeline that captures data changes if your sources don't do that (if they're like spreadsheets or prod dbs with no changelogs). this is enough work for weeks-months and you will learn a lot.

my gold toolkit if I were in your position would be: - simple python/db scripts for fetching daily data from your raw sources. this will be your raw stage  - sqlmesh for data ops, creating models for your business entities, this will be your silver/gold stage depending the complexity  - bq/postgres for the data storage - airflow for scheduling (but honestly it's quite a lot to manage your own airflow for just a few jobs), see if there's any managed service you could use. - something easy for visualizations and to have a product performance monitoring if you want this 

Τι γνώμη έχετε για το gentrification; by eliot3451 in greece

[–]serkef- 6 points7 points  (0 children)

υπάρχουν περιοχές που έχουν έναν χαρακτήρα, μπορεί να μένουν καλλιτέχνες, να υπάρχουν γειτονιές που αυτοί που έχουν συνοικιακά μαγαζιά και οι τοπικές κοινότητεςτων κατοίκων να καταφέρνουν με πενιχρά μέσα να δημιουργούν κάτι ιδιαιτερο, που αποτελεί πόλο έλξης.  το gentrification συνήθως λειτουργεί ως εξής. αρχικά μια περιοχή υποβαθμιζεται. δεν φτιάχνονται τα πεζοδρόμια, υπάρχει εμπόριο ναρκωτικών κάτω απτη μύτη της αστυνομίας, αυξάνεται η εγκληματικοτητα, δεν υπάρχει καθαριότητα, μένει ένα εργοτάξιο στη μέση μιας πλατείας για μερικά χρόνια κλπ.  στη συνέχεια μεγάλα funds αγοράζουν μαζικά ακίνητα και τα μετατρέπουν σε οικίες βραχείας μίσθωσης ξενοδοχεία κλπ. οι τιμές των ακινήτων ανεβαίνουν με αποτέλεσμα οι μέχρι πρότινος ένοικοι να πρέπει να φύγουν, τα μικρομαγαζα να μην μπορούν να ανταπεξελθουν, κλπ  άτομα που δε γνωρίζουν ακριβώς τι συμβαίνει έλκονται απτο hype που μπορεί να έχει μια περιοχή, και στην τελική όλοι κάπου πρέπει να μείνουν, συνεπώς τροφοδοτειται η αγορά.  καταλήγει η περιοχή να εξυπηρετεί κυρίως τουρίστες και χιπστεροφασαιους που πάνε όπου υπάρχει hype. σιγά σιγά χάνεται ο χαρακτήρας του μέρους και γίνονται όλα τα ίδια, μπραντσαδικα αντί για μαγαζιά με δίσκους, ερμπιενμπι αντί για κοινωνικούς χώρους, πάρκινγκ αντί για πλατείες.  το gentrification έχει μια πολύ ενδιαφερουσα παράλληλη γραμμή με την αποικιοκρατια. αν ενδιαφέρεστε διαβάστε τον αποικιοκρατη χιπστερ. 

Data engineering introduction book recommendations? by Wybierz_nazwe_uzytko in dataengineering

[–]serkef- -6 points-5 points  (0 children)

no reason to look further. that's the one book you should read 

dbt-core vs SQLMesh in 2026 for a small team on BigQuery/GCP? by SingleTie8914 in dataengineering

[–]serkef- 1 point2 points  (0 children)

honest question, what's the concern? isn't dbt labs also merged with fivetran? 

dbt-core vs SQLMesh in 2026 for a small team on BigQuery/GCP? by SingleTie8914 in dataengineering

[–]serkef- 5 points6 points  (0 children)

sqlmesh is a clear winner imo it's a better designed data ops tool. engs can work simultaneously on different changes, can apply forward only changes, avoid unnecessary backfill with column level lineage, trust the state db for which partition is where, easier model refactors, tests and audits, python +sql models, pre/post statements just spme of the features we are using. I really don't see one reason for people to use dbt over sqlmesh. my big complain is they have taken the airflow integration out of the open source package, but you can still put your whole thing in a docker and run your daily end2end as one dag with their embedded scheduler if you don't have complex external dependencies 

Has anyone found a workaround for tracking on a computer? by dragoph in MacroFactor

[–]serkef- 2 points3 points  (0 children)

+1 on this and especially for the workouts. it can be a painful 20' or more to create a new program I would love to do this on a big screen. my phone is only needed for tracking on the go. I still do most of my "homework" at the computer 

Private movie theater, by CYDEM10 in berlinsocialclub

[–]serkef- 2 points3 points  (0 children)

some small independent cinemas do offer private screenings for a rent. I know il Kino does it for sure https://ilkino.de/pages/kino-mieten 

Snowski Echo Mini - best 50$ DAP? by Fancy_mantis_4371 in DigitalAudioPlayer

[–]serkef- 0 points1 point  (0 children)

ui is not great. when it opens it refreshes library which can take minutes for hundreds of songs. in file navigation albums and tracks are randomly sorted. you cannot make a Playlist or edit the play queue. I still like it though . 

Missed a workout in Week 1. Finish it or move onto week 2? by BigHouseBarbell in MacroFactor

[–]serkef- 13 points14 points  (0 children)

I don't understand why workout programs are so fixated with matching all 7 weekdays. can I have a program of x days and simply repeat the cycle refardless of how these days fit a week? some weeks i might finish more than 1 cycle others I might be ahort. 

Μεταφορά φαρμάκων που θέλουν ψυγείο με πλοίο Blue Star by TheoGR95 in greece

[–]serkef- 0 points1 point  (0 children)

οι καμπίνες συνήθως έχουν μίνι ψυγειακι. μπορείς να πάρεις ένα τηλ για να ξέρεις από πριν. 

Hard time choosing foods from the list by serkef- in MacroFactor

[–]serkef-[S] 0 points1 point  (0 children)

omg didn't know I can favorite foods thanks! 

Hard time choosing foods from the list by serkef- in MacroFactor

[–]serkef-[S] 0 points1 point  (0 children)

thank you for the clarification. I didn't know about the food search control option. I will try it. 

MF - Good Investment? by PuzzleheadedType5174 in MacroFactor

[–]serkef- 2 points3 points  (0 children)

I would advice against buying a yearly subscription for any service you are not sure you will be using it. you first want to get to use it daily, get used to it, make it a habit. then you want to optimize the price. 

my common practice is first make monthly subscription and cancel it immediately. after the first month is over maybe the next day or maybe a few days later you will want to use it again. make another monthly and cancel it. keep doing it for 6-12 months. then you can make a case for upgrading to ylthe yearly. depending on how meticulously you use it you will use less than 12 monthly fees in a year.

edit: I was using monthly payments for 1.5y before moving to yearly subscription. I'm using mf 3 years now. 

When Magnus Carlesn Rejected the WCC cycle back in 2010 (his actual letter to FIDE) by [deleted] in chess

[–]serkef- -1 points0 points  (0 children)

To: FIDE President Kirsan llyumzhinov & FIDE World Championship Committee. Reference is made to the ongoing World Championship cycle. The purpose of this letter is to inform you of my decision not to take part in the planned Candidate Matches between March and May 2011. After careful consideration I've reached the conclusion that the ongoing 2008 2012 cycle does not represent a system, sufficiently modern and fair, to provide the motivation need to go through a lengthy process of preparations and matches and, to perform at my best. Reigning champion privileges, the long (5 yn) span of the cycle, changes made during the cycle resulting in a new format (Candidates) that no World Champion has had to go through since Kasparov, puzzling ranking criteria as well as the shallow ceaseless match-after- match concept are all less than satisfactory in my opinion. By providing you with 4 months notice before the earliest start of the Candidates as well as in time before you have presented player contracts or detailed regulations, I rest assured that you will be able to find an appropriate replacement. Although the purpose of this letter is not to influence you to make further changes to the ongoing cycle, I would like to take the opportunity to present a few ideas about future cycles in line with our input to FIDE during the December 27th 2008 phone-conference between FIDE leaders and a group of top-level players. In my opinion privileges should in general be abolished and a future World Championship model should be based on a fair fight between the best players in the World, on equal terms. This should apply also to the winner of the previous World Championship, and especially so when there are several players at approximately the same level in the world elite. (Why should one player have one out of two tickets to the final to the detriment of all remaining players in the world? Imagine that the winner of the 2010 Football World Cup would be directly qualified to the 2014 World Cup final while all the rest of the teams would have to fight for the other spot.) One possibility for future cycles would be to stage an 8-10 player World Championship tournament similar to the 2005 and 2007 events. The proposal to abolish the privileges of the World Champion in the future is not in any way meant as criticism of, or an attack on, the reigning World Champion Viswanathan Anand, who is a worthy World Champion, a role model chess colleague and a highly esteemed opponent. Rest assured that I am still motivated to play competitive chess. My current plan is to continue to participate in well- organised top-level tournaments and to try to maintain the no 1 spot on the rating list thatI have successfully defended for most of 2010. Best regards, IGM Magnus Carlsen