Plain SQL, possible?

General
1

I took a look at the different frameworks and Yii looks cool as it has this basic project which utilized bootstrap, almost feels like the ‘plain php’ and jquery I am currently using. As I am delving deeper, it looks like Yii is using an ORM (ActiveRecord?), I prefer not using an ORM and just using plain SQL, is this possible with Yii?

I haven’t had an experience using frameworks for a full web development, I only tried Slim for APIs. I may need to develop a live site in the following months and I am really concerned about security so I thought using a framework could possibly ease those security burdens, or am I wrong?

Thank you all.

2

You are right! Using a framework will improve system security and help to adopt best practices to proceed with development.

3

Thinking about it more, could I just develop the web app to use APIs and not use ORM at all?

4

https://www.yiiframework.com/doc/guide/2.0/en/db-dao#executing-sql-queries

1 Like
5

Of course you can also use plain SQL along with AR ORM. You can combine both depending on your needs.