xdanger

8 ms·

1. 1.▲
   by xdanger 6mo ago

   Almost all my client projects are using Postgraphile. What an awesome project and the best maintainer (benjie) ever!
2. 2.▲
   by xdanger 9mo ago

   I've found Backlog.md quite nice https://github.com/MrLesk/Backlog.md has a nice tui/webui for me, and mcp for the agent.
3. 3.▲
   by xdanger 1y ago

   Oh no, I have to go and setup my family's emails again. We have a domain and I used to forward to some gmail accounts (few don't want to use multiple email programs/accounts), but so much mail got lost (not even in spam folde
4. 4.▲
   by xdanger 1y ago

   Mess ups are not framework dependant.
5. 5.▲
   by xdanger 1y ago

   You should really try Nuxt (a vue framework, like Next.js but better).
6. 6.▲
   by xdanger 2y ago

   mach is the kernel he mentioned from 1985. NextSTEP userland was BSD4.something, and macos modernized somebits to freebsd userland.
7. 7.▲
   by xdanger 3y ago

   When I was a teenager I had a bbs running on my computer. When I wanted to play, I just opened the line with a phone so it would be busy if someone wanted to call. Oh the memories.
8. 8.▲
   by xdanger 3y ago

   I do enjoy using https://github.com/graphile/worker for my postgresql queuing needs. Very scalable, the next release 0.14 even more so, and easy to use.
9. 9.▲
   by xdanger 3y ago

   It's PostgreSQL protocol compatible, it's not PostgreSQL compatible. There are many differences. For more compatibility, check out YugabyteDB.
10. 10.▲
    by xdanger 4y ago

    Just to let people know how to get the latency down with uxplay: Upgrade the debian to bookworm (uxplay is in the repos for that one) apt install uxplay in in /boot/config.txt change doverlay to: dtoverl
11. 11.▲
    by xdanger 4y ago

    I did something similar for my macbook with uxplay: https://github.com/FDH2/UxPlay I ran it in console directly rendering to framebuffer and it has hardware-accelerated video decoding. On Raspberry pi 3, hooked to lan
12. 12.▲
    by xdanger 4y ago

    It's just an extension. You can build the Apache 2.0 part of the extension and ignore the Timescale License parts. Those parts are mainly about multinode, compression and continuous aggregates. TSL is mainly about not competing with th
13. 13.▲
    by xdanger 4y ago

    I've been enjoying developing on top of PostGraphile. https://www.graphile.org/ Good starter: https://github.com/graphile/starter I can add a column the the db, and my frontend gets that autimagic
14. 14.▲
    by xdanger 4y ago

    I learned so much about postgresql and RLS from postgraphile starter project: https://github.com/graphile/starter/blob/main/%40app/db/migr... also the project is worth checking out ;)
15. 15.▲
    by xdanger 5y ago

    Already someone cheating? On reply, they write the same four words (reply, might, found, backs), then there is a pause (while inputing the results on a solver?) and then the right answer. Why bother?
16. 16.▲
    by xdanger 5y ago

    Someone called it: "hasura for adults” It's highly customisable, works directly with postgresql row levels security and the performance is quite good. It has a custom GraphiQL gui to work on queries/mutations. To really see h
17. 17.▲
    by xdanger 5y ago

    Checkout postgraphile at https://www.graphile.org/ , they have a whole ecosystem build around postgresql, typescript, graphql.
18. 18.▲
    by xdanger 5y ago

    I just love vue3 with vite ecosystem. For example: https://github.com/antfu/vitesse/ is a good template to start "modern" webdev. DX is very good. you can integrate it to a server with ssr: https:/
19. 19.▲
    by xdanger 5y ago

    Also Microsoft owns Citus, which is scalable sharding for postgresql.
20. 20.▲
    by xdanger 5y ago

    And Microsoft owns Citus and Github.
21. 21.▲
    by xdanger 5y ago

    (although it can still be modified just like regular row data) But it can't be updated or deleted, so what do you mean by this?
22. 22.▲
    by xdanger 5y ago

    A great job queue for PostgreSQL running on Node.js https://github.com/graphile/worker I've been very happy with it.
23. 23.▲
    by xdanger 6y ago

    Biggest difference I think is that Hasura doesn't use RLS for security. It has it's own privileges/roles implementation. Postgraphile kinda works in postgresql, hasura works with postgresql.
24. 24.▲
    by xdanger 6y ago

    I've been following YugabyteDB ( https://www.yugabyte.com/ ) with interest for similar reasons. It's build on postgresql so it supports more features than CockroachDB. They just forked PG on top of their clustered
25. 25.▲
    by xdanger 7y ago

    I'm not really sure how can you say that the React code is simpler or cleaner? Where do props come from? Where's the span for x? <li>'s are generated by magic? I just don't like mixing html and js like that, maybe
26. 26.▲
    by xdanger 8y ago

    Actually you can use PostgreSQL in those with timescaledb plugin. ;)
27. 27.▲
    by xdanger 8y ago

    I quickly redid the benchmarks: https://gist.github.com/xvaara/df0b802b86d2aa4f30b88a3fd6b69...
28. 28.▲
    by xdanger 8y ago

    If you want a modern version of this, you should checkout https://github.com/RhodiumToad/pllua-ng A friend of mine benchmarked different pl languages and https://github.com/eugwne/pllj was basical
29. 29.▲
    by xdanger 8y ago

    I did something similiar, but directly from postgresql triggers: https://github.com/pramsey/pgsql-http You just have to be careful with failing queries and set timeout to low.
30. 30.▲
    by xdanger 8y ago

    how about: UPDATE place SET rating = new.rating from (values (1,25),(2,94),(3,16)) new(id,rating) where place.id = new.id;