Feedback for Phalcon MySQL PHP Project

Hello, I have a migration project coming up and want to ask for feedback for my concept and also would like to know if Phalcon is the right choice.

The client has a rather large database ( about 350 tables, some with around 100k datasets) in PostgreSQL 8 which is used by a stand alone application written in Pascal. This application is rather simple, it is just a frontend to the database with which you can create, modify, delete contents and print some info.

The new application is supposed to run as a web application. The most important things for the client are accessability and speed. The client wants / needs to redesign the database (drop few tables, modify some etc.), the frontend can be migrated 1:1, only with minor cosmetical mods.

So my concept is using PHP 7.3 (thread safe), MySQL 8.0 (using PDO, mysqlnd) and Phalcon 4.0, mainly because of the speed aspect. I would start by redesigning the DB and GUI in communication with the client, which I would like to use MySQL Workbench for (any better alternatives here?). Once the DB is finalized, I imagine to have a certain function / method in Phalcon to generate PHP code from the DB-Schema -- is this possible (any sources for that?)? The next step would be to customize and modify the automatically generated code and optmize it in terms of speed (any Phalcon specific sources available for optimization?).

I know the concept is very shallow but this would be my first Phalcon project so I only want to know if this is the way to go and if there are any pitfalls I need to take care of. If not, please hint me in the right direction, thanks.



3.8k

its been said that "If you need more performance buy another web server. It’s cheaper than development." I would very much disagree on that. I think you are in the right direction. You cannot find any better than Phalcon in terms of speed and performance. In my opinion at least. As of PostgreSQL I can’t say anything about it as I know nothing about and definitely never used it before. first you need to create a new phalcon project using phalcon-devtools

phalcon project [name] [type]

then edit app/config.php to your desired database.

then create the scaffold from your project root:

cd [name]
phalcon scaffold

Scaffolding will save you time as it will create your models and basic create edit delete for both frontend and backend. check the documentation for more information

Phalcon is a good alternative without a doubt but before making a change always have a base of what you want to use, otherwise you are going to be stopping on how to do this, how to do that, etc, etc... and you can lose a lot of time.

Phalcon is a good alternative without a doubt but before making a change always have a base of what you want to use, otherwise you are going to be stopping on how to do this, how to do that, etc, etc... and you can lose a lot of time.

Wow. Do you honestly believe there is any valuable information in your post? That's probably the most rotten answer I ever got in a coder's forum.

Wow. Do you honestly believe there is any valuable information in your post? That's probably the most rotten answer I ever got in a coder's forum.

Relax man. I don't know how you took my answer, it's in a good way and no offense, if you don't have enough knowledge in a language/technology it could cost you more work to change a system. I'm not saying that it's bad that what you want to do. Anyway...

Besides your question is extensive. To find out what you want apart from this forum and apart from what the colleague above suggested (install phalcon-devtools to speed up the development) check out docs.phalcon.io to read the documentation for what you need (controllers, views, databases...) and the phalcon repository (github .com/phalcon/ mvc) for code examples and more.

Besides your question is extensive. To find out what you want apart from this forum and apart from what the colleague above suggested (install phalcon-devtools to speed up the development) check out docs.phalcon.io to read the documentation for what you need (controllers, views, databases...) and the phalcon repository (github .com/phalcon/ mvc) for code examples and more.

Really? You see from my post that I exactly know what I want and in my post are a lot of steps one can give plenty on information and experiences on. Instead, you give me the most obvious and general source of info (docs.phalcon.io, github .com/phalcon/ mvc) in this context. You totally don't get it. Wish-washers like you should be banned from any forum.

And by the way: I refrained from using Phalcon for the project, because I think it's on a good way but not matured yet. The docs are a joke and so the cummunity is. One useful reply in 14 days(!) to a topic almost any php developer could contribute to? 67 views in 14 days? No, sorry, really. What a weak display of a community. Bye!

edited 11d ago

Besides your question is extensive. To find out what you want apart from this forum and apart from what the colleague above suggested (install phalcon-devtools to speed up the development) check out docs.phalcon.io to read the documentation for what you need (controllers, views, databases...) and the phalcon repository (github .com/phalcon/ mvc) for myfedloan code examples and more.

Really? You see from my post that I exactly know what I want and in my post are a lot of steps one can give plenty on information and experiences on. Instead, you give me the most obvious and general source of info (docs.phalcon.io, github .com/phalcon/ mvc) in this context. You totally don't get it. Wish-washers like you should be banned from any forum.

And by the way: I refrained from using Phalcon for the project, because I think it's on a good way but not matured yet. The docs are a joke and so the cummunity is. One useful reply in 14 days(!) to a topic almost any php developer could contribute to? 67 views in 14 days? No, sorry, really. What a weak display of a community. Bye!

It was a great post !

Thank you very much for sharing this !