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

https://sqlnet.cc

60•colinbartlett•1mo ago

Comments

_boffin_•1mo ago

Beautiful. Love the weirdness of it.

lenvl•1mo ago

Thanks!

somat•1mo 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.

cbdevidal•1mo ago

Broken link

somat•1mo 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______________•1mo ago

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

arjie•1mo 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•1mo 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

insomniacity•1mo ago

ERROR: timeout exceeded

lenvl•1mo ago

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

lenvl•1mo ago

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

victorbjorklund•1mo ago

This is so funny! Love it.

pseudocomposer•1mo ago

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

wolttam•1mo 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•1mo ago

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

lenvl•1mo ago

Back online. Proudly hosted on Raspberry PI, lol

datancoffee•1mo 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•1mo ago

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