|
|
Posted by Michael Fesser on 01/25/07 17:22
..oO(Hasin Hayder)
>If thats the issue with SQLite, let me share some info. The FK is
>available in MySQL also , but unfortunately If the table type is
>MyISAM, it doesnt maintain the FK forcefully.
The MyISAM engine is only useful for small projects or really simple
databases. For anything more sophisticated you're usually better off
with a transactional engine like InnoDB. A bit slower than MyISAM, but
full of useful features.
A while ago I considered to have a look at PostgreSQL, but meanwhile
recent versions of MySQL support all the features I need. So I'll stay
with MySQL, but keep PG in mind as an option.
Micha
Navigation:
[Reply to this message]
|