| 00:38.28 | *** join/#utah josephscott (~josephsco@2601:602:9b00:1c15:1d7f:55bf:dc96:fcfa) |
| 01:52.48 | cSmith | youtah: Gary didn't end up coming, it was just us and Michael. Had a lot of fun though, had a lot of great conversations. I've been emailing Gary and we're gonna get into the club shack here in logan and hack on CAT control for this rig |
| 01:53.02 | cSmith | they're both very cool guys |
| 01:53.49 | cSmith | and yeah michael wants me to help with the satellite bit as well |
| 01:54.07 | cSmith | I pointed him towards http://satnogs.org which I think I showed you too |
| 02:56.13 | *** join/#utah emcnabb (~emcnabb@hs-nc-1fff767f54-29977-1.tingfiber.com) |
| 04:06.55 | *** join/#utah tiwula (~lane@174-23-5-207.slkc.qwest.net) |
| 13:57.06 | *** join/#utah resplin (~richard@68.69.160.206) |
| 14:43.44 | *** join/#utah tiwula (~lane@70.89.246.241-Busname-UT.hfc.comcastbusiness.net) |
| 15:27.41 | *** join/#utah SunSparc (~jonathan@45.56.57.85) |
| 15:49.37 | *** join/#utah josephscott (~josephsco@2601:602:9b00:1c15:1d7f:55bf:dc96:fcfa) |
| 15:53.05 | SunSparc | Today I learned about 'w'. |
| 15:53.07 | SunSparc | https://rachelbythebay.com/w/2018/03/26/w/ |
| 16:15.00 | frostyfrog | w is fun, and so is who |
| 16:15.45 | frostyfrog | lol, so many tmux windows xD 2018-03-27 10:15 (tmux(3558).%92) |
| 16:18.12 | frostyfrog | SunSparc: If you're interested about learning more commands: https://kmandla.wordpress.com/software/ and https://inconsolation.wordpress.com/index/ |
| 16:21.53 | beelzebob | thanks for the tip, rachel's blog looks very interesting |
| 16:40.21 | frostyfrog | https://inconsolation.wordpress.com/2014/06/23/w-plus-a-little-rant/ |
| 16:49.45 | romanovic | I hate this https://www.bloomberg.com/news/articles/2018-03-27/oracle-wins-revival-of-billion-dollar-case-against-google |
| 17:10.44 | RyanE | oracle says it's entitled to $8.8 billion in damages... Android has generated $42 million in revenue from advertising. |
| 17:10.54 | RyanE | seems just a *bit* high... |
| 17:11.56 | RyanE | It's also $1.4 billion more than Oracle spent on the whole of Sun 8 months earlier... again, seems a bit high. |
| 17:16.49 | SunSparc | frostyfrog: lol, that rant on w :) |
| 17:17.08 | frostyfrog | :) |
| 17:17.53 | SunSparc | ~karma Oracle |
| 17:17.53 | infobot | oracle has karma of -1 |
| 17:17.59 | SunSparc | ~Oracle-- |
| 17:18.04 | SunSparc | ~lart Oracle |
| 17:18.04 | infobot | beats Oracle into protomatter with the andromeda galaxy |
| 17:19.22 | youtah | Question for ya guys |
| 17:19.27 | youtah | any SQL gurus? |
| 17:19.48 | youtah | I want to do a: |
| 17:20.07 | SunSparc | Super Qool Llamas |
| 17:20.14 | SunSparc | ~sql |
| 17:20.14 | infobot | i guess sql is handy for some things, but I think it might be overkill for PIM data. |
| 17:20.22 | youtah | SELECT * FROM tablnamehere WHERE id, column1, column2, columnn.... LIKE %phrase%'; |
| 17:20.36 | youtah | but rather than spelling out that I want it to search across all of the columns |
| 17:21.09 | youtah | is there something equivalent to SELECT * FROM * LIKE '%phrase%' |
| 17:21.12 | youtah | ? |
| 17:21.31 | youtah | where it searches across all of the columns and not just the specified ones? |
| 17:21.39 | romanovic | youtah: which sql dialect? |
| 17:21.46 | youtah | postgres |
| 17:22.56 | BigBen212 | if you want to put the work in, you could build yourself an index of all your varchars and which tables/columns contain them :) |
| 17:23.19 | youtah | BigBen212, that seems to be the 'cleanest' approach I've found so far |
| 17:23.26 | BigBen212 | but other than that, maybe a union of the selects and put it into a view |
| 17:23.30 | youtah | THey give an example of that here: https://www.sqlservercentral.com/Forums/Topic750935-338-1.aspx |
| 17:24.12 | *** join/#utah aeryndunham (~aeryndunh@170.250.131.39) |
| 17:24.14 | BigBen212 | but in any case, you'd have to write the unions first at least once to put them in the view. |
| 17:24.56 | romanovic | sql server can do something like that with CONTAINS() https://technet.microsoft.com/en-us/library/ms142488(v=sql.105).aspx |
| 17:25.12 | romanovic | but I can't find whether postgres has the same |
| 17:25.48 | youtah | Hmmmm |
| 17:25.52 | BigBen212 | hmmm, I guess postgres can do that if you put the individual columns into an array and then use the array functions to search for what's in there |
| 17:27.17 | BigBen212 | but for performance, union might be the better choice |
| 17:27.22 | youtah | AH HA |
| 17:27.29 | youtah | I think I found a good solution |
| 17:27.41 | youtah | WHERE first_name || ' ' || last_name |
| 17:27.54 | youtah | "The peculiar pipes above â otherwise recognizable as a boolean OR â are the operators for string concatenation in Postgres. In effect, we are comparing a concatenated first_name, a space, and last_name against some string (i.e., jane doe)." |
| 17:28.20 | youtah | I might be getting ahead of myself, let me keep reading on.... |
| 17:28.25 | BigBen212 | oh, concatenate all the strings ... |
| 17:28.38 | youtah | yes |
| 17:28.46 | BigBen212 | you'd not use any of your indexes if you do that though |
| 17:28.56 | youtah | uhg |
| 17:28.57 | youtah | crap |
| 17:29.02 | BigBen212 | unless you have a function-based index on that concatenation, I guess. |
| 17:29.17 | SunSparc | If you are looking for a job, SpaceX has quite a few openings: http://www.spacex.com/careers/list |
| 17:29.55 | youtah | BigBen212, https://commandercoriander.net/blog/2015/02/16/selecting-matches-across-multiple-columns-in-postgres/ |
| 17:31.21 | BigBen212 | how many columns are you thinking ? |
| 17:31.27 | youtah | 12 |
| 17:32.02 | youtah | maybe I'll just quit trying to be clever and lazy and write out a large sql query |
| 17:32.48 | BigBen212 | I think my preference here would be a union, even if it's of 12 selects |
| 17:33.00 | BigBen212 | and put that into a view |
| 17:33.07 | youtah | yeah |
| 17:33.13 | youtah | and then just call the view |
| 17:33.16 | BigBen212 | because if you ever decide you need a 13th column, it's easier to change the view to add one more union |
| 17:33.16 | youtah | I like you're thinking |
| 17:33.18 | SunSparc | youtah: maybe write a script to run multiple queries for you. |
| 17:33.32 | youtah | if only like... you could script this on a computer |
| 17:33.35 | frostyfrog | programatically grab all the column names, then generate the SQL statement? |
| 17:33.58 | BigBen212 | with the union (and indexed columns), performance isn't going to be hit as I imagine concatenating individual columns into a single string would |
| 17:34.13 | youtah | I am going to create a view |
| 17:34.21 | youtah | I think that is the appropriate answer here |
| 17:34.28 | youtah | and the easiest to change down the road |
| 17:34.32 | frostyfrog | Technically, you can script it on a computer. You just happen to be doing it on the live server computer. /smart alec |
| 17:34.41 | BigBen212 | and the easiest cross-platform |
| 17:35.05 | BigBen212 | if you ever take your postgres code and put it somewhere else |
| 17:35.38 | BigBen212 | haven't seen ilike before, is that only in Postgres? |
| 17:36.52 | BigBen212 | (I think it is) |
| 17:57.06 | *** join/#utah braxtron (~princessf@216.160.248.178) |
| 22:01.37 | *** join/#utah EM16 (~EM16@2601:681:5380:2335:892d:e183:d4b7:c5b2) |
| 22:44.25 | SunSparc | ~karma brave |
| 22:44.25 | infobot | brave has karma of 19 |
| 22:44.31 | SunSparc | ~brave++ |
| 22:57.05 | romanovic | ~Oracle-- |
| 23:10.54 | SunSparc | ~Oracle-- |