Re: [CODE4LIB] C4L2012 Hackfest
Is there a way that these can be piggybacked or combined? Recently learned Git commands would be reinforced by actually using them during a hacking session. I think it would be awesome for the Hackfest to include learning sessions such as Gitfest and R-fest. Would it be a good idea to have part of the morning for learning sessions, say from 9-11, then move onto some hacks? If we can get a room from 9-5 we'd have enough time, I think. Would anyone volunteer to do a learning session on open ILS and Drupal at the Hackfest? Jason
[CODE4LIB] C4L2012 Hackfest
Anyone interested in having a hackfest on the pre-conference day? Something like last year's CURATEcamp or the Access hackfests? There's a proposal on the wiki: http://wiki.code4lib.org/index.php/2012_preconference_proposals And a link to topics from there. Hopefully a coffee house will sponsor the event. .. Jason
Re: [CODE4LIB] mysql subquery response time
I want to select all the institutions that *only* have dates after July 1 How about: select distinct institution from renewals where snap_date = '2011-07-01'; in Oracle: where snap_date = to_date(20110701, 'MMDD'); (remove the = to not include 2011-07-01) Hopefully I understood your challenge… Cheers, Jason On 11-09-28 9:41 AM, Ken Irwin kir...@wittenberg.edumailto:kir...@wittenberg.edu wrote: Hi all, I've not done much with MySQL subqueries, and I'm trying right now with what I find to be surprising results. I wonder if someone can help me understand. I have a pile of data that with columns for institution and date. Institution gets repeated a lot, with many different dates. I want to select all the institutions that *only* have dates after July 1 and don't appear in the table before that. My solution was to do a first query for all the institutions that DO have dates before July 1 SELECT distinct institution FROM `renewals` WHERE snap_date '2011-07-01' And then to do a SELECT query on all the institutions: SELECT distinct institution from renewals And then try to do a NOT IN subquery subtracting the smaller query from the larger one: SELECT distinct institution from renewals WHERE institution not in (SELECT distinct institution FROM `renewals` WHERE snap_date '2011-07-01') ...only it doesn't seem to work. Or rather, the query has been running for several minutes and never comes back with an answer. Each of these two queries takes just a few milliseconds to run on its own. Can someone tell me (a) am I just formatting the query wrong, (b) do subqueries like this just take forever, and/or (c) is there a better way to do this? (I don't really understand about JOIN queries, but from what I can tell they are only for mixing the results of two different tables so I think they might not apply here.) Any advice would be most welcome. Thanks Ken
Re: [CODE4LIB] Looking for products/price ranges for a database of performers
Drupal Jason On 11-09-06 4:20 PM, Heather Rayl 23e...@gmail.commailto:23e...@gmail.com wrote: ** apologies for cross-posting ** Hi there, We have a database of performers that we use in our libraries. Currently, the data is stored on one person's computer in a file maker pro db that only this one person has access to (Hooray for legacy systems!). In order for the rest of the staff to have access to the performer listings, this one person runs yearly reports and they are posted on the staff intranet in a rather unwieldy series of pdf documents for staff to browse. For a sense of scale, we have over 80 libraries, about probably around 300-400 staff people accessing these documents, and there are probably around 400 or so performers in the database. Clearly, we need a new system of managing these performers!! What we would like is something like a Yelp-like system for the performer database (online obviously), where performers have the ability to go in and update their contact information, the kinds of programs they offer, their program descriptions, the price of their programs etc. Staff would have the ability to search the database in a myriad of ways, mark favorite ones, and submit an evaluation of the performer (that the performer cannot see). The evals could be anything from This person was great and I would use them again in a heartbeat to Don't book this person. They were late. gave me a hassle about the invoice and smelled like cheap wine. Ideally, the moderators of the database would also have the ability to make some of the comments public to the performers for their own use in advertising, etc. but this is not a requirement. So here's what we're grappling with: 1. We can purchase a product that would give us the framework to do this. I realize that something like a wiki would let us do some of these things, but really we are rather freaky about our content control, and a wiki is just too free-wheeling! 2. We can hire a developer/programmer to design a custom solution for us. So my questions for the list are: 1. do you know of any products that do what we want? 2. if we were to hire someone, how much is a reasonable fee - we have some money in our budget, but we don't really know what a real person would charge for this, and if the money in our budget would cover it. And I don't want to go through writing an RFP for it if in the end we won't be able to afford it anyway. Usually we develop most stuff in house, but this is outside the scope of our expertise. Many, many thanks for your thoughts! ~heather rayl Internet Services Coordinator County of L.A. Public Library
Re: [CODE4LIB] Advice on a class
Until the Singularity happens, anyway. I'd think there will always be lots of enterprise Java jobs around. The Singularity will be written in Java. Jason On 11-07-27 7:32 PM, Bill Janssen jans...@parc.commailto:jans...@parc.com wrote: If I'm hiring a programmer, I want them to know C and Python. C because all the low-level stuff is written in that, Python because it's simply the most useful all-around programming language at the moment, and if you don't know it, well, how devoted are you really to your craft? Various flavors of C are acceptable: Objective-C is OK with me, and C++ is a plus -- it's an order of magnitude more difficult than C to use properly, and people who can sling it properly are rare. Additional languages which carry weight with me on a resume are OCaml, Processing, and any of Common Lisp, Scheme, or Clojure. If I was hiring a digital *librarian*, I'd also expect them to know Javascript, the language at the heart of the EPUB format. But Javascript is kind of tricky; it's a subtle powerful language with bad syntax and weak libraries. I certainly wouldn't recommend it to start with. Cary Gordon listu...@chillco.commailto:listu...@chillco.com wrote: There are still plenty of opportunities for Cobol coders, but I wouldn't recommend that either. Java is the COBOL of the 21st century, so if you know Java well, there will be a job in that for the next 20-30 years, I'd expect. Until the Singularity happens, anyway. I'd think there will always be lots of enterprise Java jobs around. Bill
Re: [CODE4LIB] What does my solr index have against carbon dioxide?
It wants you to use Solr power. Due to excessive co2 omissions On 11-05-31 12:45 PM, Federowicz, Yvonne Marie yvonne_federow...@brown.edumailto:yvonne_federow...@brown.edu wrote: It wants you to use Solr power. On Fri, May 27, 2011 at 7:43 AM, Thomas Dowling tdowl...@ohiolink.edumailto:tdowl...@ohiolink.eduwrote: Greetings-- I'm trying to flesh out my synonyms.txt file for a couple of Solr indexes, and I stumbled across something weird. I added these lines to synonyms.txt: co2, carbon dioxide ch4, methane The second line worked as expected: I restarted Solr, reindexed, and could search ch4 and methane as synonyms of each other. The first line did something weird. Before the change, I can get results for both CO2 and for CARBON DIOXIDE (just different results). After the change, searching CO2 got zero results, as did CARBON DIOXIDE. So at least they're acting like synonyms, right? But why in the world do they both stop finding hits? Pre-change: CO2 225 hits CARBON DIOXIDE 130 hits CARBON DIOXIDE1030 hits Post-change: CO2 0 hits CARBON DIOXIDE 0 hits CARBON DIOXIDE1030 hits Also, if I want to be able to search for Greek letters by name (alpha, beta, etc.), is there a better way than to use synonmyms.txt? Δ,δ,delta TIA -- Thomas Dowling tdowl...@ohiolink.edumailto:tdowl...@ohiolink.edu
Re: [CODE4LIB] What do you wish you had time to learn?
Python No-mind (ego-less) Advanced PHP Victorian Science Jason On 11-04-26 5:30 AM, Edward Iglesias edwardigles...@gmail.commailto:edwardigles...@gmail.com wrote: Hello All, I am doing a presentation at RILA (Rhode Island Library Association) on changing skill sets for Systems Librarians. I did a formal survey a while back (if you participated, thank you) but this stuff changes so quickly I thought I would ask this another way. What do you wish you had time to learn? My list includes CouchDB(NoSQL in general) neo4j nodejs prototype API Mashups R Don't be afraid to include Latin or Greek History. I'm just going for a snapshot of System angst at not knowing everything. Thanks, ~ Edward Iglesias Systems Librarian Central Connecticut State University
Re: [CODE4LIB] What do you wish you had time to learn?
1) On Feb 18, 2011, at 10:48 AM, Eric Lease Morgan wrote: How does a person go about exporting MARC records from a III system? Thank you for all of the very helpful replied regarding the exporting of MARC records from a III system. I'm well on my way to resolving the problem, and I've ended up identifying a few very useful resources. -- Eric Lease Morgan --- 2) On 11-04-26 3:56 PM, Eric Lease Morgan emor...@nd.edumailto:emor...@nd.edu wrote: I can do that if somebody will teach me how to read minds -- Conclusion) First mine reads, then read minds. Jason
[CODE4LIB] Geo-locate EZProxy IP Addresses
plug Code4lib 2011 is awesome! /plug Any suggestions for how to take ip addresses in the ezproxy audit logs and geo locate them on a Google Map? The tricky part is translating ip address into lat/lng = Jason Fowler, BA, GCFA, CISSP Programmer Analyst UBC Library Systems 604.822.5066 jason.fow...@ubc.ca
Re: [CODE4LIB] mailing list administratativia
Square root of minus one = Jason Fowler, BA, GCFA, CISSP Programmer Analyst UBC Library Systems jason.fow...@ubc.ca On 10-10-27 3:18 PM, Ray Denenberg, Library of Congress r...@loc.gov wrote: I think the constraint is that it has to be a rational number. -Original Message- From: Code for Libraries [mailto:code4...@listserv.nd.edu] On Behalf Of Eric Hellman Sent: Wednesday, October 27, 2010 5:58 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] mailing list administratativia I vote for changing the limit threshold to PI * (eventual length of this meta-thread). On Oct 27, 2010, at 3:37 PM, Alexander Johannesen wrote: On Thu, Oct 28, 2010 at 2:44 AM, Doran, Michael D do...@uta.edu wrote: Can that limit threshold be raised? If so, are there reasons why it should not be raised? Is it to throttle spam or something? 50 seems rather low, and it's rather depressing to have a lively discussion throttled like that. Not to mention I thought I was simply kicked out for living things up (especially given my reasonable follow-up was where the throttling began). Alex -- Project Wrangler, SOA, Information Alchemist, UX, RESTafarian, Topic Maps --- http://shelter.nu/blog/ -- -- http://www.google.com/profiles/alexander.johannesen --- Eric Hellman President, Gluejar, Inc. 41 Watchung Plaza, #132 Montclair, NJ 07042 USA e...@hellman.net http://go-to-hellman.blogspot.com/ @gluejar
