Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
Hey, http://www.doctrine-project.org/documentation/manual/1_1/en Use this for Doctrine reference =) Cheers, On Tue, Apr 28, 2009 at 9:02 PM, Ajai Khattri wrote: > On Tue, 28 Apr 2009, Guilherme Blanco wrote: > >> The usage of Doctrine will never be found on Symfony tutorials... >> you can

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Ajai Khattri
On Tue, 28 Apr 2009, Guilherme Blanco wrote: > The usage of Doctrine will never be found on Symfony tutorials... > you can probably find a couple of examples in the Doctrine manual. Some docs here: http://www.symfony-project.org/doctrine/1_2/en/ -- Aj. ___

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
uot;i am currently > working with doctrine" in my last email. > > nice to see some great people are on this mailing list!!! > > sincerely, > ~rob > > > -Original Message- > From: Guilherme Blanco > To: NYPHP Talk > Sent: Tue, 28 Apr 2009 2:16 pm > Subjec

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
The usage of Doctrine will never be found on Symfony tutorials... you can probably find a couple of examples in the Doctrine manual. On Tue, Apr 28, 2009 at 4:18 PM, Ajai Khattri wrote: > On Tue, 28 Apr 2009, Guilherme Blanco wrote: > >> Specially for people like you, Doctrine provide a couple of

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread y2rob
2009 2:16 pm Subject: Re: [nyphp-talk] ORM that uses more advanced MySQL features Specially for people like you, Doctrine provide a couple of CLI tasks that can do a lot of things. For example... you can define your models into an YAML file, and simply call: php ./doctrine.php generate-m

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Ajai Khattri
On Tue, 28 Apr 2009, Guilherme Blanco wrote: > Specially for people like you, Doctrine provide a couple of CLI tasks > that can do a lot of things. Im using symfony and I know a lot of these tasks are available through the symfony CLI tool. But Im new to Doctrine in symfony (still learning it).

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
sorry for going on the tangent > > -Original Message----- > From: Guilherme Blanco > To: NYPHP Talk > Sent: Tue, 28 Apr 2009 12:46 pm > Subject: Re: [nyphp-talk] ORM that uses more advanced MySQL features > > Doctrine_View is able to handle views in any DBMS. > > Also,

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread y2rob
ps - sorry for going on the tangent -Original Message- From: Guilherme Blanco To: NYPHP Talk Sent: Tue, 28 Apr 2009 12:46 pm Subject: Re: [nyphp-talk] ORM that uses more advanced MySQL features Doctrine_View is able to handle views in any DBMS. Also, you can manually map

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
Doctrine_View is able to handle views in any DBMS. Also, you can manually map the view if you want to work on updatable views, just like Oracle supports. Stored procedures works on the fly, just like a common function call. Doctrine does something like that: In case DQL can interpret it, apply th

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Marcelo Araujo
Since when, Guilherme? On Tue, Apr 28, 2009 at 1:31 PM, Guilherme Blanco wrote: > www.doctrine-project.org > > =) > > On Tue, Apr 28, 2009 at 1:08 PM, Ajai Khattri wrote: >> >> Does anyone know of an ORM that can use views and stored procedures in >> MySQL? > -- > Guilherme Blanco - Web Develope

Re: [nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Guilherme Blanco
www.doctrine-project.org =) On Tue, Apr 28, 2009 at 1:08 PM, Ajai Khattri wrote: > > Does anyone know of an ORM that can use views and stored procedures in > MySQL? > > > -- > Aj. > > ___ > New York PHP User Group Community Talk Mailing List > http://l

[nyphp-talk] ORM that uses more advanced MySQL features

2009-04-28 Thread Ajai Khattri
Does anyone know of an ORM that can use views and stored procedures in MySQL? -- Aj. ___ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show_participation.php

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-17 Thread tedd
At 8:02 PM -0400 9/16/07, Mark Armendariz wrote: Rob Marscher wrote: On Sep 15, 2007, at 3:24 PM, Mark Armendariz wrote: Anyways, that's my take on SQL and ORM. Both - with an easily manipulated and portable meta language. Sounds pretty cool. Ever thought of analyzing the queries used within

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-16 Thread Mark Armendariz
Paul Houle wrote: Mark Armendariz wrote: I'm really fascinated by ideas like this. Have you seen HQL, the query language that comes with the (Java-based) Hibernate ORM system? http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html This is interesting, Paul. Thank you. I've

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-16 Thread Mark Armendariz
Rob Marscher wrote: On Sep 15, 2007, at 3:24 PM, Mark Armendariz wrote: Anyways, that's my take on SQL and ORM. Both - with an easily manipulated and portable meta language. Sounds pretty cool. Ever thought of analyzing the queries used within an application and automatically generate (or sug

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-16 Thread Rob Marscher
On Sep 15, 2007, at 3:24 PM, Mark Armendariz wrote: Anyways, that's my take on SQL and ORM. Both - with an easily manipulated and portable meta language. Sounds pretty cool. Ever thought of analyzing the queries used within an application and automatically generate (or suggest) indexes? S

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-16 Thread Paul Houle
Mark Armendariz wrote: This might seem completely ridiculous and tear the idea to shreds if you must, but I've been working on a library with it's own query language that creates both the SQL and the PHP Objects to reference everything returned. Though I've been working on it for quite some

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-16 Thread Gary Mort
Mark Armendariz wrote: I'm a huge fan of SQL, and I've been using it for over 10 years. its a solid and reliable friend. But it seems to be far too wordy and gets hairy to maintain, which is why we tend to look for ways to modularize it within our programming languages. Personally, my feeli

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Kenneth Downs
Mark, this all sounds very interesting. Nothing will improve your code nearly as much as letting other people see it. Get it on sourceforge! Release early! Release Often! Mark Armendariz wrote: I'm a huge fan of SQL, and I've been using it for over 10 years. its a solid and reliable frien

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Mark Armendariz
I'm a huge fan of SQL, and I've been using it for over 10 years. its a solid and reliable friend. But it seems to be far too wordy and gets hairy to maintain, which is why we tend to look for ways to modularize it within our programming languages. When using SQL, we're just working with stri

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread David Krings
Paul Houle wrote: Other databases (for instance, MS Access) won't, and you need to write Since when is Access a database? It is a big piece of stinkin' garbage. ;) David ___ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread David Krings
Paul Houle wrote: I think of ORM as a partial solution to the problems of building database-backed web apps. People call database applications "CRUD" apps, short for I have no idea what ORM is, mainly because I didn't follow the past threads, but here is my take of the problem you describe

What Does ORM Mean? Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Kenneth Downs
rstname, last_name = $lastname, ... Which is *basically* the same as what your saying ORM is useful for in this case... - Ben - Original Message - From: "Paul Houle" <[EMAIL PROTECTED]> To: "NYPHP Talk" Sent: Saturday, September 15, 2007 12:50 PM Subject: [nyphp

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Ben Sgro \(ProjectSkyLine\)
tember 15, 2007 1:14 PM Subject: Re: [nyphp-talk] ORM vs SQL: the ultimate showdown Ben Sgro (ProjectSkyLine) wrote: Why not just do: SET ... first_name = $firstname, last_name = $lastname, ... Which is *basically* the same as what your saying ORM is useful for in this case... That&#

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Paul Houle
Ben Sgro (ProjectSkyLine) wrote: Why not just do: SET ... first_name = $firstname, last_name = $lastname, ... Which is *basically* the same as what your saying ORM is useful for in this case... That's a very nice syntax. It's also mysql-specific. I love mysql, and it may be very sensi

Re: [nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Ben Sgro \(ProjectSkyLine\)
Saturday, September 15, 2007 12:50 PM Subject: [nyphp-talk] ORM vs SQL: the ultimate showdown I think of ORM as a partial solution to the problems of building database-backed web apps. People call database applications "CRUD" apps, short for Create Recall Update Delete ORM i

[nyphp-talk] ORM vs SQL: the ultimate showdown

2007-09-15 Thread Paul Houle
I think of ORM as a partial solution to the problems of building database-backed web apps. People call database applications "CRUD" apps, short for Create Recall Update Delete ORM is good for Create, and for many cases of Update and Delete. It can be used to do Recall, but can be d

Re: [nyphp-talk] ORM anyone?

2007-09-14 Thread Kenneth Downs
Ajai Khattri wrote: On Wed, 12 Sep 2007, Kenneth Downs wrote: ... We accept the obligation to learn HTML, CSS and Javascript, and even a few things about HTTP headers and so forth, but we think it is optional to learn SQL and to treat the database as what it is. That really puzzles me. T

Re: [nyphp-talk] ORM anyone?

2007-09-13 Thread Ajai Khattri
On Wed, 12 Sep 2007, Kenneth Downs wrote: > ... We accept the obligation > to learn HTML, CSS and Javascript, and even a few things about HTTP > headers and so forth, but we think it is optional to learn SQL and to > treat the database as what it is. That really puzzles me. The only > explan

Re: [nyphp-talk] ORM anyone?

2007-09-12 Thread Jon Baer
(This might have already been mentioned, sorry lost some emails) ... I think no matter what ORM framework you pick you always have to look @ its lazy + eager loading options (this is even before the optimization). You can run into big problems if you don't consider the timing of data in yo

Re: [nyphp-talk] ORM anyone?

2007-09-12 Thread Rob Marscher
I think ORM definitely fits a lot of common models. It can be great for rapid development which is why frameworks like Ruby on Rails and CakePHP have it build in. You just define the fields and the relationships to other objects and the built in methods for saving the objects (which will

Re: [nyphp-talk] ORM anyone?

2007-09-12 Thread Kenneth Downs
Ajai Khattri wrote: On Tue, 11 Sep 2007, Kenneth Downs wrote: That's a personal opinion, not a system requirement. We *can* agree that SQL is not PHP (or Ruby or Python). Sure. What's a "conceptual relationship?" If you put your data into tables, then the relationships betwee

Re: [nyphp-talk] ORM anyone?

2007-09-11 Thread Ajai Khattri
> On Tue, 11 Sep 2007, Kenneth Downs wrote: > > That's a personal opinion, not a system requirement. We *can* agree that SQL is not PHP (or Ruby or Python). > What's a "conceptual relationship?" If you put your data into tables, > then the relationships between the tables are foreign keys. T

Re: [nyphp-talk] ORM anyone?

2007-09-11 Thread Ken Downs
Ajai Khattri <[EMAIL PROTECTED]> wrote: > On Tue, 11 Sep 2007, Kenneth Downs wrote: > > > As you may guess, I'm no fan of ORM. The main reason is what I just > > said above. OO code and table-based data are two very different beasts > > with very different natures. ORM tries to make one look

Re: [nyphp-talk] ORM anyone?

2007-09-11 Thread Ajai Khattri
On Tue, 11 Sep 2007, Kenneth Downs wrote: > As you may guess, I'm no fan of ORM. The main reason is what I just > said above. OO code and table-based data are two very different beasts > with very different natures. ORM tries to make one look like the > other. Why would anybody want to do t

Re: [nyphp-talk] ORM anyone?

2007-09-11 Thread Kenneth Downs
LK wrote: Hello, Please help me in overcoming a mental block about this wonderful thing called ORM. By reading some examples on using ORM, such as setting up Author/Books parent/child objects, I notice that each author and each book has to be individually assigned in the PHP script and sav

Re: [nyphp-talk] ORM anyone?

2007-09-11 Thread csnyder
On 9/11/07, LK <[EMAIL PROTECTED]> wrote: > Please help me in overcoming a mental block about this wonderful thing > called ORM. ORM is a concept, not a defined system. It may help to get your questions answered if you say whether you are using an existing framework or designing your own. > 1. i

[nyphp-talk] ORM anyone?

2007-09-11 Thread LK
Hello, Please help me in overcoming a mental block about this wonderful thing called ORM. By reading some examples on using ORM, such as setting up Author/Books parent/child objects, I notice that each author and each book has to be individually assigned in the PHP script and saved. This is

Re: [nyphp-talk] ORM

2007-01-27 Thread inforequest
Greg Rundlett greg.rundlett-at-gmail.com |nyphp dev/internal group use| wrote: On 1/27/07, Kenneth Downs <[EMAIL PROTECTED]> wrote: Oh, well, enough of this ranting, I'm putting some intro material on the Andromeda website today, and getting a new domain name, its only fun for so long to

Re: [nyphp-talk] ORM

2007-01-27 Thread Kenneth Downs
Greg Rundlett wrote: Ken, you obviously have good RDBMS knowledge, I hope that the next time you discover such mistakes in wikipedia that you might just hit the 'edit' link and add your contributions for everyone's benefit. Then you could post a link to the NYPHP group about how the article on w

Re: [nyphp-talk] ORM

2007-01-27 Thread Greg Rundlett
On 1/27/07, Kenneth Downs <[EMAIL PROTECTED]> wrote: I'm not usually one to complain about wikipedia, but I wouldn't put too much faith in that particular article, the author's knowledge of RDBMS is extremely weak. Examples of fundamental misunderstanding include: [snip] Oh, well, eno

Re: [nyphp-talk] ORM

2007-01-27 Thread Kenneth Downs
e, its only fun for so long to beat up on somebody's work, much more fun to perfect your own Baer, Jon wrote: For those not understanding the term or issues, Wikipedia has a great resource on it ... http://en.wikipedia.org/wiki/Object-relational_mapping - Jon -Original Message-

RE: [nyphp-talk] ORM

2007-01-26 Thread Baer, Jon
-talk] ORM I can't believe that my group is the only group on this list that has implemented ORM. If you have implemented ORM, what challenges did you face? And how did you solve them? What compromises did you choose? Were they conscious or unconscious compromises?

Re: [nyphp-talk] ORM

2007-01-26 Thread Kenneth Downs
Hans C. Kaspersetz wrote: I can't believe that my group is the only group on this list that has implemented ORM. One reason it is not that common is that it is a response based on experience with lots of biz apps. A great many PHP programmers have never seen a biz app and never will. There

Re: [nyphp-talk] ORM

2007-01-26 Thread csnyder
On 1/26/07, Hans C. Kaspersetz <[EMAIL PROTECTED]> wrote: I can't believe that my group is the only group on this list that has implemented ORM. If you have implemented ORM, what challenges did you face? And how did you solve them? What compromises did you choose? Were they conscious or uncons

[nyphp-talk] ORM

2007-01-26 Thread Hans C. Kaspersetz
I can't believe that my group is the only group on this list that has implemented ORM. If you have implemented ORM, what challenges did you face? And how did you solve them? What compromises did you choose? Were they conscious or unconscious compromises? Hans __