I looked briefly at mySql and think it's a very viable DB product, but
it clearly lacks the "fit and finish" of Rbase in addition to it's many
features.
But if you must use it and miss views and sub-selects, I don't see
why a person couldn't just substitute multi-table selects.
Sel tbl1_col from tbl1 whe ID in (sel ID from table2)
would become
Sel tbl1_col from tbl1 t1, tbl2 t2 whe t1.ID = t2.ID
As we've heard before, views are nothing more than stored selects.
If you had to, even view definitions that I use that are pages long
could be repeated each time a data set is required (Although I'm
not sure what you'ld do to replace cascading views). But I think a
few hundred dollars to avoid the struggle and get the added
features is $$ well spent.
Ben Petersen
On 28 May 2001, at 23:29, jwk at Zone Alpha wrote:
> Very nice summary, David,
>
> One thing I am not too sure about is... Is R:Base for Linux going to be
> client-server database? MySQL is. If R:Base for Linux can replace MySQL,
> it would be just wonderful and might shake things up in the Linux/Unix
> world... and empower a lot of R:Basers in this more and more
> Internet-centric world. I practically run my business with R:Base. If I
> can extend this R:Base power to the Internet, it would just be wonderful. I
> hate struggling with MySQL et al. with their limitations, especially NO
> sub-select.
>
> James Kim
>
>
> ----- Original Message -----
> From: David Ballantyne <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, May 28, 2001 2:12 AM
> Subject: RE: BASE Web Front End
>
>
> > Hi Jenna;
> >
> >
> > 5) The MySQL data dictionary is virtually non existant
> >
> > All I can say to Razzak in relation to R:BASE for Linux is...:
> >
> > "Bring it On Razzak"
> >
> > ...because if MySQL is currently the "Buzz Word" in Linux Database
> > solutions, The Linux community is in for a big shock when R:BASE for Linux
> > is released.
> >
> > Couple R:BASE's existing speed, flexibility and stabilty with the fact
> that
> > Linux is a very,very lean O/S and you may just find that MySQL will simply
> > be "too scared" to post R:BASE benchmark tests on it's website!
> >
> > Kindest Regards
> >
> >
> > David Ballantyne
> >
>
>
>
