Hello dev team,
we are porting the MySQL Midgard interface to Oracle8.
1. Datatype
With MySQL we use the TEXT datatype.
With Oracle, there is:
* VARCHAR2 with 4Kb searchable
* LONG with 4 Mb no searchable
* LOB with 4Gb no searchable
We choose the LONG datatype. No objection?
2. Article extension
We want also to have external tables to be linked to articles.
Some local developpers ask me about this.
Is this interface skeleton exists and frozen in V2?
We want also the article extension to be searchable.
Before starting this point, any ideas are welcome.
Yes, we can use the php interface to oracle to do this,
but we don't want to have extra database connections.
The idea is not to rewrite a db interface, but a selective
extract from one table based on articleid, topicid and a list of custom
fields.
This feature can be used also for Midgard tables like person
when we have a lot of user.
What do you think about this?
3. Date datatype and functions
Midgard uses a lot of mysql date functions and features.
It's hard to implement in Oracle, this takes more time than expected.
In the next release V2, what is the direction for the sql syntax?
4. First Beta release
A first package based on Midgard 1.2.5 is expected
February, 15th.
Jean-Pierre Arneodo
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
