faizshah

36 ms·

1. 421.▲
   by faizshah 5y ago

   Really cool, I’m a big user of SQLite. Reminds me of visidata but for SQLite: https://github.com/saulpw/visidata
2. 422.▲
   by faizshah 5y ago

   Thanks this is really illuminating, how did you find projects like this? Where did u get the visibility to be able to find problems like this that were priorities for leadership?
3. 423.▲
   by faizshah 5y ago

   Thanks! That makes a lot of sense.
4. 424.▲
   by faizshah 5y ago

   Can you give an example of a project like that? Or at least a hypothetical example if they are confidential. I can’t think of a project like that that people said couldn't be done, its usually just people saying “we cant do it at this
5. 425.▲
   by faizshah 5y ago

   Sorry I think I may have come off as criticizing you when I meant it as a more general point. Sorry for the misunderstanding.
6. 426.▲
   by faizshah 5y ago

   I actually disagree with this (if you’re aiming to work at a company between Unicorn and FANG size), I think there’s 2 parts to getting hired as a new grad or getting an internship as a student. The first part is the University Hiring recru
7. 427.▲
   by faizshah 5y ago

   IMO the only advice I can give college students trying to break into tech is to always have a tech related internship every summer no matter what. Even if you have to apply to nonprofits looking for an IT admin intern, just have a track rec
8. 428.▲
   by faizshah 5y ago

   When I was trying to get my first internship it took me 160 applications to get 1 interview, before that I applied every year for ~20 internships at the big names and never got 1 interview. Similarly for my senior year I applied to full tim
9. 429.▲
   by faizshah 5y ago

   Does tap water really make that much of a difference? Anyone tried side by side?
10. 430.▲
    by faizshah 5y ago

    Would this support pydantic dynamic models? https://pydantic-docs.helpmanual.io/usage/models/#dynamic-mo... Or rather can I pass an existing pydantic class to SQLModel somehow?
11. 431.▲
    by faizshah 5y ago

    Large companies often have security mandates that dependencies should be regularly updated.
12. 432.▲
    by faizshah 5y ago

    The scale is the problem, the assumptions you make for a 100k rps system break for a 1m rps system. For example, in a 10k rps system “just shard it and add another replica” might work but at 100x the throughput your replication strategy i
13. 433.▲
    by faizshah 5y ago

    You seem to think that this is just a service that reads and writes data like any CRUD app. The hard problems stem from how the system deals with failures and how the system propagates writes across the replicas while meeting latency and co
14. 434.▲
    by faizshah 5y ago

    “Accessing almost static data at a very high speed” This is a globally distributed service operating at massive throughput and ultra low latency scaling requirements where if it fails millions of customers and a majority of online commerce
15. 435.▲
    by faizshah 5y ago

    Found something if anyone else is interested: https://github.com/syrusakbary/aiodataloader
16. 436.▲
    by faizshah 5y ago

    Is there anything similar to DataFetcher in python? I have been considering using Prefect which is a workflow system with caching.
17. 437.▲
    by faizshah 5y ago

    Argh I just learned I have only been subscribed to the email list since 2017, I don’t actually have an account.
18. 438.▲
    by faizshah 5y ago

    Sqlite provides a full text search module (FTS5) which provides a lot of nice search features. I have used this numerous times to build serverless apis for large static datasets for frontend analytical experiences like data tables without s
19. 439.▲
    by faizshah 5y ago

    I’ve worked on multiple codebases where nobody on the team had been there when the sausage was first made. The squash commits are some of the worst commits for finding out why a weird design decision was made because all the things that cam
20. 440.▲
    by faizshah 5y ago

    Yep I love the git GUI in Jetbrains IDEs, especially the change lists and shelf based workflow. I also like using the IDE’s diff to quickly use parts of an old shelved patch or when I’m working through a book I can diff my project with the
21. 441.▲
    by faizshah 5y ago

    I really like this book on CQRS & ES: https://www.amazon.com/Practical-Microservices-Event-Driven-... It’s a really practical treatment of CQRS & ES with JS examples. I had heard about CQRS & ES on HN for years
22. 442.▲
    by faizshah 6y ago

    How strange, sorry, I didn't know that it did that. Just updated it to an archive link. This is the only source I know of that gives an overview of closures.c so it's worth the read.
23. 443.▲
    by faizshah 6y ago

    There's also a pretty nice built-in sqlite extension for transitive closures that helps in searching hierarchical/tree structures in sqlite: https://web.archive.org/web/20141127001741/https://ch
24. 444.▲
    by faizshah 6y ago

    I wrote that as a one liner it’s not supposed to be readable. Here’s a readable version of essentially the same program: https://perlmaven.com/count-words-in-text-using-perl
25. 445.▲
    by faizshah 6y ago

    Honestly, when you don’t know perl it looks really unreadable but if you spend some time learning it it’s not that hard it’s just many of the operators are not google-able. The harder part, from experience, is maintaining perl scripts. A lo
26. 446.▲
    by faizshah 6y ago

    Nice! I came up with: perl -nle '$w{lc s/[[:punct:]]//r}++ foreach split(/\s+/,$_); print map{"$w{$_} $_ \n"} (sort{$w{$a} <=> $w{$b}} keys(%w)) if eof()' < kjvbible.txt If anyone'
27. 447.▲
    by faizshah 6y ago

    I’ve been using reddit since around 2012 and throughout that time I rarely used Reddit’s search mainly because it didn’t search through comments in a post to score relevance. The only times I would use Reddit’s search was if I remembered so
28. 448.▲
    by faizshah 6y ago

    It's not really that complicated it's just error bubbling with a lack of comments. Definitely worth a refactor into an exception map or something instead of this nested mess though. I've seen worse pass lazy code review hones
29. 449.▲
    by faizshah 6y ago

    We used to play connect 4 like this in high school, it’s frustratingly difficult to remember the game state but it’s easy to play (you just call out the column). You can easily forget the board position if you think too long about a move an
30. 450.▲
    by faizshah 6y ago

    Kind of related: is there something like Dokku but for FaaS?