Re: Thoughs after discussions at OSCON

jdavis-pgsql(at)empires(dot)org (Jeff Davis) writes:
> Jim C. Nasby wrote:
>> Has anyone looked at how easy it would be to migrate an application
>> from SQLLite to PostgreSQL? I'm asking not because I think we need
>> to try and take space away from them, but because a number of
>> sites/projects that start out thinking "oh, this will never grow
>> beyond a few users" end up in a lot of pain when that assumption is
>> proven false. Livejournal is a great example of this. So it would
>> be good if those people had a moderately painless means to migrate
>> to PostgreSQL after they out-grew what SQLLite has to
>> offer. Perhaps it would be worth trying to work with the SQLLite
>> folks on this.
>
> Do you know of any non-standard behavior in SQLLite aside from a
> missing feature?

Well, it in a sense doesn't have data types. The *honest* type that
applies to every type is the STRING/TEXT type.
--
(format nil "~S(at)~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/linuxxian.html
First Rule of Computer Security
- Only forbid that which can be made impossible.
- Facilitate the possible.
- Have the wisdom to explain the difference.
-- Mark Miller