Objectivist
Joined: 14 May 2004
Posts: 3
Posted: 2004-06-01 13:05
Back to top
Reply with quote
|
I've used phpMyEdit a bit for a MySQL based system but I'm now looking at the PostgreSQL database system as a potential alternative to MySQL for a number of reasons (i.e. better architecture, free for commercial redistribution unlike MySQL, etc.)
Can the developers indicate how hard it would be, in their opinion, to abstract phpMyEdit to work with other databases than MySQL?
Are other people interested in this?
Phil
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-06-03 12:25
Back to top
Reply with quote
|
rewriting pme code to work with other databases is definetly in the TODO list.
1. one problems is with patching class to not use mysql_* functions. namely myquery() connect() disconnect() as pme methods and mysql_fetch_array() _field_len() _affecter_rows() _free_result() used all arround the place.
2. second question is with sql queries, whether they will work in other databases. (LEFT OUTER JOIN, and some other)
3. third one is a more philosophical: support pme only on mysql or also on other databases. (more resources needed to check every database with every change).
|
Glenn
Joined: 23 Jun 2004
Posts: 1
Posted: 2004-06-23 22:46
Back to top
Reply with quote
|
I routinely have to work with both mySQL and postgreSQL... if phpMyEdit worked with both it would be a God-send.
Designing phpMyEdit to use an abstraction layer such as ADODB would solve many maintennance problems. It would also open the market to users of Oracle, Access, and many other DBs.
Regards,
Glenn
|
arueda
Joined: 04 Feb 2005
Posts: 4
Posted: 2005-02-18 22:40
Back to top
Reply with quote
|
Any news on the cross db support ??
ADODB seems to be a good tool used in many projects and it seems to be very stable and it would be an excellent solution fo PHPMyEdit class.
Where could I learn more about the new features included in the next release of PHPMyEdit ??
I am new working with this class guys and it really rocks. I thought it would be more difficult to learn it but it is really easy to use and it is very powerfull.
Excellent work ...
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2005-02-23 18:57
Back to top
Reply with quote
|
No new news. Still many other useful things todo. If this come to implementation, we will most likely use PEAR:DB abstraction class.
_________________ Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
arueda
Joined: 04 Feb 2005
Posts: 4
Posted: 2005-02-23 22:02
Back to top
Reply with quote
|
That would be an excellent aproach too ... even better as it would be more open standard concept.
hope the new version will come soon ...
thanks for your response,
Alberto
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2005-06-18 21:19
Back to top
Reply with quote
|
Hello,
Because i need a version of PhpMyEdit for PostgreSQL ASAP, i try to hack it starting this evening.
At this point :
The database functions were translated.
DB connection works.
LIMIT n OFFSET n SQL error fixed.
The next goal is to create the same set of test tables on a MySQL and PostgreSQL DBMS and test one by one all the functions.
|
bobtreu
Joined: 22 Oct 2004
Posts: 3
Posted: 2005-07-24 02:09
Back to top
Reply with quote
|
| mc.rraph wrote: |
Hello,
Because i need a version of PhpMyEdit for PostgreSQL ASAP, i try to hack it starting this evening.
|
I hope you will share your results. I am interested in postgres too, more specifically enterpriseDB ( http://www.enterprisedb.com ) which is Postgress with an Oracle compatiblity layer.
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2005-07-25 16:25
Back to top
Reply with quote
|
| Quote: |
| I hope you will share your results. I am interested in postgres too, more specifically enterpriseDB ( http://www.enterprisedb.com ) which is Postgress with an Oracle compatiblity layer. |
First, my hack works with a large set of options !
Before any public release, i will wait the answer of the PHPMyEdit team.
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2005-10-18 18:35
Back to top
Reply with quote
|
That is !
The project phppgedit is on sourceforge.net
I will add a website and the first alpha release ASAP.
|
pluk77
Joined: 09 Jan 2006
Posts: 2
Posted: 2006-01-09 17:14
Back to top
Reply with quote
|
The site seems still very empty...
http://sourceforge.net/projects/phppgedit
http://www.phppgadmin.org
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2006-01-25 12:48
Back to top
Reply with quote
|
Hi !
At last, i found some minutes to upload files on sf.net.
There is some little bugs and it is still a quick hack but, as i said, it works !
Please go the this forum or on sf.net and post if you wish further dev.
Thanks for testing !
|
domodo
Joined: 20 Feb 2006
Posts: 1
Posted: 2006-02-20 14:39
Back to top
Reply with quote
|
Hi,
I would also appreciate a PEAR DB aware version! Is there any development in that direction?
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2006-02-20 14:44
Back to top
Reply with quote
|
Good idea.
I will think about it.
Thanks you for your beta testing.
|
mc.rraph
Joined: 18 Jun 2005
Posts: 6
Posted: 2007-03-19 15:19
Back to top
Reply with quote
|
After one year here the new version at www.PHPPgEdit.org
Beta testers welcome !
The main class is fully working.
The archive includes a working example.
And the port of phpPgEditSetup.php are really in progress.
|
|
Post new topic
Reply to topic
Goto page 1, 2 Next
|