Hi there.
I have just downloaded SQLite and it seems a really interesting alternative
to postgresql for some of my projects. As SQLite CLI is not as versatile as
a GUI, I searched for a good frontend to SQLite databases. I found kira and
knoda. I tried both and knoda convinced me the most.
I made some tests and I found two important weakness of SQLite: Alter table
and full (right) outer join are missing. I tried the first one in knoda
(sqlite3 driver) and it complains when you delete columns and can't change
the order of columns. I haven't tested the second yet, but I think it will
have the same problem as I found code like the next in the hk_classes
sources:
hk_string r=internal_delete_fields_arguments();
hk_string error;
if (r.size()>0)
{
error=hk_translate("hk_sqlite3table:: Driver does not support the
deletion of columns!\n");
p_sqlitedatabase->sqliteconnection()->servermessage(error);
}
r=internal_new_fields_arguments(true);
if (r.size()==0)
{
error+=hk_translate("hk_sqlite3table::No columns to add!");
p_sqlitedatabase->sqliteconnection()->servermessage(error);
return false;
}
My question the is:
Why there is not implemented a "fake" alter table support without losing
data by just copying the table, creating a new table as desired and then
fullfiling it?, There are any plans to do it?
Thanks in advance for your answer.
--
Camilo Andrés Jiménez Cruz
Físico
Universidad Nacional de Colombia
Bogotá
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
