Live data from Hacker News

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

sqlnet.cc

11–20 of 20 posts

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

#14
post #3

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.

Broken link

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

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

#15
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

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

#16
post #15

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.

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

#19

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
Post reply on HN