Greg Sexton comments

Results 85 comments of


                                            Greg Sexton

[stdlib] Make use of question mark operator in IO.

+1. I love it.

Cannot insert expressions

For sure. Just pointing out that users can work around the limitation.

"Access key" or "user ID"?

Yeah we should converge. I avoided 'user' in the auth because you don't choose your id, it's generated. This is a common pattern with web services and they usually call...

Referencing the current SKDB userID.

``` skdb.exec( `INSERT INTO foo (x, skdb_access, skdb_author) VALUES (@dbName, @whoami, @whoami);`, { dbName, whoami: skdb.currentUser ?? null }, ); ```

Referencing the current SKDB userID.

I think this can be done quite easily and I'm not against it. Can't hurt to make this situation convenient. But I'm less sold on the value prop. And I...

Evaluating a select where in (select...) query does not seem to work

I'm expecting the relevant row to be returned but I get an empty result set.

Evaluating a select where in (select...) query does not seem to work

Simplifying as much as I can `select * from task_events where eid in (SELECT max(eid) FROM task_events);` doesn't return any results either.

Evaluating a select where in (select...) query does not seem to work

Ah! But `select * from task_events where eid in (SELECT eid FROM task_events);` does. So must be the function?

Creating an SKDB instance as a worker causes JS to hang

This is a low hanging one if someone fancies a quick win.

Server using most recently created user?

Pass —user to control who you’re logged in as. In dev mode credentials are fetched from the server itself. If you don’t specify a user, it uses the first in...