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:

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

2010-07-27 Thread John Bokma
John Nagle na...@animats.com 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.

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

Re: Why are String Formatted Queries Considered So Magical?

2010-07-26 Thread Ben Finney
Justin Smith justin2009sm...@gmail.com 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

Re: Why are String Formatted Queries Considered So Magical?

2010-07-03 Thread Lawrence D'Oliveiro
In message pan.2010.06.29.09.35.18.594...@nowhere.com, 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

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 pan.2010.06.29.09.35.18.594...@nowhere.com, 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

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: Nobodynob...@nowhere.com wrote: And what about regular expressions? What about them? As the saying goes:

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

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

Re: Why are String Formatted Queries Considered So Magical?

2010-07-01 Thread Roy Smith
Stephen Hansen me+list/pyt...@ixokai.io 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

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

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 Hansenme+list/pyt...@ixokai.io 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.

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 silly. RE is a

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: Nobodynob...@nowhere.com 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 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: Nobodynob...@nowhere.com wrote: And what about regular expressions? What about them? As the saying goes: Some people, when confronted with a problem, think

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

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,

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: Nobodynob...@nowhere.com wrote: And what about regular expressions? What about them? As the saying goes: Some people, when confronted with a problem,

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-29 Thread Duncan Booth
Owen Jacobson angrybald...@gmail.com 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.

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Roy Smith
Nobody nob...@nowhere.com 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

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: Nobodynob...@nowhere.com 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.

Re: Why are String Formatted Queries Considered So Magical?

2010-06-29 Thread Carl Banks
On Jun 28, 3:07 am, Dennis Lee Bieber wlfr...@ix.netcom.com wrote: On Sun, 27 Jun 2010 21:02:57 -0700, Stephen Hansen me+list/pyt...@ixokai.io 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

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

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 next

Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 24, 6:02 pm, Roy Smith r...@panix.com wrote: In article i00t2k$l0...@lust.ihug.co.nz,  Lawrence D'Oliveiro l...@geek-central.gen.new_zealand 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

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 pavlovevide...@gmail.com 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

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks pavlovevide...@gmail.com 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. --

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 4:35 pm, Ben Finney ben+pyt...@benfinney.id.au wrote: Carl Banks pavlovevide...@gmail.com 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

Re: Why are String Formatted Queries Considered So Magical?

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

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 r...@panix.com wrote: In article 14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com,  Carl Banks pavlovevide...@gmail.com wrote: Seriously, almost every other kind of library uses a binary API. What

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 r...@panix.com wrote: In article 14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com,  Carl Banks pavlovevide...@gmail.com wrote: Seriously, almost every other kind of library uses a binary API. What

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks pavlovevide...@gmail.com writes: On Jun 27, 4:35 pm, Ben Finney ben+pyt...@benfinney.id.au wrote: Carl Banks pavlovevide...@gmail.com writes: Seriously, almost every other kind of library uses a binary API. Except for the huge number that deal with text protocols or

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:19 pm, Owen Jacobson angrybald...@gmail.com wrote: On 2010-06-27 22:51:59 -0400, Carl Banks said: On Jun 27, 3:20 pm, Roy Smith r...@panix.com wrote: In article 14e44c9c-04d9-452d-b544-498adfaf7...@d8g2000yqf.googlegroups.com, Carl Banks pavlovevide...@gmail.com wrote:

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.

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(...)

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:52 pm, Stephen Hansen me+list/pyt...@ixokai.io 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

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

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 8:33 pm, Ben Finney ben+pyt...@benfinney.id.au wrote: Carl Banks pavlovevide...@gmail.com 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

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Carl Banks
On Jun 27, 9:02 pm, Stephen Hansen me+list/pyt...@ixokai.io 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

Re: Why are String Formatted Queries Considered So Magical?

2010-06-27 Thread Ben Finney
Carl Banks pavlovevide...@gmail.com writes: On Jun 27, 8:33 pm, Ben Finney ben+pyt...@benfinney.id.au wrote: Carl Banks pavlovevide...@gmail.com writes: I'm disappointed, usually when you sit on your reinforced soapbox and pretense the air of infinite expertise you at least use