I understand both sides of this discussion.

Without reading thru it all I would say that Tim made a most valiant and commendable attempt to integrate MySQL into EWB. Most valiant. That took up considerable time and we were patient as we expected it would open up a easier path to shared web hosts. However, for reasons well explained it could not happen.

The numerous does imply a whole lot more, yes. However, I rather support this EWB effort as I see where it is and where it is heading and the positive impact it has made to my focus and increasing productivity in my web app related solutions.

I suspect that with the release of Delphi 10.2 and the Linux ability the coming 6 months shall be very exciting!

in another thread Trinione wrote:
> I would say that Tim made a most valiant and commendable attempt to integrate
> MySQL into EWB. Most valiant. That took up considerable time and we were patient as we expected it would
> open up a easier path to shared web hosts. However, for reasons well explained it could not happen.

I did a bunch of programs using EWB + PHP, but have since almost entirely moved away from PHP and to object Pascal for the server (Windows + some Linux) for the last eight months.  I did it using EWB+Mormot (open source) which compiles with both Delphi and NewPascal (free FreePascal variant)

Some observations:
 - PHP database support is lacklustre compared to Mormot
 - run time errors are common in PHP, whereas Pascal catches most at compile time
 - PHP debugging is not as easy/robust as Dephi/NewPascal IDE
 - PHP language is changing leaps and bounds, compatibility is a pain, Object Pascal is mature, we don't need to keep rewriting
 - mormot talks JSON, EWB talks JSON, it takes one function call to match mormot's JSON with EWB's tdataset.
 - mormot + NewPascal/FreePascal are open source, or you can use it with Delphi Pro if you want, I use both options
 - PHP is harder to secure

Mormot is used in some huge database systems, it really scales well.  There are examples of people running sites with thousands of concurrent users (eg. Poker site)

Okay, but what about cheap hosting?  What Tim was aiming for (and I was too) was running on a cheap shared  hosting plan.

But now, with today's available, cheap virtual machine hosting is making it possible to run you own VMs (Windows or Linux) for $4 US a month in other people's data centres.  Obviously you can do it with Amazon, but locally you will find competition has lower prices.

> I suspect that with the release of Delphi 10.2 and the Linux ability the coming 6 months shall be very exciting!

It was released this week.  Very unexciting actually, as Embarcadero made Linux only available for $4k enterprise users.  I've protested, and I suggest you do too.  But NewPascal has been used for several years with mORmot+Linux servers in heavy production use.  

I have always been a Delphi user since Version 1, and I am happy to pay reasonable rates for software.  But with Embarcadero placing Linux at four times the price I had been paying for regular Delphi, I have lost patience with them.  I still have a lot of code invested in Delphi so I'll keep buying Pro., but am migrating new *server* projects to NewPascal.

EWB continues to offer excellent value and support.  I'm happy to renew and spread the word so others will join our developer community.

Erick
http://www.erickengelke.com

erickengelke wrote:

>It was released this week.  Very unexciting actually, as Embarcadero made Linux only available for $4k enterprise users.  I've protested, and I suggest you do too.  

I did protest - by not renewing my support contract which is up for renewal in a couple of weeks. After numerous requests to renew from Ashley over at Embarcadero, I e-mailed her and told he that I wouldn't be renewing as soon as I found that Linux support wasn't in Pro.

erickengelke wrote:

<< ... Embarcadero made Linux only available for $4k enterprise users.  >>

Good Lord! NO!

Ah well. It's their product to price as they please. Thankfully - Pascal is not Delphi and Delphi is not Pascal. Similar to Jell-O not being gelatin and a soda not being a Coke.

It's time to brand Pascal/Object Pascal differently and move it away from its Delphi moorings as much as possible. Embarcadero is going from bad to worst to horrible to [no words left to describe the mad pricing].

erickengelke wrote:

<< I did a bunch of programs using EWB + PHP, but have since almost entirely moved away from PHP and to object Pascal for the server (Windows + some Linux) for the last eight months.  I did it using EWB+Mormot (open source) which compiles with both Delphi and NewPascal (free FreePascal variant) >>

Is the database EDB? From what you mentioned elsewhere Momot does not do EDB.

<<  Some observations: - PHP database support is lacklustre compared to Mormot ..... >>

The thing is, PHP, like Pascal, has also been around a very long time and there are tons of programs for the web that are PHP based and pretty much built into the 'net' and readily available with hosting options.

Pascal is the better choice for sure, but Pascal lacks proper documentation to guide users along. There is a lot of assumed knowledge that loses and confuses many.


<< But now, with today's available, cheap virtual machine hosting is making it possible to run you own VMs (Windows or Linux) for $4 US a month in other people's data centres.  Obviously you can do it with Amazon, but locally you will find competition has lower prices. >>

Can the Mormot and Dephi/Lazarus apps run on VM then? Is it a CGI/FastCGI you are referring to?


<< I have always been a Delphi user since Version 1, and I am happy to pay reasonable rates for software.  But with Embarcadero placing Linux at four times the price I had been paying for regular Delphi, I have lost patience with them.  I still have a lot of code invested in Delphi so I'll keep buying Pro., but am migrating new *server* projects to NewPascal. >>

They lost me after Delpih 2007 which I still use to develop desktop apps. I am moving to Lazarus and NewPascal. Linux and Windows - which is why I am excited about EDB on Linux now that D10.2 is out..


<< EWB continues to offer excellent value and support.  I'm happy to renew and spread the word so others will join our developer community. >>

Same here. I have a project I am about to get to that shall play its part. Pascal, IMO, needs an identity away from Delphi branding, and the Delphi of the 1990s mindset.