Re: Why are String Formatted Queries Considered So Magical? (Spammer analysis)

2010-07-27 Thread John Bokma
John Nagle writes: > On 7/26/2010 4:19 PM, Justin Smith wrote: >> Seeking industry expert candidates >> >> I’m Justin Smith, Director of Tech Recruiting at Express Seattle. I >> am currently seeking candidates to fill Tech Positions for multiple A- >> List Clients: > >Spammer detected. But

Re: Why are String Formatted Queries Considered So Magical? (Spammer analysis)

2010-07-27 Thread John Nagle
On 7/26/2010 4:19 PM, Justin Smith wrote: Seeking industry expert candidates I’m Justin Smith, Director of Tech Recruiting at Express Seattle. I am currently seeking candidates to fill Tech Positions for multiple A- List Clients: Spammer detected. Injection-Info: r27g2000yqb.googlegroup

Re: Why are String Formatted Queries Considered So Magical?

2010-07-26 Thread Ben Finney
Justin Smith writes: > Seeking industry expert candidates Please don't reply in an existing thread with an unrelated message. If you want to start a new discussion, compose a new message, not a reply. For job advertisements, please don't use this forum at all; instead use the Python Jobs Board

Re: Why are String Formatted Queries Considered So Magical?

2010-07-26 Thread Justin Smith
Seeking industry expert candidates I’m Justin Smith, Director of Tech Recruiting at Express Seattle. I am currently seeking candidates to fill Tech Positions for multiple A- List Clients: • Quality Assurance Engineer, • Senior Data Engineer, Search Experience • Senior Software D

Re: Why are String Formatted Queries Considered So Magical?

2010-07-03 Thread Rami Chowdhury
On Saturday 03 July 2010 19:33:44 Lawrence D'Oliveiro wrote: > In message , Nobody wrote: > > On Tue, 29 Jun 2010 12:30:36 +1200, Lawrence D'Oliveiro wrote: > >>> Seriously, almost every other kind of library uses a binary API. What > >>> makes databases so special that they need a string-command b

Re: Why are String Formatted Queries Considered So Magical?

2010-07-03 Thread Lawrence D'Oliveiro
In message , Nobody wrote: > On Tue, 29 Jun 2010 12:30:36 +1200, Lawrence D'Oliveiro wrote: > >>> Seriously, almost every other kind of library uses a binary API. What >>> makes databases so special that they need a string-command based API? >> >> HTML is also effectively a string-based API. >

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Stephen Hansen
On 7/1/10 5:11 AM, Roy Smith wrote: Stephen Hansen wrote: The quote does not deny the power of regular expressions; it challenges widely held assumption and belief that comes from *somewhere* that they are the best way to approach any problem that is text related. Well, that assumption comes

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Stephen Hansen
On 7/1/10 3:03 AM, Jean-Michel Pichavant wrote: Re is part of the python standard library, for some purpose I guess. No, *really*? So all those people who have been advocating its useless and shouldn't be are already too late? Damn. Well, there goes *that* whole crusade we were all out on.

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Roy Smith
Stephen Hansen wrote: > The quote does not deny the power of regular expressions; it challenges > widely held assumption and belief that comes from *somewhere* that they > are the best way to approach any problem that is text related. Well, that assumption comes from historical unix usage wher

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Jean-Michel Pichavant
Stephen Hansen wrote: On 6/30/10 11:58 PM, Jorgen Grahn wrote: On Wed, 2010-06-30, Steven D'Aprano wrote: On Wed, 30 Jun 2010 14:14:38 +, Jorgen Grahn wrote: On Tue, 2010-06-29, Stephen Hansen wrote: There's nothing silly about it. It is an exaggeration though: but it does represent a g

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Stephen Hansen
On 6/30/10 11:58 PM, Jorgen Grahn wrote: On Wed, 2010-06-30, Steven D'Aprano wrote: On Wed, 30 Jun 2010 14:14:38 +, Jorgen Grahn wrote: On Tue, 2010-06-29, Stephen Hansen wrote: There's nothing silly about it. It is an exaggeration though: but it does represent a good thing to keep in mi

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Jorgen Grahn
On Wed, 2010-06-30, Steven D'Aprano wrote: > On Wed, 30 Jun 2010 14:14:38 +, Jorgen Grahn wrote: > >> On Tue, 2010-06-29, Stephen Hansen wrote: >>> On 6/29/10 5:41 AM, Roy Smith wrote: Nobody wrote: >> And what about regular expressions? > > What about them? As the saying

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Steven D'Aprano
On Wed, 30 Jun 2010 14:14:38 +, Jorgen Grahn wrote: > On Tue, 2010-06-29, Stephen Hansen wrote: >> On 6/29/10 5:41 AM, Roy Smith wrote: >>> Nobody wrote: >>> > And what about regular expressions? What about them? As the saying goes: Some people, when confronted with

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Ethan Furman
Terry Reedy wrote: On 6/30/2010 8:22 AM, Nobody wrote: I've noticed over the years a significant anti-RE sentiment in the Python community. IMHO, the sentiment isn't so much against REs per se, but against excessive or inappropriate use. Apart from making it easy to write illegible code, they

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Terry Reedy
On 6/30/2010 8:22 AM, Nobody wrote: I've noticed over the years a significant anti-RE sentiment in the Python community. IMHO, the sentiment isn't so much against REs per se, but against excessive or inappropriate use. Apart from making it easy to write illegible code, they also make it easy t

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Stephen Hansen
On 6/30/10 7:14 AM, Jorgen Grahn wrote: On Tue, 2010-06-29, Stephen Hansen wrote: On 6/29/10 5:41 AM, Roy Smith wrote: Nobody wrote: And what about regular expressions? What about them? As the saying goes: Some people, when confronted with a problem, think "I know, I'll u

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Jorgen Grahn
On Tue, 2010-06-29, Stephen Hansen wrote: > On 6/29/10 5:41 AM, Roy Smith wrote: >> Nobody wrote: >> And what about regular expressions? >>> >>> What about them? As the saying goes: >>> >>> Some people, when confronted with a problem, think >>> "I know, I'll use regular expressions."

Re: Why are String Formatted Queries Considered So Magical?

2010-06-30 Thread Nobody
On Tue, 29 Jun 2010 08:41:03 -0400, Roy Smith wrote: >> > And what about regular expressions? >> >> What about them? As the saying goes: >> >> Some people, when confronted with a problem, think >> "I know, I'll use regular expressions." >> Now they have two problems. > > That's s

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Carl Banks
On Jun 28, 3:07 am, Dennis Lee Bieber wrote: > On Sun, 27 Jun 2010 21:02:57 -0700, Stephen Hansen > declaimed the following in > gmane.comp.python.general: > > > (This is an area where parametrized queries is even more important: but > > I'm not sure if MySQL does proper prepared queries and cach

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Stephen Hansen
On 6/29/10 5:41 AM, Roy Smith wrote: Nobody wrote: And what about regular expressions? What about them? As the saying goes: Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. That's silly. RE is a

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Roy Smith
Nobody wrote: > > And what about regular expressions? > > What about them? As the saying goes: > > Some people, when confronted with a problem, think > "I know, I'll use regular expressions." > Now they have two problems. That's silly. RE is a good tool. Like all good tools

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Duncan Booth
Owen Jacobson wrote: > However, not every programming language has > the kind of structural flexibility to do that well: a library similar > to SQLalchemy would be incredibly clunky (if it worked at all) in, say, > Java or C#, and it'd be nearly impossible to pull off in C. I guess you've ne

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Nobody
On Tue, 29 Jun 2010 12:30:36 +1200, Lawrence D'Oliveiro wrote: >> Seriously, almost every other kind of library uses a binary API. What >> makes databases so special that they need a string-command based API? > > HTML is also effectively a string-based API. HTML is a data format. The sane way to

Re: Why are String Formatted Queries Considered So Magical?

2010-06-28 Thread Peter H. Coffin
On Mon, 28 Jun 2010 03:07:29 -0700, Dennis Lee Bieber wrote: > Coding for something like a DBTG network database did not allow for > easy changes in queries... What would be a simple join in SQL was > traversing a circular linked list in the DBTG database my college > taught. EG: loop get nex

Re: Why are String Formatted Queries Considered So Magical?

2010-06-28 Thread Lawrence D'Oliveiro
In message <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>, Carl Banks wrote: > Seriously, almost every other kind of library uses a binary API. What > makes databases so special that they need a string-command based API? HTML is also effectively a string-based API. And what a

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks writes: > On Jun 27, 8:33 pm, Ben Finney wrote: > > Carl Banks writes: > > > I'm disappointed, usually when you sit on your reinforced soapbox and > > > pretense the air of infinite expertise you at least use reasonable > > > logic. > > > > Kindly stop inventing straw men to attack;

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 9:02 pm, Stephen Hansen wrote: > On 6/27/10 8:48 PM, Carl Banks wrote: > > > I don't know the exact details of all of these, but I'm going to opine > > that at least some of these are easily expressible with a function > > call API.  Perhaps more naturally than with string queries.  For

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:33 pm, Ben Finney wrote: > Carl Banks writes: > > I'm disappointed, usually when you sit on your reinforced soapbox and > > pretense the air of infinite expertise you at least use reasonable > > logic. > > Kindly stop inventing straw men to attack; I deny the position you're > painti

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Owen Jacobson
On 2010-06-28 00:02:57 -0400, Stephen Hansen said: On 6/27/10 8:48 PM, Carl Banks wrote: I don't know the exact details of all of these, but I'm going to opine that at least some of these are easily expressible with a function call API. Perhaps more naturally than with string queries. For ins

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:52 pm, Stephen Hansen wrote: > Then there's the type of SQL that results in DBA's having jobs-- and > deservedly so. Its *really* a very flexible and powerful language > capable of doing quite a lot to bend, flex, twist, and interleave that > data in the server while building up a res

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Stephen Hansen
On 6/27/10 8:48 PM, Carl Banks wrote: I don't know the exact details of all of these, but I'm going to opine that at least some of these are easily expressible with a function call API. Perhaps more naturally than with string queries. For instance, set operations: query1 = rdb_query(...) query

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Stephen Hansen
On 6/27/10 7:51 PM, Carl Banks wrote: I'm not the biggest expert on SQL ever, but the only thing I can think of is expressions. Statements don't express anything very complex, and could straightforwardly be represented by function calls. See, there's really two kinds of SQL out there. There's

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:19 pm, Owen Jacobson wrote: > On 2010-06-27 22:51:59 -0400, Carl Banks said: > > On Jun 27, 3:20 pm, Roy Smith wrote: > >> In article > >> <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>, > >> Carl Banks wrote: > > >>> Seriously, almost every other kind of library

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks writes: > On Jun 27, 4:35 pm, Ben Finney wrote: > > Carl Banks writes: > > > Seriously, almost every other kind of library uses a binary API. > > > > Except for the huge number that deal with text protocols or languages. > > No, not really. Almost all types of libraries have binary

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Owen Jacobson
On 2010-06-27 22:51:59 -0400, Carl Banks said: On Jun 27, 3:20 pm, Roy Smith wrote: In article <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>,  Carl Banks wrote: Seriously, almost every other kind of library uses a binary API. What makes databases so special that they

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Owen Jacobson
On 2010-06-27 22:51:59 -0400, Carl Banks said: On Jun 27, 3:20 pm, Roy Smith wrote: In article <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>,  Carl Banks wrote: Seriously, almost every other kind of library uses a binary API. What makes databases so special that they

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 3:20 pm, Roy Smith wrote: > In article > <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>, >  Carl Banks wrote: > > > > > Seriously, almost every other kind of library uses a binary API. What > > makes databases so special that they need a string-command based API? >

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 4:35 pm, Ben Finney wrote: > Carl Banks writes: > > Seriously, almost every other kind of library uses a binary API. > > Except for the huge number that deal with text protocols or languages. No, not really. Almost all types of libraries have binary APIs, including those that deal wi

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks writes: > Seriously, almost every other kind of library uses a binary API. Except for the huge number that deal with text protocols or languages. > What makes databases so special that they need a string-command based > API? Because SQL is a text language. -- \ “In t

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Roy Smith
In article <14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com>, Carl Banks wrote: > Seriously, almost every other kind of library uses a binary API. What > makes databases so special that they need a string-command based API? > How about this instead (where this a direct binary i

Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 24, 6:02 pm, Roy Smith wrote: > In article , >  Lawrence D'Oliveiro wrote: > > > I construct ad-hoc queries all the time. It really isn’t that hard to do > > safely. All you have to do is read the documentation > > I get worried when people talk about how easy it is to do something > safel