News for hackers. Stuff that matters.

xdanger

Re:Postgraphile v5 Released on Tuesday March 24, 2026 @04:00PM (#47508235)
Almost all my client projects are using Postgraphile. What an awesome project and the best maintainer (benjie) ever!
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.

Re:No more "check mail from other accounts" in Gmail web on Thursday October 02, 2025 @04:26AM (#45447396)
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 folder) that I just had to switch everyone to pop3 fetch to gmail.com. Now at least email get's there, even if it's 30-60mins late (really annoying for logins/verifications/etc.).

Maybe it's time to switch everyone out of gmail and make gmail forward the email to out hosted accounts.

Re:Next.js Is Infuriating on Thursday September 04, 2025 @10:49AM (#45127930)
Mess ups are not framework dependant.
Re:Next.js Is Infuriating on Tuesday September 02, 2025 @06:26AM (#45101160)
You should really try Nuxt (a vue framework, like Next.js but better).
mach is the kernel he mentioned from 1985. NextSTEP userland was BSD4.something, and macos modernized somebits to freebsd userland.
Re:Most 16-year-olds don't have servers in their rooms on Saturday December 23, 2023 @05:00AM (#38743002)
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.
Re:Choose Postgres Queue Technology on Sunday September 24, 2023 @05:16PM (#37637277)
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.
It's PostgreSQL protocol compatible, it's not PostgreSQL compatible. There are many differences. For more compatibility, check out YugabyteDB.
Re:Using a Raspberry Pi to add a second HDMI port to a laptop on Wednesday March 15, 2023 @12:43PM (#35171009)
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:
    dtoverlay=vc4-kms-v3d
    force hdmi: (i had some problems with kms)
    hdmi_force_hotplug=1
    add gpu mem:
    gpu_mem=256

    then run: (-a disables audio)
    uxplay -vs kmssink -a
and now you have and airplay monitor that can mirror or extend your desktop.
Re:Using a Raspberry Pi to add a second HDMI port to a laptop on Wednesday March 15, 2023 @12:05PM (#35170442)
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 and my macbook on wifi the lag is ok. It's about the same as ssh over slow cellular. I mainly run my terminals watching the logs/builds etc. on that display.

Re:Partitioning in Postgres, 2022 Edition on Wednesday October 05, 2022 @06:41PM (#33102140)
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 their cloud offerings. So you can't run a database-as-a-service for time series data with it.

More about the license: https://www.timescale.com/blog/building-open-source-business...

Comparison about the open source and community editions: https://docs.timescale.com/timescaledb/latest/timescaledb-ed...

Re:Ask HN: Solo Dev Stack of 2022? on Saturday October 01, 2022 @11:19AM (#33047231)
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 autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.

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 ;)

Re:Squabble.me – Multiplayer Wordle Royale on Thursday February 03, 2022 @08:18AM (#30192011)
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?
Re:PostgREST 9.0 on Tuesday November 30, 2021 @07:46AM (#29391524)
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 how it all works together checkout the starter project: https://github.com/graphile/starter it has migrations, job queue, graphql-codegen etc.

Benjie (https://github.com/benjie) is one of the greatest maintainers I've ever seen!

Re:PostgREST 9.0 on Tuesday November 30, 2021 @05:27AM (#29390718)
Checkout postgraphile at https://www.graphile.org/ , they have a whole ecosystem build around postgresql, typescript, graphql.
Re:Angular 13 on Thursday November 04, 2021 @07:58AM (#29105996)
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://github.com/frandiox/vite-ssr

Re:Partitioning GitHub’s relational databases to handle scale on Tuesday September 28, 2021 @09:39AM (#28682641)
Also Microsoft owns Citus, which is scalable sharding for postgresql.
Re:Partitioning GitHub’s relational databases to handle scale on Tuesday September 28, 2021 @09:38AM (#28682630)
And Microsoft owns Citus and Github.
Re:ClickHouse, Inc. on Monday September 20, 2021 @06:31PM (#28599891)
(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?

A great job queue for PostgreSQL running on Node.js https://github.com/graphile/worker

I've been very happy with it.

Re:PostgREST: REST API for any Postgres database on Sunday November 22, 2020 @12:44PM (#25179323)
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.
Re:PostgreSQL is the worlds’ best database on Friday April 03, 2020 @03:58AM (#22767120)
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 document store. And the newest version (2.1) is production ready (their words).

Just haven't had the reason to dive in yet, but seems good. Their PR department just isn't as good as CockroachDBs one.

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 that's why it also seems messy to me.

The vue example also isn't the greatest, some cruft could be removed using default slot and shorter syntax.

Re:Postgres 11 – A First Look on Sunday September 23, 2018 @01:04PM (#18051981)
Actually you can use PostgreSQL in those with timescaledb plugin. ;)
Re:PL/Lua: Lua as a loadable procedural language for Postgres on Wednesday September 19, 2018 @10:23AM (#18024359)
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 basically the fastest, but it's not so actively maintained. pllua-ng with luajit 2.1 was also faster than plv8. But that was about two years ago, your milage may vary.

"Lua is faster - PL/V8 is lightly faster than Python, but Lua is about 30% faster than PL/V8" - Pavel Stěhule and that was without luajit, but 4 years ago.

Maybe someone should build a benchmark :D

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.

Re:My Favorite PostgreSQL Queries and Why They Matter on Tuesday April 17, 2018 @03:56AM (#16856389)
how about:

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

Older »