[Radiant] Part types

[Andi]

Hi John,

> Right now the way I'd like for attachments to be implemented looks like this:
> http://johnwlong.com/downloads/radiant/attachments/

That looks very cool! Can't wait to see it working.

>> Ah, btw, another thought: Can you put the public/images/* that are for
>> the admin interface in a sub-folder, say  images/admin/*
>
> That's a good idea. Can you create a patch for this and attach it to a
> ticket?

I hope I get around to it on the weekend.


>> However the RDBMS should have good support for Blobs (stay away from
>> MSSQL and Sqlite). 

> So the disadvantage for MySql and Sqlite is that they are slow?

MSSQL seems to have trouble handling BLOBs in general. And Sqlite: I did 
not get it working without encoding Base64 (it messed up the files... 
however I think it's the rails connectors' fault).

RDBMs which have sane BLOB implementations (I know of, there are 
certainly more) are: MySQL, Postgres, DB2, Frontbase.

The DB gets slow if it has to calculate with BLOBs i.e. if you process 
rows with blobs in stored procedures things get slow and can consume 
much memory. However I never had those cases, I think the logic (mainly) 
belongs to the app, not the database. So using BLOBs as simple 
backup-able replacement to for the file-system is fine (however the DBAs 
will yell about  bad style;))

> Perhaps the could be uploaded to the location where they will be stored in the
> file system and then imported into the DB?

Hmm, would be be more work I guess. I have no bad experience uploading 
them directly to the DB. However I did not try it vice versa.

Andreas

-- 
Posted via http://www.ruby-forum.com/.