SQLNet A social network that looks like Twitter but you write SQL to do anything

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 · 2 months 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 · 2 months 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 · 2 months ago

Broken link

somat · 2 months 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______________ · 2 months ago

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

lenvl · 2 months ago

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

wolttam · 2 months 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

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

datancoffee · 2 months 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?

Lol, I didn't know about Oracle sqlnet at that moment

_boffin_ · 2 months ago

Beautiful. Love the weirdness of it.

Thanks!

pseudocomposer · 2 months ago

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

victorbjorklund · 2 months ago

This is so funny! Love it.

insomniacity · 2 months ago

ERROR: timeout exceeded

Sorry, I was asleep. Just realized I got a ton of users overnight. Looking into :)