Analog Hacker News

somat a day ago

Here is my take on the subject, in my case I was more curious what a shared public postgres server would feel like.

https://www.public.outband.net

It's a bit rough and lives on an old router in my closet so be gentle.

arjie a day ago

This is fun. I thought at first it was my TERMINFO (xcolor-ghostty) but it's actually that it just takes a short while to load in the SSH public key before you can login.

Sadly I can't see anyone else's databases. I thought that's where the fun would be! Maybe I'm doing something wrong. Anyway, look in prespecialize.public.messages for a message!

I tried putting something at https://www.public.outband.net/home/prespecialize/index.html but I must have the permissions wrong, alas! Anyway, fun project :)

I thought it was clever you used IPv6. Places a tiny little barrier to entry.

[-]

somat a day ago

Every person gets their own postgres schema, sort of a namespace, other peoples tables will be under name.table but they have to grant access. something like "grant usage on schema myname to public_user; grant select on best_books to public_user;" or use row level security to grant controlled updates. create policy book_mod on best_books using (uid = current_user); grant insert(book, review) on best_books to public_user; grant update(book, review) on best_books to public_user;

an example is foregoer.collab_data

It looks like I left a bad public_html link in new accounts home directory the path is actually /var/www/(user_name)/ a fix could be "rm public_html; ln -s /var/www/${LOGNAME} public_html but I will probably go through and fix them administrativly

cbdevidal a day ago

Broken link

[-]

somat a day ago

Unfortunately the whole thing is ip6 only. A side effect of how I wired everything up. I run the whole thing from my closet over an free he ip6 tunnel.

x______________ 14 hours ago

try https://web.archive.org/web/20250224200029/https://www.publi...

wolttam 11 hours ago

I suggest updating the login form's "query" to:

  SELECT token, user_id FROM users
  WHERE username = '____'
  AND password = HASH('____')
  -- Or maybe: AND password_verify(password, '____')
  LIMIT 1;

I assume you are already hashing passwords, but the current login form's 'UI query' is enough to raise questions

[-]

lenvl 11 hours ago

Sounds good. I'm currently offline, due to migration to a different env. But I'll add this.

datancoffee 4 hours ago

Name sounded familiar. Read the post, loved the weirdness of it. Then, flashback. Oracle sqlnet! The original distributed processing framework of the greybeards and Oak Table knights. Anyone remember Oak Table?

lenvl 17 hours ago

Hey, this is the author of SQLnet. Feel free to ask me anything about this project.

pseudocomposer 14 hours ago

Neat! Missed opportunity to name it “SQLer” (squealer) though.

_boffin_ a day ago

Beautiful. Love the weirdness of it.

victorbjorklund 17 hours ago

This is so funny! Love it.

insomniacity 21 hours ago

ERROR: timeout exceeded

:(

[-]