SQLNet A social network that looks like Twitter but you write SQL to do anything
11–20 of 20 posts
Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#12Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#13Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#14Here 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
Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#15 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 questionsRe: SQLNet A social network that looks like Twitter but you write SQL to do anything
#16I 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
#17Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#18Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#19Name 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?
Re: SQLNet A social network that looks like Twitter but you write SQL to do anything
#20Beautiful. Love the weirdness of it.