jeeybee

6 ms·

1. 31.▲
   Are libraries always the best choice in secure development?

   5 points by jeeybee 2y ago|5 comments
2. 32.▲
   by jeeybee 2y ago

   Cool, to put on a bit of a tin hat, how do we know that the model is not tuned to infringe on what we in the West would consider censorship or misinformation?
3. 33.▲
   by jeeybee 2y ago

   Thanks, I haven't deployed PipeGate on AWS; it started as a personal curiosity project. There are probably many security aspects that would need to be addressed before deploying it in a production environment.
4. 34.▲
   Show HN: PipeGate – A Lightweight, Self-Hosted Proxy to Expose Local Servers(github.com)

   33 points by jeeybee 2y ago|11 comments
5. 35.▲
   by jeeybee 2y ago

   Thanks for the detailed response—lots of good points here. IT's main concern is blocking any external traffic from hitting local machines, even if tunneled or encrypted. Outbound traffic is generally fine, but many external platforms r
6. 36.▲
   by jeeybee 2y ago

   Interesting, but sounds very similar to the ngroks ssh-option?
7. 37.▲
   by jeeybee 2y ago

   Cool, dropped an email.
8. 38.▲
   Ask HN: Integrating with External Systems Without Ngrok: What Are My Options?

   3 points by jeeybee 2y ago|6 comments
9. 39.▲
   by jeeybee 2y ago

   Good point about SKIP LOCKED inefficiencies with mixed-duration jobs. In PGQueuers benchmarks, throughput reached up to 18k jobs/sec, showing it can handle high concurrency well. For mixed workloads, strategies like batching or partiti
10. 40.▲
    by jeeybee 2y ago

    I think PGQueuers main advantage is simplicity; no extra infrastructure is needed, as it runs entirely on PostgreSQL. This makes it ideal for projects already using Postgres and operational familiarity. While it may lack the advanced featur
11. 41.▲
    by jeeybee 2y ago

    PGQueuer is a lightweight job queue for Python, built entirely on PostgreSQL. It uses SKIP LOCKED for efficient and safe job processing, with a minimalist design that keeps things simple and performant. If you’re already using Postgres and
12. 42.▲
    by jeeybee 2y ago

    Thanks! This is exactly why I wrote it. So far, it has been a nice simplification that allows me to "just get on with it."
13. 43.▲
    PGQueuer v0.15.0 Released – Now with Recurring Job Scheduling(github.com)

    29 points by jeeybee 2y ago|6 comments
14. 44.▲
    by jeeybee 2y ago

    Im excited to announce the release of PGQueuer v0.15.0! PGQueuer is a minimalist, high-performance job queue library for Python that leverages PostgreSQL's robustness, designed for real-time, high-throughput background job processing.
15. 45.▲
    by jeeybee 2y ago

    PGQueuer provides job queuing, locking, and real-time notifications using PostgreSQL's FOR UPDATE SKIP LOCKED and LISTEN/NOTIFY. It's a minimalist alternative for those already using PostgreSQL, avoiding the need for Redis. -
16. 46.▲
    by jeeybee 2y ago

    Used Zed for a week or so, loved it! But the lack of mypy / git integrations forced me back to VS-code :'(
17. 47.▲
    by jeeybee 2y ago

    Got a pihole a few years ago, works like a charm. The only annoyance is when you actually look for produces and nearly all links in google are dead due to ads.
18. 48.▲
    by jeeybee 2y ago

    Unsure whats going on, but unable to add links to my question. - https://github.com/janbjorge/pgqueuer - https://news.ycombinator.com/item?id=41284703
19. 49.▲
    Ask HN: PgQueuer Improvement Ideas – Where Should I Focus?

    1 points by jeeybee 2y ago|1 comments
20. 50.▲
    PGqueuer v0.10.0 – Serialized Dispatch(github.com)

    2 points by jeeybee 2y ago|0 comments
21. 51.▲
    by jeeybee 2y ago

    Hi everyone! I’m currently enhancing the documentation for my project, PGQueuer. About PGQueuer: PGQueuer is a minimalist, high-performance job queue library for Python, leveraging PostgreSQL’s LISTEN/NOTIFY for efficient job managemen
22. 52.▲
    by jeeybee 2y ago

    I’ve seen it posted here once or twice before, but it always brings a smile to my face.
23. 53.▲
    by jeeybee 2y ago

    Of my head, you could attach a uuid or sequence number to the emitted event. Then based on the uuid or sequence you can let one or the other event consumer pick? Ex. you have two consumers, if the sequence number is odd, A picks it, if its
24. 54.▲
    by jeeybee 2y ago

    asyncpg clears out any listeners you have setup once a connection is returned to pool. This will lead to 'missed' events. I guess its something of the same story with psycopg? If event(s) any jobs will be picked up by the next eve
25. 55.▲
    by jeeybee 2y ago

    At first glans i i see two thins that PgQueuer can. It has native async support, it you can also have sync functions, they will be offloaded to threads via anyio ( https://github.com/janbjorge/PgQueuer/blob/99c
26. 56.▲
    by jeeybee 2y ago

    I was able to push PqQueuer to 25k jobs a second in my benchmarking script.
27. 57.▲
    by jeeybee 2y ago

    I haven’t used Graphile Worker since I’m not familiar with JavaScript. PgQueuer is tailored for Python with PostgreSQL environments. I’d be interested to hear about Graphile Worker’s features and how they might inspire improvements to PgQue
28. 58.▲
    by jeeybee 2y ago

    thanks for sharing, added to my to watch list.
29. 59.▲
    by jeeybee 2y ago

    I agree, there is no need for FANG level infrastructure. Imo. in most cases, the simplicity / performance tradeoff for small/medium is worth it. There is also a statistics tooling that helps you monitor throughput and failure rats
30. 60.▲
    by jeeybee 2y ago

    LISTEN/NOTIFY and SELECT FOR UPDATE SKIP LOCKED serve different purposes in PgQueuer. LISTEN/NOTIFY notifies consumers about changes in the queue table, prompting them to check for new jobs. This method doesn’t inherently lose mes