Re: Nuevos storage engines
Hola Xavier,
La verdad solidBD se presenta como una alternativa interesante para evaluar al igual que el resto de engines que pronto estarán disponibles para MySQL.
En cuando a lo que comentas que las foreign keys en solidDB no funcionan, aquí está un script donde se muestra que si funcionan.
En estoy usando la versión win-beta5-0040
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.0.27 |
+-----------+
1 row in set (0.23 sec)
mysql> show engines;
+------------+---------+--------------------------------------------------------
--------------------------------------------+
| Engine | Support | Comment
|
+------------+---------+--------------------------------------------------------
--------------------------------------------+
| solidDB | DEFAULT | Fully transactional disk-based engine with multiversion
optimistic/pessimistic concurrency control |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tabl
es |
| InnoDB | YES | Supports transactions, row-level locking, and foreign k
eys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disa
ppears) |
| EXAMPLE | NO | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | NO | CSV storage engine
|
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | NO | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+---------+--------------------------------------------------------
--------------------------------------------+
13 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> CREATE TABLE `a` (
-> `id` int(11) NOT NULL auto_increment,
-> PRIMARY KEY (`id`)
-> ) ENGINE=solidDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.20 sec)
mysql> insert into a (id) values (1);
Query OK, 1 row affected (0.07 sec)
mysql> insert into a (id) values (2);
Query OK, 1 row affected (0.04 sec)
mysql> insert into a (id) values (3);
Query OK, 1 row affected (0.05 sec)
mysql> CREATE TABLE `b` (
-> `id` int(11) default NULL,
-> KEY `FK_b` (`id`),
-> CONSTRAINT `FK_b` FOREIGN KEY (`id`) REFERENCES `a` (`id`)
-> ) ENGINE=solidDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.14 sec)
mysql> insert into b (id) values (5);
ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint f
ails
mysql> insert into b (id) values (1);
Query OK, 1 row affected (0.05 sec)
mysql> select * from a;
+----+
| id |
+----+
| 1 |
| 2 |
| 3 |
+----+
3 rows in set (0.03 sec)
mysql> select * from b;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)