[CODE4LIB] Thanks

[Edward Iglesias]

Thanks all of you who took the survey.  It will be up until 5:00 Eastern on
Friday.

https://www.surveymonkey.com/r/38H733R

Edward Iglesias

[CODE4LIB] thanks and poetry

[Joshua Gomez]

I'm sitting at the hotel waiting for my airport shuttle and I'm looking
over the list of great presentations that were given at the conference this
year. Thanks to all the presenters and the hosts. As always, code4lib was a
fun, engaging and inspiring event.

Karen Coyle's nerd poetry was a fun idea from out of left field.  I decided
to give it a try while I wait for the shuttle. I believe her idea was to
write poetry about coding, but I was inspired by the proximity of
Valentine's day to instead write a cheesy love poem in code.

if (roses == 'red' && love == True):
print 'Hello My Darling'
self.append(you)

See you all next year...I hope.

-Josh

Joshua Gomez
Digital Library Programmer Analyst
George Washington University Libraries
2130 H St, NW Washington, DC 20052
(202) 994-8267

[CODE4LIB] Thanks for everything

[Patrick Berry]

I just wanted to, again, say thanks, in no particular order, to


   - The organizers
   - The presenters
   - The volunteers
   - The streamers
   - The people who voted on presentations (even though mine didn't make
   it, next time I'll make sure my entry starts with an 'A' and not a 'W')
   - The people who asked questions
   - The people who offered help
   - The people who kept discussions going
   - The people posted links fast as lightning in the irc channel
   - The people that help run the irc channel
   - The people that brought beer
   - The people that drank beer
   - The people that shared their awesome outlet extenders
   - Everybody I had a meal or drink with
   - Everybody that came down to 1013 Drink-Up Overflow room
   - Everybody that signed the '1013 Drink-Up Overflow Room Field Notes
   Book'
   - Everybody that helped keep 1013 from getting shut down
   - Everybody that grabbed the right lunch box
   - Everybody that configured their Out of Office message to not reply to
   the list
   - Everybody that contributed to the wiki to help coordinate just about
   everything we did
   - Everybody that had their twitter/irc handle on their name tag because
   I'm horrible at remembering names.  Sorry about that.
   - Anybody who is already thinking about how to make Chicago happen


Pat/@pberry

Re: [CODE4LIB] thanks and poetry

[Megan O'Neill]

I am grinning ear to ear at my reference desk monitor right now. Well done!

Thanks for a great conference, everyone, and special thanks to Karen for
the nerd poetry - I hope that will be a gift that keeps on giving! I'm
certainly sharpening up my keyboard...

Megan


On Fri, Feb 15, 2013 at 1:26 PM, Joshua Gomez  wrote:

> I'm sitting at the hotel waiting for my airport shuttle and I'm looking
> over the list of great presentations that were given at the conference this
> year. Thanks to all the presenters and the hosts. As always, code4lib was a
> fun, engaging and inspiring event.
>
> Karen Coyle's nerd poetry was a fun idea from out of left field.  I decided
> to give it a try while I wait for the shuttle. I believe her idea was to
> write poetry about coding, but I was inspired by the proximity of
> Valentine's day to instead write a cheesy love poem in code.
>
> if (roses == 'red' && love == True):
> print 'Hello My Darling'
> self.append(you)
>
> See you all next year...I hope.
>
> -Josh
>
> Joshua Gomez
> Digital Library Programmer Analyst
> George Washington University Libraries
> 2130 H St, NW Washington, DC 20052
> (202) 994-8267
>



-- 
Megan O'Neill Kudzia
Web Services & Emerging Technologies Librarian
Stockwell-Mudd Library
Albion College
602 E. Cass St.
Albion, MI 49224

Re: [CODE4LIB] thanks and poetry

[Karen Coyle]

Yeah, Joshua! That DEFINITELY qualifies as nerd poetry IMO. I hope your 
darling can appreciate it!


kc

On 2/15/13 10:26 AM, Joshua Gomez wrote:

I'm sitting at the hotel waiting for my airport shuttle and I'm looking
over the list of great presentations that were given at the conference this
year. Thanks to all the presenters and the hosts. As always, code4lib was a
fun, engaging and inspiring event.

Karen Coyle's nerd poetry was a fun idea from out of left field.  I decided
to give it a try while I wait for the shuttle. I believe her idea was to
write poetry about coding, but I was inspired by the proximity of
Valentine's day to instead write a cheesy love poem in code.

if (roses == 'red' && love == True):
 print 'Hello My Darling'
 self.append(you)

See you all next year...I hope.

-Josh

Joshua Gomez
Digital Library Programmer Analyst
George Washington University Libraries
2130 H St, NW Washington, DC 20052
(202) 994-8267


--
Karen Coyle
kco...@kcoyle.net http://kcoyle.net
ph: 1-510-540-7596
m: 1-510-435-8234
skype: kcoylenet

Re: [CODE4LIB] thanks and poetry

[Tom Johnson]

relevant: http://everything2.com/title/Ode+To+Lynx

I like Karen's proposal of establishing an oral tradition. But I've also
been thinking about version controlled poetry in github or on a wiki, and
hyperlinked/linked data poetry. For that matter, does IRC poetry count as
oral if the channel is unlogged?

- Tom

On Fri, Feb 15, 2013 at 2:14 PM, Karen Coyle  wrote:

> Yeah, Joshua! That DEFINITELY qualifies as nerd poetry IMO. I hope your
> darling can appreciate it!
>
> kc
>
>
> On 2/15/13 10:26 AM, Joshua Gomez wrote:
>
>> I'm sitting at the hotel waiting for my airport shuttle and I'm looking
>> over the list of great presentations that were given at the conference
>> this
>> year. Thanks to all the presenters and the hosts. As always, code4lib was
>> a
>> fun, engaging and inspiring event.
>>
>> Karen Coyle's nerd poetry was a fun idea from out of left field.  I
>> decided
>> to give it a try while I wait for the shuttle. I believe her idea was to
>> write poetry about coding, but I was inspired by the proximity of
>> Valentine's day to instead write a cheesy love poem in code.
>>
>> if (roses == 'red' && love == True):
>>  print 'Hello My Darling'
>>  self.append(you)
>>
>> See you all next year...I hope.
>>
>> -Josh
>>
>> Joshua Gomez
>> Digital Library Programmer Analyst
>> George Washington University Libraries
>> 2130 H St, NW Washington, DC 20052
>> (202) 994-8267
>>
>
> --
> Karen Coyle
> kco...@kcoyle.net http://kcoyle.net
> ph: 1-510-540-7596
> m: 1-510-435-8234
> skype: kcoylenet
>

Re: [CODE4LIB] thanks and poetry

[Karen Coyle]

Tom, no reason why we can't also have written poetry -- and performances 
for when we are together. Some "slam" poetry as well as much rap is not 
recorded, and therefore has the same passing existence of an unlogged 
IRC channel. I would be fun to have a wiki for more durable poetry 
(github unfortunately would be a barrier to many). Wiki formatting will 
make even that a challenge, so we'll need to instruct folks to use a 
 block (c4l wiki recognizes that, right?).


kc

On 2/15/13 3:12 PM, Tom Johnson wrote:

relevant: http://everything2.com/title/Ode+To+Lynx

I like Karen's proposal of establishing an oral tradition. But I've also
been thinking about version controlled poetry in github or on a wiki, and
hyperlinked/linked data poetry. For that matter, does IRC poetry count as
oral if the channel is unlogged?

- Tom

On Fri, Feb 15, 2013 at 2:14 PM, Karen Coyle  wrote:


Yeah, Joshua! That DEFINITELY qualifies as nerd poetry IMO. I hope your
darling can appreciate it!

kc


On 2/15/13 10:26 AM, Joshua Gomez wrote:


I'm sitting at the hotel waiting for my airport shuttle and I'm looking
over the list of great presentations that were given at the conference
this
year. Thanks to all the presenters and the hosts. As always, code4lib was
a
fun, engaging and inspiring event.

Karen Coyle's nerd poetry was a fun idea from out of left field.  I
decided
to give it a try while I wait for the shuttle. I believe her idea was to
write poetry about coding, but I was inspired by the proximity of
Valentine's day to instead write a cheesy love poem in code.

if (roses == 'red' && love == True):
  print 'Hello My Darling'
  self.append(you)

See you all next year...I hope.

-Josh

Joshua Gomez
Digital Library Programmer Analyst
George Washington University Libraries
2130 H St, NW Washington, DC 20052
(202) 994-8267


--
Karen Coyle
kco...@kcoyle.net http://kcoyle.net
ph: 1-510-540-7596
m: 1-510-435-8234
skype: kcoylenet



--
Karen Coyle
kco...@kcoyle.net http://kcoyle.net
ph: 1-510-540-7596
m: 1-510-435-8234
skype: kcoylenet

Re: [CODE4LIB] thanks and poetry

[Hillel Arnold]

I know some people know about this already, but for the past few years I've 
been using Git to version my songs [1], then publishing them using Github Pages 
[2]. It's actually worked out really well for my limited and specific purposes. 
Pull requests accepted!
Hillel

[1] https://github.com/helrond/songs
[2] http://songs.hillelarnold.com/



> Date: Fri, 15 Feb 2013 15:12:38 -0800
> From: johnson.tom+code4...@gmail.com
> Subject: Re: [CODE4LIB] thanks and poetry
> To: CODE4LIB@LISTSERV.ND.EDU
> 
> relevant: http://everything2.com/title/Ode+To+Lynx
> 
> I like Karen's proposal of establishing an oral tradition. But I've also
> been thinking about version controlled poetry in github or on a wiki, and
> hyperlinked/linked data poetry. For that matter, does IRC poetry count as
> oral if the channel is unlogged?
> 
> - Tom
> 
> On Fri, Feb 15, 2013 at 2:14 PM, Karen Coyle  wrote:
> 
> > Yeah, Joshua! That DEFINITELY qualifies as nerd poetry IMO. I hope your
> > darling can appreciate it!
> >
> > kc
> >
> >
> > On 2/15/13 10:26 AM, Joshua Gomez wrote:
> >
> >> I'm sitting at the hotel waiting for my airport shuttle and I'm looking
> >> over the list of great presentations that were given at the conference
> >> this
> >> year. Thanks to all the presenters and the hosts. As always, code4lib was
> >> a
> >> fun, engaging and inspiring event.
> >>
> >> Karen Coyle's nerd poetry was a fun idea from out of left field.  I
> >> decided
> >> to give it a try while I wait for the shuttle. I believe her idea was to
> >> write poetry about coding, but I was inspired by the proximity of
> >> Valentine's day to instead write a cheesy love poem in code.
> >>
> >> if (roses == 'red' && love == True):
> >>  print 'Hello My Darling'
> >>  self.append(you)
> >>
> >> See you all next year...I hope.
> >>
> >> -Josh
> >>
> >> Joshua Gomez
> >> Digital Library Programmer Analyst
> >> George Washington University Libraries
> >> 2130 H St, NW Washington, DC 20052
> >> (202) 994-8267
> >>
> >
> > --
> > Karen Coyle
> > kco...@kcoyle.net http://kcoyle.net
> > ph: 1-510-540-7596
> > m: 1-510-435-8234
> > skype: kcoylenet
> >
  

Re: [CODE4LIB] thanks and poetry

[Sharp, Chris]

- Original Message -
> From: "Karen Coyle" 
> To: CODE4LIB@LISTSERV.ND.EDU
> Sent: Friday, February 15, 2013 6:38:53 PM
> Subject: Re: [CODE4LIB] thanks and poetry

> (github unfortunately would be a barrier to many)

GitHub fortunately has excellent startup documentation for new users:

https://help.github.com/articles/set-up-git

I recommend GitHub as an entry point to using git (or to "coding" for that 
matter).

Hope that's helpful,

Chris

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csh...@georgialibraries.org
http://pines.georgialibraries.org/

Re: [CODE4LIB] thanks and poetry

[Karen Coyle]

gitHub may have excellent startup documentation, but that startup 
documentation describes git in programming terms mainly using *nx 
commands. If you have never had to use a version control system (e.g. if 
you do not write code, especially in a shared environment), "clone" 
"push" "pull" are very poorly described. The documentation is all in 
terms of *nx commands. Honestly, anything where this is in the 
documentation:


On Windows systems, Git looks for the |.gitconfig| file in the |$HOME| 
directory (|%USERPROFILE%| in Windows’ environment), which is 
|C:\Documents and Settings\$USER| or |C:\Users\$USER| for most people, 
depending on version (|$USER| is |%USERNAME%| in Windows’ environment).


is not going to work for anyone who doesn't work in Windows at the 
command line.


No, git is NOT for non-coders.

kc

On 2/16/13 4:25 AM, Sharp, Chris wrote:

- Original Message -

From: "Karen Coyle" 
To: CODE4LIB@LISTSERV.ND.EDU
Sent: Friday, February 15, 2013 6:38:53 PM
Subject: Re: [CODE4LIB] thanks and poetry
(github unfortunately would be a barrier to many)

GitHub fortunately has excellent startup documentation for new users:

https://help.github.com/articles/set-up-git

I recommend GitHub as an entry point to using git (or to "coding" for that 
matter).

Hope that's helpful,

Chris



--
Karen Coyle
kco...@kcoyle.net http://kcoyle.net
ph: 1-510-540-7596
m: 1-510-435-8234
skype: kcoylenet

Re: [CODE4LIB] thanks and poetry

[Tom Johnson]

I think Karen is right in essence.

There *are* windows GUI clients. I haven't used them, and couldn't speak to
how easy they are to setup, understand, and use.

Something about Git (and GitHub) captures a hacker's spirit of sharing,
cooperation, and even the oft missing openness to criticism. Take your bug
reports and accept pull requests.

My impulse is to want to share this with people who hack in other ways;
through art, craft, culture, or otherwise. I'm not sure if we have the
tools to do that in a way that is accessible, but Karen's right that the
default tools aren't them.

- Tom

On Sat, Feb 16, 2013 at 6:42 AM, Karen Coyle  wrote:

> gitHub may have excellent startup documentation, but that startup
> documentation describes git in programming terms mainly using *nx commands.
> If you have never had to use a version control system (e.g. if you do not
> write code, especially in a shared environment), "clone" "push" "pull" are
> very poorly described. The documentation is all in terms of *nx commands.
> Honestly, anything where this is in the documentation:
>
> On Windows systems, Git looks for the |.gitconfig| file in the |$HOME|
> directory (|%USERPROFILE%| in Windows’ environment), which is |C:\Documents
> and Settings\$USER| or |C:\Users\$USER| for most people, depending on
> version (|$USER| is |%USERNAME%| in Windows’ environment).
>
> is not going to work for anyone who doesn't work in Windows at the command
> line.
>
> No, git is NOT for non-coders.
>
> kc
>
>
> On 2/16/13 4:25 AM, Sharp, Chris wrote:
>
>> - Original Message -----
>>
>>> From: "Karen Coyle" 
>>> To: CODE4LIB@LISTSERV.ND.EDU
>>> Sent: Friday, February 15, 2013 6:38:53 PM
>>> Subject: Re: [CODE4LIB] thanks and poetry
>>> (github unfortunately would be a barrier to many)
>>>
>> GitHub fortunately has excellent startup documentation for new users:
>>
>> https://help.github.com/**articles/set-up-git<https://help.github.com/articles/set-up-git>
>>
>> I recommend GitHub as an entry point to using git (or to "coding" for
>> that matter).
>>
>> Hope that's helpful,
>>
>> Chris
>>
>>
> --
> Karen Coyle
> kco...@kcoyle.net http://kcoyle.net
> ph: 1-510-540-7596
> m: 1-510-435-8234
> skype: kcoylenet
>

Re: [CODE4LIB] thanks and poetry

[Erik Hetzner]

At Sat, 16 Feb 2013 06:42:04 -0800,
Karen Coyle wrote:
> 
> gitHub may have excellent startup documentation, but that startup 
> documentation describes git in programming terms mainly using *nx 
> commands. If you have never had to use a version control system (e.g. if 
> you do not write code, especially in a shared environment), "clone" 
> "push" "pull" are very poorly described. The documentation is all in 
> terms of *nx commands. Honestly, anything where this is in the 
> documentation:
> 
> On Windows systems, Git looks for the |.gitconfig| file in the |$HOME| 
> directory (|%USERPROFILE%| in Windows’ environment), which is 
> |C:\Documents and Settings\$USER| or |C:\Users\$USER| for most people, 
> depending on version (|$USER| is |%USERNAME%| in Windows’ environment).
> 
> is not going to work for anyone who doesn't work in Windows at the 
> command line.
> 
> No, git is NOT for non-coders.

For what it’s worth, this programmer finds git’s interface pretty
terrible. I prefer mercurial (hg), but I don’t know if it’s any better
for people who aren’t familar with a command line.

  http://mercurial.selenic.com/guide/

(As a general rule, for every programmer who prefers tool A, and says
that everybody should use it, there’s a programmer who disparages tool
A, and advocates tool B. So take what we say with a grain of salt!)

(And as a further aside, there’s plenty to dislike about github as
well, from it’s person-centric view of projects (rather than
team-centric) to its unfortunate centralizing of so much free/open
source software on one platform.)

best, Erik
Sent from my free software system .


pgpKhLEacXDgb.pgp
Description: PGP signature

Re: [CODE4LIB] Thanks for everything

[Mark A. Matienzo]

+1. :)


On Fri, Feb 10, 2012 at 9:28 AM, Patrick Berry  wrote:
> I just wanted to, again, say thanks, in no particular order, to
>
>
>   - The organizers
>   - The presenters
>   - The volunteers
>   - The streamers
>   - The people who voted on presentations (even though mine didn't make
>   it, next time I'll make sure my entry starts with an 'A' and not a 'W')
>   - The people who asked questions
>   - The people who offered help
>   - The people who kept discussions going
>   - The people posted links fast as lightning in the irc channel
>   - The people that help run the irc channel
>   - The people that brought beer
>   - The people that drank beer
>   - The people that shared their awesome outlet extenders
>   - Everybody I had a meal or drink with
>   - Everybody that came down to 1013 Drink-Up Overflow room
>   - Everybody that signed the '1013 Drink-Up Overflow Room Field Notes
>   Book'
>   - Everybody that helped keep 1013 from getting shut down
>   - Everybody that grabbed the right lunch box
>   - Everybody that configured their Out of Office message to not reply to
>   the list
>   - Everybody that contributed to the wiki to help coordinate just about
>   everything we did
>   - Everybody that had their twitter/irc handle on their name tag because
>   I'm horrible at remembering names.  Sorry about that.
>   - Anybody who is already thinking about how to make Chicago happen
>
>
> Pat/@pberry

Re: [CODE4LIB] Thanks for everything

[Schwartz, Raymond]

Gee I didn't know it was your room.  Thanks for sharing!

-Original Message-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Patrick 
Berry
Sent: Friday, February 10, 2012 12:29 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: [CODE4LIB] Thanks for everything

I just wanted to, again, say thanks, in no particular order, to


   - The organizers
   - The presenters
   - The volunteers
   - The streamers
   - The people who voted on presentations (even though mine didn't make
   it, next time I'll make sure my entry starts with an 'A' and not a 'W')
   - The people who asked questions
   - The people who offered help
   - The people who kept discussions going
   - The people posted links fast as lightning in the irc channel
   - The people that help run the irc channel
   - The people that brought beer
   - The people that drank beer
   - The people that shared their awesome outlet extenders
   - Everybody I had a meal or drink with
   - Everybody that came down to 1013 Drink-Up Overflow room
   - Everybody that signed the '1013 Drink-Up Overflow Room Field Notes
   Book'
   - Everybody that helped keep 1013 from getting shut down
   - Everybody that grabbed the right lunch box
   - Everybody that configured their Out of Office message to not reply to
   the list
   - Everybody that contributed to the wiki to help coordinate just about
   everything we did
   - Everybody that had their twitter/irc handle on their name tag because
   I'm horrible at remembering names.  Sorry about that.
   - Anybody who is already thinking about how to make Chicago happen


Pat/@pberry

Re: [CODE4LIB] Thanks for everything

[Park,Go-Woon]

Ditto, and thank you, too. :)

-Original Message-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of
Patrick Berry
Sent: Friday, February 10, 2012 11:29 AM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: [CODE4LIB] Thanks for everything

I just wanted to, again, say thanks, in no particular order, to


   - The organizers
   - The presenters
   - The volunteers
   - The streamers
   - The people who voted on presentations (even though mine didn't make
   it, next time I'll make sure my entry starts with an 'A' and not a
'W')
   - The people who asked questions
   - The people who offered help
   - The people who kept discussions going
   - The people posted links fast as lightning in the irc channel
   - The people that help run the irc channel
   - The people that brought beer
   - The people that drank beer
   - The people that shared their awesome outlet extenders
   - Everybody I had a meal or drink with
   - Everybody that came down to 1013 Drink-Up Overflow room
   - Everybody that signed the '1013 Drink-Up Overflow Room Field Notes
   Book'
   - Everybody that helped keep 1013 from getting shut down
   - Everybody that grabbed the right lunch box
   - Everybody that configured their Out of Office message to not reply
to
   the list
   - Everybody that contributed to the wiki to help coordinate just
about
   everything we did
   - Everybody that had their twitter/irc handle on their name tag
because
   I'm horrible at remembering names.  Sorry about that.
   - Anybody who is already thinking about how to make Chicago happen


Pat/@pberry

[CODE4LIB] Thanks and a question

[William Gunn]

Thanks everyone for the days packed with interesting discussions. It was 
a great experience and I've already been talking to some people about 
plans for Chicago awesomeness.


I remember a presentation where someone, perhaps Mike Schultz 
http://code4lib.org/conference/2012/schultz said they switched the Solr 
search default from OR to AND and they saw great improvements in search 
success. Does anyone know who that was and if they have any data they 
can share? I'd really like to get this implemented at Mendeley if I can 
make a case for it.


Also, this is the last call for those who want to either give me 
presentation feedback or get a free trial of some not-yet-publicly 
released features: http://mnd.ly/C4L2012WG


Thanks again to the wonderful hosts. Seattle is a lovely town and it was 
great to share it with you.


Best,
--
William Gunn

Re: [CODE4LIB] Thanks and a question

[Schneider, Wayne]

I think it was Tom Burton-West's talk on the first day (just getting my
notes in order, too):

http://code4lib.org/conference/2012/burton-west

His slides are linked there (thanks, Tom!).

wayne

-Original Message-
From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of
William Gunn
Sent: Friday, February 10, 2012 4:43 PM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: [CODE4LIB] Thanks and a question

Thanks everyone for the days packed with interesting discussions. It was
a great experience and I've already been talking to some people about
plans for Chicago awesomeness.

I remember a presentation where someone, perhaps Mike Schultz
http://code4lib.org/conference/2012/schultz said they switched the Solr
search default from OR to AND and they saw great improvements in search
success. Does anyone know who that was and if they have any data they
can share? I'd really like to get this implemented at Mendeley if I can
make a case for it.

Also, this is the last call for those who want to either give me
presentation feedback or get a free trial of some not-yet-publicly
released features: http://mnd.ly/C4L2012WG

Thanks again to the wonderful hosts. Seattle is a lovely town and it was
great to share it with you.

Best,
--
William Gunn

[CODE4LIB] Thanks! Re: [CODE4LIB] SQL query

[Ken Irwin]

Hi all,

Thanks for these myriad responses! I've gotten at least three distinct
approaches to try. I knew there had to be a better way.

your sql-fu is appreciated!

joys
Ken

[CODE4LIB] Thanks for taking the survey

[Edward Iglesias]

Thanks to all 204 of you who took my Systems Librarian Survey.  Results are at

http://library.ccsu.edu/staffblog/?p=147

The full results and analysis will be part of an upcoming book from
Chandos publishing tentatively called "Systemic Shifts: The Changing
Role of the Systems Librarian".

Edward Iglesias
Systems Librarian
Central Connecticut State University

Re: [CODE4LIB] Thanks! Re: [CODE4LIB] SQL query

[Jeffrey Barnett]

You have gotten a lot of suggestions, but here is one more.

select * from lib_books where good_thing = 'TRUE'
MINUS
select * from lib_books where bad_thing = 'TRUE'

I think MINUS is faster than JOIN.

Other SET OPERATIONS include UNION and INTERSECT.

Set operations require that the underlying result sets be "compatible":
Same number of columns.
Corresponding columns have matching datatypes.


Ken Irwin wrote:

Hi all,

Thanks for these myriad responses! I've gotten at least three distinct
approaches to try. I knew there had to be a better way.

your sql-fu is appreciated!

joys
Ken
begin:vcard
fn:Jeffrey Barnett
n:Barnett;Jeffrey
org:Yale University Library;Integrated Library Technical Services
adr;dom:;;;New Haven;CT;06520-8240
email;internet:[EMAIL PROTECTED]
title:Sr. Research Analyst
tel;work:(203) 432-1752
x-mozilla-html:FALSE
version:2.1
end:vcard

Re: [CODE4LIB] Thanks! Re: [CODE4LIB] SQL query

[Jonathan Gorman]

Last I checked MySQL doesn't support MINUS, but it's been a few years
since I used it.  I vaguly remember talk about the developers planning on
adding it.  I took a quick glance at the docs, but I can't seem to find
anything one way or another.  Is it in one of the later versions of MySQL?


On Fri, 26 Jan 2007, Jeffrey Barnett wrote:


You have gotten a lot of suggestions, but here is one more.

select * from lib_books where good_thing = 'TRUE'
MINUS
select * from lib_books where bad_thing = 'TRUE'

I think MINUS is faster than JOIN.

Other SET OPERATIONS include UNION and INTERSECT.

Set operations require that the underlying result sets be "compatible":
Same number of columns.
Corresponding columns have matching datatypes.


Ken Irwin wrote:

Hi all,

Thanks for these myriad responses! I've gotten at least three distinct
approaches to try. I knew there had to be a better way.

your sql-fu is appreciated!

joys
Ken

[CODE4LIB] Thanks for the help and support from libraries

[Charles Antoine Julien, Mr]

I had recently posted a "HELP!!!" request concerning the difficulty I'm
having getting raw data from a library collection and its associated
subject authority files.

I was touched by haw many of you answered me with offers of data or
locations where I could get some.  I had been adamantly warmed by
faculty not to expect support from our local libraries.  Turns out
library managements I've contacted have given me positive responses...I
have no data yet but it seems wheels are turning.  I feel humbled by the
experience and am reminded how local politics can easily cloud one's
(i.e., my) judgment.

Some felt it necessary to warn me I might be stepping into a world of
pain by trying to build an interactive visual LCSH structure.  I've read
and appreciated the warnings/related articles (McGrath in Code4Lib,
inkdroid pointing to two Dykstra articles in 1988 Lib Journals, any
others?).  Research often means tinkering, there seems to be much
opportunity for that with LCSH.  I'm naively looking forward to
developing "something" which dramatically increases the
visibility/usability of subject browsing and I'll be sure to share it
with this community if and when I do.

Thanks again for your patience,

Charles-Antoine Julien
Ph.D Candidate
School of Information Studies
McGill University