PDO and other DB related suggestions
10 posts,
4 voices
4 posts
|
First I want to thank you for your work on Frog CMS. I always liked Radiant but couldn't stand ROR complicated deployment. However I have a few questions - suggestions for you if you don't mind :)
Thanks |
541 posts
|
the beta version of the new frog is now all myisam from is first version frog use PDO!! now frog use PDO, but I have code a PDO adapter for those how doesn't have PDO :) if you want to try it with sqlite I will really apreciate that ... juste set you DB_DSN to your sqlite (located in config.php) you will need port mysql database to sqlite |
|
4 posts
|
Thanks for the quick answer, Philippe! Didn't know that Frog uses PDO; I was ready to download and try it on my server but stopped after reading it requires InnoDB. Today I'll give it a try using both MySQL and Sqlite. BTW are you going to implement commenting features? As already told you, I haven't try Frog yet. However from what I've seen using the demo, Frog is really great. Add some blog features like comments, a contact form and maybe some anti-spam (captcha) and I'll drop Drupal from all my clients. And my final suggestion: Please keep the "bloat" out of your script. Radiant great success was due its minimalistic nature. |
|
4 posts
|
Update: I've installed Frog and works fine so far (MySQL PDO driver). Unfortunately I was not able to run it with sqlite. DB schema uses some mysql-specific semantics such as "enum" datatype, that cannot be translated in sqlite easily. Any idea? |
|
541 posts
|
what do you mean with "bloat" (sorry but English is not my first language) and for the sqlite I don't have any idea by now I will have to check that later |
|
4 posts
|
Saying "bloat" I mean useless features that increase memory and cpu usage. |
|
541 posts
|
Bloat (wikipedia definition): is a medical condition in which the stomach becomes overstretched by excessive gas content. ok but I think that will all I have add to Frog CMS, Frog CMS still win in all domain (less memory usage and faster execution time) PHP is really faser dans Ruby On Rails and it cost less in memory, and Frog Use a nice little Framework for is backend, but use the minimalistic for the front end AND store in the database all executed filter part, like that less execution need in frontend too I think that answer your question :) |
25 posts
|
Make frog v.0.2.2 without pdo? I dont like beta 1... its not like radiant anymore. |
|
541 posts
|
Ok I got it ! I understand your point ;) remembre frog is still a open source product ... this mean that the one that code it (me) is not paid for that, and if I didn't got pleasure to do it I will not do it !! but I'm really open ... if many people ask me for it I will do it by pleasure :) maybe you can try to be more open too and accept the fact that Frog is not exactly like radiant anymore ... and I have try to make a php radiant, but the team of php refuse me that name ... so here it come some change ... we have to improvise sometime. it is like the radius tag in rail .. every one love them .. I love them too .. but I think it will be for me a big job to implement it and for you more memory usage, more execution time, so php tag are not so bad I think |
|
541 posts
|
for all of you that can't live without sqlite .. I have run Frog CMS on a sqlite3 yesterday ( you can have sqlite3 only with PDO) !! So it is possible !! The only problem I got was on the archive behavior, but I have patch it ... maybe I can provide a plugin to have Frog CMS with SQLite !! Hope I can release it with version 1 ... I will try !! again sorry for my english ! |
56 posts
|
Philippe, I've done more research into the whole date/time thing with SQLite and MySQL. Feel free to poke me if you are interested. I have a couple of ideas I have not yet tested. ;) |