Just found another option: Yellow Duck Framework 2.0
2 2006-02-13 14:58
Topic: Rails for PHP? (3 replies, posted in General discussion)
Hi,
I really wonder, if there is a RoR thing for PHP out there?
Since there is such a big RuR hype - I like it too - some PHP coder
must have migrated the MVC idea to PHP.
Any hints?
CU,
deepblue
3 2006-02-09 13:18
Re: Running punBB on Oracle - How? (4 replies, posted in PunBB 1.2 troubleshooting)
Rickard wrote:
Well, I guess that would solve it. We would have to add some code to the query method of the db class to rewrite the query, but that's very possible. Also, I'm sure a couple of queries would have to be rewritten completely, but that's no biggie either.
This confirmes my expectations.
Rickard wrote:
However, I have never been in contact with an Oracle database, so I wouldn't even know where to start. If someone else would be willing to investigate this, I would be very grateful.
I'll forward details to my colleges. They are going to implement this.
In case of problems, should we send emails to you directly or should we forward details to the forum?
Technically:
All Oracle code should go in an 'oracle.php' module and dispatching code to 'common_db.php'.
But how about the other queries your mentioned? If my colleges need to change other
source modules, do they need to use a special syntax to mark changes to get merged in
the main code stream later on?
Or should they just download the lastest release, change things as needed and you diff stuff
later on?
Rickard wrote:
Then there's another thing. The search feature of PunBB ...
Sorry, not enough time these days - as all days, probably later ;-)
4 2006-02-09 11:42
Re: Running punBB on Oracle - How? (4 replies, posted in PunBB 1.2 troubleshooting)
Rickard wrote:
The biggest problem with using oracle is that it doesn't support LIMIT/OFFSET, so there's no simple way to display 30 topics starting with topic number 100.
A starting point might be this query:
>>>
SELECT * FROM
(SELECT firstName, lastName FROM customer ORDER BY firstName)
WHERE ROWNUM < 6
<<<
This might be not quite cheap, but at least useful. Shouldn't a combination of two ROWNUM restrictions like this one
>>>
WHERE ROWNUM < 100 and ROWNUM > 90
<<<
solve the problem?
Rickard wrote:
And before anyone comments on this. Yes, I'm aware that LIMIT/OFFSET is not SQL Standard, but that doesn't change the fact that it's damn convenient.
No problem here. I see good reasons for your decision.
5 2006-02-09 10:39
Topic: Running punBB on Oracle - How? (4 replies, posted in PunBB 1.2 troubleshooting)
Hi folks,
I'd like to deploy a punBB installation on an Oracle DB server [Oracle 10 or 9].
Since punBB has this nice DB-abstraction layer and adding a
new DB-driver seems to be simple, I wonder why punBB ships
without an Oracle db-module 'oracle.php'.
Thus, these are my questions:
- May I run punBB connected to an Oracle Server?
- If not, are there any known problems?
- Does someone has a punBB DB-abstraction layer modul for punBB?
Thanks for your help and go on with your great work,
deepblue