Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-20 Thread Peter da Silva
On 2007-12-20, at 00:37, Robert Rothenberg wrote: It isn't the syntax that makes SQL hateful. I hope you mean "it isn't JUST the syntax". It's that data is partitioned into columns in tables (read: fields in flat files). SQL is 50s- era syntax for 50s-era technology (invented in the 70s, o

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-20 Thread Juerd Waalboer
Robert Rothenberg skribis 2007-12-20 6:37 (+): > But people keeping their data in relational databases because of tradition And performance. Please, come up with an object based database that can compete. The world will love you. -- Met vriendelijke groet, Kind regards, Korajn salutojn,

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-20 Thread Roger Burton West
On Wed, Dec 19, 2007 at 09:14:45PM -0800, Michael G Schwern wrote: >When there's a SQL compatibility question and MySQL's involved, you can be >sure it's MySQL that's got it wrong. They love to bolt on all sorts of >additional language extensions. Which is why I have in my sigfile: TRADITIONAL:

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-20 Thread Robert Rothenberg
On 19/12/07 20:01 Peter da Silva wrote: > I think any time SQL is involved in a hate, you need to hate the people > who designed SQL for trying to make it "user-friendly" and english-like > instead of defining a statement syntax that clearly distinguished > components of a statement and sticking to

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-20 Thread Michael G Schwern
Sean Conner wrote: > And at this point, I don't know where to direct my hate of software---is > it PHP and it's serious lack of database abstraction? It's encouragement of > shoddily written software with no pretentions of being portable? Is it the > SQL parsing of MySQL for making some parts o

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread Peter da Silva
On 2007-12-19, at 15:44, David King wrote: {select,[random,'()','*',count], {from,bar}, {where,{id,'=',5}}} That kind of wrapper around SQL can be useful, but it doesn't actually do anything about the hate that is SQL. The big problem with the SQL select statement is that it

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread David King
I'd love to access a database using code like: (select column-list selector-expression) (with table selector-expression) (group column-list query grouping-expression) (order query order-list) (join query-list join-expression) erlsql[0] attempts to add this type of syntax to Erlang, but does so

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread Peter da Silva
On 2007-12-19, at 14:23, Darrell Fuhriman wrote: You get (group ('crust ('fillings (count fillings))) (with 'menu (select ('crust 'fillings) (and (eq cheese 'extra) (eq topping 'liver ('crust)) You just more or less defined an LDAP query. ;) Then I guess this syntax fails the "obvi

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread Darrell Fuhriman
You get (group ('crust ('fillings (count fillings))) (with 'menu (select ('crust 'fillings) (and (eq cheese 'extra) (eq topping 'liver ('crust)) You just more or less defined an LDAP query. ;) Darrell

Re: Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread Peter da Silva
I think any time SQL is involved in a hate, you need to hate the people who designed SQL for trying to make it "user-friendly" and english-like instead of defining a statement syntax that clearly distinguished components of a statement and sticking to it. None of these optional "noise" word

Web based applications wedded to MySQL (SugarCRM, I'm looking at you!)

2007-12-19 Thread Sean Conner
I'm working on an internal project and for reasons that get into business type logic of which I'm not privy to, SugarCRM [1] seems to fit the bill perfectly. Well, almost perfectly. For other reasons that at the time I fully agreed with but now am having a difficult time remembering, we deci