[HacktionLab] RAD ~= collaborative != (Well Designed | Well Programmed) [was: Rails girls]

[Mike Harris]

On 31/05/2013 12:41, Charlie Harvey wrote:
> On 31/05/13 09:50, Mike Harris wrote:
> > Access is quite a good tool in
> > reality and it does do relational databases and enforces their integrity
> > better than MySQL (at least up to 5.1).
>
> Is that when it fails to allow atomic transactions or when it randomly
> corrupts your database when you have more than 2 users on your network?
>
> Referential integrity and atomic commits in InnoDB tables: MySQL 3.23
>
> Ways that Access can corrupt your data during normal use:
> http://support.microsoft.com/kb/300216/en-us

damn, I twarted my argument a bit making throwaway statements: I should
have known someone would pull me up on it.

To rephrase, if I may, I meant that when you're putting a db together in
Access, it intrinsically does the one-to-many, many-to-many
relationships between your tables.  Whereas mySQL requires you to know
what you're doing: it doesn't intrinsically make you do it.

am I off the hook?
>
> Cheers,
> Charlie
>
> _______________________________________________
> HacktionLab mailing list
> HacktionLab at lists.aktivix.org
> https://lists.aktivix.org/mailman/listinfo/hacktionlab

-- 
Mike Harris
w: http://mbharris.co.uk
t: +44 7811 671 893
0: http://mbharris.co.uk/keys/pgp.html