Will MySQL die soon ?

[James McDonald]

David A. Bandel wrote:
> On Mon, Apr 20, 2009 at 9:15 AM, Ben Duncan <bend at linux4ms.net> wrote:
>   
>> LOL ...... As my best friend says "Ben, SQL was invented for those
>> who do not know how to program".
>>     
>
> I resemble that remark!
>
> [snip]
>
>   
>>> I just wish I knew what a left outer join was. Can't be expert at
>>> everything and database dev hasn't been on my list of nightime reading.
>>>       
>
>   
> If you care to understand any of this, I suggest you work through the
> PostgreSQL tutorial -- it's short and explains joins extremely well.
> You can see and do -- best way to learn.  When properly used, any
> piece of data is used only once.  If that piece of data changes, all
> other data that depends on it uses the correct data.
>   
If I get booted out of my current position of work. I'm going to setup a 
consultancy and plan to use ledgersmb (which runs postgreSQL). So I will 
definately do that.
> Flat file databases tend to repeat data.  
Yes I used to work in a Lotus notes environment. It largely has the same 
problem as a lot of MySQL d.b's e.g. heres a giant bucket and your data 
is somewhere in it. go fetch!
> If only one of several
> identical entries is changed, tomorrow you probably can't tell me
> which is the correct entry. E.g.: 3 students, one parent.  Flat file
> has that parent listed 3 times, once in each student record.  
>   
Next to useless if you set up record management as above.
> I have several different db's accessed via Firefox (web pages thrown
> by perl scripts that access/update a postgres db).  They're not
> pretty, but they are functional (and really fast and easy to write --
> I'm not a programmer, so this is the closest I'll ever get to a
> rabid^H^H^Hpid development environment).
>   
I like to program in Perl it's like having two swiss army knifes and a 
spork in your pocket. wxPerl is the best 'look native' GUI programming 
environment for Perl (and Python as well re. wxGlade)
> BTW, for programming Perl, Padre is great!  Even better than vi (did I
>   
I've been following some of the devel comments regarding Padre on the 
wxPerl list but haven't installed it yet. I do a bit of dev in Perl so I 
should have a look.