| Porting Stellation [message #568904] |
Wed, 17 July 2002 13:36 |
 Kevin Lewis
Messages: 1
Registered: July 2009 |
Junior Member |
|
|
One thing I noticed when looking at the Stellation schema
( http://dev.eclipse.org/viewcvs/indextech.cgi/%7Echeckout%7E/ org.eclipse.ste
llation/docs/database-structure.html):
It seems to indicate that Stellation is using the PostgreSQL text type.
This is a wonderful type which allows text of arbitrary length. It's great
for things like ... well, storing source files.
I think it will be a pain to port this behavior to another database, since
very few have something like the text type (for example, neither Oracle or
DB/2 does). You can store text of arbitrary length, but you can't search
it.
This isn't a big deal to me, since I think PostgreSQL is a fine database--I
use it every day on Windows as a matter of fact. It's biggest drawback is
the lack of useful stored procedures with PL/pgSQL (I think it's called).
Anyway, I just wanted to mention this. This may not be an issue with some
of the other databases mentioned (for example HSQL has a similar text type).
--Kevin
BTW, why are the tables in the Stellation schema named like collections
instead of types?
|
|
|
Powered by
FUDForum. Page generated in 0.03372 seconds
] 
Search
Help
Register
Login
Home
