Bringing Evo back to life again

29 Posts

dmi3yy Reply #131, 14 years, 6 months ago

:)

☆ A M B ☆
24,524 Posts

sottwell Reply #132, 14 years, 6 months ago

While we're on the subject, the dmi3yy version has a very annoying way of returning to the Resource overview page (View Resource Data) with the View children tab opened after saving a page.

It also starts out a new installation with the option for Advanced Upgrade selected, since it comes with an empty config.inc.php file. This change to line 4 of install/action.mode.php will fix that:

if (file_exists("../manager/includes/config.inc.php") && filesize("../manager/includes/config.inc.php")) {

It would also work with just the filesize check. The config.inc.php file the package comes with has a space at the beginning of the file, so it's not actually empty; that space needs to be removed if the purpose is to provide a file to work with. [ed. note: sottwell last edited this post 14 years, 6 months ago.]

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

222 Posts

Stefanie Reply #133, 14 years, 6 months ago

I've done some testing with database classes.

The test showed, that ezŚQL is the fastest of all mentioned database classes.
But guess what, it is not perfect, because it hasn't implemented the connection charset for MySQL.
I decided to change the code of ezSQL to support the connection charset, because otherwise we'll may get in trouble with updating existing Evos.

The kudo for mentioning ezSQL goes to Susan, she mentioned that class on the first page of this thread.

I would like to use ezSQL as database class in this project

Gone away and found a better place to stay

☆ A M B ☆
24,524 Posts

sottwell Reply #134, 14 years, 6 months ago

Did you try native PHP PDO?

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

222 Posts

Stefanie Reply #135, 14 years, 6 months ago

No, the direct connection to MySQL without PDO. With ADOdb I tried PDO and native, both where a lot slower.
All PDO connections where in fact much slower, Zend and Doctrine are also using PDO. But I can give a try to PDO with ezSQL, but I don't believe, it will win the race.

PS.: With PDO and charset are some troubles, because there are different implementations: http://php.net/manual/en/ref.pdo-mysql.connection.php.
I don't want to run into this. [ed. note: Stefanie last edited this post 14 years, 6 months ago.]

Gone away and found a better place to stay

222 Posts

Stefanie Reply #136, 14 years, 6 months ago

Done a test with ezSQL with PDO. It is astonishing fast, nearly as fast as the native connection.
But, as mentioned above, the problem with charset in PDO with PHP prior 5.3.6 is a problem. In addition PDO has to be enabled on the webserver, the same problem as with Revo.
In ezSQL the PDO connection is done without options, to pass a charset for example. The class has to be extended to work with charsets. On the native MySQL I've already done it.

Gone away and found a better place to stay

☆ A M B ☆
24,524 Posts

sottwell Reply #137, 14 years, 6 months ago

Sounds even better than it was when I first tried it out and liked it. I was tickled by his original whitepaper, http://www.htmlgoodies.com/beyond/php/article.php/1485971/PHP-and-Working-with-Databases-for-the-Lazy-Sod.htm

About a JQuery back-end. I just installed a time-tracking application http://www.kimai.org/en/ and their installation script and the entire applications is just beautiful. JQuery, of course. It's worth installing it and looking around just to watch it work! Of course, only usage will tell me if it's as good for time tracking as it is pretty.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

222 Posts

Stefanie Reply #138, 14 years, 6 months ago

Last saturday I heard a talk of Jörn Zaefferer about single window applications with jQuery, very cool that stuff (http://mmt29.multimediatreff.de/Konferenz#vortrag7), it is in German. The talks will be published on their Youtube channel in some days.

I've done some more on ezSQL, there were some problems with the PostgreSQL connection class, it did not support ports and had no disconnect. The MySQL class also had no disconnect. I've changed the code and submitted it on github. The pull request is already accepted.

Currently I'm working on a new DBAPI class, that will deal with MySQL and PostgreSQL first. The class will have the same methods, as the old one to be compatible, but it is only one class for all RDBMS.
Today I had a day off, that helped a lot to start through with the database.

Gone away and found a better place to stay

1,613 Posts

fourroses666 Reply #139, 14 years, 6 months ago

new evo needs new tinymce!:

https://forums.modx.com/thread/75090/firefox-11-0-breaks-tinymce?page=3#dis-post-417843

Evolution user, I like the back-end speed and simplicity

☆ A M B ☆
24,524 Posts

sottwell Reply #140, 14 years, 6 months ago

Indeed. Personally, I'd like to see an adaptation for elRTE and elFinder.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org