<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Agreed. One table per object type, please.<BR><BR>Best regards,<BR>Stefan Andersson<BR>Tribal Media AB<BR><BR><BR><BR><BR>> Date: Wed, 4 Feb 2009 07:41:03 -0500<BR>> From: sdague@gmail.com<BR>> To: opensim-dev@lists.berlios.de<BR>> Subject: Re: [Opensim-dev] [Opensim-commits] r8236 - in trunk/OpenSim: ApplicationPlugins/Rest/Inventory Data/MSSQL Data/MySQL Data/NHibernate Data/SQLite Data/Tests Framework Framework/AssetLoader/Filesystem Framework/Communications/Cache Framework/Communications/Capabilities Grid/AssetServer Region/ClientStack/LindenUDP Region/Communications/Hypergrid Region/Environment/Modules/Agent/AssetTransaction Region/Environment/Modules/Agent/TextureSender Region/Environment/Modules/Avatar/Inventory/Archiver Region/Environment/Modules/Scripting/DynamicTexture Region/Environment/Modules/World/Archiver Region/Environment/Modules/World/Estate Region/Environment/Scenes Region/Environment/Scenes/Hypergrid Region/ScriptEngine/Shared/Api/Implementation<BR>> <BR>> mikem@opensimulator.org wrote:<BR>> > Author: mikem<BR>> > Date: 2009-02-03 16:01:36 -0800 (Tue, 03 Feb 2009)<BR>> > New Revision: 8236<BR>> > <BR>> > Modified:<BR>> > trunk/OpenSim/ApplicationPlugins/Rest/Inventory/RestAssetServices.cs<BR>> > trunk/OpenSim/ApplicationPlugins/Rest/Inventory/RestInventoryServices.cs<BR>> > trunk/OpenSim/Data/MSSQL/MSSQLAssetData.cs<BR>> > trunk/OpenSim/Data/MySQL/MySQLAssetData.cs<BR>> > trunk/OpenSim/Data/NHibernate/NHibernateAssetData.cs<BR>> > trunk/OpenSim/Data/SQLite/SQLiteAssetData.cs<BR>> > trunk/OpenSim/Data/Tests/BasicAssetTest.cs<BR>> > trunk/OpenSim/Framework/AssetBase.cs<BR>> > trunk/OpenSim/Framework/AssetLandmark.cs<BR>> > trunk/OpenSim/Framework/AssetLoader/Filesystem/AssetLoaderFileSystem.cs<BR>> > trunk/OpenSim/Framework/Communications/Cache/AssetCache.cs<BR>> > trunk/OpenSim/Framework/Communications/Cache/CryptoGridAssetClient.cs<BR>> > trunk/OpenSim/Framework/Communications/Cache/FileAssetClient.cs<BR>> > trunk/OpenSim/Framework/Communications/Cache/GridAssetClient.cs<BR>> > trunk/OpenSim/Framework/Communications/Capabilities/Caps.cs<BR>> > trunk/OpenSim/Grid/AssetServer/RestService.cs<BR>> > trunk/OpenSim/Region/ClientStack/LindenUDP/LLClientView.cs<BR>> > trunk/OpenSim/Region/ClientStack/LindenUDP/LLFileTransfer.cs<BR>> > trunk/OpenSim/Region/ClientStack/LindenUDP/LLImageManager.cs<BR>> > trunk/OpenSim/Region/Communications/Hypergrid/HGGridServices.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/Agent/AssetTransaction/AgentAssetsTransactions.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/Agent/AssetTransaction/AssetXferUploader.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/Agent/TextureSender/TextureSender.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/Avatar/Inventory/Archiver/InventoryArchiveReadRequest.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/Scripting/DynamicTexture/DynamicTextureModule.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/World/Archiver/ArchiveReadRequest.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/World/Archiver/AssetsArchiver.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/World/Archiver/AssetsDearchiver.cs<BR>> > trunk/OpenSim/Region/Environment/Modules/World/Estate/EstateTerrainXferHandler.cs<BR>> > trunk/OpenSim/Region/Environment/Scenes/Hypergrid/HGAssetMapper.cs<BR>> > trunk/OpenSim/Region/Environment/Scenes/Scene.Inventory.cs<BR>> > trunk/OpenSim/Region/Environment/Scenes/Scene.cs<BR>> > trunk/OpenSim/Region/ScriptEngine/Shared/Api/Implementation/OSSL_Api.cs<BR>> <BR>> <BR>> Ok, I'm reading through this patch, and it makes everything far more<BR>> confusing. Now we are flattening and unflattening between 1 and 2<BR>> objects when we touch xml and the database.<BR>> <BR>> We need to either decide the Metadata is really seperate, in which case<BR>> it's a 2nd level entity in the database and the xml (i.e. new table and<BR>> nested xml), or it isn't, and we got back. This midway point is madness.<BR>> <BR>> 1 object per database table please. Anything else is insanity for a<BR>> datamodel.<BR>> <BR>> -Sean<BR>> <BR>> -- <BR>> Sean Dague / Neas Bade<BR>> sdague@gmail.com<BR>> http://dague.net<BR>> <BR>> <BR></body>
</html>