polyrand

30 ms·

1. 331.▲
   JavaScript vs. jQuery vs. Hyperscript(hyperscript.org)

   3 points by polyrand 6y ago|1 comments
2. 332.▲
   by polyrand 6y ago

   Now there's something called Swarm mode built directly into the main Docker engine. I think that was the "replacement" of the classic Docker Swarm.
3. 333.▲
   Show HN: Use SQLite as a Message Queue

   4 points by polyrand 6y ago|0 comments
4. 334.▲
   Python Itertools and Builtins for AsyncIO(github.com)

   1 points by polyrand 6y ago|0 comments
5. 335.▲
   I wrote one of the fastest DataFrame libraries(ritchievink.com)

   389 points by polyrand 6y ago|140 comments
6. 336.▲
   by polyrand 6y ago

   One thing to note about the `RETURNING` clause is that it can't be used in subqueries[0] or CTEs. One thing I do with Postgres is using multiple CTEs with `RETURNING` clauses to have a query with many steps, without having to open a tr
7. 337.▲
   by polyrand 6y ago

   Yes, I’m aware. I usually compile it during a multi stage docker build. There’s also pysqlite3 for Python when I need the latest version. However, my issue is when I want to access the DBs from the CLI to check something. If I am using feat
8. 338.▲
   by polyrand 6y ago

   The `RETURNING` is so awesome! I'm implementing a set of data structures on top of SQLite, one of them is a queue[0], and I had to do a transaction to lock a message and then return it, but this makes it easier. There's one little
9. 339.▲
   Routing the Technical Interview(lars.hupel.info)

   3 points by polyrand 6y ago|0 comments
10. 340.▲
    What is a hash function and the different types?(exampl.io)

    1 points by polyrand 6y ago|0 comments
11. 341.▲
    Cysimdjson: Python bindings for simdjson using Cython(github.com)

    1 points by polyrand 6y ago|0 comments
12. 342.▲
    by polyrand 6y ago

    The ROCm (AMD GPUs) support really caught my attention.
13. 343.▲
    PyTorch 1.8(pytorch.org)

    26 points by polyrand 6y ago|4 comments
14. 344.▲
    by polyrand 6y ago

    I would recommend giving Caddy[0] a try. Most servers/reverse proxies need 10s of options to work more or less well. With Caddy, "correct" is the default, including having the best SSL management system (so you don't e
15. 345.▲
    by polyrand 6y ago

    I use Caddy for most of my projects and it's fantastic. Everything works as it should by default.
16. 346.▲
    by polyrand 6y ago

    I am always keeping and eye on mypyc, typed_python (llvm Python compiler)[0] and nuitka[1] I guess that because Python is extremely dynamic, we may never have a full everything-works compiler, but I’m excited about the possibility of this b
17. 347.▲
    by polyrand 6y ago

    This sounds interesting, could you share more about the migration process and how you did it?
18. 348.▲
    by polyrand 6y ago

    That sounds great! I’ve always kept an eye on how Hasura does things. Do you have any open projects using this stack?
19. 349.▲
    by polyrand 6y ago

    I was writing a cookiecutter template for this kind of stack but never finished it. After using similar stacks for a couple of projects I am going to get back to it soon with many improvements and publish it.
20. 350.▲
    by polyrand 6y ago

    Absolutely! I think it should be doable, FastAPI and other libraries do heavy Pydantic model inspection, and some do automatic code generation. I should explore this a bit more.
21. 351.▲
    by polyrand 6y ago

    I only define them once, but I define all the database schema by hand (with an SQL script). I’d love to have something that translates Pydantic to an SQL schema definition. Each asyncpg result has a dictionary-like interface, so I can conve
22. 352.▲
    by polyrand 6y ago

    Related to ORMs/queries/performance, I have found the following combination really good: * aiosql[0] to write raw SQL queries and having them available as python functions (discussed in [1]) * asyncpg[2] if you are using Postgres
23. 353.▲
    by polyrand 6y ago

    I have been using `z` for some time, and now I can't imagine working without it. I used to have a big list of aliases like: alias pro='cd ~/Projects' Seems trivial, but it was a huge time saver over time. After in
24. 354.▲
    Sharing multiple in-memory SQLite databases(ricardoanderegg.com)

    1 points by polyrand 6y ago|0 comments
25. 355.▲
    Learn Functional Programming Visually(david-peter.de)

    354 points by polyrand 6y ago|65 comments
26. 356.▲
    by polyrand 6y ago

    I agree it's a very weird API, but you get used to it. In python, when initializing the DB I always use: conn.execute(f"PRAGMA cache_size = {-1 * 64_000}") That way I never forget about the minus.
27. 357.▲
    by polyrand 6y ago

    I love it! Now I'm less afraid of JavaScript
28. 358.▲
    by polyrand 6y ago

    Regarding SQLite's performance, some things I've found very useful: Use WAL mode (writers don't block readers): PRAGMA journal_mode = 'WAL' Use memory as temporary storage: PRAGMA temp_store = 2 Faster
29. 359.▲
    by polyrand 6y ago

    I have always found the JSON functionality in SQLite fantastic. I'm using SQLite in production with Python for a project right now. It does not have much traffic yet, though. I'm using multiples DBs and one of them is a simulation
30. 360.▲
    by polyrand 6y ago

    Hi Ben, thank you so much for building this! I'm currently working on implementing a set of data structures (and more things later) on top of SQLite ( https://github.com/litements/ ) for some of the same reasons you