Big thanks for all information you provided.

I have being working with Delphi for a while, now I need enter the web world: HTML5 + CSS3 + jQuery (and plugins) + PHP (json/xml) + Firebird.
I have chosen PHP over Java because it demands more people to acomplish one single project and PHP over ASP because it requires expensivly paid licenses on low profiting projects.
But I must confess that learn and work with HTML5 + CSS3 + jQuery (and plugins) + PHP (json/xml) + Firebird is not easy for a Delphi programmer...
PHP (OOP) is not difficult to learn, but convert MySQL examples to Firebird is.
HTML5 definition is not finished and does not work equal in all browsers. This is really complicated.
CSS3 design is really strange for people coming from Delphi world.
jQuery, and its plugins, is a must to satisfy clients.
I have chosen Firebird over all other RDBMS because all known advantages such as lightness, easiness, open source, etc.

Thanks again.

Roberto



Em 31/10/2012 06:13, Lester Caine < lester@... > escreveu:
 




Roberto Carlos wrote:

> For me, as beginner on PHP, it feels like ibase represents the past and tends to be discontinued. And PDO would represent the future.
> I usually read complains about both compared with drivers for other RDBMS.
> Drupal and Wordpress have initiatives to use Firebird (via PDO), but works are slow due to difficults on using PDO_Firebird driver. Sometimes it does not behave as expectaded.

The PDO driver has had all of the bugs fixed, the problem comes with the fact
that PDO has no understanding of the differences in SQL, and since MySQL has
some strange interpretations on the SQL standard, some queries can be difficult
to convert.
Even power users of MySQL still prefer the generic drivers over PDO and the same
is true for most other drivers.
0

> Usually the examples for PHP are on MySQL, sometimes on PostgreSQL and rarely on Firebird.
> Convert MySQL driver examples to ibase is very difficult for beginners because it demands extra knowledge both on Firebird and PHP (json/xml/jquery/ajax)...
> It is also difficult to find articles (or free/paid courses) on PHP/Firebird.

> For a recent example, search Robert Carlos's post on http://www.codeproject.com/Articles/277576/AJAX-based-CRUD-tables-using-ASP-NET-MVC-3-and-jTa

While I use a little ajax stuff I'm mainly working with jquery, but I would like
to add some more functionality to the bitweaver packages. piwik uses a few more
'tricks' and is running nicely on Firebird - at least my port of it is ;)

> Do you have any information on how ibase and PDO for Firebird are maintained? Both are actively maintained?

marius has been fine tuning both, but there is no pressing bugs or enhancements
for ibase, and PDO simply never developed from the original subset of
functionality :(

> Is there a better solution?

ibase works fine ...

> Do you know blogs with good articles on PHP/Firebird?

http://fbwiki.lsces.org.uk/ used to be hosted on firebirdsql.org some of the
content has been improved on my own home site such as
http://lsces.co.uk/wiki/index.php?page=Building+a+current+FLAP+stack, but we DO
need some more up to date stuff. It's been some years since I did papers on this
at the PHP confernces :(

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk