Welcome to Geeklog, Anonymous Saturday, November 23 2024 @ 08:07 am EST

Geeklog on Oracle ??

Sunday, August 11 2002 @ 12:07 pm EDT
Contributed by: wbvreeuwijk
Views: 6,980

Hi All,

I\'ve recently managed to install Oracle 8.1.7 on my server and am now thinking of moving all my software from MySQL to Oracle. One of these applications is Geeklog. Now my question is... has anybody ever tried this before ? Has anybody any idea if this is feasible (where I consider rewriting all the SQL-statements a bit unfeasible).

Any thoughts are welcome.

Regards,
Bas van Reeuwijk

Comments

Geeklog on Oracle ?? | 5 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Geeklog on Oracle ??

Authored by: Anonymous (Anonymous User) on Sunday, August 11 2002 @ 09:46 pm EDT

it\'s possible but since most people refuse to wean themselves from the glorified filesystem interface that is mysql us users of true rdbms\'s will have to wait. this has long been my biggest complaint against geeklog the inablity to use anything other than mysql.

Geeklog on Oracle ??

Authored by: dreamscape on Monday, August 12 2002 @ 05:10 am EDT

there was a push at one time to move the 1.3.x branch to using ADODB which would have moved us towards closer portability among databases, however, there were other issues at the time so we reverted most of those changes.

I think it would be a rather big undertaking to rewrite everything to be oracle compliant. There are a lot of nice things based on your RDBMS of choice. Subselects are huge, triggers and stored procedures are nice, mysql does a ton of functional stuff on data, plus it\'s damn fast.

The next major version of geeklog will use db abstraction to make it totally portable, it looks like we will be going with PEAR::DB atm. We\'ll see.

Geeklog on Oracle ??

Authored by: Tony on Monday, August 12 2002 @ 08:21 am EDT

Dreamscape is right, I made a valiant effort to abstract the database stuff in Geeklog but it proved to be a huge tasks that introduced a million bugs. As a results we reverted back and are saving DB abstraction for GL2

---
The reason people blame things on previous generations is that there's only one other choice.

Geeklog on Oracle ??

Authored by: Anonymous (Anonymous User) on Saturday, May 31 2003 @ 09:10 am EDT

... db abstraction is good, but is PEAR::DB on the wrong level.

anyway you'll need different SQL statements for different databases...

Geeklog on Oracle ??

Authored by: Anonymous (Anonymous User) on Saturday, May 31 2003 @ 03:47 pm EDT

This is part of the concept behind a database abstraction. You define how to connect and manipulate the data for each desired database in one location. In the rest of your code, you merely call the appropriate abstraction routine. How could PEAR be on the wrong level? It is a pre-built class library to designed to do this.

Warning: Javascript required to enable functionality

Geeklog on Oracle ??

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks