xdanger

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.

Comment · 3 years ago

It's PostgreSQL protocol compatible, it's not PostgreSQL compatible. There are many differences. For more compatibility, check out YugabyteDB.

Comment · 3 years 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:
    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.

Comment · 3 years 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 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.

Comment · 4 years 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 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...

Comment · 4 years 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 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.

Comment · 4 years 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 ;)

Comment · 4 years 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?