[Pugged] mysql sub-query feature

[ciapug@ciapug.org]

[was: GForge 3.0]

Tim Perdue <tim@perdue.net> said:

> dave@visionary.com wrote:
> 
> > On the features side... I know you mentioned once that you had written
> > your own database abstraction. Does GForge use this, and if so, is it
> > thoretically possible to run on different databases? Nothing against
> > Postgres, I'm just not very familiar with it.
> 
> Yes, there is a layer for MySQL and Oracle, but neither one is
currently 
> up to date or maintained. There is some interest in back-porting it to 
> MySQL, but it might take a little bit of re-coding, as I use subqueries 
> in a few places. Maybe the latest mysql finally supports some of these 
> rudimentary database features, but I don't know. ;-)
> 

They're going to be adding sub queries in version 4.1.

http://www.mysql.com/products/mysql-4.0/index.html

That's probably the single feature I've been wanting the most. You can
work around it, but the resulting SQL statements get pretty long and
hard to read. Being able to do:

SELECT * FROM users WHERE id IN (SELECT id FROM stuff)

..makes life a lot easier when you're dealing with parent-child
relations.

I didn't see a release schedule. Version 4.0.x is in beta now, so I
bet it will be at least another 6 months.

-dc