dzamo_norton

So many data analysts that each time a new analytical database engine comes out it needs to support SQL or something like it to get any mindshare.

https://www.johndcook.com/blog/2019/04/27/rare-and-strange-i...

https://github.com/jobisoft/TbSync/issues/158

What would it do differently?

  with recursive todo_list_sorted as (
  	select
  		*
  	from
  		todo_list tl1 where prev_id is null
  	union all
  	select
  		tl1.*	
  	from
  		todo_list tl1
  	join
  		todo_list_sorted tl2 on tl1.prev_id = tl2.id
  )
  select * from todo_list_sorted

  with recursive todo_list_sorted as (
  	select
  		*
  	from
  		todo_list tl1 where prev_id is null
  	union all
  	select
  		tl1.*	
  	from
  		todo_list tl1
  	join
  		todo_list_sorted tl2 on tl1.prev_id = tl2.id
  )
  select * from todo_list_sorted

  id | text               | prev | next
   1 | "profit"           | 2    | NULL
   2 | "???"              | 3    | 1
   3 | "steal underpants" | NULL | 2

This is off topic but very briefly: implement SPF and DKIM and get a number of Gmail users (I'm not sure what this number is, but it is order of magnitude 10) to mark your emails as "Not Spam". Eventually Gmail will come to accept emails from your self-hosted server.

For a little while I was basically convinced of deliberate obstruction - no sane person would use the arguments employed by the recruiter. But, on reading through from the top once more, the recruiter was actually initially helpful and I have settled on "incompetence, not malice". Almost settled, at least.

Then again "If someone cannot explain something in plain English, then we should question whether they really do themselves understand what they profess." - Richard Feynmann