[development] Any solution for solving DB reserved wordconflict?
cxjohnson at gmail.com
Tue Feb 19 13:09:09 UTC 2008
I poked around in your sandbox a bit Larry. Saw some cool ideas
pretty well on their way to implementation there! :-)
On Feb 19, 2008 2:57 AM, Larry Garfield <larry at garfieldtech.com> wrote:
> On Monday 18 February 2008, David Durham, Jr. wrote:
> > On Feb 18, 2008 2:19 PM, David Durham, Jr. <david.durham.jr at gmail.com>
> > > On Feb 18, 2008 2:07 PM, Larry Garfield <larry at garfieldtech.com> wrote:
> > > > An ORM requires a query builder. A query builder alone is not an ORM.
> > > > I don't think we need/want a complete database-ORM, but a query builder
> > > > is very valuable to have.
> > >
> > > I know what you're saying, but a single query builder doesn't seem to
> > > suffice. You need one for mysql, postgres .. etc.
> > forgot to mention that something as seemingly trivial as join tables
> > can required different sql. Think someone brought up a point about
> > the new version of postgres requires casts when the datatypes used to
> > join are different.
> First, there's only so far a database can customize its syntax before it
> doesn't count as SQL anymore. :-)
> Second, please have a look at the database_query_builder.inc file in the pdo
> directory of my sandbox. (My CVS name is crell.) It should handle any
> reasonably standard SQL database, and is fully overridable for a specific
> database type using simple class inheritance. I am working on the patch to
> integrate it into core, which I hope to have ready for testing by the end of
> the week. At that point I welcome feedback on its compatibility with other
> Larry Garfield AIM: LOLG42
> larry at garfieldtech.com ICQ: 6817012
> "If nature has made any one thing less susceptible than all others of
> exclusive property, it is the action of the thinking power called an idea,
> which an individual may exclusively possess as long as he keeps it to
> himself; but the moment it is divulged, it forces itself into the possession
> of every one, and the receiver cannot dispossess himself of it." -- Thomas
More information about the development